Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Row numbers in Grid
Message
 
To
07/03/2005 12:31:14
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00993302
Message ID:
00993334
Views:
14
>the line:
>
>Select f1,f2,00000 as n(5,0) as rownumber from MyTable Into Cursor dummy readwrite
>Show me an error: Command contains unrecognized phrase-keyword.
>Carlos

Sorry for Jumping in, but as Terry said there is no need to format the column in SQL
it must be:
Select f1,f2,00000 as rownumber from MyTable Into Cursor dummy readwrite
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform