I would like help to condense this series of queries into one statement that
users not having access to VFP can run in MSQuery.
SELECT Prmrpmsg.fntxnqty, Prmrpmsg.fcpartno, Prmrpmsg.fcpartrev,;
 Inmast.fdescript,Prmrpmsg.fdduedate ;

HI, I´m using Delphi to access the DBF Table.
I want to update a Table setting a date Field to Blank, Null, '' or nothing
etc. using SQL OLEDB
myConn.ConectionString:='Provider='VFPOLEDB.1;Data Source=D:\BASES;Collating

De acuerdo con la doc. de Microsoft hay una lista de comandos soportados por
OleDb
According to Microsoft documentation there is a list of Supported Visual
FoxPro Commands and Functions in OLE DB Provider

I use dynamic SQL in a report and I need to search for a particular field in
a sql statement and replace it will another field.  Is there a command
similar to Replace() in VB?
Thanks

I am having a problem with a query statement when I try to use sum( ) on a
field in the query.  For example:
select somast.fsono, somast.forderdate, somast.fcompany, sorels.fduedate,
sum(fnetprice)

I open a parameterised view with the name "V_CUSTOMERS" during the INIT
statement of my code (which returns 1 record from the underlying table).
I would later like to use a SELECT statement to draw ALL the records from
the same table into a cursor...

How is it possible to use the 'Between' criteria to filter records based on
a numeric in the view designer....
Obviously between takes two parameters (along with the comparative) so how
do I input this......between ?nstart AND ?nEnd etc???????

I am an old (retired) Foxpro programmer with VERY limited VFP experience. My
retail store uses Microsoft Retail Management System (RMS). RMS stores its
data using the SQL Server MSDE. I need to know, very specifically, how to
connect so that I can use VFP 8.0 to generate data ...

I am trying to add this:
WHERE ... AND LOWER(jour.text) LIKE LOWER('%(m.Buchtext)%') INTO CURSOR ...
and it does not work.
m.Buchtext has a default of ' ' if not written to (by a inputwindow) before

How do I get a parameterised view to return ALL the rows from a table.
I can use % but isn't there an overhead to this?
-------------------
Also if I wanted the potential for every field (or more to the point a large

I need some help. I have two tables and need to update some fields between
them. I need to check a key field for equality then update several fields
in one table from several fields in another table.
Here is what I've written:

I like to create a date format in DD-MMM-YYYY format e.g;, 15-JAN-2005.
Any suggestions.
Thanks