Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select to integer
Message
 
 
To
09/10/2001 11:09:43
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00565961
Message ID:
00565974
Views:
27
>When SELECTing into a cursor, is there a way to convert to Integer? Int(MyNumericField) seems to create a field of type N(10).
>
>Hilmar.

No direct way. If you want to have Integer field, which is not in original table, you can do:
create cursor curTemp (MyIntField I)
insert 0 into curTemp

select * from myTable, curTemp into ...

Otherwise you have to ALTER TABLE after it's created.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform