Through the insert statement you can insert a record not an item.
Fetch all the item values of a record and place a pushbutton on the block.
And write following command in when-button-pressed trigger of the pushbutton to save all the values.
The good old tip for that issue is to use a timer, then put the restricted instruction in the when-timer-expire trigger.
Maybe you could describe a little more detailed what you want to achieve?
I don't fully understand, why you need to insert records on post-text-item, but the possible solution is:
- Write a DB procedure which does insert and commits it.
- Call this procedure in post-text-item.
Problems will occur if your procedure is modifying the table columns, which are used in form. Form will notice that values in DB have changed and you will have "Record has been changed by another user. Please requery to see changes" error. But if records, affected by DB procedures, are not used in form, the wverything will be OK.
I achieved what I want by another way
Thank all of you