I would like to know the SQL syntax for creating a composite key in VFP 9.
The documentation seems to indicate that this is possible but I cannot
decipher the diagram provided.
Let's say that I have 3 fields:  X Y & Z.   I would like to make a composite

i have done error handling like
PARAMETER merror, mess, mess1
cMessageTitle = 'Megasys Software'
cMessageText = 'Error no: '+ LTRIM(STR(merror))+'  Desc: ' + mess+ '  Error:

The Select statement in the AfterRowColChange method below does not behave
as  I expected it. The WAIT WINDOW statement gives the right data from disk
whereas the SELECT statement seems to read the data from somewhere else. Any
hint would be appreciated

I want to thank all the people who gave me ideas on how to accomplish a case
sensitive query on a Microsoft SQL server.
After building a remote view, I was getting all kind of results even if I
marked the Case checkmark in the Filter panel of the view designer.

here is a table (abc.dbf): id char(7), title char(250), item_tyep char(1)
id title  item_type
0011 good or bad 1
0011 good or fish 1

here's two tabkes:-
a.dbf
id char(11) PK
address char(120)

FA2 is a table in DBC with index - type REGULAR expression fas+STR(fan,10)+str(far,3)
LOCAL cmemvar
=SYS(3054,11,"cmemvar")
lcKey=vfas+str(vfan,10)

Dear friends,
I am creating a remote view in the view designer. I have one simple
condition:  myfield = 'myvalue'.
Whether or not I mark the "Case" box to the right of the "Example" box, I am

I am using VFP 8.0. How do I update error field in my table depends on
criteria match on other records in same table with UPDATE-SQL?
Here is exaample
GrpId    EmpId     EmpRole     Error

How do I write a query that uses a date from a textbox?
Tstart="01/06/2005"
USE u:\issues SHARED
SELECT * FROM issues WHERE issues.date>={^Tstart} doesn't work.

I am an Access programmer and am very new VFP 9.0.  I have a query that
works GREAT in Access but not VFP.  Can someone help please?
Access SQL-
SELECT JobListAll.Job, JobListAll.Description, JobListAll.Address_1,