String length of SQL command in SQLEXEC

[RexAdventure]

Can anyone tell me what the maxium SQL string length is for SQLEXEC? I've looked in the documentation, but I can't seem to find it anywhere. Using VFP7 and MS SQL 7.

This bit here.
||
\||/
\/
SQLEXEC(connection_handle, SQL_command, return_cursor)

 

[ramani]

HI

connection_handle is a NUMERIC. So why would you want to name it with large flowing characters and bother.

If you are talking about sql_command string.. I think it is 256.

Have a nice day

ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[rgbean]

I believe the SQL_Command length is dependent on the client/provider and/or back-end you are connecting to.

Rick

 

[chpicker]

He was actually pointing to the SQL_command, but the forum font compressed his spaces. I copied/pasted his note here in monospace:

                         This bit here.
                            ||
                           \||/
                            \/
SQLEXEC(connection_handle, SQL_command, return_cursor)
[/code

 

[chpicker]

Argh....that didn't work. Trying again...

                         This bit here.
                            ||
                           \||/
                            \/
SQLEXEC(connection_handle, SQL_command, return_cursor)