Recent content by Pieter Koemans

With PyInstaller, you can bundle all Python dependencies (including the Python runtime) into a single package, either as a standalone executable or a folder.However, there are indeed many ways to accomplish tasks between Python and Foxpro.

There is a project on GitHub: VFP-Embedded-Python, which allows you to run native Python code within Visual FoxPro (VFP). I use Python extensively, and to integrate it with my legacy VFP application, I utilize a SQLite table as a bridge between the two runtimes. This approach is incredibly fast...

You can view the data in the Serial Monitor of the Arduino IDE. All output you send to Visual FoxPro while streaming the data should be visible in the built-in Serial Monitor function of the Arduino IDE. If you do not see the data in the Serial Monitor, then FoxPro will not see the data...

To gain a better understanding of how to process the data, it would be helpful if you could share the data format that you're sending from the Arduino to FoxPro.

Yes, it is one of the quickest ways to integrate IoT into VFP.

That depends on what output rate your arduino is and also how fast you want to update.. What is your application?

I’m so sorry to hear about what you’re going through. I hope things get better for you soon.

Foxpro isn't fast enough to render graphs in realtime. For that you should use activex controls. But you can "catch" data in the background and plot it with foxcharts. To catch data in the background make sure you use the oncomm event in mscomm32

You can communicate with the Arduino using the MSComm32 control in Visual FoxPro. Make sure to register it using the regsvr32 command.Then, check the COM port assigned to the Arduino in the Windows Device Manager to identify the correct port to use. sample foxpro: PUBLIC oForm oForm =...

When working with large datasets, using a SELECT SQL statement is generally much faster than relying on SET FILTER. This is because SQL queries allow you to fetch only the necessary data, while SET FILTER still scans the entire dataset, which can be slow. To prevent altering or "blowing up" the...

Some programmers store images and PDFs in Base64 strings. Basically, any binary data can be converted to a Base64 string. The drawback is a larger size. Many websites embed images like this in text fields. This is also possible in SQLite. Perhaps your images are stored in Base64 if they are...

How about implementing a api to execute python code directly in vfp so you can mix xbase and python while leaving the vfp part intact. This will create a whole new set off tools and libraries and certainly will get the attention of many developpers.

Hi, We extensively tested VFPA32 10.1 across a range of Visual FoxPro (VFP) applications, including some of considerable size featuring over 100 forms, serial communication libraries, external protocols via DLLs, and ODBC connectivity with MySQL and SQLite databases. I can confidently affirm...

Hi, VFPA 10.1 supports files over 2 gigabytes: Maximum size of a file: 2048 TB. Maximum # of records per table file: 1 billion Maximum size of a table file (or cursor): 1 billion * RECSIZE(), if RECSIZE()=65500 (maximum), it is 65 TB. Maximum block of an FPT file: 2 billion. Maximum size of...

Hi, I can confirm it works as expected with my projects as well.Also some large applications with over 200 forms etc without any issues. Its is very much worth a try. Regard, Piko