Hi,

At May 29, 2003, 09:23, Elvinas Piliponis wrote:

> Daniel Rail wrote:


>>
>> And, how is the query generated. All I found in VisualFOX
>> documentation on MSDN, was a reference that the DB_name is used if you
>> want the query to use a non-current database. So, I would suggest not

> I've tried to create a Remote SQL view and VisualFOX generates
> statement by itself, i.e. adds "DB_name." in front

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

Here's an example taken for the MSDN website:
OPEN DATABASE testdata
CREATE SQL VIEW product_remote_view ;
CONNECTION remote_01 ;
AS SELECT * FROM products

And, as you can see DB_name is not specified. Also, which version of
Visual Fox are you using? I've been reading the documentation for
version 8.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)