Re: When length of text data is 1.
This is a discussion on Re: When length of text data is 1. within the pgsql Interfaces odbc forums, part of the PostgreSQL category; --> ожут wrote: > Hello, > > I tried to search in Internet, but didn't find answer... > I'm using ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-16-2008, 03:11 AM
| ||||
| ||||
 Re: When length of text data is 1. ожут wrote: > Hello, > > I tried to search in Internet, but didn't find answer... > I'm using PostgreSQL 8.1.5-1, ODBC, MS Visual C++ with MFC, I'm using > Unicode (database has UTF8 encoding and I'm using "PostgreSQL Unicode" odbc > driver). > I create, for example, such table: > > ***code*** > CREATE TABLE section ( > idsection INT PRIMARY KEY,") > idparent INT NULL REFERENCES section ON DELETE CASCADE,") > name TEXT NOT NULL") > ); > ********** > > Retrieve data thereby: > > ***code*** > CRecordset rcrd(&db); > CString nm; > .... > rcrd.GetFieldValue(_T("name"),nm); > ********** > > It works without any problem except when length of 'name' is 1. > For example, It works fine when name is 'John' but when name is 'J' line > rcrd.GetFieldValue(_T("name"),nm); > throws exception with empty exception message and AFAIK with return code > SQL_NO_DATA. Which version of ODBC driver are you using ? Could you send me the Mylog output ? regards, Hiroshi Inoue ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq      |
 |
« Connecting between Postgres(linux) and Access97
|
Fwd: Bug#396218: bind.c: bad handling of SQL_LEN_DATA_AT_EXEC breaks passing char buffer length at SQLExec time »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 11:37 PM.
