Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Rajesh Karunakaran

    TRY/CATCH routine: Is FINALLY is mandatory in version before 9.0?

    Yes Chris, when many people mention it like TRY/CATCH, it's more onto the purpose than to the syntax!
  2. Rajesh Karunakaran

    VFPxWorkbookXLSX: "SaveTableToWorkbookEx" method shows Windows file copy dialogs

    Scott, The following line causes the Windows native dialogs to appear. loShell.NameSpace(tcZipFile).MoveHere(loFile, FOF_SILENT) This is in the "AddFilesToZip" method. Obviously, loShell is created as below loShell = CREATEOBJECT("shell.application")
  3. Rajesh Karunakaran

    VFPxWorkbookXLSX: "SaveTableToWorkbookEx" method shows Windows file copy dialogs

    Dear all, I am writing contents of a DBF file to a XLSX file using the VFPxWorkbookXLSX library. When the "SaveTableToWorkbookEx" method is running, it shows the native Windows' file copy dialogs. Is there a way to disable these?
  4. Rajesh Karunakaran

    TRY/CATCH routine: Is FINALLY is mandatory in version before 9.0?

    Dear all, I think that particular error comes up when we don't have a ENDTRY after the CATCH. TRY =MYPRG("PARAM1") && This PRG has TRY/CATCH and it works fine. CATCH Now, when MYPRG exits, it gives the mismatch error. So, let me check with my client, if his calling program has a wrong...
  5. Rajesh Karunakaran

    TRY/CATCH routine: Is FINALLY is mandatory in version before 9.0?

    Thank you Scott. Okay, so I will now need to check deeper why he's getting that problem.
  6. Rajesh Karunakaran

    TRY/CATCH routine: Is FINALLY is mandatory in version before 9.0?

    Hi all, My client getting TRY/CATCH mismatch error in one program. Its a program where we convert a DBF to XLSX using the "VfpXworkbookXLSX" library. When I run at my end I don't come across that in spite of trying with various scenarios. Too, apparently I am not able to find anything wrong...
  7. Rajesh Karunakaran

    VFPxWorkbookXLSX takes lot of time to open large XLSX files!

    Hi mJindrova, Yes, that's the one. In fact, I want to read from XLSX and break into multiple files for subsequent import into one web application. So, I am trying to read a set of rows (from source) and writing to a new XLSX. I am writing cell by cell as I couldn't find a way to copy a range...
  8. Rajesh Karunakaran

    VFPxWorkbookXLSX takes lot of time to open large XLSX files!

    Hi Chriss, Yes, because of the nature of XLSX format, may be it takes time. The file is only 58kb. Maybe, it has may inner files and uncompressing time may also be a reason. I will do an analysis once my primary program code is finished. Rajesh
  9. Rajesh Karunakaran

    VFPxWorkbookXLSX takes lot of time to open large XLSX files!

    Dear friends, I have been using VFPxWorkbookXLSX for working with XLSX files. But so far, they were all considerably small files. Now, when I try to open a file with 16800 records and 38 columns, it appears it takes more than half a minute to open it. Is this usual? Rajesh
  10. Rajesh Karunakaran

    Does VFPxWorkbookXLSX work with old .XLS files?

    Hi mJindrova Yes, I saw that! I have already converted the XLS into XLSX. Now, I will process it for my purpose. Thanks. Rajesh
  11. Rajesh Karunakaran

    VFP9 won't start because of "insufficient memory"

    Hello kyletreyfield, If you have not VFP installation in your pc and you keep your VFP runtimes in your application folder itself, please check if you have all necessary files in place. A typical list will be as follows: All files above may not be essential though. Even if you think, you...
  12. Rajesh Karunakaran

    Does VFPxWorkbookXLSX work with old .XLS files?

    Hi friends, A simple query. I have been using VFPxWorkbookXLSX to work with .XLSX file... pretty good...! However, when I try to open a .XLS file, both 'OpenXlsxWorkbook' and 'OpenXlsxWorkbookSheet' returns 0, i.e., it failed! E.g: oSource = NEWOBJECT("VFPxWorkbookXLSX"...
  13. Rajesh Karunakaran

    Application with many data fields

    Hello SitesMasstec, I don't think, trying to relate the tables through the internal Record Number is a good idea because there are chances that at times, the same record number in the two table may not correspond to same logical record we think of. This might happen because of even unforeseen...
  14. Rajesh Karunakaran

    DevExpress.XtraPivotGrid.v7.1.dll doesn't get registered with RegSvr32

    Hi Chriss, Thank you for the reply. I do agree and usually I go the proper way for transferring a software (even our own ones!) and supporting packages. In this case, I am not sure if there was a setup routine. Let me check if I can find it. Thanks Rajesh Rajesh
  15. Rajesh Karunakaran

    DevExpress.XtraPivotGrid.v7.1.dll doesn't get registered with RegSvr32

    Hi Team! We are using the below DLL for Pivot data generation. It was working fine. However, when we changed to a new computer, it stopped working (obviously, must be because the DLL need to be registered). DevExpress.XtraPivotGrid.v7.1.dll DevExpress.XtraPivotGrid.v7.1.Core.dll (we have...
  16. Rajesh Karunakaran

    Table corrupted, after repair accessing Memo field says "Cannot open memo field"

    Dear all, I tried changing the memo fields contents with '' but even though it did not throw any error, still I was getting the same error when tried to open memo field. Finally, in current table, I removed all the memo fields and re-added them. Then I updated all the memo fields from my last...
  17. Rajesh Karunakaran

    Table corrupted, after repair accessing Memo field says "Cannot open memo field"

    Griff, The size of the FPT (the file after I fixed it with utility) is not zero but considerably good. But, when I copied the dbf/fpt to another temporary database in another folder, the size came as 1kb. The Memo field is editable there, but the values in all records are blank (yeah! because...
  18. Rajesh Karunakaran

    Table corrupted, after repair accessing Memo field says "Cannot open memo field"

    Dear all, We have a table with 4 Memo fields. It was corrupted somehow and we repaired it using a utility called 'Advanced DBF Repair' (my office has this since long). After repair, accessing the table appears to be completely okay. But however the Memo fields are not accessible. When I...
  19. Rajesh Karunakaran

    Scroll an image within a container in a form

    Martina, I think, I will have to modify many places and hard code many values in order to make it runnable. Let me check. Will let you know. Rajesh

Part and Inventory Search

Back
Top