[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: DBTASKID(1) gives ? (NULL)

[gus bjorklund]

> On Feb 13, 2020, at 9:40 AM, SJProgress wrote: > > CREATE RepData. > > ASSIGN > > RepData.RepDataID = NEXT-VALUE(RepdataID) > > RepData.DTCreate = NOW > > RepData.TransID = DBTASKID(1) / DBTASKID("DICTDB") / DBTASKID("myDBName") > > for this case, dbtaskid (1) should force a transaction start. however, the record has not yet been created (depending on indexing), it must be sent to the database and created. then the transaction id can be retrieved and the TrandID field updated. then the record has to be sent back for the update. you can force an earlier create by zzz = rowid(RepData). at some earlier point, and then RepData.TransID = dbtaskid(1). but to further complicate this example, the ASSIGN wants to delay sending the record over until the assign has finished.=

Continue reading...