Hello Daniel,

Thursday, May 29, 2003, 12:42:43 PM, you wrote:

Thank you

DR> What is the CREATE VIEW statement in Visual Fox? Have you tried using
DR> the CONNECTION keyword in it, instead of REMOTE? In the documentation
DR> it mentions that if you use CONNECTION in CREATE VIEW, you don't have
DR> to specify the DB_name in the SELECT.

CREATE SQL VIEW NOM_V REMOTE CONNECTION GAM_FB as select * from cechai
Worked flawlessly
Although only with FireBird/Intergase ODBC drivers. XTG ODBC driver
connection complained: Connectivity error: Unable to retrieve specific
errorr information. Driver is probably out of resources.

Thanks again. Now I won't have to recreate whole DB structure in
another DB

Looks i've spent too much time in front of PC. Need to have some more rest
to be able to think :(


Informatikas - diagnozė, o ne specialybė
Elvinas Piliponis mailto:elvinas.piliponis@...