Subject | Re: invalid request BLR at offset 383 BLR syntax error...... |
---|---|
Author | Leonardo Cosmai |
Post date | 2006-06-05T20:36:04Z |
--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:
This is the statement:
SELECT A.* FROM A INNER JOIN A_STORE_PROCEDURE(?,?) B ON (A.COL1 = B.COL1)
where A_STORE_PROCEDURE is really a simple FOR SELECT.....
Thanx
Ciao
L.
<aharrison@...> wrote:
>Sorry for the delay...
> Leonardo Cosmai wrote:
>
> One idea is to upgrade to 1.5.3, which fixes a bunch of bugs. Other
> ideas will need more information. Firebird is not natively a SQL
> engine. It runs a very general binary relational language called
> BLR that was designed for machine generation. Constructions of
> SQL, QUEL, and Data Language can be represented in BLR. So, your
> error says that something went wrong in the translation of your
> query to BLR... Now, that could be just your statement, though
> that's unlikely. Or it could be a stored procedure. Or it could
> be a reference to an external function.... If you can identify
> the statement associated with the error, that would be a great
> step forward.
This is the statement:
SELECT A.* FROM A INNER JOIN A_STORE_PROCEDURE(?,?) B ON (A.COL1 = B.COL1)
where A_STORE_PROCEDURE is really a simple FOR SELECT.....
Thanx
Ciao
L.