Subject Re: [IB-Conversions] Problem with store procedure (Interbase)
Author Jean-Jacques Goldschmidt
Post date 2000-10-31T16:45:44Z
Try this :


SET TERM !!
CREATE PROCEDURE Procedure_1 AS
BEGIN
SELECT * FROM MyTable ;
END!!

With best regards
Avec mes meilleures salutations
Mit freundlichen Grüssen
*************************************************
Goldschmidt Jean-Jacques
Rue de la Portettaz
 
CH-1956 St-Pierre-de-Clages
 
+41 27 306.90.46
*************************************************
jjgoldschmidt@...
*************************************************
----- Original Message -----
Sent: Monday, October 30, 2000 5:46 PM
Subject: [IB-Conversions] Problem with store procedure (Interbase)

Hello!
 
I am run the procedure below and Interbase show me this message :
"Statement failed, SQLCODE = -104
 Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 4, char -1
-END"
 
CREATE PROCEDURE Procedure1 AS
BEGIN
         select * from table
END
 
What's the problem ?
 
Marcos Fabiano Mendes de Siqueira
E-mail : marcosf@...
Tel: 55 (41) 360-3500


To unsubscribe from this group, send an email to:
IB-Conversions-unsubscribe@egroups.com