Field Limit to Create Table Command?

[JICGreg]

I am using vfp 9.0 to programically create a table. The table has about 160 fields in it. The table "appears" to be created fine. But I know this is not the case. When using the table in subsequent operations, I get the error:
"field in table <tablename> did not match the entries into the database".

Same error with validate database.

The program calls for creating 160 fields (some with rather long names -- perhaps 15-20 characters). The program seems to work creating up to the 101st field and then when it creates the 102, I get the above referenced error.

I have also tried to use create table command for the first 101 fields and then alter table add column after that with the same error.

Any input or suggestions?

Thanks

 

[Dan Freeman]

Some code would help.

Are you using a &macro and running into the length limit of that?

 

[JICGreg]

No macro. The field names used in the create table are not "hard coded names", but are variables that are created in the earlier part of the program.

 

[Dan Freeman]

Then you REALLY should post some code showing how you're doing this, or how we can repro it.

We're not mind readers.

 

[JICGreg]

here is the code

STORE "sp_lm" TO prefix
STORE "returns_sp500_spmid" TO fileheading
DO create_tables

PROCEDURE create_tables
FOR x = 1 TO 12

STORE fileheading + "_" + ALLTRIM(STR(x)) + "month" TO filename


STORE 1 TO ma
STORE 1 TO percentile

STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "ma" + ALLTRIM(STR(ma)) TO var2
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "ma" + ALLTRIM(STR(ma+1)) TO var3
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "ma" + ALLTRIM(STR(ma+2)) TO var4
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "ma" + ALLTRIM(STR(ma+3)) TO var5

..... similar code between var6 and var13 then changes to .....

STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile)) + "ma" + ALLTRIM(STR(ma)) TO var14
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile)) + "ma" + ALLTRIM(STR(ma+1)) TO var15
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile)) + "ma" + ALLTRIM(STR(ma+2)) TO var16
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile)) + "ma" + ALLTRIM(STR(ma+3)) TO var17
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile)) + "ma" + ALLTRIM(STR(ma+4)) TO var18

..... similar code out to var157 .....


open database n:\development\research\capmkt\regression\data

if indbc("&filename", "table") = .T.
remove table &filename delete
else
endif

create table n:\development\research\capmkt\regression\returns\&filename database n:\development\research\capmkt\regression\data name &filename (date d, next1 n(10,4) null,;
next2 n(10,4) null, next3 n(10,4) null, next4 n(10,4) null,;
next5 n(10,4) null, next6 n(10,4) null, next7 n(10,4) null,;
next8 n(10,4) null, next9 n(10,4) null, next10 n(10,4) null,;
next11 n(10,4) null, next12 n(10,4) null, &var1 n(10,4) null, &var2 n(10,4) null,;
&var3 n(10,4) null, &var4 n(10,4) null, &var5 n(10,4) null,

..... out to var157 .....
endfor
endproc

 

[dgrewe]

I would use the alter table command for something that large. I know VFP9 increased the string length limit from 256 to 4180. Maybe you maxed out the 4k string limit when it tried to expand the macros.


David W. Grewe(Dave)

 

[JICGreg]

I have already tried alter table. I get to the same point (var102) and the error pops up.

 

[baltman]

And the value of var102 is...

 

[Dan Freeman]

OK, if you're unwilling to provide some code to repro this, I'll show you some code that has no problem going up to 250 fields.

*Begin
CLOSE DATABASES ALL
ERASE foo.*
CREATE DATABASE foo
CREATE TABLE Foo (FirstField c(10))
FOR x = 1 TO 250
varname = "foo" + TRANSFORM(x)
ALTER Table foo ADD COLUMN &varname N (10,4) Null
ENDFOR
MODIFY STRUCTURE
*End

Now what's different in ".... similar code out to ...." ???

It sounds like you've hard coded the CREATE TABLE statement but you said you haven't. And you also said you haven't used &macros but you have.

You're making it really hard to answer questions.

 

[JICGreg]

There is nothing special, as far as I can tell, about the var102 variable -- it is sp_lm_1mop6ma5. The variable before it would be ma4 and the one after should be ma6.

But there is something with that "spot" that the pgm does not like...

Dan:
When I say similar code out to var157 the only thing that changes is that percentile and ma are incremented. For example, after ma counts up to 12 (ma1,ma2...ma12) then percentile is incremented by 1 (p1ma1, p1ma2 ... p1ma12 then would go to p2ma1, p2ma2 ...p2ma12). This process continues until the last fields which would be p12ma1, p12ma2 ...p12ma12.

Remember, before all the "p1ma1" there is a prefix added on so the variable name is actually sp_lm_1mop1ma1.

I did not think people wanted this much code, but here it is:

SET CENTURY on
SET ESCAPE ON
CLOSE DATABASES all
CLOSE TABLES all

SET DEFAULT TO n:\development\research\capmkt\regression\returns


STORE "sp_lm" TO prefix
STORE "returns_sp500_spmid" TO fileheading
DO create_tables


PROCEDURE create_tables
FOR x = 1 TO 12

STORE fileheading + "_" + ALLTRIM(STR(x)) + "month" TO filename


STORE 1 TO ma
STORE 1 TO percentile

STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" TO var1

STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "ma" + ALLTRIM(STR(ma)) TO var2
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "ma" + ALLTRIM(STR(ma+1)) TO var3
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "ma" + ALLTRIM(STR(ma+2)) TO var4
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "ma" + ALLTRIM(STR(ma+3)) TO var5
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "ma" + ALLTRIM(STR(ma+4)) TO var6
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "ma" + ALLTRIM(STR(ma+5)) TO var7
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "ma" + ALLTRIM(STR(ma+6)) TO var8
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "ma" + ALLTRIM(STR(ma+7)) TO var9
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "ma" + ALLTRIM(STR(ma+8)) TO var10
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "ma" + ALLTRIM(STR(ma+9)) TO var11
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "ma" + ALLTRIM(STR(ma+10)) TO var12
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "ma" + ALLTRIM(STR(ma+11)) TO var13

STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile)) + "ma" + ALLTRIM(STR(ma)) TO var14
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile)) + "ma" + ALLTRIM(STR(ma+1)) TO var15
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile)) + "ma" + ALLTRIM(STR(ma+2)) TO var16
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile)) + "ma" + ALLTRIM(STR(ma+3)) TO var17
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile)) + "ma" + ALLTRIM(STR(ma+4)) TO var18
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile)) + "ma" + ALLTRIM(STR(ma+5)) TO var19
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile)) + "ma" + ALLTRIM(STR(ma+6)) TO var20
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile)) + "ma" + ALLTRIM(STR(ma+7)) TO var21
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile)) + "ma" + ALLTRIM(STR(ma+8)) TO var22
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile)) + "ma" + ALLTRIM(STR(ma+9)) TO var23
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile)) + "ma" + ALLTRIM(STR(ma+10)) TO var24
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile)) + "ma" + ALLTRIM(STR(ma+11)) TO var25

STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+1)) + "ma" + ALLTRIM(STR(ma)) TO var26
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+1)) + "ma" + ALLTRIM(STR(ma+1)) TO var27
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+1)) + "ma" + ALLTRIM(STR(ma+2)) TO var28
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+1)) + "ma" + ALLTRIM(STR(ma+3)) TO var29
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+1)) + "ma" + ALLTRIM(STR(ma+4)) TO var30
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+1)) + "ma" + ALLTRIM(STR(ma+5)) TO var31
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+1)) + "ma" + ALLTRIM(STR(ma+6)) TO var32
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+1)) + "ma" + ALLTRIM(STR(ma+7)) TO var33
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+1)) + "ma" + ALLTRIM(STR(ma+8)) TO var34
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+1)) + "ma" + ALLTRIM(STR(ma+9)) TO var35
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+1)) + "ma" + ALLTRIM(STR(ma+10)) TO var36
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+1)) + "ma" + ALLTRIM(STR(ma+11)) TO var37

STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+2)) + "ma" + ALLTRIM(STR(ma)) TO var38
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+2)) + "ma" + ALLTRIM(STR(ma+1)) TO var39
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+2)) + "ma" + ALLTRIM(STR(ma+2)) TO var40
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+2)) + "ma" + ALLTRIM(STR(ma+3)) TO var41
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+2)) + "ma" + ALLTRIM(STR(ma+4)) TO var42
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+2)) + "ma" + ALLTRIM(STR(ma+5)) TO var43
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+2)) + "ma" + ALLTRIM(STR(ma+6)) TO var44
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+2)) + "ma" + ALLTRIM(STR(ma+7)) TO var45
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+2)) + "ma" + ALLTRIM(STR(ma+8)) TO var46
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+2)) + "ma" + ALLTRIM(STR(ma+9)) TO var47
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+2)) + "ma" + ALLTRIM(STR(ma+10)) TO var48
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+2)) + "ma" + ALLTRIM(STR(ma+11)) TO var49

STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+3)) + "ma" + ALLTRIM(STR(ma)) TO var50
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+3)) + "ma" + ALLTRIM(STR(ma+1)) TO var51
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+3)) + "ma" + ALLTRIM(STR(ma+2)) TO var52
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+3)) + "ma" + ALLTRIM(STR(ma+3)) TO var53
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+3)) + "ma" + ALLTRIM(STR(ma+4)) TO var54
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+3)) + "ma" + ALLTRIM(STR(ma+5)) TO var55
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+3)) + "ma" + ALLTRIM(STR(ma+6)) TO var56
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+3)) + "ma" + ALLTRIM(STR(ma+7)) TO var57
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+3)) + "ma" + ALLTRIM(STR(ma+8)) TO var58
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+3)) + "ma" + ALLTRIM(STR(ma+9)) TO var59
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+3)) + "ma" + ALLTRIM(STR(ma+10)) TO var60
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+3)) + "ma" + ALLTRIM(STR(ma+11)) TO var61

STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+4)) + "ma" + ALLTRIM(STR(ma)) TO var62
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+4)) + "ma" + ALLTRIM(STR(ma+1)) TO var63
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+4)) + "ma" + ALLTRIM(STR(ma+2)) TO var64
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+4)) + "ma" + ALLTRIM(STR(ma+3)) TO var65
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+4)) + "ma" + ALLTRIM(STR(ma+4)) TO var66
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+4)) + "ma" + ALLTRIM(STR(ma+5)) TO var67
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+4)) + "ma" + ALLTRIM(STR(ma+6)) TO var68
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+4)) + "ma" + ALLTRIM(STR(ma+7)) TO var69
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+4)) + "ma" + ALLTRIM(STR(ma+8)) TO var70
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+4)) + "ma" + ALLTRIM(STR(ma+9)) TO var71
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+4)) + "ma" + ALLTRIM(STR(ma+10)) TO var72
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+4)) + "ma" + ALLTRIM(STR(ma+11)) TO var73

STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+5)) + "ma" + ALLTRIM(STR(ma)) TO var74
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+5)) + "ma" + ALLTRIM(STR(ma+1)) TO var75
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+5)) + "ma" + ALLTRIM(STR(ma+2)) TO var76
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+5)) + "ma" + ALLTRIM(STR(ma+3)) TO var77
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+5)) + "ma" + ALLTRIM(STR(ma+4)) TO var78
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+5)) + "ma" + ALLTRIM(STR(ma+5)) TO var79
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+5)) + "ma" + ALLTRIM(STR(ma+6)) TO var80
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+5)) + "ma" + ALLTRIM(STR(ma+7)) TO var81
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+5)) + "ma" + ALLTRIM(STR(ma+8)) TO var82
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+5)) + "ma" + ALLTRIM(STR(ma+9)) TO var83
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+5)) + "ma" + ALLTRIM(STR(ma+10)) TO var84
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+5)) + "ma" + ALLTRIM(STR(ma+11)) TO var85

STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+6)) + "ma" + ALLTRIM(STR(ma)) TO var86
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+6)) + "ma" + ALLTRIM(STR(ma+1)) TO var87
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+6)) + "ma" + ALLTRIM(STR(ma+2)) TO var88
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+6)) + "ma" + ALLTRIM(STR(ma+3)) TO var89
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+6)) + "ma" + ALLTRIM(STR(ma+4)) TO var90
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+6)) + "ma" + ALLTRIM(STR(ma+5)) TO var91
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+6)) + "ma" + ALLTRIM(STR(ma+6)) TO var92
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+6)) + "ma" + ALLTRIM(STR(ma+7)) TO var93
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+6)) + "ma" + ALLTRIM(STR(ma+8)) TO var94
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+6)) + "ma" + ALLTRIM(STR(ma+9)) TO var95
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+6)) + "ma" + ALLTRIM(STR(ma+10)) TO var96
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+6)) + "ma" + ALLTRIM(STR(ma+11)) TO var97

STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+7)) + "ma" + ALLTRIM(STR(ma)) TO var98
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+7)) + "ma" + ALLTRIM(STR(ma+1)) TO var99
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+7)) + "ma" + ALLTRIM(STR(ma+2)) TO var100
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+7)) + "ma" + ALLTRIM(STR(ma+3)) TO var101
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+7)) + "ma" + ALLTRIM(STR(ma+4)) TO var102
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+7)) + "ma" + ALLTRIM(STR(ma+5)) TO var103
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+7)) + "ma" + ALLTRIM(STR(ma+6)) TO var104
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+7)) + "ma" + ALLTRIM(STR(ma+7)) TO var105
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+7)) + "ma" + ALLTRIM(STR(ma+8)) TO var106
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+7)) + "ma" + ALLTRIM(STR(ma+9)) TO var107
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+7)) + "ma" + ALLTRIM(STR(ma+10)) TO var108
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+7)) + "ma" + ALLTRIM(STR(ma+11)) TO var109

STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+8)) + "ma" + ALLTRIM(STR(ma)) TO var110
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+8)) + "ma" + ALLTRIM(STR(ma+1)) TO var111
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+8)) + "ma" + ALLTRIM(STR(ma+2)) TO var112
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+8)) + "ma" + ALLTRIM(STR(ma+3)) TO var113
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+8)) + "ma" + ALLTRIM(STR(ma+4)) TO var114
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+8)) + "ma" + ALLTRIM(STR(ma+5)) TO var115
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+8)) + "ma" + ALLTRIM(STR(ma+6)) TO var116
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+8)) + "ma" + ALLTRIM(STR(ma+7)) TO var117
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+8)) + "ma" + ALLTRIM(STR(ma+8)) TO var118
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+8)) + "ma" + ALLTRIM(STR(ma+9)) TO var119
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+8)) + "ma" + ALLTRIM(STR(ma+10)) TO var120
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+8)) + "ma" + ALLTRIM(STR(ma+11)) TO var121

STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+9)) + "ma" + ALLTRIM(STR(ma)) TO var122
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+9)) + "ma" + ALLTRIM(STR(ma+1)) TO var123
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+9)) + "ma" + ALLTRIM(STR(ma+2)) TO var124
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+9)) + "ma" + ALLTRIM(STR(ma+3)) TO var125
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+9)) + "ma" + ALLTRIM(STR(ma+4)) TO var126
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+9)) + "ma" + ALLTRIM(STR(ma+5)) TO var127
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+9)) + "ma" + ALLTRIM(STR(ma+6)) TO var128
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+9)) + "ma" + ALLTRIM(STR(ma+7)) TO var129
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+9)) + "ma" + ALLTRIM(STR(ma+8)) TO var130
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+9)) + "ma" + ALLTRIM(STR(ma+9)) TO var131
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+9)) + "ma" + ALLTRIM(STR(ma+10)) TO var132
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+9)) + "ma" + ALLTRIM(STR(ma+11)) TO var133

STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+10)) + "ma" + ALLTRIM(STR(ma)) TO var134
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+10)) + "ma" + ALLTRIM(STR(ma+1)) TO var135
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+10)) + "ma" + ALLTRIM(STR(ma+2)) TO var136
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+10)) + "ma" + ALLTRIM(STR(ma+3)) TO var137
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+10)) + "ma" + ALLTRIM(STR(ma+4)) TO var138
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+10)) + "ma" + ALLTRIM(STR(ma+5)) TO var139
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+10)) + "ma" + ALLTRIM(STR(ma+6)) TO var140
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+10)) + "ma" + ALLTRIM(STR(ma+7)) TO var141
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+10)) + "ma" + ALLTRIM(STR(ma+8)) TO var142
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+10)) + "ma" + ALLTRIM(STR(ma+9)) TO var143
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+10)) + "ma" + ALLTRIM(STR(ma+10)) TO var144
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+10)) + "ma" + ALLTRIM(STR(ma+11)) TO var145

STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+11)) + "ma" + ALLTRIM(STR(ma)) TO var146
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+11)) + "ma" + ALLTRIM(STR(ma+1)) TO var147
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+11)) + "ma" + ALLTRIM(STR(ma+2)) TO var148
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+11)) + "ma" + ALLTRIM(STR(ma+3)) TO var149
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+11)) + "ma" + ALLTRIM(STR(ma+4)) TO var150
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+11)) + "ma" + ALLTRIM(STR(ma+5)) TO var151
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+11)) + "ma" + ALLTRIM(STR(ma+6)) TO var152
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+11)) + "ma" + ALLTRIM(STR(ma+7)) TO var153
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+11)) + "ma" + ALLTRIM(STR(ma+8)) TO var154
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+11)) + "ma" + ALLTRIM(STR(ma+9)) TO var155
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+11)) + "ma" + ALLTRIM(STR(ma+10)) TO var156
STORE prefix + "_" + ALLTRIM(STR(x)) + "mo" + "p"+ ALLTRIM(STR(percentile+11)) + "ma" + ALLTRIM(STR(ma+11)) TO var157


open database n:\development\research\capmkt\regression\data


if indbc("&filename", "table") = .T.
remove table &filename delete
else
endif

