Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create table...
Message
 
 
To
15/08/2007 14:19:57
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01248311
Message ID:
01248313
Views:
20
One or more of the fields are longer than 10 chars (i.e. rd_approve_date). Free tables only allow 10 characters as maximum for field names.

>What is wrong with this code?
>
>
>CREATE TABLE assets FREE (region c(6), market c(6), location c(6), asset_type c(10), asset n(10), tag_nbr c(15), description c(30), insrv_date D NULL, ;
>	life n(3), life_rem n(3), book_basis n(9,2), book_val n(9,2), last_close n(9,2), status c(10), completed d NULL, submit_date D NULL, ;
>	rd_approve_date d NULL)
>
>
>Im getting "Field name duplicate or invalid..." error.
>
>
>FWIW: CREATE CURSOR assets... works.
>
>TIA.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform