Generate row numbers in SQL from Interbase
Is this possible from Interbase ? For example like in this link. ...
interbase
IBDAC / UniDAC + interbase 6 or 7 + a table field named "returning"
Hello there! I am porting REALLY old code to use the UniDAC components. I have hit a wall with a specific UPDATE sql that changes a field named "returning." Simply wrapping the field in quotes does not resolve the issue, because the SQL dialect in the database is 1, which does not support double quote field delimiters. Is there any w...
How to change characterset of an existing database for Interbase
We have a database and our client is written with Delphi 2007. The latest Interbase 2009 is used. The database is old, I believe it was created around 2002 and is now over 25 GB. Recently I discovered that in IBConsole upper('åäö') generate 'åäö'. It should be 'ÅÄÖ'. This is swedish characters that are missing in the English alphabet...
Why in the first case displays debit = 'null', and the second the right amount
Why in the first case displays debit = 'null', and the second the right amount ~ SELECT o.kadastr, /* Кадастровый номер */ d.ar_inn, /* ИНН арендатора */ o.adres, /* Адрес участка */ r.name, /* ФИО арендатора */ o.pl_common, /* Общая плащад...
How reliable are modern databases in the presence of disk errors?
InterBase had an architecture that caused disk-writes to leave the database in an always-consistent state -- 97 things every software architect should know, p87 Is this property finally common in 2010 ? Is there a study about database stability/reliability in presence of disk errors ? ...
Delphi Interbase Sql Conversion to Sql Server and Oracle
hello, i have a delphi application which uses database interbase / firebird. To consult and write data I use the InterBase components palette (IBTable, IBQuery, IBDataset). I'm performing the conversion of my system to sqlserver / Oracle but i have thousands of queries that are assembled at runtime with SQL Instructions Specific of datab...
Command to get identity of newly inserted record in Interbase 2007
In Interbase (I'm using 2007, I don't know if it matters) is there a command to get the identity of a newly-inserted record, similar to SCOPE_IDENTITY() in SQL Server? ...
How do I configure IIS 7 to allow a remote database connection from within an ISAPI Web Server
I have a native Web service application (ISAPI) that I have built with Delphi 2010. At this time, it only exposes two methods. The first one, EchoString, is designed to give me feedback that the Web service is functioning properly, and it adds a couple characters to the string that I send to it from my Delphi Web service client. This alw...
Interbase PSQL return values
Hi, I wrote a very simple script. I am new to PSQL and I wanted to return some values based on a very simple loop. CREATE PROCEDURE DRAW_DOWN RETURNS( I_VAL INTEGER) AS DECLARE VARIABLE STARTING_BALANCE INTEGER; DECLARE VARIABLE TRADING_SERIES INTEGER; DECLARE VARIABLE I INTEGER; BEGIN SUSPEND; I_VAL = 1; WHILE (i < 5) DO BEGIN /*RA...