Search results for query: *

In my application with UI, I have a timer. It checks, if the hour of time is 9, 10, 11... and so on and if matches, ie at each hour, process something and upload to an Ftp. If I run this in pc as usual the UI displays and the timer correctly does the process at each hour. When I set a Task...

Dear friends, I'm using the community library FoxBarcodeQR for generating qr codes. Using the below commands loQr = CREATEOBJECT("FoxBarcodeQR") s=REPLICATE('X',950)+'...' lcQRImage = loQr.QRBarcodeImage(s, lpath + "qrimage5.png", 5, 2) But the result qr code when scanned doesn't show the...

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

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

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?

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

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

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

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

Dear all, I have searched for any existing discussions with suggestions and solutions but couldn't find a suitable one! I have a form with a container. Inside the container I have an image control. I used 'Isometric' in the Stretch method and it shows in the image control as follows: As...

Dear friends, What would be a good way to export a vfp report (output from FRX) as an image (eg PNG)? For example, we can convert a report output to a PDF using FoxyPreviewer (there are other ways also of course). Similary, I want to get the output from a FRX run onto an image file, preferably...

Dear all, I am using MSXML2.ServerXMLHTTP.6.0 for communicating with a API oHttp = CREATEOBJECT("MSXML2.ServerXMLHTTP.6.0") I am calling the .open() method, initializes required headers, prepare the input body text etc etc and then calling the .send() method. The API endpoint is to create...

Dear friends, This is actually similar to one of my own threads on establishing a Numeric Key Pad on screen. It was successfully established. But this time, the need is a bit different, or rather, a different approach. Now, I want to try using the general Vfp native command button right on a...

Dear friends, I use FoxyPreviewer to produce excel files from FRXs as in lcReportFullName = 'MyReport.frx' lcOutPutFilePath = 'd:\temp\' lcOutPutFileName = FORCEEXT(JUSTSTEM(pFrxName), 'xls') DO FoxyPreviewer.App REPORT FORM (lcReportFullName) OBJECT TYPE 13 TO FILE (ADDBS(lcOutPutFilePath) +...

Dear all, This may not be a entire VFP related question. Our users connects to a server through RDP, both local and remote. For remote RDP, we have port forwarding through Dyndns service. It's working without any issue. We have a Dotnet application which accesses DBF files using OLEDB but...

Dear all, I am connecting to a remote server using RDP. In RDP connection, I have selected the local user C drive to be used from within the server. If I use GETDIR() from server, I can see the user's local pc C drive. Now, is there any way to know the local logged in username from within...

Dear all, I have a table at client place which has gone size around 1.8 gb. When I try to import from it onto the new database structure, I am getting "size too big" error for obvious reasons. Is there any way/work arounds that I can import from it? Rajesh

Dear all, I have seen some very interesting discussions on VFP Advanced (by Chen) here and other places! Even found web pages with its details and for downloading its 32 bit and 64 bit versions. However, I have not tried it yet! What would be your general opinions/advices/suggestions on it...

Hi all, We have a procedure in an external APP file which is called from multiple codes in application. The .APP name is added to the project but tagged as Excluded. While building Project/Application, it gives error that "<our procedure name> Not Found" How do you indicate the...