RE: Oracle's SQLRowCount deficiency

Yea,

I don't think ODBC is bi directional.  What really needs to happen is 1
of 2 things

1) Rlib does a row cache as it's going along so that the rows can be
recalled later

2) Requery

Both kinda suck.  Are you guys using rlib_followers  w/ ODBC??

- bob

On Thu, 2005-03-31 at 11:45 -0600, Derek Giromini wrote:
> My C is good, but my problem has been time. Unfortunately, my job involves
> doing a lot of little side things that keep me from focusing too much energy
> on the project involving RLIB -- especially at the end of the month.
> 
> What I've done it added an SQLFetch loop inside of
> odbc_new_result_from_query if SQLRowCount returns -1. I then use SQLGetPos
> to reposition the cursor to the beginning of the resultset. I added some
> output that gives me the rowcount. While the rowcount is correct, I get no
> data. I assume this is because I still haven't figured out how to "reset"
> the resultset.
> 
> -----Original Message-----
> From: Bob Doan [mailto:bdoan-J0aWFLYJOWhWk0Htik3J/[email protected]]
> Sent: Thursday, March 31, 2005 10:55 AM
> To: Derek Giromini
> Cc: '[email protected]'
> Subject: Re: [Rlib-users] Oracle's SQLRowCount deficiency
> 
> 
> Do you get anything at all???
> 
> How's your c?  I can give you some pointers in the code where to look.
> 
> 
> 
> On Thu, 2005-03-31 at 09:56 -0600, Derek Giromini wrote:
> > I've had no luck getting RLIB to pull a decent resultset from Oracle
> through
> > Microsoft's ODBC. I've also found absolutely no code fragments on the web
> to
> > assist me with this. Is there something in ODBC that I'm missing that
> could
> > help me? I've already tried SQLSetPos and other such functions.
> > 
> > > I think I know whats going on, someone reported this before but
> > disappeared while in the middle of debugging the problem.
> > 
> > > Oracle does not implement SQLRowCount.  I think I can write the ODBC
> > connector w/ out this or perhaps you want to give it a shot
> > (rlib/inputs/odbc/odbc.c)
> > 
> > 
> > -------------------------------------------------------
> > This SF.net email is sponsored by Demarc:
> > A global provider of Threat Management Solutions.
> > Download our HomeAdmin security software for free today!
> > http://www.demarc.com/info/Sentarus/hamr30
> > _______________________________________________
> > Rlib-users mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/rlib-users



-------------------------------------------------------
This SF.net email is sponsored by Demarc:
A global provider of Threat Management Solutions.
Download our HomeAdmin security software for free today!
http://www.demarc.com/info/Sentarus/hamr30