Friends,
I was using the following query ini VFP 6:
   SELECT lev_name, SUM(leave_acc) ;
   FROM  vEmpPayLeaves ;

Dear friends,
I have purchased VFP8 and found that "Setup" wizard is missing. I used
Install shield express that comes with VFP8 to create setup disks, but that
does not automatically install all required support files for me.

i'm at a new job where a ordering program is build in clipper with a
database in dbase III. Ofcourse ; ) i want to rebuild this in vfp. I am
using VFP 6.0. This is a rather huge application, and i don't want to
rebuild it at once. I figured i first build the gui just for lookup

Friends,
I am using VFP6 and Access using ODBC. I have installed my program using
setup (compiled in XP) at customer place in XP (PC) and Win2000 pro
(Laptop).. XP is perfectly OK. Win2000 says VFP support files are missing. I

I have a single table in a large database which I can't access through odbc.
The error I get is "Microsoft ODBC ..... not a table".  I also cannot access
this table using my old VFP 6 -- I must use VFP 8 to open it.  I have looked
for an updated version of vfpodbc but I can't ...

i'm saving a field into the current record and then doing a sum of that
field for any other records
so a couple of lines of code like this...
select deal

I am running into some problems especially on deletes using SPT, VFP8 and
SQL 2000. I am seeing in EM where locks on objects from single row
deletions, i.e. delete dbo.tablename where id = ?paramID.
These locks are causing blocking and I am not sure how to get around it. If

Has anyone got any ideas for creating a version number for a dbc by adding a
user field or other method.  I want a way that I can keep seperate version
number for the dbc similiar to that of the EXE version.  We have a
commercial application that we provide for a client base ...

Does any one know what is max limit records in a visual foxfro table?
TIA,
Elton Wang

I am using VFP 6.
This is a general question.
I have a table ('CodeBank'), in my DBC which stores the name of the
tables/views and the last used IDs.

Using a VB.Net app to connect to a Foxpro database, I get this error when I
issue an Update command against a dbf file directly (meaning, "Update
tablename, set columnname = value")
I have looked at the properties of the dbf file and it is not set as

I got a strange behavior, I need to connect to a table in MySql through ODBC
driver
No problem to create the connection, when i try to create a remote view I
got an error when I try to add any tables of the db and the error is that

I need to create a table in runtime, the definition's table is in a
variable.
strCadCreate = "create table Txx ( campo1 type, c2 type ) "
I need to execute the CREATE TABLE statement strCadCreate

I'm trying to insert a record into a foxpro table using
the VFPOLEDB driver. The table uses a validation rule
that triggers a stored procedure. The stored procedure
fails if i include the new error expression syntax

Hi...
Me Again...
How could I temporarily interrupt the effect of the
Insert, Update and Delete Triggers on a table?