create table n:\development\research\capmkt\regression\returns\&filename database n:\development\research\capmkt\regression\data name &filename (date d, next1 n(10,4) null,;
next2 n(10,4) null, next3 n(10,4) null, next4 n(10,4) null,;
next5 n(10,4) null, next6 n(10,4) null, next7 n(10,4) null,;
next8 n(10,4) null, next9 n(10,4) null, next10 n(10,4) null,;
next11 n(10,4) null, next12 n(10,4) null, &var1 n(10,4) null, &var2 n(10,4) null,;
&var3 n(10,4) null, &var4 n(10,4) null, &var5 n(10,4) null, &var6 n(10,4) null, &var7 n(10,4) null,;
&var8 n(10,4) null, &var9 n(10,4) null, &var10 n(10,4) null, &var11 n(10,4) null, &var12 n(10,4) null,;
&var13 n(10,4) null, &var14 n(10,4) null, &var15 n(10,4) null, &var16 n(10,4) null, &var17 n(10,4) null,;
&var18 n(10,4) null, &var19 n(10,4) null, &var20 n(10,4) null, &var21 n(10,4) null, &var22 n(10,4) null,;
&var23 n(10,4) null, &var24 n(10,4) null, &var25 n(10,4) null, &var26 n(10,4) null, &var27 n(10,4) null,;
&var28 n(10,4) null, &var29 n(10,4) null, &var30 n(10,4) null, &var31 n(10,4) null, &var32 n(10,4) null,;
&var33 n(10,4) null, &var34 n(10,4) null, &var35 n(10,4) null, &var36 n(10,4) null, &var37 n(10,4) null,;
&var38 n(10,4) null, &var39 n(10,4) null, &var40 n(10,4) null, &var41 n(10,4) null, &var42 n(10,4) null,;
&var43 n(10,4) null, &var44 n(10,4) null, &var45 n(10,4) null, &var46 n(10,4) null, &var47 n(10,4) null,;
&var48 n(10,4) null, &var49 n(10,4) null, &var50 n(10,4) null, &var51 n(10,4) null, &var52 n(10,4) NULL,;
&var53 n(10,4) null, &var54 n(10,4) null, &var55 n(10,4) null, &var56 n(10,4) null, &var57 n(10,4) null,;
&var58 n(10,4) null, &var59 n(10,4) null, &var60 n(10,4) null, &var61 n(10,4) null, &var62 n(10,4) NULL,;
&var63 n(10,4) null, &var64 n(10,4) null, &var65 n(10,4) null, &var66 n(10,4) null, &var67 n(10,4) null,;
&var68 n(10,4) null, &var69 n(10,4) null, &var70 n(10,4) null, &var71 n(10,4) null, &var72 n(10,4) null,;
&var73 n(10,4) null, &var74 n(10,4) null, &var75 n(10,4) null, &var76 n(10,4) null, &var77 n(10,4) null,;
&var78 n(10,4) null, &var79 n(10,4) null, &var80 n(10,4) null, &var81 n(10,4) null, &var82 n(10,4) null,;
&var83 n(10,4) null, &var84 n(10,4) null, &var85 n(10,4) null, &var86 n(10,4) null, &var87 n(10,4) null,;
&var88 n(10,4) null, &var89 n(10,4) null, &var90 n(10,4) null, &var91 n(10,4) null, &var92 n(10,4) null,;
&var93 n(10,4) null, &var94 n(10,4) null, &var95 n(10,4) null, &var96 n(10,4) null, &var97 n(10,4) null,;
&var98 n(10,4) null, &var99 n(10,4) null, &var100 n(10,4) null, &var101 n(10,4) null, &var102 n(10,4) null,;
&var103 n(10,4) null, &var104 n(10,4) null, &var105 n(10,4) null, &var106 n(10,4) null, &var107 n(10,4) null,;
&var108 n(10,4) null, &var109 n(10,4) null, &var110 n(10,4) null, &var111 n(10,4) null, &var112 n(10,4) null,;
&var113 n(10,4) null, &var114 n(10,4) null, &var115 n(10,4) null, &var116 n(10,4) null, &var117 n(10,4) null,;
&var118 n(10,4) null, &var119 n(10,4) null, &var120 n(10,4) null, &var121 n(10,4) null, &var122 n(10,4) null,;
&var123 n(10,4) null, &var124 n(10,4) null, &var125 n(10,4) null, &var126 n(10,4) null, &var127 n(10,4) NULL,;
&var128 n(10,4) null, &var129 n(10,4) null, &var130 n(10,4) null, &var131 n(10,4) null, &var132 n(10,4) null,;
&var133 n(10,4) null, &var134 n(10,4) null, &var135 n(10,4) null, &var136 n(10,4) null, &var137 n(10,4) null,;
&var138 n(10,4) null, &var139 n(10,4) null, &var140 n(10,4) null, &var141 n(10,4) null, &var142 n(10,4) null,;
&var143 n(10,4) null, &var144 n(10,4) null, &var145 n(10,4) null, &var146 n(10,4) null, &var147 n(10,4) null,;
&var148 n(10,4) null, &var149 n(10,4) null, &var150 n(10,4) null, &var151 n(10,4) null, &var152 n(10,4) null,;
&var153 n(10,4) null, &var154 n(10,4) null, &var155 n(10,4) null, &var156 n(10,4) null, &var157 n(10,4) null)
ENDFOR
endproc

 

[StewartUK]

I copied your program and ran it without any problems!

I was sure from your postings whether you get the error while creating the tables or when using them. It might help if you would clarify that.

I don't know if that helps you at all, but there would seem to be nothing wrong with the code.

Stewart

 

[StewartUK]

I posted too soon!

I closed VFP and reopened it, opened the database your code creates and then tried to use one of the tables, which is when I got the error you mention in your first post.

2 lists follow:
The first one is the listing of records in data.dbc
The second is the structure of returns_sp500_spmid_1month

ObjectId   ParentId   ObjectType ObjectName
1          1          Database   Database  
   
