Deear friends,
How can I read the installed path of my program (dev by VFP8) on user
machine?
Usage: To distribute upgrade program on CD. When autorun starts my upgrade

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 looking for that utility that you can use to print out the data
definitions of your DBC....

I'm using ADO connection/recordsets in VFP 6.0 and I need an example of a
connection string to get to my Free Tables Directory on my local machine.
Could someone please post an example code for using ADO against DBFs?

how is varchar type field definining useful over standard character type
fields.
i thought varchar types would save diskspace but infact it is increasing the
physical size of the dbf ???

How do I run a SELECT COUNT(*) and put the results into a variable in code?

I need to execute a SELECT statement that has an IN clause; but it needs to
behave like NOT IN.  My current statement looks like
SELECT * FROM Company WHERE Company.Name IN "A"
I need it to act like WHERE Company.Name NOT IN "A", so is this a valid

Note: I have already posted this in another discussion group fox.vfp.setup
but I repost it in here since it should be posted in here instead.
What are the possible causes to get the error "Cannot resolve backlink"?
My understanding is that opening a dbf which has problem in ...

We are currently re-writting some code that wraps around a system that is Fox
5 that we do not own the code for ( eek ).  The problem stems from an update
that needs to be done on an order table.  The update merely indicates the qty
of pieces that have shipped on the packer we ...