Results 1 to 10 of 15

Thread: [Solved] Calling a stored procedure

Threaded View

  1. #1

    [Solved] Calling a stored procedure

    Hello,

    I created a stored procedure in "southwind" database through Lianja App builder. I named is as

    sp_GetOrderDetails.prg
    =======================
    select * from order_details into cursor cc

    I can run this in console and can browse cc cursor.

    How can I call this or any other stored procedure from "Lianja Sql Server" to VFP ?

    I am getting error in vfp if I call it as

    ? SQLEXEC(lnConnHandle,"exec sp_GetOrderDetails")
    Connectivity error: Unrecognized SQL phrase/keyword near column 4


    Thanks
    Last edited by barrymavin; 2014-12-23 at 21:33.

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us