Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi,

to format an SQL statement in Basic, please read THIS. You will see that you might use - only if you're using Access2Base - square brackets to surround table and field names instead of double quotes (that have to be doubled again due to their presence within a Basic string).

To get the results of the statement in your program, typically read THIS . The OpenRecordset method may receive your SQL as statement and GetRows will load the whole set at once in a Basic variant array.

Hoping this might help.

JPL