Search results for query: *

Hi, We're using VFP8 and the following code to copy a folder: oFSO = CREATEOBJECT("Scripting.FileSystemObject") oFSO.copyfolder(source, destination,.F.) and it works fine until such time as somebody is editing one of the files contained in the folder, at which point we get a "COM command...

Or does the PACK do both?

We have a problem where at times our users experience an error saying: "There Is Not Enough Disk Space For....." The message ends with the name of a memo file. As it happens there is loads of space for the memo file over 90GB but the memo file itself is just over 2GB. The corresponding table...

For example: We have a table with 10 records in, 3 are flagged for deletion (the little black mark when browsing a table). However the index reports 4 are deleted (We have an index on DELETED()) and as far as we are concerned this is correct because: 1. It is in line with what our code should...

Hi, I have written a small prg using Fox 7 where I use the following SELECT statement: SELECT *; FROM product_transaction_header; WHERE product_transaction_header.pth_unit_qty_id = 0; INTO CURSOR cur_trans_w_out_puq I then do RECCOUNT("cur_trans_w_out_puq") to find out how many records...

Hi, We have a spreadsheet that was created using Excel 2003. The data comes from a query and contains (amongst other things) a column for account number and a column for product code. The sql is set to sort on product code, which worked fine. However, the user then decided to sort on account...

We have a vfp7 application that displays data using grids. As a grid is loading, a progress bar (which is essentially a form) is displayed, and all the progress bar functionality is wrapped up in a class. The grids tend to be on a pagegrame with active tabs, and the progress bar form will sit...

Hi, I have some existing VFP7 code that features a lot of SQL queries and I want to identify any queries in that code that are not Rushmore optimised. I have figured out how to use SYS(3054) to return info on an individual query. However, with my current understanding, I am thinking that I am...

Hi, I wonder if anybody can help. We have a customer database that stores the different parts of the customer address separately i.e. customer.add1, customer.add2, etc.. Sometimes some of the fields will be blank, so for formatting reasons, when we print the address on a report we concatenate...

My table contains a memo field that stores data that can run to some considerable size. I want to print this information on a report and there is no problem setting up a field that references the memo - the data will print correctly. However, I need to do some preprocessing before printing...

Hi, I have a table of products, some of which are held at remote stock locations. If they are an entry is made in a table, remotestockquantities, storing the id of the product (rsq_prod_id) and the id of the remote stock location (rsq_rsl_id) along with the quantity held (rsq_qty). If a product...

We have an application that will print reports to the Windows default printer unless a Prompt For Printer checkbox is ticked, in which case the user can select the printer they wish to print to. However, what I want to do is send the report to a printer other than the default printer without...

I have just bought a new laptop with 1056.50 MB RAM. The operating system is WIN XP Version 5.1.26. I loaded Office 2000 Pro onto the system but now when I try to go into Query from Excel, I get the message that there is not enough memory. I downloaded the service packs for Office 2000 but the...