I have created a view in my database which is based on an ODBC connection to
a database in a proprietory piece of software that we use. It takes about 30
minutes to read all the records from the source. If I open the VIEW under
VFP then I can see the record counter clock up nicely ...

I am trying to write a sql statement but I have had no luck. I have three tables: city, customers, suppliers, the primary key is codcity
City
Codcity,    namecity
01    New York

I am trying to provide validation data in a field (e.g. title) where data is looked up in another table (e.g. title with field titlename).
I can't seem to do this using FoxPro v. 6 table designer.
Thanks,
Kit

I am getting a Syntax error on the following code... Anyone see whats wrong?
CLOSE ALL
SET SAFETY OFF
xFn = "REC03.XLS"

Hello (and sorry for my bad english)
When executing a remote query via ODBC, how can i make message "Executing remote ... Press ESC to cancel" don´t appear in the corner of the screen ?
Thank you.

I am trying to write a sql statement where I create a table in the FROM portion of the statement but have had no luck.
SELECT msm.* FROM (SELECT me_number FROM ME_ST_MATCH WHERE me_number NOT IN(SELECT me_number FROM ME_AND_NAME_MATCH)) msm, MasterFile m WHERE msm.me_number = m ...

I want to delete procedure from Command Window, i.e. with SQL statement. Something like "DELETE procedure  myproc".
Regards KalliMan.

I have to create a report in Crystal Reports off of a FoxPro database.  I
need to do a SQL UNION between two tables and it can't be done within
Crystal.  With SQL Server I would create a view or stored procedure and base
the report off of the view or stored procedure.  Is there a ...

I have a TextBox and a grid on a form. In the TextBox InterActiveChange method I have this code in order to populate the grid
Select Noms.Matricule, IIF(ISNULL(Noms.Employee),"N.D.",IIF(Noms.Employee,"Oui ","Non ")) As VdL, "(S)" As Fichier, Noms.Nom, Noms.Rue, Noms.Lieu ;
From ...

I need to return an image column from my SQL SERVER table using SQLEXEC() into a VFP BINARY MEMO datatype.
My cursor always returns the IMAGE as a GENERAL datatype. I need the column datatype in my VFP cursor to be a BINARY MEMO to allow me to use the APPEND MEMO command.
Thanks ...

In a VFP 8.0 SP1 application, I seem to have problems with table locking.
In this case, the front-end application (which runs on Win98SE, Win2k and
WinXPprof) connects to a SQL Server 2000 (latest SP) on a Win2k server via
ODBC.

I tried using the new v9 beta OleDb driver but it doesn't work still.
Please anybody, is it supposed to be this way or what am I doing wrong.
The record is inserted no matter what.
Se a condensed code snippet here from a TestClass i wrote to validate this:

I have created views in Code (Form Init Event) and then populate a grid with it. However, I have noted I can't do so because that view has to be declared on Form Data Environment. How can I declare a View in Data Environment on Run-Time? Or, It is necessary to create views before ...

I call Ms Query out of Excel environment and run nice a query to extract
from a Oracle database. I can see the data on screen but I need to write
it on any kind of file, such txt or dbf.
I was trying add the "into table xxx" like-Foxpro instruction but don't

I'm currently in training course and I have to check if it's possible to use FoxPro's Database command (like USE, APPEND BLANK,...) with a SQL database.
Can you help me?
Thanks.