Search results for query: *

Hi, I have the following code in Informix 4GL, but I am running problem and unable to findout, please help me. Thank you. CREATE PROCEDURE trig_insert_test1(ncode CHAR(2), nname CHAR(32)) DEFINE ocode CHAR(2); FOREACH SELECT code INTO ocode FROM state WHERE...

Hi, I want a simple sql (trigger) for duplicate checking. My table name is test1 with 2 columns code and sname, before inserting new record, check - if the record is already exist, then error, not insert. or Insert it. Thank you, Magni

Hi I want a simple sql (trigger) for duplicate checking. My table name is test1, before inserting new record, check - if exist, then error, and not insert. Thank you, Magni

Hi, could anyone go through my source code and tell me where I'm wrong. //TODO ALL IDs MUST BE INCLUDED for ll_row_class= 1 to ::mds.aso.ii_max_division ls_find = "division_id_" + string(ai_division_number) + " = ~'"+ this.dw_criteria.getitemstring(1, "division_" +...

I have total 5 dropdown fields, they are d1, d2, d3, d4, d5. I need to filter dropdown datawindow based on the content of the selection from the fields.. I want to create a filter. Each fields contain 5 items. that is d1 - A, B, C, D, E d2 - AA, BB, CC, DD, EE d3 - AAA, BBB, CCC, DDD, EEE d4 -...

Hi I have a dw called dw_search that is working fine and displaying all the products. I have a size button on that dw_search. I created a datastore called dw_sizestore. Also I created another window called dw_size. In my datastore I store size table, product table and calss table. here my...

Hi, I am new to PB, help me with a filter for this. When value is 1 the row is a new product_id, when value is 0 The row is an other size with in a same product ID