SQL alter table / macro subst 1

[MrFancyteeth]

I'm trying to create a common structure for several dbf files. The Fieldname,Fieldtype and fieldwidth are stored in a cursor.

i'm then scanning through the cursor and using SQL alter table to modify and existing table structure

SELECT curstrus
scan

cfname=curstrus.fname
cftype=curstrus.ftype
nfsize=curstrus.fsize

ALTER TABLE tabresult ADD COLUMN &fname &ftype(&nfsize)

ENDSCAN

The problem occurs in the field size (&nfsize) part

any ideas?

mrF

 

[monikai]

Try create string

zm_s='ALTER TABLE tabresult ADD COLUMN '+alltrim(fname)+' '+alltrim(ftype)+'('+alltrim(str(nfsize))+')'
&zm_s



Monika from Warszawa (Poland)
(monikai@yahoo.com)

 

[MrFancyteeth]

Many thanx

Works like new

mrF