FiveTech Software tech support forums

... when you use SELECT * , unless you specify every column and provide unique alias column name for the duplicated column names, in all DBMS expect MSACCESS. Ok, I didn't understand. You can use SELECT *, PRESTAMOS.REGISTRO AS PREREG, etc. FROM ... It is highly desirable to avoid duplicate field ...

... when you use SELECT * , unless you specify every column and provide unique alias column name for the duplicated column names, in all DBMS expect MSACCESS. It is highly desirable to avoid duplicate field names by laboriously specifying all field names in the select clause. Sad no DBMS, except ...

... SQL functions fully support SQLite and Oracle also suitably taking care of the field types and formatting appropriate to the RDBMS in addition to MSACCESS, MSSQL and MySQL. In the next versions, we propose to add FireBird and Postgresql. I suppose with that we would be covering adequate range ...

Hello,

Anyone is using it?.

Any particular issue?. For example, SQLite has its own format for dates, different tan MSACCESS/MYSQL.

Thank you very much.

... 5. nMultiRowSize [Optional: Default 20]: This function used SQL "INSERT" statements to speed up import instead of ADO's AddNew(). Though MSACCESS allows only single row inserts, most other RDBMS permit multi-row inserts. By default for RDBMS other than MSACCESS, the function prepares ...

Mr. Nages,

In the datarow.prg you sent me on 15th I still get the error.

The error only happens with MSACCESS, not with MySQL or MSSQL server.

Thank you.

... is managed by MySQL: cQuery += "ID INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY(ID), " What is the equivalent please for MS Access?. For MsAccess, I tried with NO luck: cQuery += "Id INT IDENTITY PRIMARY KEY, " But the auto increment feature is not managed propelly, I always ...

... is managed by MySQL: cQuery += "ID INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY(ID), " What is the equivalent please for MS Access?. For MsAccess, I tried with NO luck: cQuery += "Id INT IDENTITY PRIMARY KEY, " But the auto increment feature is not managed propelly, I always ...

Lucas, Mr. Enrico, Thank you very much, but I always get, either MYSQL or MSACCESS: Incorrect arguments, out of range or in conflict with others. (0x800A0BB9) What I am doing wrong?. Thank you. Please, show me how are you calling the function. A reduced and self-contained ...

Mr. Enrico,

Thank you very much, but I always get, either MYSQL or MSACCESS:

Incorrect arguments, out of range or in conflict with others. (0x800A0BB9)


What I am doing wrong?.

Thank you.

... Useful for deciding if a field is readonly. New: FW_DateToADO( dDate ) --> '#YYYY-MM-DD#' Converts a date as literal for use in ADO and also MsAccess SQL Enhanced: FW_OpenAdoConnection( cConnStr, [ lShowError ] ) In case of MSAccess, it is enough if the name of mdb/accdb file is specified ...

... }  This sample program is fully self contained and you can just compile and run. The program creates a sample MDB ( MsAccess database ), creates parent and child tables and shows the browse. You can add parents and childs and see how it works. #include "fivewin.ch"#include ...

... are ok: http://forums.fivetechsupport.com/viewtopic.php?p=140460#p140460 * Enhancement: FW_OpenAdoConnection( cConnStr ) Now for connecting to MSAccess mdb database it is enough to specify the full path of the mdb file For connectiong to a folder containing DBF tables, it is enough to specify ...

... 7 DWM Notification Window, C:\Windows\system32\Dwm.exe 8 Escriba una pregunta, C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE 9 FiveWin for Harbour, C:\ProyectosADO\BrinquisMdb\CEMEIN.Exe 10 MCI command handling window, C:\Program Files\AVAST Software\Avast\AvastUI.exe ...

I extensively use xbrowse with ADO ( SQL Server, Oracle, MSAccess, etc )
XBrowse behaves correctly.

Are you assigning any value to oBrw:bPastEof ?

Can you post a small self contained example ?