FiveTech Software tech support forums

This is not true:

Yes, not true for MsAccess, MSSQL and ALL other RDBMS with ADO.
But true for Excel ADO recordset

hi Enrico, it is IMHO while "MSACCESS" is "known" but not "EXCEL" as Provider by Fivewin that is why i ask to enhance FWAdoStruct() / FWAdoFieldStruct() / FW_RDBMSName() for cDbms = "MS JET EXCEL 12.0" ...

hi,

nageswaragunupudi wrote:Using fwh\samples\access.prg, the msaccess database of Read/Write.
We revised access.prg and here it is:

Please copy this program to 32-bit fwh\samples folder overwriting the existing access.prg and build with

Great, thx

Using fwh\samples\access.prg, the msaccess database of Read/Write. We revised access.prg and here it is: #include "fivewin.ch"REQUEST DBFCDXstatic oCn//----------------------------------------------------------------------------//function ...

If you are working with MSACCESS oRs:Filter := "LDATE >= #2023-01-01# AND HDATE < #2023-02-01#" If you are working with Microsoft SQL oRs:Filter := "LDATE >= '2023-01-01' AND HDATE < '2023-02-01'" Note: ...

... 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 any specific software for ADO/OLEDB ...

... dbForge studio for Oracle and many many others Is the fwh ADO class good as well for MSSQL or is this only for MariaDB? ALL eg.,Dbase,FoxPro,MSAccess,Microsoft SQL,SQLite,Oracle,PostGre (natively) and any other RDBMS with connectionstrings.

Otto Here is a snapshot of MsAccess ... Customer table which I only encrypt personal information : http://img4.imagetitan.com/img4/small/25/25_cust.jpg Here is what the Hex looks like ( I presume ) for the same Customer ...

... world. because some database servers accept American notation of dates. For example your syntax of DTOC() does not work for me in India even on MSACCESS. In these forums, please post solutions which are Universal.

Table handling with ADO (MSSQL,SQLEXPRESS,MSACCESS,MYSQL,ORACLE,etc) oRs := FW_OpenRecordSet( oCn, "select * from customer" )// accessing field value? oRs:Fields( "salary" ):Value// modifying field value and ...

... there is a need to do maintenance on compaction, reindexing No need for SQLEXPRESS, MSSQL, ORACLE, etc. Well, you need to do it if you are using MSACCESS and adofuncs have function to do this. 2) How to run an Rlock or Flock to prevent two users from working on the same record or groups of records. ...

... can be: CREATE TABLE `adoimage` (     `ID` INT AUTO_INCREMENT PRIMARY KEY,    `NAME` VARCHAR ( 10 ),    `FOTO` LONGBLOB)  For MSACCESS: CREATE TABLE [adoimage] (    [ID] AUTOINCREMENT PRIMARY KEY,   [NAME] VARCHAR ( 10 ),   [FOTO] ...

Rao Sir,
How to open Password protected MSaccess / Excel file

There is not Memo Field type in any sql database, MSAccess, MySql or MSSql
In MSAccess, MySql, MSSql the field type is TEXT.
In Oracle the field type is also called CLOB

... Fecha (Date) y Fecha/Hora (DateTime) en ADO, XBrowse, TDataRow, TRecSet y en la función FWAdoStruct( oRs ) En muchas bases de datos como MSAccess, MSSQL, Oracle, solo el tipo de campo DateTime está disponible para almacenar fechas simples y valores de fecha y hora. Si un campo en particular ...