Re: VB 5.0 and Oracle 8.0.5

From: MMK Productions <nospammmkprod_at_bellatlantic.net>
Date: 1998/09/02
Message-ID: <6skoao$5ju@world6.bellatlantic.net>#1/1

Look for a setting in one of your property sheets where it set the max rows returned from a SQL statement. Since it is exactly 100, my guess is that is was hardcoded somewhere for you by default.

I think there is a way to search your settings by name. Look for "max" or "rows" or "SQL" and see if something is set to 100. You will want to set this really high or to something which means "don't limit my row count"

Good luck.

Mike Messeh wrote in message <35ed8452.0_at_news>...
>I am a developer using Visual Basic 5.0 and writing to an Oracle 8.0.5
>database using my local Oracle 8.0.5 ODBC driver. I am attempting to run a
>query which should return 539 rows, but instead returns only 100 rows. I
>have no idea why this is happening. The query ran fine in the old program,
>which ran over a SQL Server backend. If anyone can help me solve this
>problem, I would greatly appreciate it.
>
>
Received on Wed Sep 02 1998 - 00:00:00 CDT