Create Select Statement using C codes

[patcccc]

Hi,

Is it possible to create the following select statement in a C business function for JDE Edwards?

Select * from F4211 where Order type in [O4, O5, O6] and Order Number = 10.

Thanks for your precious help.

 

[peter_hamilton]

Have a look at the BSFN B9600430 and at BSFN B98230A.

 

[BOster]

JDEBASE api JDB_SetSelectionX will allow you to create compound where clauses with parenthesis i.e.
where (x = 1 OR x = 2) AND z = 1