Hello!  My query skills are in need of some help.  I've simplified my tables
in order to explain what it is that I'm trying to do.  I need this to create
dynamic checkboxes on an asp.net page and to have the checkbox values set as
the tables are drawn dynamically.  Anyway, here goes ...

   How to create SQL-SP from VFP6.0?

Can anyone help me to do a query that limit the number of characters for
display.
For exemple i have a filed with 2000 characters and i just want display the
first 300 characters. is that possible?

Given a table containing a list of transactions against a stock item
by date,
I want to determine the minimum stock available between two dates
Transact

I have a table with a date field:
01/02/2004
01/04/2004
01/06/2004

Hope you guys can help me out. I have export of dbf files without dbc file
included. I would be getting  frequent export of these files. I am
developing a vb.net console application to read data from these files.
My application is failing when I try to read count of records in those ...

The following worked fine in VFP6:
SELECT CheckName, Ssn ;
 FROM Payroll ;
 INTO TABLE TempPay ;

I use a remote view in my database to connect to a MYSQL database on the
internet. I need to delete ALL the records from the table but have found
that although the ZAP command seems to clear the local copy of the table the
remote table still contains all the record once I close and ...

I have an error message that says line is too long when I am dealing with a
huge file. There are many fields and the length of the file goes up to 2016
Characters.
And this is what the error message says:  

We are encountering Fatal Exception C0000005 Error quite frequently with a Oracle backend. The line where it occurs is SQLExec call and the same Update-SQL statement works without any probs for 1000 odd times and then all of a sudden it will throw up that Fatal Exception Error.

I have two tables:
CityState (City,Zip,State)
Clients(Name,Zip)
What I need is find all clients which falls in same state for given zip. Is

Is there any way to generate unique primary key value while inserting record
into table? Maybe there is some sort of system variable like @@identity in
SQL Server.

Can anybody kindly tell me whether Visual Foxpro 6.0 - 9.0 support the SQL
syntax Intersect, Except and Minus ?
Thank in advance.

I have a question about the behavior of the SELECT-SQL command. When I
insert a new record in a table (not in buffering mode) with INSERT-SQL
command and then try to select that record with SELECT-SQL the new record
doesn't appear in the results. It should have been there bacause it

Hi Group --
I have a client that is really down on VFP.  He thinks that it is slow, that
it can't handle large databases and that it will disappear since no one is
using it.  He wants me to use a Microsoft SQL server.