I have a SELECT FROM Table_A, Table_B, Table_C ...
WHERE Table_A.Link1 = Table_B.Link1 AND Table_B.Link2 = Table_C.Link2 ...
How can I do this with INNER JOINs?
Thanks

My VB.NET application connects to FoxPro dbf (free table with cdx file) via
OLE DB 9.0 driver. I have about 100 000 records in the table. Simple query
“SELECT * FROM mytable WHERE id=’value’” runs about 7 seconds. The same
query written in native FoxPro syntax runs less than ...

I am trying to create a remote view with calculated fields that use
functions such as PADR,IIF and
VAL.  I get "Connectivity error: Incorrect syntax"  every time I try to save
the view.

i had to fire the trigger before insert and delete in table login
which contains loginid,loginname,password.....for example
before insert or delete on the table login i want to fire trigger...
before insert or delete on login

I'm connecting to a VFP6 DB via the OLEDB driver.  I issue the following
Update statement:
update EMBTRAKQ set EMQPDT = {^2005/5/21 11:53} where EMQTAB = 'INVMASTER'
and EMQPID = 23

I have a well established Fox 6 application that I am migrating to Fox 9.  I
have a probelm with performance.  All that I have change so far is set
enginebehaviour to 70 and tablevalidet to 0.  Everything else remains the
same as the Fox 6 compiled code.  If I run my query in Fox ...

Just swapped from VFP 7 to 9 and I want to use a config.fpw file on startup
with the line "ENGINEBEHAVIOR=70" so that I don't have to re-write all of
the group by clasues on my hundreds of programs. I've created the file,
saved it in the c:\program files\visual foxpro 9 folder. Now, ...

hi friends
am wondering what is easiest way to delete duplicate records.
i have 3 fields (type,number,provider) which have duplicates and i want to
keep one of them delete the rest.

Does anybody know of a good Promatrix tutorial on how to work with remote
data ?  The information in the Online help is kind of scattered.  I'd prefer
all the instructions compiled together in simple steps that I coudl follow.
Thank you

I have a vfp6 program where I want to create a file, acmast, with just the
fields from 1 file, npain, but get all the fields from the second file,
lelcin. I want to select only the npain records that are found in lecin as
shown below:

Where can I find documentation of the SQL variant used by VFP6?  I find
plenty of stuff for versions 8 & 9 on the MSDN site, but I'm interfacing to
AMAS and told it's VFP6.
Thanks.

I created an updatable remote view based on a SQL table, BLANKed out some
date fields, did the TABLEUPDATE and then REQUERY.  The fields show now
01/01/1900.
This confuses my application because I normally check for empty(date)  or