i have the following tiboquery defined:

select b.id, b.field1, b.field2, b.dateField, b.matchiD, pe.name1,
pe.name2, pe.pkid
from table1 b
join table2 on b.matchID = pe.pkid

keylinksautodefine = false
keyLinks = b.id

orderingitem 1 = pe.name1, b.id

updateSql:editSql is
Update table1 set
dateSent = :dateSent
where
id = :old_id

refreshLIve = false (have tried this as true)
preparedEdits = true
other properties are default

in code i have
with qry do
begin
first
while not eof do
begin
edit
fieldByName('dateSent').asString := sDate
post
next
end
end

when we run this we now get the error 'field datesent cannot be
modified' error.

again this was working before we upgraded to 4.5.b (from 4.3.aa)
any suggestions on how to get the editsql to get this field to be
updated?

we're using delphi 7

thanks!
-martha