Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Recordset to Cursor
Message
From
22/02/2006 17:32:08
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01098156
Message ID:
01098300
Views:
22
This message has been marked as the solution to the initial question of the thread.
>>>Wish .Net was in play
>
>LOL! Cetin .Net is in play... I'm passing the recordset back from a C# class method. I can do whatever I want with that recordset in C# before it gets passed back via interop to Visual FoxPro... what did you have in mind? Before you answer that please know that I have absolutely no knowledge of what fields will be in the recordset or what their types are. All I know is that everything seems to work with your approach to creating the cursor over in Visual FoxPro from the recordset except for the this one ADVARWCHAR field that has paths in it. I'm assuming it is the forward slashes in the paths that are causing the rs.save() to fail since everything else works great.

Greaatt:)
Before trying anything else DS.WriteXml with sxhema generated XML might be an answer?
Second create a table on the fly with VFPOLEDB (you have schema so you have structure, no?) and fill from yours?
Unfortunately my C# backyard is on my work computer:)
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform