Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Foxpro data to .Net
Message
From
14/09/2006 18:35:13
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01153891
Message ID:
01153893
Views:
12
>I have to convert a VFP(.prg) into a VB.Net program and I have some difficulty.
>
>My biggest difficulty is because the foxpro program use cursor in his traitment and I don't know how to do the same thing in .Net. I know how to do simple select or update, but I don't know how to convert the cursor.

The goal here is to obtain one overall SQL from the master one and the inside loop one. It is possible to adjust that into one SQL. Then, from that SQL result, from the dataset, you will be able to loop and do your updates. Or, maybe there could be a way to update it all in one command. I don't have the time to try to look for the syntax that would support it all in one SQL but that would be the way to go.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform