Field name is a duplicate or invalid when creating temp?

[Redsz]

I keep getting the message - field name is a duplicate or invalid when creating a temptable. anybody see my error?

ctemp2 = sys(2015)
** Creating the temporary table.
create table &ctemp2 free ( ;
cupc c(25), ;
cid c(35), ;
nqty n(10,2), ;
cdesc c(50), ;
cinvno c(10), ;
mremark m, ;
cstationid c(10), ;
cphone c(20), ;
ddate d, ;
dsalesstamp t, ;
nrevno n(2,0), ;
linside l, ;
ccashier c(10), ;
lmodifier l,;
cputime c(10), ;
cpudate c(10), ;
mhremark m, ;
nqty2 n(10,2), ;
cuom c(25), ;
cdesc2 c(50), ;
cdelivery c(25), ;
component c(25), ;
lprtkit l, ;
lprint l)

use &ctemp2 alias temptable2

 

[CJWARNER]

Maybe the field "dsalesstamp" is too long for a free table.
Change it to 10 characters or less and try it again.


==Carl
Carl Warner
VFUg Officer,

http://vfug.org:8080/

 

[Redsz]

Thx Carl. That was it

 

[RedLion]

Hi Redsz,

Your problem is due to the field dsalesstamp2. The reason is that the field name is longer then 8 characters, what is not allowed for free tables. So make the table part of a database, or chose a shorter name.


Charl

 

[RedLion]

While making the post Carl made the post ;-)