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