interbase
How to speed up Count(*) in Interbase/Firebird
Interbase is a generational database. That\'s great because rollbacks are near instantaneous, but count(*) takes forever.[详细]
2023-03-01 17:16 分类:问答Executing a script using ISQL
I\'m creating a simple isq开发者_开发技巧l script but it\'s not working and I need some help to find out whats wrong with it.[详细]
2023-03-01 03:40 分类:问答How can I update a row in Interbase database?
I have two rows with same data in an Interbase table.The table开发者_如何转开发 does not have a primary key. How can I update a single row in that table?Interbase tables has a system column named RDB$[详细]
2023-02-28 07:55 分类:问答Changed php-interbase default transaction behaviour
I have some PHP CLI scripts that run for a long time (24 hours plus) and although they do regular \'commit\'s I had some problems with orphaned transactions - possibly caused by scripts crashing out.[详细]
2023-02-20 16:22 分类:问答Help with SQL totals and sums
I have this SQL. Im not sure it is what i need, but it does select all the records i need. I just need to condense them now and total the counts and amounts for unique dates.[详细]
2023-02-13 00:02 分类:问答SQL for extract portion of a string
I have a zipcode stored in a text field (string) and would like to select only the last 3 digits of the value in my select statement. is this possible? Is there a standard way of doing this so that th[详细]
2023-02-11 23:38 分类:问答Select AS not working in interbase
works select payeeid, EXTRACT(WEEKDAY FROM checkdate) as DOW, (bankcleared - checkdate) as DateDiff from Master[详细]
2023-02-11 16:50 分类:问答How can I get an Interbase password if I have only the BDE alias?
I am trying to connect to a Interbase DB at runtime via the BDE. I am trying to do this in a formless project (but not a console app). The alias is known. I retrieve the alias from the registry.Exampl[详细]
2023-02-08 04:46 分类:问答interbase and BDE on windows 7
OK I know this has been deprecated, and bde is older than Moses, but we have some legacy applications that have not been migrated still using bde.[详细]
2023-02-04 14:09 分类:问答insert null date interbase
I need to insert a null or \'开发者_如何学JAVA00/00/00\' date value. Is it possible to do it on interbase?[详细]
2023-02-02 12:10 分类:问答