Search results for query: *

I am working with EXCEL and Visual Foxpro, creating excel worksheets from Customer data. The current worksheet reports show data and multiple subtotals of data on each worksheet. We would like to programically using the group feature. (i.e., like manual selection of Data,Group and...

Does anyone know if there is anyway to increase the limit of the copy to command when trying to copy a data set of records to EXCEL. If the table size is greater than 16,384 records, the remaining records are just dropped with no error message from Foxpro or Excel. (i.e. 25000 records in the...

My company is attempting to place our VFP 7 projects into VSS but we are having major difficulty. We have four developers working on the various projects and need to have them available in development, testing for QC and production. The system is a conversion from Fox2.6 windows,into vfp6 and...

Because of the empty date value being interpreted at 12/30/1899 when creating a recordset from a VFP7 table, I have been working with this workaround but not successful. What am I missing in the statements? The report field is printing as blanks for all dates, and does not put in the current...

As a new user of Crystal Reports I am experiencing problems with date fields when working with a VFP7 table. If the date field contains a valid date value no problem, but if date field is empty it is reported/displayed as 12/30/1899 and then when the report is exported to Excel the same date...

I am hoping some of you sharp VFP people have Crystal Reports experience. As a new user of Crystal Reports I am experiencing problems with date fields when working with a VFP7 table. If the date field contains a valid date value no problem, but if date field is empty it is reported/displayed as...

As a new user of Crystal Reports I am experiencing problems with date fields when working with a VFP7 table. If the date field contains a valid date value no problem, but if date field is empty it is reported/displayed as 12/30/1899 and then when the report is exported to Excel the same date...

The following command is used is our application, where v1 is the variable containing the unique id. cSQL = "SELECT * from tblAMC2_practice WHERE sql_d_pk=&v1" SQLResult= SQLExec(hdlpline,cSQL) The value of SQLResult is 1, whether records were found or not. How can I identify whether...

Our problem with the unique index violation error is occuring after a record is deleted from a table and a corrected record is trying to be inserted. The main index keys were not changed just some of the other field values, but how do we get Fox CDX to ignore the existence of the deleted record...

In our VFP6 application version we were able to cut and paste between textboxes, now in VFP7 we have lost that feature. Does anyone have any solutions.

We are experiencing a problem with the Memo table for a table in our DBC. We are using VFP7.0 now but the problem had just begun while still in VFP6. Each day the memo table for this particular table doubles in size each day. We have a nighttime process that is reindexing all tables (stonefield...

We are still having problems with character displays and error messages in some applications after converting from VFP6 to VFP7. I have not had any response to previous posts about the problem. I would be happy to send some screen shots as a Word.doc attachment to any of our Web Tech Experts...

We are currently converting from VFP6.0 to VFP7.0 and are having a problem with menu bar text option displaying incorrectly. (i.e file edit view, is appearing as 'A'1/4p(E) +1/4(E), *i'u(H), these are not quite right because they are from a different character set, but result is...

We have been using the wwPDF class for adobe printing to a PDF file with VFP6.0 Is anyone aware of any problems with this auto process after converting to VFP7.0 This is the class from Rick Strahl of West Wind Technologies for creating adobe documents on the fly. Thanks for your input.

I am not seeing in the Stonefield 6.0 documentation any reference to setting it up for network and multi-developer access. We are getting ready to upgrade from VFP6 and Stonefield 5.1 to VFP7 and Stonefield 6.0. Currently it is only available at one developer station and only recognized by VFP6...

We are attempting to use an auto email notification process at the end of various programs, such as night updating and major data transfer programs. I have created the program using the following beginning type creation and connection and it functions perfectly from my IT computer. oSess...

Our IT department is getting ready to upgrade from VFP6 to VFP7 and I was wondering if there are any tips out there that will help us avoid any "gotchas' that may be lerking. Also any real world user comments on performance would be appreciated. Once again thank you all.............

We are experiencing a slowdown of access to Foxpro tables on an NT network with approximately 80 users. The largest table contains 1 million plus records. Using this as a test table from development it is taking 10-20 seconds to even display straight browse commands results on the screen and...

I am new to the VFP6.0 to Microsoft SQL Server process. My problem is when trying to insert records with the Insert statement. I have 11 fields identified with their values and the INSERT statement functions correctly. Now I am trying to add additional fields and their values and the statement...

I have a problem that I am trying to resolve with VFP6 and it concerns users on records. Within our company code, we have a lot of old code that was upgraded from 2.6 and before. Is there a way with foxpro commands to find out which workstations have a particular table open? All the new...