Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
Back to article list Search Articles Add Comment Printer friendly Direct link Par2: Running MSSQL stored procedures from Clarion 1998-10-20 -- Ben Williams Just change your SQL statement to use CALL instead of execute
filename{prop:sql} = 'CALL jb_test1 'test'
Scott has changed the CW ODBC driver to set the statement handle if you use
a CALL in the {PROP:SQL}
Regard the quote marks, George Hall notes:
In your prop:sql statement, try two single quotes ('')before and after
hello, not one doublequote (")
Scott Ferret comments:
> filename{prop:sql} = 'CALL jb_test1 'test'
>
The correct syntax for this instance of using CALL would be:
filename{prop:sql} = 'CALL jb_test1 (''test'')'
Today is May 7, 2024, 8:38 am This article has been viewed 35121 times.
|
|