Use MyTable in 0
if fsize("SomeField")<30 && field size is zero (d not exist) or less than 30
  Use MyTable in "MyTable" EXCLUSIVE && exclusive use is required fro table structure altering
  if fsize("SomeField") = 0 && field do not exist
    ALTER TABLE MyTable ADD COLUMN SomeField C(30)
  else
    ALTER TABLE MyTable ALTER COLUMN SomeField C(30)
  endif
endif


HTH.

>I have distribuited an aplication with some tables
> Now I updated my .exe and will send it to my client.
>
> There's a problem: Some fields of client's table are
> too short or do not exist.
>
> How can I build a little code to proceed to changes as below:
>
>  Change 1
>  If field1 size is < than 30
>  Then icrease it's size to 50
>
>  Change 2
>  If field2 does not existe
>  Then create field2
>
>
>  Thanks
>
>  Moisés
>
>
>
>
>
>

Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.