Re: [firebird-support] Basic sql alter table commands

2014-02-22 Thread Paul Vinkenoog 
Hi Jack,

> Achieved success using examples from the Razor site. If that is the best 
> available, I'm fine with that. Thanks anyway.

You can pick up the InterBase 6 Language Reference here: 
http://www.ibphoenix.com/files/60LangRef.zip, and visit the section "SQL 
Statement and Function Reference :: ALTER TABLE". That's the basis.

The document Thomas pointed you to contains the updates since Firebird was 
forked from the IB sources.


Good luck,
Paul Vinkenoog

Re: [firebird-support] RE: Where I put firebird.msg on PC with two client?

2014-02-22 Thread hvlad 

 

 >  Why do you think you can't use just v2.5 client ?


>isn't  supported from Zeoslib for Delphi 5 :(

Sounds crazy, sorry. Can you provide a reason for it ? Just curious...


 >  Choose any folder you like, put firebird.msg there and set environment 
 > variable
 >FIREBIRD_MSG pointing to this folder. You should set it before you'll load 
 >fbclient.dll.





> In this case, I have conflict with version 2.5 (in this case nt works fine 
> the 2.5 version) because environment 
> variable is in system scope. Is there a way to set an environment variable in 
> scope only for application that set it?
 
Sure. You can
a) run your application using bat\cmd file with two lines
SET FIREBIRD_MSG= 


or you can
b) call WinApi function SetEnvironmentVariable before attempt to load 
fbclient.dll

Re: [firebird-support] Basic sql alter table commands

2014-02-22 Thread Jack Cane 
Achieved success using examples from the Razor site. If that is the best 
available, I'm fine with that. Thanks anyway.

Best,
jwc

On Feb 22, 2014, at 2:23 PM, Jack Cane  wrote:

> Although longtime FB user, I'm new to the alteration process, and having 
> difficulty finding the right sources. 
> 
> 
> Would you please point me to a basic text on 
> renaming/altering/dropping/adding columns to existing FB tables.
> 
> Best,
> jwc
> 
> 
>

Re: [firebird-support] Basic sql alter table commands

2014-02-22 Thread Jack Cane 
Immediate need is pretty simple I think: rename a column and change data type 
of another column. Tried a couple variants based on examples from web search, 
but my IB_SQL scripting tool rejected them. 

Thanks,
jwc

On Feb 22, 2014, at 2:23 PM, Jack Cane  wrote:

> Although longtime FB user, I'm new to the alteration process, and having 
> difficulty finding the right sources. 
> 
> 
> Would you please point me to a basic text on 
> renaming/altering/dropping/adding columns to existing FB tables.
> 
> Best,
> jwc
> 
> 
>

Re: [firebird-support] Basic sql alter table commands

2014-02-22 Thread Thomas Steinmaurer 
> Although longtime FB user, I'm new to the alteration process, and having
> difficulty finding the right sources.
>
> Would you please point me to a basic text on
> renaming/altering/dropping/adding columns to existing FB tables.

http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-ddl-table.html


-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

[firebird-support] Basic sql alter table commands

2014-02-22 Thread Jack Cane 
Although longtime FB user, I'm new to the alteration process, and having 
difficulty finding the right sources. 

Would you please point me to a basic text on renaming/altering/dropping/adding 
columns to existing FB tables.

Best,
jwc

[firebird-support] Trigger not working

2014-02-22 Thread Werner 
Hi,

I have the following trigger which doesn't work for me, i.e. the columns 
in winerackit are never updated by it.

In my current test case the 'fk_winerackit_id' column is set to "Null", 
so I would expect this trigger to fire and set the 'usedcapacity' column 
to '0' as it was '1' before the update to the bottag table.

I must do something really stupid.  Any hints on how I could debug this, 
e.g. tutorial on how to write values to some log table would be very 
appeciated.

Werner

CREATE OR ALTER trigger bottag_biud0 for bottag
active after insert or update or delete position 0
as
   declare variable oldid bigint;
   declare variable newid bigint;
   declare variable curcap integer;
   declare variable oldcap integer;
   declare variable newcap integer;
begin
   curcap = 0;
   oldcap = 0;
   newcap = 0;
   /* if it was assigned to rack */
   if (old.fk_winerackit_id is not Null) then
  begin
  select id, usedcapacity from winerackit wi
where wi.id = old.fk_winerackit_id
into :oldid, :curcap;
  oldcap = :curcap-1;
  end

   /* if it is newly assigned to rack */
   if (new.fk_winerackit_id is not Null) then
  begin
  select id, usedcapacity from winerackit wi
where wi.id = new.fk_winerackit_id
into :newid, :curcap;
  newcap = :curcap+1;
  end

   if (:oldid is not Null) then
  update winerackit set usedcapacity=:oldcap
 where winerackit.id = :oldid;
   if (:newid is not Null) then
  update winerackit set usedcapacity=:newcap
 where winerackit.id = :newid;
end

Re: [firebird-support] RE: Where I put firebird.msg on PC with two client?

2014-02-22 Thread Luigi Siciliano 

Hallo,

Il 21/02/2014 21.24, hv...@users.sourceforge.net ha scritto:


  Why do you think you can't use just v2.5 client ?

isn't  supported from Zeoslib for Delphi 5 :(


  What problem do you have ?
I case of error using the fbclient21.dll (2.1 version), I obtain a 
"Can't format message" because the firebird.msg is for 2.5 version". The 
application that use 2.5 version works fine.




But you better should not put non-system files into Windows system folder

Ok.



  Choose any folder you like, put firebird.msg there and set 
environment variable
FIREBIRD_MSG pointing to this folder. You should set it before you'll 
load fbclient.dll.
In this case, I have conflict with version 2.5 (in this case nt works 
fine the 2.5 version) because environment variable is in system scope. 
Is there a way to set an environment variable in scope only for 
application that set it?


Thanks.
--

Luigi Siciliano
--