General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Long column names are the problem. I took them out and the script worked fine.
>>If I try to add the long name back I get the error around column 120. By the way this table has 220 columns including 11 memos.
>
>I vaguely remember similar problem discussed few months ago at tek-tips.com website.
>
>Looks like you found some limitation which is unknown. Would be good to see the whole script.
The script is very simple but why the long names caused the problem is different story.
The following is example of the script and it goes to 220 columns
CREATE TABLE 'zzz.DBF' NAME 'zzz' ;
(ID C(10) NOT NULL, ;
COL_109 C(4) NOT NULL, ;
COL_110 C(20) NOT NULL, ;
COL_111 C(50) NOT NULL, ;
COL_112 C(4) NOT NULL, ;
COL_113 C(4) NOT NULL, ;
COL_114 C(4) NOT NULL, ;
COL_115 C(4) NOT NULL, ;
COL_116 C(4) NOT NULL, ;
COL_117a L NOT NULL, ;
COL_117b L NOT NULL, ;
COL_117c L NOT NULL, ;
COL_117d L NOT NULL, ;
COL_117e M NOT NULL, ;
COL_117f L NOT NULL, ;
COL_117g L NOT NULL, ;
COL_117h C(25) NOT NULL, ;
COL_118 C(20) NOT NULL, ;
COL_119 C(4) NOT NULL, ;
COL_120 C(4) NOT NULL, ;
COL_121 C(4) NOT NULL, ;
COL_122_1_a C(30) NOT NULL, ;
COL_122_1_b1 C(25) NOT NULL, ;
COL_122_1_b2 C(25) NOT NULL, ;
COL_122_1_b3 C(25) NOT NULL, ;
COL_122_1_b4 C(25) NOT NULL, ;
COL_122_1_b5 C(25) NOT NULL, ;
COL_122_1_c1 C(25) NOT NULL, ;
COL_122_1_c2 C(25) NOT NULL, ;
COL_122_1_c3 C(25) NOT NULL, ;
COL_122_1_c4 C(25) NOT NULL, ;
COL_122_1_c5 C(25) NOT NULL, ;
COL_122_1_d1 C(25) NOT NULL, ;
COL_122_1_d2 C(25) NOT NULL, ;
COL_122_1_d3 C(25) NOT NULL, ;
COL_122_1_d4 C(25) NOT NULL, ;
COL_122_1_d5 C(25) NOT NULL, ;
COL_122_1_e C(40) NOT NULL, ;
COL_122_1_f C(4) NOT NULL, ;
COL_122_1_g C(4) NOT NULL, ;
COL_122_1_h M NOT NULL, ;
COL_122_2_a C(30) NOT NULL, ;
COL_122_2_b1 C(25) NOT NULL, ;
COL_122_2_b2 C(25) NOT NULL, ;
COL_122_2_b3 C(25) NOT NULL, ;
COL_122_2_b4 C(25) NOT NULL, ;
COL_122_2_b5 C(25) NOT NULL, ;
COL_122_2_c1 C(25) NOT NULL, ;
COL_122_2_c2 C(25) NOT NULL, ;
COL_122_2_c3 C(25) NOT NULL, ;
COL_122_2_c4 C(25) NOT NULL, ;
COL_122_2_c5 C(25) NOT NULL, ;
COL_122_2_d1 C(25) NOT NULL, ;
COL_122_2_d2 C(25) NOT NULL, ;
COL_122_2_d3 C(25) NOT NULL, ;
COL_122_2_d4 C(25) NOT NULL, ;
COL_122_2_d5 C(25) NOT NULL, ;
COL_122_2_e C(40) NOT NULL, ;
COL_122_2_f C(4) NOT NULL, ;
COL_122_2_g C(4) NOT NULL, ;
COL_122_2_h M NOT NULL, ;
...
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only