Re: Creating views

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Thu, 27 Oct 2005 13:30:14 GMT, Leemi@xxxxxxxxxxxxxxxxxxxx (Lee
Mitchell) wrote:

To be complete: a remote view can also connect to a DBF through ODBC,
making it a very roundabout way to access the data, but nice for
testing.

>Hi Preacher Man:
>
>In my book, a view and a SQL View really man the same thing. A local view
>is a view that shows data from a VFP table. This view does not use a ODBC
>driver to connect. A remote view is any view that connects to data other
>than VFP tables. For example, a remote view would use ODBC to connect to
>SQL Server, Oracle, or Microsoft Access.
>
>I hope this helps.
>
>This posting is provided "AS IS" with no warranties, and confers no rights.
>
>Sincerely,
>Microsoft FoxPro Technical Support
>Lee Mitchell
>
>*-- VFP9 HAS ARRIVED!! --*
>Read about all the new features of VFP9 here:
>http://msdn.microsoft.com/vfoxpro/
>
>*--Purchase VFP 9.0 here:
>http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
>69-4500-8bf2-3f06689f4ab3&type=ovr
>
>Keep an eye on the product lifecycle for Visual FoxPro here:
>http://support.microsoft.com/gp/lifeselectindex
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
>
>>I am just getting my feet wet in connecting to a SQL database through VFP.
>
>>What is the difference between a view and a sql view?
>
>>Also, can you explain the difference between local views and remote views?
>
>>Thanks.

.

Relevant Pages

  • Re: VFP9 + SQL 2005 using VFP remote views CANNOT INSERT VALUE NULL
    ... As you've seen it's ok to join a regular VFP table with the remote view ... VFP, and don't have a Default defined, and don't accept Null? ... Using SQL Server and remote views with VFP is likely five times easier ...
    (microsoft.public.fox.programmer.exchange)
  • Re: ODBC or OLE DB
    ... I'm using Native for the cursoradapter with VFP backend, and ODBC for the ... SQL and that would then use the OLE DB connection string but would that mean ... What I'm trying to do is use a consistent way of interfacing between our VFP ...
    (microsoft.public.fox.programmer.exchange)
  • Re: vfp 6.0 and MS sql 2000
    ... don't insert PK values /fields in your vfp remote view - let the SQL ... I prefer to use straight SQL PassThrough, ... Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html ...
    (microsoft.public.fox.vfp.queries-sql)
  • Re: VFP with MSSQL
    ... Since you're using a remote view, you need to have checked off the updatable ... fields and indicated which ones are the key fields on the Update Criteria ... You also need to make sure the Send SQL updates ... > in VFP with SQL as backend. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: VFP with MSSQL
    ... > updatable fields and indicated which ones are the key fields on the Update ... > SQL updates box is checked on that same tab. ... >> It is my first time develope a VFP application with SQL through remote ... >> insert data in VFP with SQL as backend. ...
    (microsoft.public.fox.programmer.exchange)