Exists any incompatibility with fields like timestamp?
JC wrote:Antonio and friends,
This is my example for testing!
Please, modify and check!
http://rapidshare.com/files/189783905/ADODB.zip.html
Application
===========
Path and name: E:\FWXHARB\ADODB.EXE (32 bits)
Size: 1,675,264 bytes
Time from start: 0 hours 0 mins 5 secs
Error occurred at: 01/26/09, 20:26:40
Error description: Error ADODB.RecordSet/6 DISP_E_UNKNOWNNAME: ACTIVECONNECTION
Args:
[ 1] = L .F.
Stack Calls
===========
Called from: source\rtl\win32ole.prg => TOLEAUTO:ACTIVECONNECTION(0)
Called from: ADODB.prg => MYSQLRECORDSET(152)
Called from: ADODB.prg => EXECCONNECTION(29)
Called from: ADODB.prg => MAIN(14)
cConnectionString := "Driver={MySQL ODBC 5.1 Driver}" + ;
";Server=127.0.0.1" + ;
";DefaultDatabase=genesis" + ;
";Database=aservit" + ;
";Port=3306" + ;
";User=genesis" + ;
";Password=genesis" + ;
";Option=3;"Sorry, I haven't MySql to test your sample.
EMG
Enrico Maria Giordano wrote:Sorry, I haven't MySql to test your sample.
EMG
Armando,
The problem is with fields that's type is timestamp!
SELECT reg_id, reg_data, reg_update FROM mytable ORDER BY reg_update DESCSELECT reg_id, CAST( reg_data AS CHARACTER ) AS reg_data, CAST( reg_update AS CHARACTER ) AS reg_update FROM mytable ORDER BY reg_update DESCSomeboby?
I still have the problem, if somebody can help me.. thanks
Dear friends,
Thanks for all! I can make this! Now, all it's ok with ADBODB.Connection, ADBODB.RecordSet and ADBODB.Stream with MySQL, PostgreSQL and Oracle... all they with Fivewin 8.10!
Thank so much!
JC wrote:Dear friends,
Maybe the error is on datatype convertion of xHarbour, for fields like TIMESTAMP!
If you make a cast convertion, works!
reg_id = numeric, auto_increment, not null
reg_data = timestamp, notnull, default '0000-00-00 00:00:00'
reg_update = timestamp, notnull, default '0000-00-00 00:00:00'
Error:
SELECT reg_id, reg_data, reg_update FROM mytable ORDER BY reg_update DESC
When the field is filled with any value like '2009-01-27 16:42:25', the ADO return this value like this 2009-01-27, as date
Ok:
SELECT reg_id, CAST( reg_data AS CHARACTER ) AS reg_data, CAST( reg_update AS CHARACTER ) AS reg_update FROM mytable ORDER BY reg_update DESC
In this case, any value of field return a value like this '2009-01-27 16:42:25' as string (because typecast)
And xBrowse do not show the complete value of field... only the data part!
XBrowse shows date part of DateTime values of xHarbour ( including TimeStamp field values of ADO ) by default. If we want full date time value to be shown in xBrowse, we should set oCol:cDataType := 'T'. Then xBrowse shows the values with date and time.
