Archive for the ‘Stored procedure’ Category

Stored procedure

Posted: 2017-01-24 in Stored procedure

You can pass parameters to your stored procedure, e.g. nret = sqlexec(nhand,”call sp_demo(‘MA’)”,”mycursor”)


Currently, the ‘.prg’ needs to be present for stored procedures. This will be resolved in a future release, so that only the ‘.dbo


Lianja SQL Server lets you call stored procedures (or in fact just procedures) that use SEEK/SCAN/etc NoSQL commands inside them.

Server-side pages (
.rsp pages written in VFP compatible scripting) provide the same level of functionality in the cloud.
Best of both worlds NoSQL and SQL.


Q:
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 ?
A:
call sp_name()
to to get multiple result sets issue two sqlexec() calls.


Q:
In VFP, a Databsae file (.DBC), saved all sotred procedures in field named as ‘code‘.
We can
edit any procedure with ‘modify procedure.
Can we have multiple stored procedures in a single sp_library.prg file ?
A:
You edit stored procedures in the “Data” workspace for the database table.

No. Lianja will look for the stored procedure by filename in the database container directory.