Michale

> I have a table need to add fields to a exact number? How can I do it? The following code have error ,How to change it?

To add to Sergey's correct reply that fieldnames cannot begin with a number, here is a way to do this.

LOCAL lni, lcFld
CREATE TABLE Temp (Field1 N(8))
FOR lni = FCOUNT("TEMP") + 1 TO 38
	lcFld = "Field" + LTRIM(STR(lni,2))
	ALTER TABLE Temp ADD COLUMN &lcFld N(8)
NEXT lni
BROWSE