SQL Stored procedure from Clarion
SQL Stored procedure from Clarion
(OP)
How do i call an SQL stored procedure(MS SQL 2k), with parameters, from Clarion?
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you a
Computer / IT professional? Join Tek-Tips Forums!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
SQL Stored procedure from Clarion
|
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
RE: SQL Stored procedure from Clarion
I normally create a Dummy Table in MS-SQL and then create a view on that table and execute the SQL command on the view.
The way to execute is to use PROP:SQL.
SQLView VIEW(DummyFile)
....
END
Param1 string(30)
Param2 long
RetVal LONG
STORED PROCEDURE with Parameters Passed :
SQLView{PROP:SQL} = 'CALL dbo.store_proc_name (<39>' & CLIP(Param1) & '<39>, ' & Param2 & ')'
STORED PROCEDURE with Parameters Passed with Return Value:
BIND('RetVal',RetVal)
SQLView{PROP:SQL} = '&RetVal = CALL dbo.store_proc_name (<39>' & CLIP(Param1) & '<39>, ' & Param2 & ')'
UNBIND('RetVal')
STORED PROCEDURE with Parameters Passed with Return Value & OUTPUT Parameter (Param1):
BIND('RetVal',RetVal)
BIND('Param1',Param1)
SQLView{PROP:SQL} = '&RetVal = CALL dbo.store_proc_name ( &Param1, ' & Param2 & ')'
UNBIND('RetVal')
UNBIND('Param1')
RE: SQL Stored procedure from Clarion
RE: SQL Stored procedure from Clarion
i make a back end script with sql server200 and i want to make progress bar in clarion can anyone help me.
thanks
Lie Andry Ridwan