1. ODBC question
Using a cursor for moving around and changing records, how do you delete a
record and have it show up in the cursor? refresh the cursor?
thanks.
george
2. Re: ODBC question
Thanks, Matt.... that did work.. It would be nice (if MS has such a
function) to remove it from the cursor rather than reloading the data,
particularly if it's a larger file.
george
----- Original Message -----
From: "Matt Lewis" <matthewwalkerlewis at yahoo.com>
To: "EUforum" <EUforum at topica.com>
Subject: RE: ODBC question
>
>
> > From: George Walters [mailto:gwalters at sc.rr.com]
> >
> > Using a cursor for moving around and changing records, how do
> > you delete a record and have it show up in the cursor?
> > refresh the cursor?
>
> I haven't done this yet, but that would be my recommendation. The cursor
is
> based on a SQL statement, and the data returned by the statement, so it
> wouldn't change when the underlying [table] data is modified--it exists
> separately from the tables in your database.
>
> Matt Lewis
>
>
>
> TOPICA - Start your own email discussion group. FREE!
>
>
3. ODBC question
Matt, is there a way to position in a cursor other than by a "record
number"?.... for example find partNbr 1234 in the cursor set?
george
