Hey Mark,
Thanks for the help. For each SQL Table I had generated 4 basic stored procedures (Insert/Update/Delete/Select/SelectAll). All but the SelectAll stored proc is parameterized.
For some reason SQL doesn't like when I try to use the parameterized select statement without parameters. But I am able to set the lNoDataOnLoad parameter to .F. and use the unparameterized SelectAll command to get the desired result.
I knew the lNoDataOnLoad was an option somewhere, I was looking for the property in the CA class though (hehehe).
Thanks again!
Aloha,
James
>See CursorFill in VFP Help. The second parameter in that method call can be set to .T. [lNoDataOnLoad]. If your SelectCMD is parameterized, just set the parameter to some value that does not exist in the table.
>
>Take a look at what my CA Builder does. Just download, unzip and read the comments at the beginning of the CABuilder.prg file. The VCX it builds of CAs for you will handle this for you.
>
>
http://www.mctweedle.com/downloads/CABuilder.zip>
>
>>Hi All,
>>
>>I got my CursorAdapters to run off of SQL Stored Procedures and they work seem to be working alright. I'm just wondering how I get an empty cursor so that I can add/append data to that will responde to a tableupdate().
>>
>>Aloha,
>>
>>James