Search found 51 matches: informix

Return to advanced search

Re: DISP_E_UNKNOWNNAME: RECORDCOUNT

Thanks for reply Rick

I have try
If oRset:RecordCount() > 0

and many other options

I use Informix database
May be that is the problem with ado and win 10?
or informix odbc driver ?
In any opinion RecordSet produce error on win 10

Best regards.
by avista
Wed Apr 19, 2017 8:04 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DISP_E_UNKNOWNNAME: RECORDCOUNT
Replies: 8
Views: 1394

Re: Nuevo ADORDD

... next time is opened. Tested engines: ACCESS ADS DBASE FIREBIRD FOXPRO MS SQL MYSQL POSTGRE SQLITE Still not tested but should work ok: ANYWHERE INFORMIX MARIADB ORACLE
by AHF
Thu Nov 26, 2015 5:47 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Nuevo ADORDD
Replies: 55
Views: 16411

Re: ADO RDD xHarbour

... next time is opened. Tested engines: ACCESS ADS DBASE FIREBIRD FOXPRO MS SQL MYSQL POSTGRE SQLITE Still not tested but should work ok: ANYWHERE INFORMIX MARIADB ORACLE
by AHF
Thu Nov 26, 2015 5:47 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441907

ADORDD FAQs

... is Transactional you will have transactions control in adordd. 13) What SQL engines can I use ? ADS ACCESS ANYWHERE DBASE POSTGRE FIREBIRD FOXPRO INFORMIX MSSQL MYSQL ORACLE POSTGRE SQLITE But others can be easily added to be supported. 14) What about if MS stops development or support to MS ADO ...
by AHF
Sun Nov 15, 2015 6:26 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADORDD FAQs
Replies: 87
Views: 19522

Re: Nuevo ADORDD

... además MsSql, MySql, Access, ADS, FoxPro, dBase. Debería funcionar sin problemas, pero no probado con Sybase tipo de servidores SQL Server, Informix, PostGreSQL. Probablemente Oracle también pero Ill comprobarlo pronto.
by AHF
Tue Nov 10, 2015 10:16 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Nuevo ADORDD
Replies: 55
Views: 16411

Re: ADO RDD xHarbour

... sqlite and firebird besides MsSql, MySql, Access, ADS, FoxPro, Dbase. Should run without problems but not tested with Sybase kind of Sql Servers, Informix, PostGre. Probably Oracle also but Ill check it soon.
by AHF
Tue Nov 10, 2015 10:13 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441907

Re: Nuevo ADORDD

Nueva versión ADORDD en https://github.com/AHFERREIRA/adordd.git

Correcciones menores.
Añadido cadenas de conexión a (no probado):

SQLITE
POSTGRE
INFORMIX
ANYWHERE
by AHF
Thu Jun 25, 2015 3:47 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Nuevo ADORDD
Replies: 55
Views: 16411

Re: ADO RDD xHarbour

New version adordd at https://github.com/AHFERREIRA/adordd.git

Minor corrections.
Added connection strings to (not tested) :

SQLITE
POSTGRE
INFORMIX
ANYWHERE
by AHF
Thu Jun 25, 2015 3:46 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441907

Re: for Mr. Nages ADO SELECT for logical fields

... unsafe and also experienced it. But we can't change their age old habits) I understand Postgre has a boolean field type. Not sure about postgre, informix, etc Personally I use =0 or <> 0 instead of =0 and =1.
by nageswaragunupudi
Sun Jun 21, 2015 9:58 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: for Mr. Nages ADO SELECT for logical fields
Replies: 5
Views: 833

Re: HCAD, Acceso Comun a Bases de Datos con Harbour...

... with any of these servers without any change. Only change is the initial connection. We also like to include full support for others like Postgre, Informix and Firebird, if programmers using these databases provide necessary support and feedback to us.
by nageswaragunupudi
Mon May 04, 2015 12:03 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: HCAD, Acceso Comun a Bases de Datos con Harbour...
Replies: 7
Views: 2982

Re: Considering moving to Korea to build FiveTouch

... FIVEWIN is not CLIPPER for windows anymore I work in company with around 2000 peoples and around 100 IT engineers, using few strong servers wiht Informix db Everyone like my tools programs but when i ask to buy few more licenses of fivewin and they open your web site they laught to me .... CLIPPER ...
by avista
Thu Nov 20, 2014 2:56 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Considering moving to Korea to build FiveTouch
Replies: 30
Views: 6755

Re: ADO & SQL INSERT Statement

... not have idea how to implement in program ... i will try this days and please if you have some experiance with this tell me some sugestions IBM Informix Guide to SQL: Tutorial Using an Insert Cursor The DECLARE CURSOR statement has many variations. Most are used to create cursors for different ...
by avista
Thu Jul 31, 2014 7:28 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO & SQL INSERT Statement
Replies: 9
Views: 2216

Re: ADO & SQL INSERT Statement

... following code CODE: SELECT ALL EXPAND VIEW insert into test (campo1,campo2) values ('1','texto1'),('2','texto2') and no error. But like Rao said, Informix does not support. We need to do single row inserts only. Statements UNLOAD TO and LOAD FROM are not standard SQL statements and they are part ...
by avista
Thu Jul 31, 2014 6:59 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO & SQL INSERT Statement
Replies: 9
Views: 2216

Re: ADO & SQL INSERT Statement

... this way or similar way. (Note: FW_AdoImportFromDBF() uses the syntax appropriate for different servers using multiple row insert statements) Informix does not support. We need to do single row inserts only. Parameterized queries as suggested above will improve the speeds.
by nageswaragunupudi
Thu Jul 31, 2014 1:14 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO & SQL INSERT Statement
Replies: 9
Views: 2216

Re: ADO & SQL INSERT Statement

... SQL you can now execute much faster inside a for loop many times changing the values each time. Each SQL will vary its syntax. Can't help with Informix, but ADS uses a set of functions from ACE32.dll named ADSSet....() to set each parameter. Perhaps you can do a search for named parameters ...
by reinaldocrespo
Wed Jul 30, 2014 1:48 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO & SQL INSERT Statement
Replies: 9
Views: 2216
Next

Return to advanced search