2          1          Database   TransactionLog  
3          1          Database   StoredProceduresSource
4          1          Database   StoredProceduresObject
5          1          Database   StoredProceduresDependencies
6          1          Table      returns_sp500_spmid_1month
7          6          Field      date            
8          6          Field      next1           
9          6          Field      next2           
10         6          Field      next3           
11         6          Field      next4           
12         6          Field      next5           
13         6          Field      next6           
14         6          Field      next7           
15         6          Field      next8           
16         6          Field      next9           
17         6          Field      next10          
18         6          Field      next11          
19         6          Field      next12          
20         6          Field      sp_lm_1mo       
21         6          Field      sp_lm_1moma1    
22         6          Field      sp_lm_1moma2    
23         6          Field      sp_lm_1moma3    
24         6          Field      sp_lm_1moma4    
25         6          Field      sp_lm_1moma5    
26         6          Field      sp_lm_1moma6    
27         6          Field      sp_lm_1moma7    
28         6          Field      sp_lm_1moma8    
29         6          Field      sp_lm_1moma9    
30         6          Field      sp_lm_1moma10   
31         6          Field      sp_lm_1moma11   
32         6          Field      sp_lm_1moma12   
33         6          Field      sp_lm_1mop1ma1  
34         6          Field      sp_lm_1mop1ma2  
35         6          Field      sp_lm_1mop1ma3  
36         6          Field      sp_lm_1mop1ma4  
37         6          Field      sp_lm_1mop1ma5  
38         6          Field      sp_lm_1mop1ma6  
39         6          Field      sp_lm_1mop1ma7  
40         6          Field      sp_lm_1mop1ma8  
41         6          Field      sp_lm_1mop1ma9  
42         6          Field      sp_lm_1mop1ma10 
43         6          Field      sp_lm_1mop1ma11 
44         6          Field      sp_lm_1mop1ma12 
45         6          Field      sp_lm_1mop2ma1  
46         6          Field      sp_lm_1mop2ma2  
47         6          Field      sp_lm_1mop2ma3  
48         6          Field      sp_lm_1mop2ma4  
49         6          Field      sp_lm_1mop2ma5  
50         6          Field      sp_lm_1mop2ma6  
51         6          Field      sp_lm_1mop2ma7  
52         6          Field      sp_lm_1mop2ma8  
53         6          Field      sp_lm_1mop2ma9  
54         6          Field      sp_lm_1mop2ma10 
55         6          Field      sp_lm_1mop2ma11 
56         6          Field      sp_lm_1mop2ma12 
57         6          Field      sp_lm_1mop3ma1  
58         6          Field      sp_lm_1mop3ma2  
59         6          Field      sp_lm_1mop3ma3  
60         6          Field      sp_lm_1mop3ma4  
61         6          Field      sp_lm_1mop3ma5  
62         6          Field      sp_lm_1mop3ma6  
63         6          Field      sp_lm_1mop3ma7  
64         6          Field      sp_lm_1mop3ma8  
65         6          Field      sp_lm_1mop3ma9  
66         6          Field      sp_lm_1mop3ma10 
67         6          Field      sp_lm_1mop3ma11 
68         6          Field      sp_lm_1mop3ma12 
69         6          Field      sp_lm_1mop4ma1  
70         6          Field      sp_lm_1mop4ma2  
71         6          Field      sp_lm_1mop4ma3  
72         6          Field      sp_lm_1mop4ma4  
73         6          Field      sp_lm_1mop4ma5  
74         6          Field      sp_lm_1mop4ma6  
75         6          Field      sp_lm_1mop4ma7  
76         6          Field      sp_lm_1mop4ma8  
77         6          Field      sp_lm_1mop4ma9  
78         6          Field      sp_lm_1mop4ma10 
79         6          Field      sp_lm_1mop4ma11 
80         6          Field      sp_lm_1mop4ma12 
81         6          Field      sp_lm_1mop5ma1  
82         6          Field      sp_lm_1mop5ma2  
83         6          Field      sp_lm_1mop5ma3  
84         6          Field      sp_lm_1mop5ma4  
85         6          Field      sp_lm_1mop5ma5  
86         6          Field      sp_lm_1mop5ma6  
87         6          Field      sp_lm_1mop5ma7  
88         6          Field      sp_lm_1mop5ma8  
89         6          Field      sp_lm_1mop5ma9  
90         6          Field      sp_lm_1mop5ma10 
91         6          Field      sp_lm_1mop5ma11 
92         6          Field      sp_lm_1mop5ma12 
93         6          Field      sp_lm_1mop6ma1  
94         6          Field      sp_lm_1mop6ma2  
95         6          Field      sp_lm_1mop6ma3  
96         6          Field      sp_lm_1mop6ma4  
97         6          Field      sp_lm_1mop6ma5  
98         6          Field      sp_lm_1mop6ma6  
99         6          Field      sp_lm_1mop6ma7  
100        6          Field      sp_lm_1mop6ma8  
101        6          Field      sp_lm_1mop6ma9  
102        6          Field      sp_lm_1mop6ma10 
103        6          Field      sp_lm_1mop6ma11 
104        6          Field      sp_lm_1mop6ma12 
105        6          Field      sp_lm_1mop7ma1  
106        6          Field      sp_lm_1mop7ma2  
107        6          Field      sp_lm_1mop7ma3  
108        6          Field      sp_lm_1mop7ma4  
109        6          Field      sp_lm_1mop7ma5  
110        6          Field      sp_lm_1mop7ma6  
111        6          Field      sp_lm_1mop7ma7  
112        6          Field      sp_lm_1mop7ma8  
113        6          Field      sp_lm_1mop7ma9  
114        6          Field      sp_lm_1mop7ma10 
115        6          Field      sp_lm_1mop7ma11 
116        6          Field      sp_lm_1mop7ma12 
117        6          Field      sp_lm_1mop8ma1  
118        6          Field      sp_lm_1mop8ma2  
119        6          Field      sp_lm_1mop8ma3  
120        6          Field      sp_lm_1mop8ma4  
121        6          Field      sp_lm_1mop8ma5  
122        6          Field      sp_lm_1mop8ma6  
123        6          Field      sp_lm_1mop8ma7  
124        6          Field      sp_lm_1mop8ma8  
125        6          Field      sp_lm_1mop8ma9  
126        6          Field      sp_lm_1mop8ma10 
127        6          Field      sp_lm_1mop8ma11 
128        6          Field      sp_lm_1mop8ma12 
129        6          Field      sp_lm_1mop9ma1  
130        6          Field      sp_lm_1mop9ma2  
131        6          Field      sp_lm_1mop9ma3  
132        6          Field      sp_lm_1mop9ma4  
133        6          Field      sp_lm_1mop9ma5  
134        6          Field      sp_lm_1mop9ma6  
135        6          Field      sp_lm_1mop9ma7  
136        6          Field      sp_lm_1mop9ma8  
137        6          Field      sp_lm_1mop9ma9  
138        6          Field      sp_lm_1mop9ma10 
139        6          Field      sp_lm_1mop9ma11 
140        6          Field      sp_lm_1mop9ma12 
141        6          Field      sp_lm_1mop10ma1 
142        6          Field      sp_lm_1mop10ma2 
143        6          Field      sp_lm_1mop10ma3 
144        6          Field      sp_lm_1mop10ma4 
145        6          Field      sp_lm_1mop10ma5 
146        6          Field      sp_lm_1mop10ma6 
147        6          Field      sp_lm_1mop10ma7 
148        6          Field      sp_lm_1mop10ma8 
149        6          Field      sp_lm_1mop10ma9 
150        6          Field      sp_lm_1mop10ma10
151        6          Field      sp_lm_1mop10ma11
152        6          Field      sp_lm_1mop10ma12
153        6          Field      sp_lm_1mop11ma1 
154        6          Field      sp_lm_1mop11ma2 
155        6          Field      sp_lm_1mop11ma3 
156        6          Field      sp_lm_1mop11ma4 
157        6          Field      sp_lm_1mop11ma5 
158        6          Field      sp_lm_1mop11ma6 
159        6          Field      sp_lm_1mop11ma7 
160        6          Field      sp_lm_1mop11ma8 
161        6          Field      sp_lm_1mop11ma9 
162        6          Field      sp_lm_1mop11ma10
163        6          Field      sp_lm_1mop11ma11
164        6          Field      sp_lm_1mop11ma12
165        6          Field      sp_lm_1mop12ma1 
166        6          Field      sp_lm_1mop12ma2 
167        6          Field      sp_lm_1mop12ma3 
168        6          Field      sp_lm_1mop12ma4 
169        6          Field      sp_lm_1mop12ma5 
170        6          Field      sp_lm_1mop12ma6 
171        6          Field      sp_lm_1mop12ma7 
172        6          Field      sp_lm_1mop12ma8 
173        6          Field      sp_lm_1mop12ma9 
174        6          Field      sp_lm_1mop12ma10
175        6          Field      sp_lm_1mop12ma11
176        6          Field      sp_lm_1mop12ma12

