Re: Select error with SQLBase

[mahidhar puvvada <mpuvvada@HOTMAIL.COM>]

Hi,
To increase the buffer size in the "Begin-Select" statement you have to
use -B flag. the default size is 10 rows and if u want to increase the
size the syntax looks this way

   Begin-Select   -Bnn
    ---stuff----
   End-select
   nn is the size of the buffer

Hope this helps


>Date:         Fri, 11 Sep 1998 12:26:01 +1000
>Reply-To: SQR-USERS@USA.NET
>From: Pietersz Mark x8921 <mpieters@CITIPOWER.COM.AU>
>Subject:      Select error with SQLBase
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>
>Folks,
>
>Database        SQLBase 6.1
>SQR             4.2.3
>OS              NT 4.0 sp3
>Product         PeopleSoft 7.5 single user
>
>I get the following error message when performing a begin-select
>
>(SQR 5528) SQLBase SQLFET error 105 in cursor 1:
>   Attempt to fetch into numeric column that is too small
>
>Error on line 71:
>   (SQR 3725) Bad return fetching row from database.
>
>Database        Oracle 7.3.4
>SQR             3
>
>I understand that it is possible to change the buffer size on the
>begin-select but the doco doesn't give any samples. Also it doesn't
>state what the default values are to begin with.  I'm not even sure if
>this will help
>
>When I try this against an oracle database there is no problem.
>
>TIA
>
>Mark Pietersz
>PeopleSoft Consultant
>


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com