--- In firebird-support@yahoogroups.com, Ann Harrison <aharrison@...> wrote: > > On Fri, May 3, 2013 at 8:07 PM, dice_in_trouble > <dice_in_trouble@...>wrote: > > You wrote: > > > > > > > > > the client id also doens't auto increment. > > > > > > > I asked > > > > > > > How do you generate client identifiers? > > > > > > > You responded > > > What do you mean by client identifiers? I would like to summarize all the > > data in a certain column. > > > > Summarizing data can be done with computed columns, or with triggers. > Triggers introduce a chance > for deadlocks but perform better if you have a high read:write ratio > because the sum doesn't have to be > computed on reference. However, you also mentioned that your client_id > field is not generated automatically. > One way people get in trouble with Firebird is using something like setting > an identifier column with an > expression like <identifier> = MAX(<identifier>) + 1 I wondered if that > was how you were creating unique > identifiers. > > Good luck, > > Ann > > > [Non-text portions of this message have been removed] >
Thanks for the reply. Unfortunately I just put a char on the id and without a null option. I encountered once a problem because I used the number 1 already but have it deleted on the record, but I cannot use the number 1 again. Anyways I was planning to make the client ID automatically generates the numbers so that I will not mix up if the time comes that I have lots of data already encoded to the database. Regarding your answer regarding the summary. I honestly can't understand anything from deadlocks to triggers and identifiers. Thank you. Sincerely, Cedris