FiveTech Software tech support forums

Syntax of SQL Query has nothing to do with FWH function. It is for the programmer to know the correct syntax of SQL supported by Jet OLE/ACE ole Normally GROUP BY clause is used for Aggregate functions. Example: SELECT STATE,SALARY FROM CUSTOMER GROUP BY STATE ORDER BY STATE Some Databases ...

... and without the overhead of an SQL server. Especially for beginners who come from HTML but also need some database functionality - just like the Jet(access) engine users back in the day on the WEB - would be a big target audience for us. But unfortunately, the view here is MVC and SQL. I agree.

... and without the overhead of an SQL server. Especially for beginners who come from HTML but also need some database functionality - just like the Jet(access) engine users back in the day on the WEB - would be a big target audience for us. But unfortunately, the view here is MVC and SQL. One more ...

... you. Now. For this quick test, you have used ACE. We know ACE is to be installed by the user and is not installed by default. So, I tried with Jet OLEDB. This created ".XLS" file. That is great too. We can now try TRY   use ACECATCH   TRY      use ...

... ) static saProviders := { ;{ "DBASE",    "OLEDB", { "Microsoft.ACE.OLEDB.12.0", "Microsoft.Jet.OLEDB.4.0" }, "Extended Properties=dBASE III" }, ;{ "MSACCESS", "OLEDB", { "Microsoft.ACE.OLEDB.12.0", ...

No driver or provider need to be installed for using DBFs without FPT files. The default Jet OLEDB provider that comes bundled with Windows OS is enough. FWH ADO functions take care of everything for you Establishing a connection. oCn := FW_OpenAdoConnection( foldername ...

... For this reason, you want to use ADO. That is fine. If we confine our application to "*.xls" files only, this is very simple. With Jet OLEDB that is installed by default on alll PCs your application will run fine without any problems at all on all PCs whether Office is installed ...

there seems to be NO "Microsoft.ACE.OLEDB.12.0" on Microsoft Windows [Version 10.0.25387.1] (latest Canary Version)

Jet OLEDB comes bundled with Windows OS.
If we want to use ACE provider, we need to download and install it.

... on your disk, using this single line code: XBROWSER GetExcelRange( cExcelBookNameFullPath ) Function FW_OpenADOExcelSheet() uses ADO using Jet or ACE OleDB provider and Function GetExcelRange() uses Excel Ole.

but ADO is not "on-Board" in Windows. By default, every Windows OS comes with Jet OLEDB. This OLEDB supports ADO with DBase and mdb files with MSAccess and Excel. We do not need to install anything else. We can try this code, without specially installing ...

Ok, but i just want to use the dbf with an old VB6 program that uses a JET connection like this "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=dBase IV;Data Source=" I suppose that i must change the encrypted flag in dbf file header in some ...

First thing I'd investigate is the default printer on each computer. I had a similar problem some years ago and if I remember well it was due to differences between printers ink jet/laser, portrait vs landscape etc. Unfortunatly I can't recall ATM.

... do not have the printer at home while this morning at school I realized that something was wrong and the computer is equipped with an HP printer (jet Ink) how could I solve the problem? I did this at home with the virtual preview ie without the printer https://i.postimg.cc/wByNrmv3/creatodame.png ...

... [lHeaders := .t.] ) --> objeto AdoConnection - Es posible abrir archivos xls en todos los equipos usando el proveedor predeterminado de Jet Ado. Para abrir archivos xlsx, xlsm, xlsb, el proveedor Microsoft ACE.OLEDB.12.0 debe estar instalado en el equipo. Esto se puede hacer instalando ...

... cFileXLS, [lHeaders := .t.] ) --> AdoConnection Object - It is possible to open xls files on all computers using the default Jet Ado provider. To open xlsx, xlsm, xlsb files, Microsoft ACE.OLEDB.12.0 provider must have been installed on the computer. This can be installed ...