General information
Title:
Need info about CursorAdapter
I'm trying to understand and find benefits in using CursorAdapter.
I've read the help and couldn’t find samples of code that would explain-me my doubts.
In the server side I have SP to Insert/Delete/Update.
Those SP always have this structure.. SSP_Action_TableName, where Action can be INS/DEL/UPD.
I would like to call the SP and send the parameters from the cursor to the SP in SQL Server.
Should I use SQLEXEC ?
The question is because when I use SPT I first build the statement that I send to SQL Server...
cSQL = " (ALLTRIM(cursor_name.field1.VALUE))" + "," + ;
"(ALLTRIM(cursor_name.field2.VALUE))".....
SQLString = "EXECUTE" + Stored_Procedure_Name + cSQL
IF SQLExec(nHandle, cSQLString) < 1
* Error !!
ENDIF
Do I use SQLEXEC to call a SP and pass the parameters in CA?
If not?, how can I call a SP and pass those parameters...(If possible some sample)
----
I'm trying to go one step ahead to increase the speed when developing with CA.
In my case, because I call SP I have to build my own commands for the Update/Delete/Insert operations.
first I want to get the name of the SP relative to the table.
Because all my SP at the server have the name of the table, I thing I could get the name of those SP doing something as:
Select name from sysobjects where xtype = 'P' and patindex('%Table_Name%',name) <> 0
Then select the SP from the list and then add all the fields’ values necessary from the cursor to the SP.
Is this a good approach? any better ideia ?
----
The more o try to understand CA, I only see 2 benefits in using it:
1) No need of Database at station
2) Create a Base Class of CA and all subclasses would use the same Connection Handle.
I can't see anything else; I also at this moment see more work in building my CA.
What I'm missing??
----
Where Can I find some good samples about CA?
IMO this is a new topic in VFP, so I expected a better sample and a better help from MS,
I fill that MS expect that we should know everything from the beginning, for waht a help for
a new topic.
Any help would be appreciated.
Thanks in Advance
Peter
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only