I sometimes get this error in Visual, when using forms as objects, which are members of other objects, and then showing / hiding them.
My documentation says the following:
'Record your recent actions and contact Microsoft Support'
I think that this is an internal FoxPro error, and my error...
I don't think that this is the problem really, because the file is opened at the beginning of my program (and it is shared) and then written to often by my program - so I am not trying to open it, and because it is already open, it cannot be in use by another user exclusively as I would get a...
I have a recurring problem when inserting items into a table using VFox 6, using Novell as the Network OS.
At seemingly random intervals, the system crashes with a FILE 108(file is in use by another user) error.
I am simply using the INSERT INTO command, with a table that is already open, so...
Hiya, I am trying to use the DDE functions to program Excel from Fox for Windows 2.6, however, the DDEInitiate command fails and cannot start Excel under Windows 9.x / 2000.
I therefore resorted to run /n start excel.exe and then making the connection, which is cool in 9.x , however, under...
No, the system needs to create the table that holds the data to export in the first place. It is this that takes the time.<br><br>The user wishes to extract sales information, selectable by product and customer for a year, starting on any month, and for each month, sales qty's and...
The average data set is about 900 records x 27 fields of 10.2 numeric format.<br><br>This equates to about 12 pages in Excel.<br><br>I don't think that this size is in any way excessive really, it's just that Excel was really slow.<br><br>Simon<br><br>
Jon, I tried the method you suggested and now instead of taking 60 minutes to run, it takes 1 - I think as a percentage, that is quite an impressive speed improvement!<br><br>I was a complete pain to re-do my code to work but is was worth it in the end(and I will know for next time)...
What I do is get my report data into a cursor, then in a loop, enter all the fields and records into an Excel Object, e.g.<br><br>FOR colCount_n = 1 to (COLTOTAL_N - 1)<br> excelAutoObject_o.Cells(rowIndex_n,colIndex_n).NumberFormat = "0.00"<br>...
Performance: starting the application and closing down the application I do find is slower than normal, however, once the application has opened I find that because forms are already initialised as objects they pop up on the screen extrememly fast.<br><br>I also open all my tables at the start...
I've had a look at the export command, and yes, it is really, really fast, but unfortunatly it does not allow you to store format information (such as bold, text size, underlining etc) <br><br>You may think that I am asking to much, but one of my customers who used to spend 4 or 5...
I create objects, say for a customer, and then create properties which are form objects. This way, all properties and methods of all form objects belonging to the customer object, say, are accessible to every other object belonging to the customer object(including the customer object...
I need to be able to export data from foxpro into an Excel spreadsheet with formatting.<br><br>I've tried creating an Excel object and setting the cell object properties but this is too slow. <br><br>I was wondering if there was an API or somthing similar for creating Excel workbook...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.