I try to put the total number of records in my MySQL table into a
variable.
Something like
public recs

I am using fox to connect to a remote sql database. When I populate the one
field with is an ntext field type the information gets cut off at 420
characters. Is there a reason or a solution to this?

I want to select all records out of MyReference and
only those records from MyList that match
SELECT R.Name, M.Item
FROM MyReference R LEFT OUTER JOIN MyList M

Having a problem getting a unique item and a min date for that object.
Any suggestions.  I have a cursor with a number of items (repeat
several times with different dates.  Need to be able to get a list of
item so the only appear once and have the earliest date.  I'm at a

I need to connect to a table in MySql through ODBC driver
No problem in the connection designer, when I try to create a remote view in
the View Designer I got an error when I add any tables and the error is that
VFP switch the name of the database with the name of the login user

How do I read a field that has [ it's name.
See custaddr.addr[1] below.
Example
sql = "SELECT co.[co-num] as conum, custaddr.addr[1]  ,"

This SQL returns to me the last 10 records in a table, order by Id field
       SELECT * FROM MyTable WHERE Id IN ( SELECT TOP 10 Id FROM Table
ORDER BY Id DESC) ORDER BY Id
But i need to get a similar result based in two o more id Fields

How can I retrieve a return value from a MSSQL server sproc using SPT?
For instance, returning an @@IDENTITY.
Thks & brgds,
andy

When I send a query 'SELECT somedatecolumn FROM....' I got resultset
containing datetime. It's ok because it is a datetime field (or
smalldatetime) but it is a little frustrating because I'm interested only in
date. Is it possible to get only a date, without the time? My previous ...

I am working on Access 97 Database and need to add a new coloumn in one of
the tables existing in access database. I dont have copy of Access 97.
Please guide me if there is any way to add a new coloumn or if there is any
way to change the structure of tables in Access using VFP8.

Hi I need to do this update:
table t1 : c1 , c3
table t2 : c1 , c2
t1.c1 = t2.c1

I am using SQL Passthru to update a free table, I create the DSN name under
system DSN.
STORE SQLCONNECT('SystemDSN', '', '') TO gnConnHandle
IF gnConnHandle <= 0

I have an VFP 6 application that is performing data writes to two seperate
MS SQL 2000 servers.
I have a connection set up in the VFP application for each server, meaning I
have two SQL connection handles.