SELECT structure. Need more info

[lincor]

SELECT structure. Need more info

I try to found some information about SELECT fields.
It is necessary to fill this one when you prepare selection criteria for "SetSelection(...)" function.
Which types have fields in this structure? Which valid values?
Thanks. LinCor.


Have a nice coding. LinCor

 

[pcaenaro]

Re: SELECT structure. Need more info

Hi Lincor,

I thought I replied through the List, but it seems that it didn't go through.

Actually, I don't have a reply to your question, but more questions...
What select function are you talking about?
What are you trying to do exactly?


Cheers

Philippe


One World B7332 SP14.2 AS400

 

[lincor]

Re: SELECT structure. Need more info

Hi Philippe!
This function is JDB_SetSelection(HREQUEST, LPSELECT, nNumSelect, JDEDB_SET) from JDE API Guide. his API is equivalent to a WHERE clause in an SQL statement.

I try to fill LPSELECT structure which identifies the type of selection to process. For example, when I determine a 'lpSelect.nCmp' field I'd like to know more about valid values of this parameter. But there is only 'JDEDB_CMP_EQ' in API Guide.

Actually, I need scan F4101Z1 by any (not indexed) field like:

1. JDB_OpenTable(....)
2. jdeAllocReturnIfError(...)
3. Filling LPSELECT structure
4.JDB_SetSelection(.. ,lpselectStructure,...);
5 JDB_SelectKeyed(...)
6 JDB_Fetch(...)
{scan operations}

Sorry to my terrible English.



Have a nice coding. LinCor

 

[pcaenaro86]

Re: SELECT structure. Need more info

Hello again,

I never used this function, but a quick look at the developper's guide
gave me a few more allowed values for the nCmp parameter:

JDEDB_CMP_LE Less than or Equal
JDEDB_CMP_GE Greater than or equal
JDEDB_CMP_EQ Equal
JDEDB_CMP_LT Less Than
JDEDB_CMP_GT Greater Than
JDEDB_CMP_NE Not Equal
JDEDB_CMP_IN In
JDEDB_CMP_NI Not In
JDEDB_CMP_BW Between
JDEDB_CMP_NB Not Between
JDEDB_CMP_LK Like

Hope this helps

Cheers

Philippe

 

[lincor]

Re: SELECT structure. Need more info

Thanks a lot, Philippe it really helps me!





Have a nice coding. LinCor

 

[pcaenaro]

Re: SELECT structure. Need more info

You are welcome. Let the list/forum know if you need more info.



One World B7332 SP14.2 AS400

 

[Zoltan_Gyimesi]

Re: SELECT structure. Need more info

Hi LinCor,

At first, You are welcome on the Forum/List!

You can get some information about these JDE APIs in the OneWorld on-line help. Follow the steps to access it:

1.) Start from OW Explorer
2.) Select the Contents from the Help menu
3.) Two new window will bring up: "OneWorld Help Directory" and "Help Topics: OneWorld Help".
4.) The second has the input focus, close this making available to acces the first one.
5.) Open the "Tools, Technical and Foundation" folder
6.) Select the "Published APIs" (in prior XE) or the "OneWorld Tools API Reference" (in XE)
7.) The opened help window won't be represented on the taskbar and in some cases will be overlayed by the existing windows. If you do not see the help window then minimize your existing windows one by one to catch it.
8.) You can locate your APIs easily on the Find tab.

On the other hand, you can find other useful informations in this help e.g. about Events and Systemfunctions, visit the Contents tab of this help to locate them.

Regards,
Zoltán
P.S.: Please, place your system configuration informations in your signature.


B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)