>Thanks Mark. I am doing better as my reply to myself reports.
>I am stuck on creating an empty cursor so that I can append records and manipulate them before saving to the target.
>
>Is it something to do with schema?
Go to
http://www.mctweedle.com and click the FoxPro Tools link. Download my CABuilder file. Read the comments in the CABuilder PRG file. This will create a ClassLib of CAs for all your tables. I have added 2 properties so you can control whether or not your specified CursorSchema [lUseCursorSchema] is used and if the cursor is returned with no data [lNoDataonLoad property]. In VFP9, the VFP Team added these properties to the CA. Otherwise, you have to use something like what my builder does, or handle calling the CursorFill() method yourself and passing the appropriate 1st and 2nd parameters.
Mark McCasland
Midlothian, TX USA