Board index » delphi » Is QC 2721 solved in DBX4?
delfo
Delphi Developer |
Is QC 2721 solved in DBX4?2008-02-21 08:21:09 PM delphi162 I have set sqlconnection decimal separator to ",", and yes, when I do a query it shows numbers with a comma, but if I try to update a table with a NUMBER(5,0) as part of the key it gives an error ORA-01722 Invalid Number. I had commented the line ExecuteDirect('alter session set nls_numeric_characters=''.,'''); because I thought it wasn't neccesary in Delphi2007. Just uncommenting it the update works. Am I missing something? |