Search results for query: *

Chriss, The table is not that big and I do not want to create an index as well. Also, with my query it fetches records I need fast. Anyway, thank you for your input and idea on using an IDX freely in such circumstances.

...have a Unique key set and I can't create one too! So I solved it like below, I was trying for a shorter method though (why I posted here). SELECT *, RECNO() rno FROM yourtable INTO CURSOR allrecs SELECT ref, MIN(rno) AS rno FROM allrecs GROUP BY ref INTO CURSOR firstrecs SELECT allrecs.* ...

Rob, thanks. To test, I copied my table to 'yourtable'. It gives error SQL: Column 'yourtable' not found. In fact, I also was trying in the same way. Are you sure this code works at your end?

I have a table with column 'code' and many other details. Table has multiple records for each 'code'. What is the simplest/shortest method to select only the 1st record for each 'code'? Thanks

Chriss, I have not studied deeper the methods, properties or other features of the library and its controls. I am just following the ways shown in their demos (and obviously made some modification to match my needs). If you download the library, you will see a form...

...size correctly applied. Can see imgCanvas with border and diagonal cross lines. Basically, below is the basic and essential code that I use: */ In form Load method Do system.app && this is a part of library and we need to do this. */ In form Init method limg = "myPic.jpg" */ This is...

Dear all, I am using the GDIPlusX library downloaded from here. I have a form and added the ImageCanvas control from the above library in it. At run time, I am making the form maximised to entire screen and the size of ImageCanvas control also. In native Vfp image control, when we set the...

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

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")

Yes, it shows the code if I Set Step On.

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?

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...

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

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...

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...

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

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

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

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...

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"...