>On the following code example in VFP7...
>
>SQLEXEC(h,'select * from ARTICLE',"XXX")
>ALTER TABLE XXX ADD &cPicGname g(4)
>
>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