Home » Developer & Programmer » Forms » how to update record in block on view
how to update record in block on view [message #177893] Sat, 17 June 2006 08:58 Go to next message
RAY_HT
Messages: 155
Registered: May 2005
Location: Giza
Senior Member
dear all

i create block on database view and create trigger instad of update on this view but when i update this record on form and commit no change hapining
Re: how to update record in block on view [message #177896 is a reply to message #177893] Sat, 17 June 2006 09:56 Go to previous messageGo to next message
mane
Messages: 7
Registered: May 2006
Junior Member
create a form using wizard with base table as the database view.
In the form, go to the properties of the column you would like to update,
change the item type as 'Check box' and the data base item as 'No'.
Then to this field create trigger - 'When-checkbox-changed' and write the
update details and commit;
Hope this will solve your problem.
Re: how to update record in block on view [message #177981 is a reply to message #177896] Sun, 18 June 2006 21:35 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Use standard.commit instead of commit. For a fuller explanation search this forum for 'standard.commit'.

David
Previous Topic: message line parameters
Next Topic: warning message
Goto Forum:
  


Current Time: Fri Sep 20 09:48:48 CDT 2024