Hi,

I'm no expert in Firebird but am developing in Visual Fox Pro 7.0
using a Firebird server (nor a Fox expert either).

To connect to the server I use the Gemini ODBC drivers. It work's
fine. To create remote views just use the Views Designer. The SQL
statements: I send them throught the sqlexec() function. The sintax
would just be "select * from Table_name", or if you want to pass some
paramentes just do "select * from table_name where Id = ?m.Code",
where Code is not a cursor field, but a simple variable.

Server is runing on WinNT.

hope it helps,

Pablo Lerner

--- In ib-support@yahoogroups.com, Daniel Rail <daniel@a...> wrote:
> 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)