System form Vendor Proprties

[Former Member]

How Can I read the selection vendor proprties from

form "Purchase Analysis" (870)?

[Former Member]

Thank You It's Work Fine

[rasmuswulff_jensen]

Sorry about the additional posts... there was something wrong with the forum and the posts did not appear...

[rasmuswulff_jensen]

Remove due to doublicated post...

[rasmuswulff_jensen]

Remove due to doublicated post...

[rasmuswulff_jensen]

Remove due to doublicated post...

[rasmuswulff_jensen]

The data is stored in the DBDatasource of table OFLT in field VeQryGroup. The data is a string that look like this:

YNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNYYN

Position 1-64 is the properties (Pos 1 = Property 1 ect.)

Last 3 digits are used for:

- Pos 65 = Or/And (And = Y / Or = N)

- Pos 66 = Ignore (N = Ignore is checked / Y = Ignore is not checked)

- Pos 67 = Closed Properties Range (Y = Checked / N = Unchecked)

(Above have properti 1 selected, not ignored, AND-condition with no Closed Properties range)

Code to get the data:

DbDatasourece dbds = oForm.DataSources.DBDataSources.Item("OFLT");
string valueToUse = dbds.GetValue("VeQryGroup",dbds.Offset).Trim();