> --
> Robert

> Guillermo Casta?o A wrote in message
> <3B7AE1D3.65A7C...@GrupoMillennium.com>...
> >Hi, i have a TQuery descendent component that works over queries
> >assigning them a consecutive value in the DoOnNewRecord procedure. (Then
> >i call the DoOnNewRecord of the ancestor). The field of the consecutive
> >always is created in the first position of the fields.
> >(Query.Fields[0].AsInteger := MyConsec).
> >It works pretty well most of the time, but from time to time an error
> >raises when trying to post the record: "The field 'IdOfMyTable' can't be
> >null" but if you close the application and do the process again, all
> >works fine again. It's like if for some reason i don't understand,
> >referring to Fields[0] not always assign the value to the proper
> >database field.
> >Any ideas?
> >Thanks in advance
> >--
> >Guillermo Castano Acevedo
> >Gerente de Sistemas - Grupo Millennium Ltda
> >Guiller...@GrupoMillennium.com
> >www.GrupoMillennium.com

> They do not change arbitrarily or randomly, but as per Robert's example, if
> you change the order of columns in a grid at runtime (by either dragging or
> in code) then the TField order in the dataset will be changed accordingly.

> The easy solution in this case is to use FieldByName instead of
> Fields[index].

> --
> Wayne Niddery (Logic Fundamentals, Inc.)
> RADBooks: http://www.logicfundamentals.com/RADBooks/delphibooks.html
> "Some see private enterprise as a predatory target to be shot, others as a
> cow to be milked, but few are those who see it as a sturdy horse pulling the
> wagon." - Winston Churchill