Devart Forums

I used new version 2.10.7 .
But still wrong value .

It garbles sometimes. (not always)

ex)
Dim dbCmd As New CoreLab.PostgreSql.PgSqlCommand
dbCmd.CommandText = "SELECT MAX(PERSON_ID) FROM TBL_PERSON ;"
dbCmd.ExecuteScalar()
The answer is '001'. but dbCmd.ExecuteScalar() answer '001x'.

postgreSQL 8.0.2 encoding:EUC_JP

Please send us script to create "TBL_PERSON" table.

This is Create table SQL.

CREATE TABLE TBL_PERSON (
USER_ID VARCHAR(10),
PERSON_ID VARCHAR(10),
KIND_CD VARCHAR(10),
TIMEZONE_CD INT DEFAULT 0,
SEQ INT DEFAULT 0,
LAST_NAME VARCHAR(50),
FIRST_NAME VARCHAR(50),
LAST_NAME_KANA VARCHAR(50),
FIRST_NAME_KANA VARCHAR(50),
DEPT VARCHAR(100),
TEL VARCHAR(50),
FAX VARCHAR(50),
E_MAIL VARCHAR(255),
NOTES TEXT,
CREATE_DATE TIMESTAMP,
CREATOR VARCHAR(50),
UP_DATE TIMESTAMP,
UPDATER VARCHAR(50),
DEL_DATE TIMESTAMP,
PRIMARY KEY (USER_ID,PERSON_ID,KIND_CD,TIMEZONE_CD)
);


'0001' is OK. But '001' is wrong.('001x')

Could you get '001x' using another tools, for example PgAdmin?

PgAdminIII is no problem.
It operates normally.

We can not reproduce the problem. Please specify after what actions do you get the corrupted values.
Probably problem is not in getting data but in inserting data in to the table.
Please check with PgAdmin the table contents as soon as you get wrong values with PostgreSQLDirect .NET.