Hi, i would like to understand this plan
PLAN (TABLE1 ORDER TABLE1_IDX1 INDEX (TABLE1_UK))
And the select that generets it is this one:
SELECT first 1 PREU_COST
FROM TABLE1
WHERE ARTICLE = :p_article
AND DATA = :P_DATA
AND DIVISA = :P_DIVISA
AND PREU_COST 0
ORDER BY DATA DESC,ID
30.08.2014 11:25, Jaume Llunell Gómez wrote:
Hi, i would like to understand this plan
PLAN (TABLE1 ORDER TABLE1_IDX1 INDEX (TABLE1_UK))
And the select that generets it is this one:
SELECT first 1 PREU_COST
FROM TABLE1
WHERE ARTICLE = :p_article
AND DATA = :P_DATA
AND
Hi,
Should the Execute statement work on an ODBC datasource already with FB 3.0?
EXECUTE BLOCK AS
BEGIN
EXECUTE STATEMENT 'SELECT * FROM TEST_TABLE'
ON EXTERNAL 'ODBC://TEST';
END
I receive the following error message:
Execute statement error at attach :335544721 : Unable to complete
Questions on Firebird 3.0 - as long as it isn't final - should be
directed to the firebird-devel mailinglist.
Note that the document you link to is about the provider architecture,
there is no ODBC provider included in Firebird 3.0, so this doesn't work
out of the box.
Mark
On 30-8-2014
30.08.2014 14:25, bert_herngr...@yahoo.com wrote:
Should the Execute statement work on an ODBC datasource already with FB 3.0?
No.
The ability to access foreign database engines using providers should
not be overlooked, either. It might seem
strange to consider this, given the number of
Thank you very much Dimitry
2014-08-30 10:41 GMT+02:00 Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] firebird-support@yahoogroups.com:
30.08.2014 11:25, Jaume Llunell Gómez wrote:
Hi, i would like to understand this plan
PLAN (TABLE1 ORDER TABLE1_IDX1 INDEX
On FreeBSD 10, the following command:
pkg install databases/firebird25-server
will only install version 2.5.2_5.
How do I get it to pull version 2.5.3 from the sourceforge repository?