I'm trying to run SQL queries against VFP 8.0 using the Microsoft OLEDB
Provider and Visual Basic 5.0.
If I read directly from a free table everything works perfectly.
But if I read from a View located withing a DBC file an error is produced

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.

I have a database that I extract data from and I am having an odd occurance.
To make it simple let says:
Select MLine(memofield,1) from Database!table
This normally returns the complete first line of the memo field.  For some

If I check the cUpdateInsertCmd passed into the AfterUpdate event, I get a
sql statement with the table names and field names in it.
I want to get the actual sql statement passed to the database.
Anybody have any ideas on how to translate

Hi to all,
In a Form I have the Field From Code and the Field To Code.
The Field 'From code' is the Start code for my Query, and the field 'To
code' is the end code of query.

I have one database in VFP but I will  want migrate to SQL Server.
I have one form that use combo to select employee Lastname and filter the
customer data and show it inside the grid.. How I create saem store
procedure or another rutine that I will do the same but I don't like use ...

If I join two tables in quirey on more than one condition (both are
indexed), would it be optimized query.
CREATE CURSOR tmp1 (tabname C(5),lastname C(12), firstname C(15))
SELECT tmp1

I am looking for having training course in Developing VFP application in SQL.
Any suggestions?
Thx

At my workplace our ERP software in on a VFP database.  I have learned quite
a bit about extracting data with the select statements from the VFP
database.  We are in the talks of converting the the SQL version of our ERP
and I have some very basic questions since I am extremely new ...

In my data environment I have a remote view with Optimistic Record Buffering.
The user makes his/her changes then has to hit a "save" button. Before I do a
tableupdate, I want to check the remote data source to see if the record's
timestamp has changed (indicating another user ...

How to get the last created SQL Identity number when using Append/Insert from
VFP, currently I am using an SQL Stored Procedure to insert the record and
return the last Identity, is it possible to return it by VFP when using
Append or Insert?

How do I get the actual foxpro data type through oledb?  
I know how to get column information through GetOleDbSchemaTable -
System.Data.OleDb.OleDbSchemaGuid.Columns, but this gives me the .NET data
type.  

vfp6.0
I don't understand why columns R2-R12 results are 0.0000.  I am
expecting
R2-R12 to be 1.4000, which is the max().  Any one have any suggestions?

any idea why the statment below is not creating a temp table?
if i run it as a regular stament (not dynamic) the table is created.
EXEC ('
SELECT F.COMPANYID,F.COMPANYNAME,DNB.DNB_Duns_nbr,

Help
i'm getting an error trying to create a view into a MySQL database.
CREATE SQL VIEW 'webcontacts' CONNECTION 'resources' as "select * from
contacts"