Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Cast()
Message
 
To
22/10/2004 14:20:48
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro Beta
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00953825
Message ID:
00954448
Views:
14
Jerry,

Your example was:

SELECT sales.*, ;
CASE(NULL AS I) AS myint ;
FROM sales ;
INTO CURSOR mysales

The problem is a "typo" in your command. You used the keyword "CASE" instead of the keyword "CAST". The command works if it is:

SELECT sales.*, ;
CAST(NULL AS I) AS myint ;
FROM sales ;
INTO CURSOR mysales

Regards,
Paul James
Previous
Reply
Map
View

Click here to load this message in the networking platform