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
Alexandre Benson Smith wrote:
To achieve what he wants he will need to write an app (or stored
procedure, or whatever) that loops trough the fields and generate the
trigger PSQL code like
No need to write anything. In FlameRobin, you can right-click the table,
select Generate code and then
EXECUTE STATEMENT is for executing queries only, your code is not just a
query as it contains an IF statement. I think for your purposes you need
to use EXECUTE BLOCK
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-execblock.html
Thanks
On 9-8-2012 22:13, Sergio wrote:
EXECUTE STATEMENT is for executing queries only, your code is not just a
query as it contains an IF statement. I think for your purposes you need
to use EXECUTE BLOCK
Em 9/8/2012 17:19, Mark Rotteveel escreveu:
I think you need to create an EXECUTE BLOCK statement as text and then
execute that using EXECUTE STATEMENT, however I am not actually sure if
that would give you access to the NEW and OLD context tables.
Mark
There is no way to access NEW and OLD