General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
The statement should not need the ; because only fox needs this to continue the line--the whole idea is to pass a single string which will execute in the SQL server as a three line command. We use Microsoft SQL7, but the statement should work for any SQL server, since the syntax is ANSI 92 compatible. The chr(13) carriage return character serves as the line break at the SQL server. An example string would be:
"set rowcount 1"+chr(13)+"select * from pubs order by tag"+chr(13)+"set rowcount 0"
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only