>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.