[Gambas-bugtracker] Bug #2171: gb.db.odbc: unable to convert date

bugtracker at gambaswiki.org bugtracker at gambaswiki.org
Thu Apr 29 16:10:52 CEST 2021


http://gambaswiki.org/bugtracker/edit?object=BUG.2171&from=L21haW4-

Comment #10 by PICCORO LENZ MCKAY:

registro insertados 
gb.db.odbc: unable to convert date: 2013-08-07
row count 0

BUT: after added LC_ALL and LC_LANG set to "C" i got a garbage in the count row:

registro insertados 
gb.db.odbc: unable to convert date: 2013-08-07
row count 0 pe�?


```
    $con.Exec("DROP TABLE IF EXISTS `tabla3`;")
    $con.Exec("CREATE TABLE IF NOT EXISTS `tabla3` ( `col1` nvarchar(60), col3 date );")
    rs = $con.Exec("INSERT INTO tabla3 ( col1, col3) VALUES ( 'peñe',CONVERT(DATETIME,'08/07/2013',101) )")
    Print "registro insertados "
    rs = $con.Exec("SELECT col1, col3 FROM tabla3 ") 
    While (rs.Available)
        Print "row count " & rs.Index;
           For Each rf In rs.Fields
               Print " " & rs[rf.Name];
           Next
          rs.MoveNext()
          Print " - "
    Wend
```

puff, I guess Gianluigi you are a project leader, you should get more involved instead of delegating to such an extent that you can't execute a simple example.

PICCORO LENZ MCKAY changed the state of the bug to: Accepted.




More information about the Bugtracker mailing list