Remote View Problem 
Author Message
 Remote View Problem
I am developing a program which SQLServer 6.5 as the backend and Vfp5.0 as
the frontend.
I want to create a remote view in Vfp that need two table from different
Sqlserver databases. But i can't.
Pls HELP ME!
Thx.


Thu, 15 Feb 2001 03:00:00 GMT
 Remote View Problem

Addie
Create three views, one for each SQLServer database and one based on these
two views. You can create views of views. This may not be the best solution
but you haven't described the errors you're getting or where you're geting
stuck or if yo've been asble to create any view at all.
-Anders
Quote:

>I am developing a program which SQLServer 6.5 as the backend and Vfp5.0 as
>the frontend.
>I want to create a remote view in Vfp that need two table from different
>Sqlserver databases. But i can't.
>Pls HELP ME!
>Thx.



Thu, 15 Feb 2001 03:00:00 GMT
 Remote View Problem
Created the view from the View Designer.  (Just the basic view
without how many WHERE clause parameters.)

Then, using the SQLGetProp command, look at the settings you created
from the View Designer.  This should provide you with an exceptional
fast start of SQLSetProp.  Microsoft has provided us with such a
great quick start (although I hate to complement them).

As a side note ... so often it is easy to use Microsoft's macro
recording program in Excel and then to replay them from VFP.  We
don't have to reinvent the wheel.

Quote:

>I am developing a program which SQLServer 6.5 as the backend and Vfp5.0 as
>the frontend.
>I want to create a remote view in Vfp that need two table from different
>Sqlserver databases. But i can't.
>Pls HELP ME!
>Thx.



Fri, 16 Feb 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Update by SQl Pass through and remote view problems

2. VFP 6.0/SQL 6.5 - Parameterized Remote View Problem

3. Remote View Problem - Access Database with Permissions

4. VFP6.0: Remote View Problem

5. Remote view problem

6. Remote View Problem

7. VFP Remote View Problem - ODBC

8. Is it possible to combinbe remote views into one view

9. Problem with a remote view

10. problem updating an Oracle table using VFP remote views

11. view designer says error when using mssql functions in remote views

12. Which is Better: Local Views or Remote Views


 
Powered by phpBB® Forum Software