Re: Manuel for ODBC

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Cindy Winegarden (cindy.winegarden_at_mvps.org)
Date: 06/23/04 

Date: Wed, 23 Jun 2004 18:04:10 -0400

In news: uWtt4tTWEHA.3640@TK2MSFTNGP11.phx.gbl,
Predrag Milanovic <mpele@tesla.rcub.bg.ac.yu> wrote:
>.... is it posible to create view with this kind of connection?

Hi Predrag,

Are you creating a VFP view of the SQL data or a new view on your MySQL
database? For a VFP view look at the Create SQL View command. For a view on
your MySQL database you'll need to pass the Create View command through as
a text string command in whatever subset/superset of the standard SQL that
your database understands. 

-- 
Cindy Winegarden  MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org  www.cindywinegarden.com

Relevant Pages

  • Re: Select - SQL vs. SUM
    ... If you have to use an earlier version of VFP earlier than 9, ... >> also force VFP to read from the buffer with a new clause in the SQL ... >> The SELECT command doesn't move the record pointer in the grid's record ... >>> I have a grid whose recordsource is a table named _payments. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Cannot use a CONTAINS or FREETEXT predicate on table...
    ... command from the context of the database I wish to publish. ... This database is not enabled for publication. ... The replication agent has been successfully started. ... Source: Microsoft SQL Native Client ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL update in SQL database issue
    ... I am thinking if i change the database from Foxpro to SQL or MS Access, ... program installation require, if a table corrupted, user can just attach ... should I use SQL pass through command to update the Foxpro Database or ...
    (microsoft.public.fox.programmer.exchange)
  • Re: what to choose
    ... but the record size is 3,5kb so it looks anyway too much for fox pro database. ... >> and he is not very convinced to fox pro solution since he says that SQL ... >> Server would be better and stable. ... There is no need to you to change VFP as a developing language. ...
    (microsoft.public.fox.programmer.exchange)
  • Help needed, ASP.NET caching with SQL Server doesnt work
    ... I'm trying to use ASP.NET caching with my web site and SQL Server, ... First I run the aspnet_regsql tool on the command line succesfully to enable ... the database for cache notification: ... dependency matches exactly the table name used in cache notification ...
    (microsoft.public.dotnet.framework.aspnet)