gulya2005
9th February 2005, 10:21
We want to delete data from table on click button cont.process.
We have written:
tabl_id = db.bind("telmnf023")
db.lock.table(tabl_id)
db.clear.table(tabl_id, 1,308)
commit.transaction()
Error 203: Action not allowed within transaction on process in lock_table.
How to delete data from table if we not want to use function db.delete.

vahdani
9th February 2005, 12:06
Hi,

there is no need to use db.lock.table() [or for that matter db.bind()! :D ].

use something like this:

table ttdroe750
long ret
...
function refill.tdroe750()
{
| first clear content
db.retry.point()
ret = db.clear.table(ttdroe750, 0)
commit.transaction()
| now fill table with new data!
....
}