<font face="Default Sans Serif, Verdana, Arial, Helvetica, sans-serif"
size="2"><div><div>hallo,</div><div> </div><div>iuse the cygwin postgresql 7.03.x and i have ported some tables from
accessto pg. for example the following you can see at the bottom of this mail. and there are some datasets in this
table(more than 1!!!).</div><div>with libodbc++ i login into the db, create and execute my select-statement and let get
theresultset with:</div><div> odbc::ResultSet* rs = stmt->getResultSet();</div><div> </div><div>and with
rs->next()i go to the first dataset. all to this point works fine and the data is also correct. but if i try to get
thenext dataset with rs->next() i get this sql-exception:</div><div> Error fetching numeric statement option: Not
positionedon a valid row.</div><div> </div><div>but there are more than 1 dataset in this table.</div><div>the odbc
driverseems to work correctly cause access shows me all datasets.</div><div> </div><div>i hope, somebody can help
me.</div><div>thanksin advance,</div><div>axel</div><div> </div><div> </div><div><font color="#0000ff"><p><font
face="DefaultMonospace, Courier New, Courier, monospace">CREATE</font></font><font face="Default Monospace, Courier
New,Courier, monospace"> <font color="#ff0000">TABLE</font> public.devices ( key_devclass int4 NOT NULL, key_devname
varchar(50)NOT NULL, </font><font face="Default Monospace, Courier New, Courier, monospace"><font
color="#ff0000">CONSTRAINT</font>devices_pkey PRIMARY KEY (key_devname)</font><font face="Default Monospace, Courier
New,Courier, monospace">) WITH OIDS;</font></div><div> </div></div></font>