Home » Developer & Programmer » Forms » list item- Form Builder 6.0
list item- Form Builder 6.0 [message #79812] Tue, 16 July 2002 03:46 Go to next message
Novica Stefanovic
Messages: 2
Registered: June 2002
Junior Member
hi!
from the list item, i want to use value for query,in the section of WHERE .....,
for example:
trigger : WHEN-LIST-CHANGED...
select product_name
into ....from .....
WHERE PRODUCT_ID = A VALUE FROM LIST ITEM.....
how? what is the syntax for this?

Report message to a moderator

Re: list item- Form Builder 6.0 [message #79813 is a reply to message #79812] Tue, 16 July 2002 04:18 Go to previous message
Balamurugan.R
Messages: 91
Registered: March 2001
Member
Hai,

U can simply give the list item name in the

"where" condition ,by writing query with

where name = :list_item_name in the when_list_changed

query.

Report message to a moderator

Previous Topic: if the stored procedure name is store in a VARCAHR2, how can i execute such stored procedure in form
Next Topic: FRM-40600: Record has already been inserted.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 05:19:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.