On Thu, 26 Apr 2001 19:28:38 +0300 (EET DST), Tumelis Giedrius IF 5/1 wrote:
** This is not a support list. For more help, try the IB-Support list (which I forgot the
mail to subscribe))) ;-). **
This thing of declaring cursors is only for
Embedded SQL (using the ancient program
called GPRE).
Not for stored procedures or Dynamic SQL queries.
>hello,
>
>As writen in Interbase 6.01 documentation, there is capability to create
>cursor in the Interbase 6.01 server and insert blob data in the database
>table using this created cursor.
>
>First I tried to create some test cursor to see how this works.
>
>As writen in documentation, the cursor declaration syntax is:
>declare <cursor name> cursor for <select block>;
>
>For example:
>
>declare kurs cursor for select * from Product;
>
>This statemend I tried to use with IBConsole, isql and in java source.
>Everywhere got message about error :
>error -104 <..> line 1 char 8.
>
>:(
>
>
>
>Is it possible to create currsor in the interbase ?
>
>If so, how to do that ?
>If not, why then is otherwise declared in the documentation, and how to
>insert blob data in the table without using cursor ?
>
>with respect
>Giedrius Tumelis.
>
>
>Community email addresses:
> Post message: IBDI@yahoogroups.com
> Subscribe: IBDI-subscribe@yahoogroups.com
> Unsubscribe: IBDI-unsubscribe@yahoogroups.com
> List owner: IBDI-owner@yahoogroups.com
>
>Shortcut URL to this page:
> http://www.yahoogroups.com/community/IBDI
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>