There is an error when I save memo field from a edit box using Update /
Insert command.
What is the problem?

How to retrieve the data from RecordSet to cursor in VFP9?
Since i wish to browse the data.
Thank!

There is an error Alias 'txtStudentCode' is not found when I run this Sql
statement, what is the problem?
Update Student Set StudentCode = thisform.txtStudentCode.Value,;
                               StudentName = thisform.txtStudentName.Value;

There is an error Alias 'txtStudentCode' is not found when I run this Sql
statement, what is the problem?
Update Student Set StudentCode = thisform.txtStudentCode.Value,;
                               StudentName = thisform.txtStudentName.Value;

There is an error when i issue this command:
SQLEXEC(hConn,"select top 1 StudentCode from (select distinct StudentCode
from Payment)Payment order by StudentCode")
But no problem with this command:

I'm working at a client site where they have FoxPro front end to SQL Server
back end.
Parametized remote views are being used to get subsets of single tables. One
client record. All the orders for that client, for this year, and so forth.

The following code works in VFP5 and VFP8
  nresult=sqlexec(ogx.odbm.connectionhandle,;
"{CALL
csauth.logon('&cuser.','&cpasswrd.','"+cosuser+"',NULL,'"+chost+"','GX.EXE

Is there a good utility to find records that have data in certain fields that
do not match the field specification?
Example: Field name xyz defines as Decimal 5,2 but actuall has data in it
that looks like 1234.

I like to know what exact command I should use to copy the data from a
fox pro table to a text file. If I open the text file , each column
length should exactly match to each field length of the table even
though some fields have no data. If the field has no data, it should

dear friends
i have a param. view like
create view vfile as select * from tran where tran.date="?ffromdate","?todate"
Now if i issued command

I was given a foxpro database (file structure) and asked to write a
report. From the foxpro interface I found the appropriate table and a
wizard of such to create the SQL statement. After running the query I
returned 1666 rows. I copied the query and ran it in VB using ADO and

I have a SQL database and I need to link to a VFP table.  I have been told
that a view is what I am needing.
Can someone lead me in the right direction of creating and using a view to a
VFP table?

i want to do this :
have a object "text1" and i wont the returned value from query to show
in "text1"
rmobile = "select mobile FROM client WHERE cnumber = combo1.value "