INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

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?


RE: SQL Stored procedure from Clarion

Have you Read the Clarion Help - MSSQL Acc - Using Embedded Code?

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

If you are using the PROP:SQL to return back OUTPUT Parameters, the DummyFile should be opened in READ-ONLY, DENY ALL mode. You can set this in the File Overrides of the Global settings of the APP.

RE: SQL Stored procedure from Clarion

i need help about progress bar.
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

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.

Join Us             Close