Richard,

Build your command like this:

lcSelect = [SELECT ...]
lcFrom = [FROM ...]
lcWhere = [WHERE ...]

lcSQL = lcSelect + lcFrom + lcWhere
SQLEXEC(nHandle, lcSQL, [SQLResults])

The 256 character limit is for a string literal (each one piece above), not the whole command.


>I have experienced an apparent limit of 255 chars length for the text within a SQLEXEC() command? Any Ideas as to what is going on? I thought the limit was supposed to be about 64K.
>
>Many thanks for any inputs
>
>Dick Balluff
>RLB Associates
>can be reached here or via rlb@surewest.net
>(916)789-8855