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.
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
I\'m looking for a way to solve my SQL problem. I have 2 tables in Firebird 2.5 ( T1 and T2 ) like these:
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\'
Does the new XE2 dbExpress still ha开发者_JAVA技巧ve problems using Boolean fields?The best way is to use a domain
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
Question: How can I store a 128 bit integer (IPv6) with nHibernate ? 开发者_运维技巧Especially on Firebird, where the BigInteger MAX size is 2^64 .
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).
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.
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
加载中,请稍侯......