Hi Jean-René,
There's good info at
http://fox.wikis.com/wc.dll?Wiki~VFPCommandSQLStringConnectCheers,
Andrew
>Thank you Abdrew. This is really helping.
>
>I am new at this. Can you give me a example of a SQLStringConnect?
>This will also help me.
>
>>Assuming you've established a connection to the SQL Server (with SQLConnect or SQLStringConnect) and stored the connection handle in lnConnHandle, you can use the syntax
>>
lnResult = SQLExec(lnConnHandle, "exec MyStoredProcedure param1, param2, param3...", 'MyNewCursor')
>>This will return the result of the SP into a cursor called MyNewCursor. If you omit the third parameter, the cursor will be called SQLRESULT.
>>
>>Cheers,
>>
>>Andrew
>>
>>>I have a Store procedure in SQL 2000 that process a large amount of data. The result of this SP is a sub set of data.
>>>
>>>How can I call from VFP my Store Procedure and get the result in a VFP cursor?
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.