Hi Thomas,
How does the CursorAdapter work with memo (text), general and binary (image) fields from SQL server? Any problems with those at all?
Thanks for the info,
- Brian
>Hi All,
>
>Just thought I would let you know that I tried compiling and implementing the CursorAdapter within my COM Servers data layer this morning and it was a breeze and worked first time. The only spot that I became a little confused on was that the cursor kept disappearing on me at first and then I realized that the cursor is actually part of the cursoradapter object and of course when the object is released so is the cursor.
>
>There was a simple answer to that one as well. Since it was being utilized in my data layer, I simply performed a CURSORTOXML and then returned the XML to the Business Layer. After that All I had to do was call XMLTOCURSOR and process my cursor.
>
>It all worked flawlessly. While I didn't notice any significant performance differences in the test I ran, I did realize that it definately minimized the amount of coding to perform this task.
>
>Hope everyone had a good time at DEVCON.
>
>Tom Thayer
VFP6 SP5, VFP8 SP1, VFP 9 SP 1 and Win XP SP 3 (unless otherwise specified)
www.wulfsden.com