Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Cursor mysteries
Message
From
01/10/2015 11:41:44
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01625276
Message ID:
01625330
Views:
49
>>I'm converting some dbf's to SQL Server tables.
>>In several cases, I have to replace the dbf as a recordsource of a grid with a cursor created by reading from a SQL table.
>>I set the cursor name as the recordsource property of the grid, set the column names as the controlsource properties of the columns.
>>When I show the form instead of showing the named columns column1 in the grid shows the contents of column 1 in the cursor, etc, etc.
>>As a workaround, I changed the query so that things work, but that will not work in every case.
>>Any ideas?
>
>BTW, I always use AliasName.colName for control source and not just colName. We had some problems with the latter technique a while while back (in 2003, I think).

Yes, that's how I do it also.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Previous
Reply
Map
View

Click here to load this message in the networking platform