CAN'T TRIGGER THE FUNCTION IN INSERT DATA

ckwong · Post by **ckwong** » Wed 13 Jan 2010 19:46

Normal operation, my table could run a trigger function when insert data.

but I found program shown "exception Lost Connection During Query " when no operate few minutes.

I changed setting as below to prevent error
TCustomDAConnection.Options.LocalFailover = True
TCustomDAConnection.Options.DisconnectedMode = True
TUNiquery.CachedUpdates = True
TUNiquery.specificoption.FetchAll = True
TUNiquery.Options.LocalMasterDetail = True

After above setting, the table can't run trigger function when insert data.
Any idea ?

tobias_cd · Post by **tobias_cd** » Thu 14 Jan 2010 06:24

Hi, why do you set DisconnectedMode to True?

Plash · Post by **Plash** » Thu 14 Jan 2010 08:31

We could not reproduce the problem. Please send to support*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.