How can I search some particular character on the entire database with IBexpert? For example: I have some \"\'\" (\') in some part in the data of the tables and this is getting me an error later on,
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 ma
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 han
if you are running a query that inserts a new set of records in a table from other one, t开发者_开发技巧here is a way to force the update of the coincident pk record in the destination table, without
The query is: SET TERM ^ ; ALTER PROCEDURE SALVARROTA ( datahora timestamp, distancia double precision, custo double precision,
I have a production database, using Firebird 2.1, where I need to find out how much space is used by each table, including the blobs. The blob-part is the tricky one, because it is not covered using t
I need some help with a query - I\'m using Firebird 2.1. I have a table like: RowID (primary key) | ActivityID | Duration | BilledAt
Consider this table (from http://www.tizag.com/mysqlTutorial/mysqlmax.php): Idnametypeprice 123451 Park\'s Great HitsMusic19.99
I\'m using D2K9, Zeos 7Alpha, and Firebird 2.1 I had this working before I added the autoinc field. Although I\'m not sure I was doing it 100% correctly. I don\' know what order to do the SQL code, w
How do I make an autoinc field in firebird with Zeos. -Br开发者_Python百科adIt is explained in Firebird FAQ #29. See the bottom of that page.I don\'t know what do you mean by \"making an autoinc fiel