Search results for query: *

QUERY TAKES TOO LONG I have a form with a grid I have an invoice table. I want to display records that match certain criteria: First_name, last_name I also have indices for each field first_name and last_name. The problem that I am having is it takes too long that query and sometimes I have a...

I have a form with 2 grids Grid1 contains information about invoices Grid2 contains transactions related to invoices This form allows to look information by a column agent and column invoice No The table Invoice has an index on agent + invoice_no Table invoices have 23,000 records Table...

Does anyone have any experience with CommTools / Sax Comm Objects? Any input will be apreciated. Thanks

Help with Grid class and tables -I have a grid class, mygrid. -I using addobject("oGrid","myGrid") in the load event of the form Problem was that grid was being loaded with info of the first table in DE. I fixed this by adding the following in the init event of the DE...

Query takes long only the first time -I have a transacctions table -One of the index tag of this table is by account id -I also have a data entry form where it check previous transacctions of a customer (by account_id) - transacctions table is about 90,000 records -This is a multiuser...

Why is that when I create a form, place a grid, and any (one) table in the data environment, the grid is being load with this table. Grid properties are: RecordSource = none Recordsourcetype = SQL Thanks

Hi, I have an application in VFP7 and I am using InstallShield that comes with VFP7. I just wonder what files I need to distribute with my applications besides vfp7r.dll? I building my set of files on a CD. (I was trying to do it into floppies like I did in VFP6 but I couldn't do it) Do I have...

Hi, I just got VFP7 (Profesional Edition) and I was trying to distribute an application. Dou I have to have an extra windows installer to do that now? Since there is no more setup with tools->wizards like VFP6 Thanks

Hi, I have table transactions. This table has a column status. Status value can 'V','X' or ' ' In the grid I want to be able to display 'VOID' or 'CANCELLED' depending on the value of status. I tried to put this code in the init event of the column if transactions->status = 'V' this.value =...

I am using VFP 6 and I am trying to run a report over the network. It runs the first first time. If I try that again system freezes. It works fine in a single user environment. I created a custom window so I can preview my reports. So in the click event of the "Print" button I create...

I am using VFP 6 and I am trying to run a report over the network. It runs the first first time. If I try that again system freezes. I created a custom window so I can preview my reports. So in the click event of the "Print" button I create an instance of that preview window. Local...