dbase easy question

[bboggessswcg]

I am converting a dbase file. I am reading a dbase file and then running an SQL statment that Selects everything in the file and then puts it into a new file. My problem is that if I add a field to this new file in my SQL statement then I need to be able to set the field width. Can anyone help with this??

 

[tedsmith]

I have done this but cant remember how!
I didnt add the field in the SQL statement but I think used a separate Add field line and EXECUTE thingy I found in help and wrote *30 for 30 characters in a string. Numbers automatically set depending on the type you specify (Eg 2 for an integer)