Nando wrote:
ISC ERROR CODE:335544348
no current record for fetch operation.
Use LEFT JOIN:
http://www.firebirdfaq.org/faq144
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
Hi,
I'm having trouble with this simple stored procedure:
SET TERM !! ;
CREATE PROCEDURE test_proc (d_date TIMESTAMP)
RETURNS (Result CHAR(50))
AS BEGIN
Result = CAST(d_date AS CHAR(50));
SUSPEND;
END !!
SET TERM ; !!
If I execute this statement it works fine:
SELECT a.my_id,
Hi,
I'm having trouble with this simple stored procedure:
SET TERM !! ;
CREATE PROCEDURE test_proc (d_date TIMESTAMP)
RETURNS (Result CHAR(50))
AS BEGIN
Result = CAST(d_date AS CHAR(50));
SUSPEND;
END !!
SET TERM ; !!
If I execute this statement it works fine:
SELECT a.my_id,