On Fri, May 3, 2013 at 8:07 PM, dice_in_trouble <dice_in_trou...@yahoo.com>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]
