Dear sir/madam,
Thanks for the one who answer my question previously. Here is the question:-
a table called "abc.dbf" that contains the following data/records:-
a                              b

I've got one form that displays the results of a query in a grid.
I've got another form that I use to add records to one of the underlying
tables.
After I use the second form to add records, I would like to see that

I am running an SQL select query against a third party VFP database
table.  Here is what the SQL statement currently looks like; "Select
* From ABC Where FileDate = {06/27/2005}"  I want to select all
records within this table where the FileDate equals  just the date and

Dear Sir/Madam,
Here is the table named "oo.dbf" with the following data:-
A9090090
A9203388

i have two tables. One with titles and one with title_info. In titles
the field EAN is unique, in title_info it isn't. In title_info i have a
field date, this is the date the info on the ean is added, and i have a
status field.

How can I get the current month dates?  For example, get 6/01/2005 and
6/30/2005?

IN VFP 5.0 I am trying to build a where clause in a string variable.  It's
been so long since I used VFP that I have forgotten how to do it.
The following is generating an error on the SELECT... line:
IF somecond

I'm having an issue that is driving me nuts and I can't figure out what's
going on.
I'm using the SQLEXEC() funciton to return a record set from a view in SQL7
that contains a BETWEEN statement using datetime data and one character based

Hi! I'm just learning how to make FoxPro 7.0 talk to a SQL Server database.
I've got some great documentation to learn from & I'm making good progress,
however, I don't have any info on appending a new record to a SQL table. Can
anyone tell me how to do this? I'm using remote ...

I have a query tool that was written in FP/VFP. It works fine for the last 10
years in our application. Now we are moving from FoxPro backend to RDBMS, to
SQL Server in particular. We are using RV and SPT and VFP DAL for the data
connection. Unfortunately, ODBC can't convert such ...

Hi, any references about MyOleDB 3.0 working with MySQL an Visual Foxpro?
Thanks for your time,
Juan.

I am using Visual Basic 6 with ADODB, Visual FoxPro 7.0.
I have a strange error that I do not understand. Also, I did not find any
ways to reproduce the problem. It just happen after my software runs for a
certain time. The SQL string can be different from each other. I know the

I'm trying to create a Parameterized View flexible enough to receive as
parameter any SQL expression.
Something like
  create  sql view MyView Remote connection MyConnection  as select * from