Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create table
Message
 
To
06/11/2005 08:34:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01065820
Message ID:
01065822
Views:
19
Since you are creating a free table (not part of a database) the field lenght limit is 10 (Your field customer_tel has 12). Try using a shorter name.

>hi all,
>
>i try to create table , some fields as number(numaric)TYPE
>
> CREATE TABLE home(list_no N(10), customer_tel C(15),name C(80), area_no C(10),account C(10), qdate C(30),home C(10), bus C(40),survey_no c(10), flag N(10),n_try N(10)  NOCPTRANS)
>
>THANKS
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform