Re: Server Side Cursors.

Hiroshi,

Here is some more information..

> What cursor type are you using ?

Working setup is:
Client Side Cursors Location, Static cursor type, and Optimistic Locking.

The Following setups return only 8 records out of 5110:
Server Side Cursors Location, Static cursor type, and Optimistic Locking.
Server Side Cursors Location, Keyset cursor type, and Optimistic Locking.
Server Side Cursors Location, Static cursor type, and Pessimistic Locking.
Server Side Cursors Location, Keyset cursor type, and Pessimistic Locking.
Server Side Cursors Location, Static cursor type, and ReadOnly Locking.

The following return 0 records:
Server Side Cursors Location, Dynamic cursor type, and Optimistic Locking.
Server Side Cursors Location, forward-only cursor type, and ReadOnly Locking.
Server Side Cursors Location, Dynamic cursor type, and Pessimistic Locking.
Server Side Cursors Location, Dynamic cursor type, and ReadOnly Locking.

The Select command the dataenvironment is using is;
select * from bloods where date is not null order by date desc

Here is the table structure:
CREATE TABLE "bloods" (
"date" date,
"animal" varchar(10),
"p" text,
"s" char(15),
"glu" float8,
"bun" text,
"crea" float8,
"tp" float8,
"alb" float8,
"tbil" float8,
"alp" float8,
"alt" float8,
"ast" float8,
"chol" text,
"ca" float8,
"phos" float8,
"na" float8,
"k" float8,
"cl" float8,
"agratio" text,
"buncreatinineratio" float8,
"globulin" text,
"magnesium" text,
"hgb" float8,
"htc" float8,
"wbc" float8,
"rbc" float8,
"mcv" float8,
"mch" float8,
"mchc" float8,
"plt" float8,
"plymph" text,
"plymphpercent" text,
"band" text,
"bandpercent" text,
"lymph" text,
"lymphpercent" text,
"mono" text,
"monopercent" text,
"eos" text,
"eospercent" text,
"baso" text,
"basopercent" text
);
CREATE INDEX "date_bloods_key" ON "bloods" ("date");
CREATE INDEX "animal_bloods_key" ON "bloods" ("animal");

Thanks again.

Ryan