Thanks Cetin it's an idea...
Side question: Is there a command that will tell me if the table is "remote" or not?

>>I get "Function is not supported on remote tables (Error 1525)"
>>
>>What's the easiest way to add the column to the table?
>>Note that I have an additional consideration in that I may need
>>to add one to ten columns and the cursor could sometimes be very large
>>so a select is not the best.
>>
>>I was hoping for something like:
>>USE DBF("XXX") AGAIN IN 0 ALIAS yyy
>>ALTER TABLE yyy ADD &cPicGname g(4)
>>
>>
>>BR
>>Tim
>
>Tim,
>You might create a temp cursor in backend and cross join the tables. ie: With SQL server :
>
>

>lnHandle=SQLStringConnect('DRIVER=SQL Server;SERVER=Server;DATABASE=pubs;Trusted_Connection=Yes')
>SQLExec(lnHandle,;
>  'create table ##myDummy (myGen image, myChar varchar(20), myDate datetime, myDummy int)')
>SQLExec(lnHandle,'insert into ##myDummy (myDummy) values (0)')
>SQLExec(lnHandle,'select * from authors cross join ##myDummy','v_authors')
>SQLDisconnect(lnHandle)
>select v_authors
>browse
>

Cetin