I have a query in Delphi using DBExpress TSQLQuery that looks like so ActiveSQL.sql.add('SELECT * FROM MYTABLE where MYFIELD=(:AMYFIELD) '); ActiveSQL.ParamByName('AMYFIELD').AsString := 'Some random string that is to long for the field'; ActiveSQL.Open; If I run it, when it executes the open command I get the following exceptio...
I can't seem to find a good script or anything to use for installing Firebird (the InterBase-decendent RDBMS) using InstallShield. There is a way to silently install it using the firebird install executable, but I don't know enough about InstallShieldscripts to be able to do it! If anyone knows any information on a) how to execute an ex...
I've got a sql query (using Firebird as the RDBMS) in which I need to order the results by a field, EDITION. I need to order by the contents of the field, however. i.e. "NE" goes first, "OE" goes second, "OP" goes third, and blanks go last. Unfortunately, I don't have a clue how this could be accomplished. All I've ever done is ORDER BY ...
Looks like the TSQLConnection only connects to existing databases, and I could not find another component that allows me to send commands to the database server. I'm using Delphi 2009 with Firebird and MSSQL. One idea that came was to connect to a system database (master or tempdb in MSSQL for example) and then send create commands to ...
I'm trying to insert some new objects into a firebird database using NHibernate. I get the error "could not get next sequence value[SQL: SQL not available]" Here is the mapping I'm using at present. Note ANML_EVNT is the name of the generator I want to use. <id name="Id" column="ID" type="integer"> <generator class="sequence"> ...
I need to create a Firebird Database programmatically using DBExpress. I have done this for SQL server, by first connecting to Master, then passing in the script for Create to a query, but with Firebird I have a little chicken and egg problem. ...
Hi, I’m developing a .NET application with an auto refresh feature. Every table in my database has a MODIFIED_DATE column that gets updated after each update or insert. At the moment the auto refresh feature will apply to only one table, however it may change in the future. I’m currently considering the following possible solutions: C...
I know: Firebird FIRST and SKIP; MySql LIMIT; Sql Server ROWNUMBER(); Does someone knows a SQL ANSI way to perform result paging? ...
I'm starting up a new web application. It's going to be hosted on a service that charges extra for SQL Server and frankly I don't think the site needs that much of a database. Right now the data model is 5 tables. And I'll be amazed if the largest table ever goes of 10k records. So I'd like to keep the db lightweight. SQLite piqued my ...
Is there a tool native to SQL Server to do the migration (i.e., Import/Export)? Any other options (SSIS). Please point me to helpful info. ...
Simple question. I'm considering Firebird and SQLite for an upcoming project. SQLite has SQLite Administrator, which is pretty good but gets +1M because it has autocomplete. But Firebird supports FKs, so I'm more comfortable with it. I'm leaning toward Firebird right now. What is your favorite Firebird IDE and why? Edit: Personally, ...
I'm pretty perplexed... I've got 5 different test computers, all relatively blank Windows XP machines running similar hardware specs. I run a silent install of the FireBird (Classic) database and my application. Some computers require "localhost:" (or 127.0.0.1) before the database location to make a connection, and some simply don't wor...
Has anybody done any benchmarking/evaluation of the popular open-source embedded SQL DBs for performance, particularly write performance? I've some 1:1 comparisons for sqlite, Firebird Embedded, Derby and HSQLDB (others I am missing?) but no across the board comparisons... Also, I'd be interested in the overall developer experience for ...
I'm developing a application that needs storing secrets in a database. I need a portable database (like Firebird, Sqlite, etc) where the data will be stored encrypted or password protected or both... Let's take as example that I want create a password manager. I will need store that passwords in a database. I'm accustomed to use Embed ...
I am investigating the possibility of updating our application to work with database servers other than Firebird. We rely on "STARTING WITH" for accessing our hierarchical data. Without it, I don't see how we can migrate to another database without some serious redesign. If you are not familiar with STARTS WITH, it simply checks to see ...
I'm trying to read image from firebird with c#, and save it to file system. I can read from table and save. but image can not be viewed. I tried many piece of code on net.but result is same :( Can any one help me please? ...
Does anybody know about good SQL parser with sources, written in Delphi? I need in parsing SQL commands (with all new features of Firebird 2.5) into object structure. ...
I have a VARCHAR field in a Firebird 2.0 table that can contain alphanumeric characters. I need to sort data on this field, sorting all values that contain only numbers as numbers, and sort all other values as 0. For example, if I have four values, "1", "2", "10", "string", I need to sort it as "string", "1", "2", "10". Default sort with...
I have this SQL: SELECT * FROM Requisicao r join convenio c on c.idconvenio = r.idconvenio join empresa e on e.idempresa = c.idempresa When I execute it I get this plan of execution: PLAN JOIN (C NATURAL,E INDEX (INTEG_160),R INDEX (INTEG_318)) What means that Convenio's index was not used (every table has its indexes) I w...
Everyone here has always been such great help, either directly or indirectly. And it is with grand hope that this, yet again, rings true. For clarification sakes, the Stored Procedure is running under FireBird and the VB is of the .NET variety I have a stored procedure (excerpt below, important bit is the WHERE) select pn, pnm.desc...