firebird
Question on indices
If I have a table with the following columns as the primary key: Username, Title, Start Date, then the database will automatically create an index on it.[详细]
2023-04-04 16:11 分类:问答Stop .NET Firebird (2.6.5) provider writing all SQL to console
The new .NET Firebird provider is writing A开发者_开发问答LL SQL to the console which slows down the execution of our program in Visual Studio. We use NHibernate and monitor all SQL commands using NHi[详细]
2023-04-04 14:33 分类:问答Mix records of two different tables
I\'m looking for a way to solve my SQL problem. I have 2 tables in Firebird 2.5 ( T1 and T2 ) like these:[详细]
2023-04-04 13:53 分类:问答Calculating a field from SQL Query Selecting from multiple tables with Union
I have the following query, which works great. The problem I have is that in both tables (and the aggregate unioned table), there is a field called MTGUID. I need to multiply MTGUID by a number (let\'[详细]
2023-04-03 19:52 分类:问答How to use Booleans with Delphi XE2 dbExpress and Firebird 2.5
Does the new XE2 dbExpress still ha开发者_JAVA技巧ve problems using Boolean fields?The best way is to use a domain[详细]
2023-04-03 08:23 分类:问答Cast as Int only when character is a number on Firebird 2.5
I have a query that I use on a MySQL database that orders the result, casting a char database field to integer when possible (when the char string is numeric), so for example the ORDER BY clause that[详细]
2023-04-02 06:56 分类:问答How to store a 128 bit integer with nHibernate?
Question: How can I store a 128 bit integer (IPv6) with nHibernate ? 开发者_运维技巧Especially on Firebird, where the BigInteger MAX size is 2^64 .[详细]
2023-04-01 07:35 分类:问答TSQLConnection.GetFieldNames not working on 64-bit machine
I have Delphi 2005 code that I use to retrieve database table field names. It works with no problems on 32-bit machines (Windows XP, Windows Vista, Windows 7).[详细]
2023-04-01 02:12 分类:问答Cursor not returned from Query
I\'m usingDelphi XE and FireBird 2.5. Try use a TSQLStoredProc and give me the error \"Cursor not returned from Query\" when I put the Active property to TRUE.[详细]
2023-04-01 00:14 分类:问答Compiling IBPP with VS2010 - linking issue
I have a C++ project that uses IBPP to access a firebird database. I simply do it by including the file \"all_in_one.cpp\" in my project, and all went well with both VS6 (yes, I still have some of tho[详细]
2023-03-31 04:25 分类:问答