I'm getting this for a query as VFP 6 executes
= requery( "lv_customer")
lv_customer is the datasource for a grid.
the SQL for the query is

I have like 40 fields in one table of vfp and i have created a
identical table in sql server.  I wanna create a procedure that do
incremental inserts to sql server.  When i do sqlexec("dsn", insert
into customer (f1..) values (m.f1..), it takes a lot of coding to

I'm using VFP 7.0 and would like to do a "where in" query. I've tried
the syntax a bunch of different ways but can't get it right. The
documentation doesn't give examples and the Intellisense suggestion
doesn't work either.

I want to add some Referential Integrity to my VFP tables so I go into the
Database Designer, but the Edit Relationship is always grayed out. There are
no links showing between any of the tables. If I try to drag a line from one
table's field to another it won't allow it.

I what to scan a table to see if there is any record equal to the record
that i'm inputing.
EX.
Table xpto

I have to create a table's which i can control a sub level category, i.e :
ALPHABET main category
   A,B,C,D,E,F ... Z
  A now is became a catogory it contains, AA,AB,AC,AD,AE etc...

If I made the following query
SELECT
FROM tblTabl
INTO crsCurso

like:
select room_id, ;
(select person_name from cur1 where cur1.roomn = rooms.room_id and cur1.bed
= 'A') as person_name_bed_A, ;

I have a SQL View that provides data to a grid control, and the grid control
is located in a form that is called by a '.prg' program. Everything works
well (I specify the SQL View name in the RecordSource property and in the
Data Environment).

I have some SQL data that I want to display in a grid control, but the way
the data is laid out in the grid control is not the same as the way it is
laid out in the SQL table. So I will read the data into my program, juggle
it around, and then display it the way I want.

I am using VFP 5.0 (and will soon be upgrading to the latest). How do I
create a control-array in my current version (5.0)?
Thanks in advance,
Tom Edelbrok

in SQL2k in the Query analyzer, any sql command you execute, it return how
many records are affected. can I get this result from VFP ?
Thanks in advance
Samir R. Ibrahim

I'm working with VFP6 SP5 - XPPro - Oracle8i
Using a SQLCONNECT command, i get a cursor from Oracle8i database and the fields with decimals are correctly retrieved; but when i use an APPEND FROM  command to save the cursor data to a local table (with the fields properly defined as ...

I'm currently issuing the "copy to file [...] delimited with tab" VFP
command to create a plain-text tsv file that I can bulk load into a
MySQL database.
It works great except for null values which come out as zeros. Is there

table has one index primary field and one character field.
duplecate means double records in character field.