Re: [firebird-support] confusion trigger
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 Delete Begin if (inserting) then begin ... end if (updateing) then begin ... end if (deleting) then begin delete from Tab2 where ... end End I know that this problem is solved if we add to Tab2 delete but why is not correct formulation above Björn -- Björn Reimer - RRZE
[firebird-support] autodate and autofill columns
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 200 then tomorrow it will auto fill the cells with the same data on the name and balance columns but the date will be set on the current date. is this possible? if it is can somebody help me on this matter? btw i am using zeoslib and delphi 7 thanks
Re: [firebird-support] Re: Select column AS [column name] with space
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, section Migrating databases to dialect 3 (page 39). You can download it from http://www.firebirdsql.org/en/reference-manuals/ Biggest difference is some keywords, changes with DATE (in dialect 3 it doesn't contain a time portion, you need TIMESTAMP in dialect 3) and strings should be quoted with single quotes. Mark -- Mark Rotteveel
Re: [firebird-support] autodate and autofill columns
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 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. date name balance payment 20/4/13 client1 100 20/4/13 client2 200 then tomorrow it will auto fill the cells with the same data on the name and balance columns but the date will be set on the current date. is this possible? if it is can somebody help me on this matter? btw i am using zeoslib and delphi 7 thanks ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links [Non-text portions of this message have been removed]