Hi, all.
I was doing some training last week at a customer. They are using SQL Server 2000 and they has a corporate policy to do all DB access trough Store Procedures. I helped them in the past to build a data access component when they where using VFP 7, and we sat for a round of test-driven development to refactor it using CursorAdapter. It was more an exercise than something very critical, but anyway...
I couldn't find a good way to make the CursorAdapter use the Select/Insert/Update/Delete SPs.
We try to fiddle with the *Cmd methods, but to no avail. The problem I couldn't figure out was how to pass parameters to the SP. I tried adding them to the SP command string in the Before* (BeforeInsert, for example), but my changes are not applied. I managed to force the parameters before calling TableUpdate, but this only works in single-record cases.
Any hint or example? I guess it should be some easy way I'm totally overlooking.
Thanks in advance,