DATE
NEXT1
NEXT2
NEXT3
NEXT4
NEXT5
NEXT6
NEXT7
NEXT8
NEXT9
NEXT10
NEXT11
NEXT12
SP_LM_1MO
SP_LM_1MOM 
SP_LM_1MO2 
SP_LM_1MO3 
SP_LM_1MO4 
SP_LM_1MO5 
SP_LM_1MO6 
SP_LM_1MO7 
SP_LM_1MO8 
SP_LM_1MO9 
SP_LM_1M10 
SP_LM_1M11 
SP_LM_1M12 
SP_LM_1MOP 
SP_LM_1M13 
SP_LM_1M14 
SP_LM_1M15 
SP_LM_1M16 
SP_LM_1M17 
SP_LM_1M18 
SP_LM_1M19 
SP_LM_1M20 NS
SP_LM_1M21 N]
SP_LM_1M22 Ng
SP_LM_1M23 Nq
SP_LM_1M24 N{
SP_LM_1M25 N…
SP_LM_1M26 N?
SP_LM_1M27 N™
SP_LM_1M28 N£
SP_LM_1M29 N­
SP_LM_1M30 N·
SP_LM_1M31 NÁ
SP_LM_1M32 NË
SP_LM_1M33 NÕ
SP_LM_1M34 Nß
SP_LM_1M35 Né
SP_LM_1M36 Nó
SP_LM_1M37 Ný
SP_LM_1M38 N
SP_LM_1M39 N
SP_LM_1M40 N
SP_LM_1M41 N%
SP_LM_1M42 N/
SP_LM_1M43 N9
SP_LM_1M44 NC
SP_LM_1M45 NM
SP_LM_1M46 NW
SP_LM_1M47 Na
SP_LM_1M48 Nk
SP_LM_1M49 Nu
SP_LM_1M50 N
SP_LM_1M51 N‰
SP_LM_1M52 N“
SP_LM_1M53 N?
SP_LM_1M54 N§
SP_LM_1M55 N±
SP_LM_1M56 N»
SP_LM_1M57 NÅ
SP_LM_1M58 NÏ
SP_LM_1M59 NÙ
SP_LM_1M60 Nã
SP_LM_1M61 Ní
SP_LM_1M62 N÷
SP_LM_1M63 N

SP_LM_1M64 N
SP_LM_1M65 N
SP_LM_1M66 N
SP_LM_1M67 N)
SP_LM_1M68 N3
SP_LM_1M69 N=
SP_LM_1M70 NG
SP_LM_1M71 NQ
SP_LM_1M72 N[
SP_LM_1M73 Ne
SP_LM_1M74 No
SP_LM_1M75 Ny
SP_LM_1M76 Nƒ
SP_LM_1M77 N?
SP_LM_1M78 N—
SP_LM_1M79 N¡
SP_LM_1M80 N«
SP_LM_1M81 Nµ
SP_LM_1M82 N¿
SP_LM_1M83 NÉ
SP_LM_1M84 NÓ
SP_LM_1M85 NÝ
SP_LM_1M86 Nç
SP_LM_1M87 Nñ
SP_LM_1M88 Nû
SP_LM_1M89 N
SP_LM_1M90 N
SP_LM_1M91 N
SP_LM_1M92 N#
SP_LM_1M93 N-
SP_LM_1M94 N7
SP_LM_1M95 NA
SP_LM_1M96 NK
SP_LM_1M97 NU
SP_LM_1M98 N_
SP_LM_1M99 Ni
SP_LM_1100 Ns
SP_LM_1101 N}
SP_LM_1102 N‡
SP_LM_1103 N‘
SP_LM_1104 N›
SP_LM_1105 N¥
SP_LM_1106 N¯
SP_LM_1107 N¹
SP_LM_1108 NÃ
SP_LM_1109 NÍ
SP_LM_1110 N×
SP_LM_1111 Ná
SP_LM_1112 Në
SP_LM_1113 Nõ
SP_LM_1114 Nÿ
SP_LM_1115 N	
SP_LM_1116 N
SP_LM_1117 N
SP_LM_1118 N'
SP_LM_1119 N1
SP_LM_1120 N;
SP_LM_1121 NE
SP_LM_1122 NO
SP_LM_1123 NY
SP_LM_1124 Nc
SP_LM_1125 Nm
SP_LM_1126 Nw
SP_LM_1127 N?
SP_LM_1128 N‹
SP_LM_1129 N•
SP_LM_1130 NŸ
SP_LM_1131 N©
SP_LM_1132 N³
SP_LM_1133 N½
SP_LM_1134 NÇ
SP_LM_1135 NÑ
SP_LM_1136 NÛ
SP_LM_1137 Nå
SP_LM_1138 Nï
SP_LM_1139 Nù
SP_LM_1140 N
SP_LM_1141 N  
SP_LM_1142 N
SP_LM_1143 N!
SP_LM_1144 N+
SP_LM_1145 N5
SP_LM_1146 N?
SP_LM_1147 NI
SP_LM_1148 NS
SP_LM_1149 N]
SP_LM_1150 Ng
SP_LM_1151 Nq
SP_LM_1152 N{
SP_LM_1153 N…
SP_LM_1154 N?
SP_LM_1155 N™
_NullFlags 0£
..\data.dbc

Hope that helps,

Stewart
PS If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[JICGreg]

StewartUK

I appreciate what you have done, but I don't really know how to interpret the info. Can you provide any guidance?

Thanks

 

[Dan Freeman]

It looks like you need to make sure the first 10 chars are unique in field names.

 

[JICGreg]

Thank you everyone for your suggestions. After looking at StewartUK display structure, I was puzzled as to why the
structure went from
SP_LM_1MO9

to

SP_LM_1M10
SP_LM_1M11
SP_LM_1M12

...losing the "o".

So, what I did was change the prefix to simply "S" and the pgm worked fine and validate database gave no errors. If I used "SP" (1 additional character) pgm would not work.

So it appears (without thoroughly checking) danfreeman's statement about making the first 10 characters unique is correct.