Re: [firebird-support] confusion trigger

2013-04-20 Thread Björn Reimer
Are you aware of the possibility to grant permissions to triggers? That should solve your problem. Why User1 is restricted for any insert or update operation ? User1 privileges: Tab1 - select,insert,update,delete Tab2 - select,insert update Trigger Tab1_BA BEFORE Insert or Update or

[firebird-support] autodate and autofill columns

2013-04-20 Thread dice_in_trouble
hello i have a firebird database in which i have columns namely date, name, balance and payment i want my software to publish a list of the content with the date being adjusted daily and the content being the same, e.g. datenamebalance payment 20/4/13 client1 100 20/4/13 client2

Re: [firebird-support] Re: Select column AS [column name] with space

2013-04-20 Thread Mark Rotteveel
On 19-4-2013 19:09, ramona.grissom wrote: The error is Invalid token. Dynamic SQL Error. SQL error code = -104. Token unknown - line 3, column 1. account number. I believe they are dialect 1, what is the difficulty in changing the dialect? Start with the Interbase 6.0 Getting Started,

Re: [firebird-support] autodate and autofill columns

2013-04-20 Thread Marcus Bajohr
hej, AFAIK that cannot be handled by firebird on its own, as fb has no anchor to the outer world as long as there is no active connection. cheers, marcus dice_in_trouble mailto:dice_in_trou...@yahoo.com Samstag, 20. April 2013 14:22 hello i have a firebird database in which i have columns