Thanks for all the great info folks. Figured out why the text in Patel's .CHM file wasn't displaying for me. I had to go into the properties on the file and 'unblock' it.
I have got the SetSequencing working okay for me, but now I am having a bit of a problem with the SetSelection.
Let's say I wanted to select an employee only if their union code was MGTCNT or MGTFT or MGTPT. When declaring the SELECTSTRUCT variable, I essentially set it up to have 4 elements. One for the address number and 3 for the different union codes.
So, my code would look like this:
jdeNIDcpy(SelectF060116[0].Item1.szDict, NID_ANPA);
jdeNIDcpy(SelectF060116[0].Item1.szTable, NID_F060116);
SelectF060116[0].Item1.idInstance = 0;
jdeNIDcpy(SelectF060116[0].Item2.szDict, _J(""));
jdeNIDcpy(SelectF060116[0].Item2.szTable, _J(""));
SelectF060116[0].Item2.idInstance = 0;
SelectF060116[0].lpValue = &dsF060116.yaan8;
SelectF060116[0].nValues = 1;
SelectF060116[0].nAndOr = JDEDB_ANDOR_AND;
SelectF060116[0].nCmp = JDEDB_CMP_EQ;
jdeNIDcpy(SelectF060116[1].Item1.szDict, NID_UN);
jdeNIDcpy(SelectF060116[1].Item1.szTable, NID_F060116);
SelectF060116[1].Item1.idInstance = 0;
jdeNIDcpy(SelectF060116[1].Item2.szDict, _J(""));
jdeNIDcpy(SelectF060116[1].Item2.szTable, _J(""));
SelectF060116[1].Item2.idInstance = 0;
SelectF060116[1].lpValue = _J("MGTCNT");
SelectF060116[1].nValues = 1;
SelectF060116[1].nAndOr = JDEDB_ANDOR_AND;
SelectF060116[1].nCmp = JDEDB_CMP_EQ;
jdeNIDcpy(SelectF060116[2].Item1.szDict, NID_UN);
jdeNIDcpy(SelectF060116[2].Item1.szTable, NID_F060116);
SelectF060116[2].Item1.idInstance = 0;
jdeNIDcpy(SelectF060116[2].Item2.szDict, _J(""));
jdeNIDcpy(SelectF060116[2].Item2.szTable, _J(""));
SelectF060116[2].Item2.idInstance = 0;
SelectF060116[2].lpValue = _J("MGTFT ");
SelectF060116[2].nValues = 1;
SelectF060116[2].nAndOr = JDEDB_ANDOR_OR;
SelectF060116[2].nCmp = JDEDB_CMP_EQ;
jdeNIDcpy(SelectF060116[3].Item1.szDict, NID_UN);
jdeNIDcpy(SelectF060116[3].Item1.szTable, NID_F060116);
SelectF060116[3].Item1.idInstance = 0;
jdeNIDcpy(SelectF060116[3].Item2.szDict, _J(""));
jdeNIDcpy(SelectF060116[3].Item2.szTable, _J(""));
SelectF060116[3].Item2.idInstance = 0;
SelectF060116[3].lpValue = _J("MGTPT ");
SelectF060116[3].nValues = 1;
SelectF060116[3].nAndOr = JDEDB_ANDOR_OR;
SelectF060116[3].nCmp = JDEDB_CMP_EQ;
Where I am confused is at which point do I set the .nAndOr value to JDEDB_ANDOR_OR? Does the .nAndOr value apply to the element that it resides with or to the next element in the group? Is the code I have above correct or should the 2nd element be JDEDB_ANDOR_OR instead of JDEDB_ANDOR_AND?
Thanks...
Al