Information générale
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement