Hi, I just want to retrieve some records from a DBF file to a recordset
throgh VB6 and I get 0 records when I should get a set of them.
This is the code:
Set cnn1 = New ADODB.Connection

I found that VFP 6.0 would delete 'some' DBF files when PACK statement
is executed. Then, "File does not exists" error occurs.
However, this problem does not delete all my DBF files but just some of
them. I still cannot find its pattern.

I'm trying to insert/update a VFP8 Table memo field with text posted from a
HTML form (text area).
The code I'm using is this:
sql="UPDATE DATA2!personefisiche SET  memo=[" & trim(Request.Form("memo")) &

Hi,
I'm trying to create link of fox tables into msaccess from the source code.
I have installed vfpoledb, but there is only article how to link msaccess
table into msaccess. There is a part of code I understand:

I am using FoxPro 6 and I have written a program to PACK tables that have
records marked for deletion.  I want the PRG file to run at the startup of
foxpro, and I want to know if connecting to a foxpro database via ODBC and
ADO connection string will make foxpro run the PRG, or ...

There is a change in Close database function in VFP9.
Once, a database is opened in a form, it can be closed only when a form is
closed. This major change has been indicated only by way of note in help
topic of Close Database.

Somebody knows something of this product to VFPServer in this web site
www.vfpserver.com
Thanks
E.Paredes

I have SQL2K in the backend and visual foxpro in front end.
My sql database has a column called address and it is in memo type.
I tried following but could not get anywhere:
select cast(address as char(35))

I am trying to insert a record into sqlser 2000/2005.  I can query and update
existing records but not insert.  I don't get an error on the command but
nothing is posted to the table. My code looks like this
<begin code>