Check with cursorgetprop('SourceType',lcAliasName)
If remote then return value is 2.
Cetin
>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