Re: ForwardOnly ?
От | Petr Odložil |
---|---|
Тема | Re: ForwardOnly ? |
Дата | |
Msg-id | 426DDAA2.7030907@trakceol.cz обсуждение исходный текст |
Ответ на | Re: ForwardOnly ? (lothar.behrens@lollisoft.de) |
Список | pgsql-odbc |
I've tried both. to switch off the updateable cursors and to uninstall ODBC driver and install 7.3.2. but still the same problem. I've looked into the psqlodbc_xxxx.log and found this message : conn=25181736, query='SELECT * FROM modules WHERE m_sname='KRASNE_LOUCKY' AND m_type=0 AND m_ip0=10 AND m_ip1=0 AND m_ip2=2 AND m_ip3 = 20 AND m_mb=2' [ fetched 7 rows ] STATEMENT ERROR: func=PGAPI_ColAttributes, desc='', errnum=13, errmsg='Invalid column number in ColAttributes.' ------------------------------------------------------------ hdbc=25181736, stmt=25202240, result=25202080 manual_result=0, prepare=0, internal=0 bindings=25203160, bindings_allocated=8 parameters=0, parameters_allocated=0 statement_type=0, statement='SELECT * FROM modules WHERE m_sname='KRASNE_LOUCKY' AND m_type=0 AND m_ip0=10 AND m_ip1=0 AND m_ip2=2 AND m_ip3 = 20 AND m_mb=2' stmt_with_params='SELECT * FROM modules WHERE m_sname='KRASNE_LOUCKY' AND m_type=0 AND m_ip0=10 AND m_ip1=0 AND m_ip2=2 AND m_ip3 = 20 AND m_mb=2' data_at_exec=-1, current_exec_param=-1, put_data=0 currTuple=-1, current_col=-1, lobj_fd=-1 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1 cursor_name='SQL_CUR01808E40' ----------------QResult Info ------------------------------- fields=25175672, manual_tuples=0, backend_tuples=25214360, tupleField=25214360, conn=25181736 fetch_count=0, num_total_rows=7, num_fields=8, cursor='(NULL)' message='(NULL)', command='SELECT', notice='(NULL)' status=8, inTuples=0 CONN ERROR: func=PGAPI_ColAttributes, desc='', errnum=0, errmsg='(NULL)' ------------------------------------------------------------ henv=25181680, conn=25181736, status=1, num_stmts=16 sock=25192736, stmts=25201016, lobj_type=-999 ---------------- Socket Info ------------------------------- socket=572, reverse=0, errornumber=0, errormsg='(NULL)' buffer_in=25192808, buffer_out=25196912 buffer_filled_in=557, buffer_filled_out=0,buffer_read_in=557 In mylog_xxx.log I've found this [1268][[SQLColAttribute]][1268]PGAPI_ColAttributes: entering..col=9 1011 len=256. [1268]SC_pre_execute: status = 3 [1268]**** PGAPI_ColAtt: result = 25202080, status = 3, numcols = 8 [1268]STATEMENT ERROR: func=PGAPI_ColAttributes, desc='', errnum=13, errmsg='Invalid column number in ColAttributes.' [1268]CONN ERROR: func=PGAPI_ColAttributes, desc='', errnum=0, errmsg='(NULL)' [1268][SQLBindCol][1268]PGAPI_BindCol: entering... and several lines down after that this : [1268]PGAPI_ExtendedFetch: stmt=25202240 [1268]SQLFetchScroll return = -1 [1268][[SQLGetDiagRec]] [1268]PGAPI_GetDiagRec entering rec=1[1268]**** PGAPI_StmtError: hstmt=25202240 <512> [1268]SC_get_error: status = 33, msg = #The fetch type for PGAPI_ExtendedFetch isn't allowed with ForwardOnly cursor.# [1268] szSqlState = 'S1106',len=77, szError='The fetch type for PGAPI_ExtendedFetch isn't allowed with ForwardOnly cursor.' [1268]PGAPI_GetDiagRec exiting 0 Petr lothar.behrens@lollisoft.de wrote: > Am 25 Apr 2005 um 8:00 hat Jeff Eckermann geschrieben: > > >>--- Petr Odložil <odlozil@trakceol.cz> wrote: >> >>>I din't set this option forward cursors only and I >>>even can't find it to >>>check the state of it. I'm using ODBC driver for >> >>My understanding is that, if you want an updateable >>cursor, it has to be forward only. This is a >>limitation of the PostgreSQL ODBC driver. I believe >>that the "updatable cursors" driver setting refers to >>this. But I'm only working from memory here; I could >>not find a reference to this when I looked. Someone >>else please correct me as necessary. > > > I use updateable cursors also when moving back. > I do not remember, if it not works, when I move a row back > after editing a row. > > But I must say, that there will be a problem with the 8.x ODBC > driver. Even reinstalling the old 7.3.200 version it didn't resolved > it. > This is because the install process may be brocken. I have removed > the 8.x driver by hand, before reinstallation of 7.3.200. > > The code for my ODBC abstraction classes are public. All can try it. > See the link below. > > Lothar > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > -- Odchozí zpráva neobsahuje viry. Zkontrolováno Antivirovým systémem AVG. Verze: 7.0.308 / Virová báze: 266.10.3 - datum vydání: 25.4.2005
В списке pgsql-odbc по дате отправления: