Search results for query: *

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