firebird2.1
How can I search a specified character in the entire SQL database with IBexpert?
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,[详细]
2023-01-24 07:24 分类:问答Howto update duplicates in firebird?
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[详细]
2023-01-19 03:34 分类:问答ibase_execute just hangs when there is a deadlock
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[详细]
2023-01-17 20:49 分类:问答In Firebird would be a way to auto-update coincident rows in a INSERT procedure?
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[详细]
2023-01-17 18:31 分类:问答Why can't I execute this alter procedure firebird query?
The query is: SET TERM ^ ; ALTER PROCEDURE SALVARROTA ( datahora timestamp, distancia double precision, custo double precision,[详细]
2023-01-16 08:19 分类:问答How can I measure the amount of space taken by blobs on a Firebird 2.1 database?
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[详细]
2023-01-15 17:49 分类:问答Help with SQL query - some magic needed
I need some help with a query - I\'m using Firebird 2.1. I have a table like: RowID (primary key) | ActivityID | Duration | BilledAt[详细]
2023-01-10 07:18 分类:问答How to get all the fields of a row using the SQL MAX function?
Consider this table (from http://www.tizag.com/mysqlTutorial/mysqlmax.php): Idnametypeprice 123451 Park\'s Great HitsMusic19.99[详细]
2022-12-31 14:31 分类:问答Delphi: how to create Firebird database programmatically
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[详细]
2022-12-29 07:49 分类:问答Delphi firebird autoinc
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[详细]
2022-12-28 17:34 分类:问答
加载中,请稍侯......