Home » Developer & Programmer » Forms » POST-QUERY
POST-QUERY [message #285526] Wed, 05 December 2007 00:01 Go to next message
sinida1984
Messages: 83
Registered: September 2007
Location: India
Member
Hi all,

I have a database datablock in my form. In that i have some display items also which is not database item in the same block. So in POST-QUERY trigger i selected description from a table based on the code in the database block. The block will return multiple records...means it is like a table view. But after POST-QUERY as that record's status got changed from 'QUERY' to 'CHANGED', even if i didnt make any change, it is asking for 'Do you want to save the changes ?'. Don't know why it is coming like that..Because even if i have written a POST-QUERY the records' status should be 'QUERY' only..rite? But it is getting to the status 'CHANGED'. If i comment POST-QUERY, it is working fine. All the items which i have assigned is not database item. If anyone knows the answer pleaaaaaaaase help me,,,

Thanks and regards
Sinida
Re: POST-QUERY [message #285530 is a reply to message #285526] Wed, 05 December 2007 00:07 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear plz check the property of your non-basetable items/display items which should also be set to basetable = false.
Re: POST-QUERY [message #285533 is a reply to message #285530] Wed, 05 December 2007 00:11 Go to previous messageGo to next message
sinida1984
Messages: 83
Registered: September 2007
Location: India
Member
It is set to false only..

Thanks
Sinida
Re: POST-QUERY [message #285535 is a reply to message #285533] Wed, 05 December 2007 00:16 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Ok... check your POST-QUERY's code. I m sure you are by mistake either trying to populate an item or an item's basetable property is set to true.
Re: POST-QUERY [message #285560 is a reply to message #285535] Wed, 05 December 2007 01:11 Go to previous message
sinida1984
Messages: 83
Registered: September 2007
Location: India
Member
Hi

It got corrected. Thanks.

Bye
Sinida
Previous Topic: Make Privileges to admin and different users in forms
Next Topic: Set Navigation between block items using TAB
Goto Forum:
  


Current Time: Mon Dec 05 15:21:06 CST 2016

Total time taken to generate the page: 1.31320 seconds