Hi Set and Walter

Sorry I have not been able to provide feedback eariler.  I intend to install 2.5 and try out both your suggestions and get back to you again.

Thanks and regards
Bhavbhuti

 

>>Is this a Firebird 2.5 database with dialect 3 (if the database was created with InterBase before Firebird was born,
>>it could be dialect 1, if it is a newer database it is most likely dialect 3 unless it is explicitly set to a
>>different dialect)?
>>
>>I created two tables (MACCOUNTS & SSALEINVOICEFOOTER), added the records you mentioned and ran the SQL through
>>Database Workbench before I posted my reply, so the code ought to work. To me it seems as whatever tool you're using
>>to execute the query thinks that the semicolon actually ends the query rather than being part of the statement. You
>>could of course try
>>
>>SET TERM ^^ ;
>>
>>before EXECUTE BLOCK, but I've never had to do that with EXECUTE BLOCK. I'm sorry that I've no other suggestion for
>>you, if the database is not Firebird 2.5 with dialect 3 (OK, I jumped directly from Firebird 1.5 to Firebird 2.5, so
>>I'm not certain whether it will work with older Firebird 2.x), then I simply don't think my suggestion can help you.
>
>Yes you are correct Set maybe I will have to update to FB 2.5 because I am on 2.1.4 still.  Glad to know you did the jump,
>I was think to jump to FB 3 directly when it comes but I guess I will have to update to 2.5 inbetween.

Thinking about it, Bhavbhuti, EXECUTE BLOCK is more or less an 'unstored' procedure. So you could try replacing EXECUTE BLOCK with CREATE PROCEDURE (though I haven't tried this yet and cannot do it from where I'm sitting just now). Though I don't know why EXECUTE BLOCK didn't work for you, according to the release notes it has been available since Fb 2.0 (although changed) and CTEs since Fb 2.1. And there's nothing complicated in what I'm doing (the resulting query is a bit complex, but selecting a string cannot be considered complex). What tool are you using when you get the error?

Set

-- 


Thanking you.

Yours Faithfully,
For Venus Software Operations
----
Mr. Bhavbhuti Nathwani
___________________________________________
Softwares for Indian Businesses at: http://www.venussoftop.com

venussoftop@...
venussoftop@...
___________________________________________

Please note: We reserve complete rights for policy changes in the future and the same will be applicable immediately as and when made.  Attachments may get corrupted before reaching you, in such a situation please let us know and we will resend you the same at the earliest.  We do not take any responsibility for data loss of any type and kind.  Data safety remains the sole the responsibility of the users of our softwares.
___________________________________________

Internet email confidentiality:

This message may contain information that may be privileged or confidential.  If you are not the addressee nor are you responsible for the delivery of the message to the addressee indicated in this email, then you may not copy or deliver this email to anyone and you should notify the sender by reply email and then destroy this message.

Please reply email immediately to this message with REMOVE in the subject, if you or your employer do not consent to email of this kind.

Opinions, conclusions and other information in this message that do not relate to the official business of my firm shall be understood as neither given nor endorsed by my company.