Urgent: Committing specific blocks in Forms [message #81694] |
Wed, 12 March 2003 02:09 |
sonic
Messages: 11 Registered: March 2003
|
Junior Member |
|
|
Hi all,
Can anyone tell me if there's a way to commit data in a specific block. The COMMIT command will not work as it commits data in all the blocks. I've tried changing the status of the record to NEW and QUERY, then reset it to INSERT and CHANGED after I've committed. This works to an extent. If I then try to update the block, I get the "Record changed by another user, Re-query to see changes". Any suggestions ?!?!
Thanx
Sonic
|
|
|
Re: Urgent: Committing specific blocks in Forms [message #81700 is a reply to message #81694] |
Wed, 12 March 2003 16:29 |
magnetic
Messages: 324 Registered: January 2003
|
Senior Member |
|
|
add a when button pressed trigger on that block you want to commit,or other proper trigger, with code: commit;
it this wont work then you have to do it the hard way:
again a proper trigger on block level
then the code
insert into table newbies(col1,col2...)
values(:field1,:field2);-- fields of the block you wanna commit
commit;
|
|
|
Re: Urgent: Committing specific blocks in Forms [message #81705 is a reply to message #81694] |
Thu, 13 March 2003 01:47 |
sonic
Messages: 11 Registered: March 2003
|
Junior Member |
|
|
Thanx Magnetic but I dont think you understand my problem. When I issue the commit, all the blocks on the form will be committed as well and thats what I DONT want. I only want to commit one block's data leaving the other blocks as they are.
|
|
|
|