Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Modifying returned cursor structures
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Modifying returned cursor structures
Miscellaneous
Thread ID:
00612134
Message ID:
00612134
Views:
51
I have a case where the sql to the backend returns a structure slightly different than what I want. What I want to do is alter the column(s) of the result set to the datatype that I want. I have one of several ways that I can do this: 1 - create the cursor structure I want and append the result set into that structure, 2 - open the dbf() again in new work area and close it in the first and then alter the structure, 3 - figure a way to set the read only attribute of the cursor to read-write and alter it. #1 is okay, except I want to be someone generic in what I am doing. #2 works but truncates long field names. #3 is what I want but I can't figure out how to do it with the cursor open and not running a dos attrib command. I know it sounds weird, but it does have its place. Any ideas?
Next
Reply
Map
View

Click here to load this message in the networking platform