the query is: SET TERM ^ ; ALTER PROCEDURE SALVARROTA ( datahora timestamp, distancia double precision, custo double precision, capacidadelivre double precision, capacidadetotal double precision, nome varchar(50), depositox double precision, depositoy double precision, chegadax double precision, ...
How can I compact Firebird 2.1 database, like we do in MS Access (discarding erased data, remaking index, etc)? There's a way to do it? Thanks! ...
if you are running a query that inserts a new set of records in a table from other one, there is a way to force the update of the coincident pk record in the destination table, without deleting records or split the process in two others (insert new and update existing)? ...
Setup: firebirdsql 2.1.3 win32, php 5.3 (installed with xampp) When I try to update a record that's edited in a desktop app or IBexpert, and there is a deadlock, ibase_execute just hangs, does not return any value nor raises an exception. When there's no deadlock, everything works fine. Any ideas how to catch this? ...
Hi everyone. Searched google for "firebird update duplicates" and "firebird handle duplicate update" but did not get any stuff, that would solve my question; so i thought it would be a good idea to use this marvellous site for the first time :) So how do i achieve mysql's "INSERT INTO asdf (x,y,z) VALUES ('a',1,2) ON DUPLICATE KEYS UPDA...