Hi,
Normally, when I make a modificacion to the metadata ( DDL ) I shut
down the database because it is not clear to me what happens if I alter
a table or a stored procedure while it is being used or invoked by
another user.
Is it actually necessary to shut down the database in order to
On 2012-08-05 19:26, Matthias Hanft wrote:
Now I don't want to be NBR the primary key any more (the numbers there
have a special meaning where I need to have some 0 entries now); I'd
like to insert another ID colum which should be the new primary key
(and filling it automatically from 1 to N
On 2012-08-06 14:33, Tomasz Tyrakowski wrote:
3. create the new primary key column (alter table MyTable add NewKey not
null)
It should have been
alter table MyTable add NewKey integer not null
Forgot the column type. Sorry for that.
Tomasz
--
__--==--__
__--==
--- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote:
On 4-8-2012 16:06, venussoftop wrote:
Hi all
I have an app that uses FireBird is being used regularly on Windows XP
pretty nicely.
Now when I install the same app on Windows 7 I am still able to enter data
as
Tomasz Tyrakowski wrote:
That's the procedure I've been using in the past in such cases:
[...]
Thank you very much; I'll save this useful instruction manual for later :-)
1. drop the current primary key (alter table MyTable drop constraint
OldPrimaryKeyName)
That's what I wanted to do, but
Matthias Hanft wrote:
4. fill the new column using the generator:
update MyTable set NewKey=(select gen_id(MyGen,1) from RDB$DATABASE)
update MyTable set NewKey = gen_id(MyGen,1);
Brilliant :-) (I already wondered how to fill up an incrementing
column automagically.)
Well, now you know of
Hello all,
I am new to this world of connecting and converting databases.
I am trying to convert a database from one format to the other.
It was recommended in the set instructions written by the previous author to
use Firebird, and hence I am here.
I am using Windows XP (32 bit only) and
Em 6/8/2012 13:28, himanshu escreveu:
Hello all,
I am new to this world of connecting and converting databases.
I am trying to convert a database from one format to the other.
It was recommended in the set instructions written by the previous author to
use Firebird, and hence I am here.
I
I installed Firebird and then tried to connect the database. The system gave
me following error message
Failed to load gds32.dll (#-904)
When you installed the Firebird version, did you tell it to create a version of
gds32.dll (which is really more like FBClient.dll but reports itself as
Eduardo A wrote:
So, consider uninstalling and reinstalling paying attention to the check
boxes that tell the
install program what to do with gds32.dll.
IMHO looking for a file called fbclient.dll somewhere on your hard
disk and copying it as gds32.dll to C:\Windows\System32 should be
BACKGROUND INFO:
I have a stored procedure with two BLOB SUB_TYPE 1 variables declared. One
contains a letter template, the other contains the letter text. In the
template I have the character string [LETTER_BODY] at the place where I want
the letter text to appear. (It is placed in the
11 matches
Mail list logo