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...

I need help with this following. I created the following procedure and trigger but getting error. This I am using for inofrmix 4GL. Thankyou. CREATE PROCEDURE trig_insert_test1(ncode CHAR(2), nname CHAR(32)) DEFINE ocode CHAR(2); FOREACH SELECT code INTO ocode FROM state...

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

Thank you, but in my case I am only 3 weeks in informix 4gl no clue. how to create.

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

Not for free, but you can have trail for 30 days that is free.

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...

Can you just tell me where I'm wrong with this??? string ls_tmp, ls_tmp1, ls_find long ll_rowsw, ll_rowds dw_size.Reset() dw_size.SetRedraw(false) ll_rowds = dw_size.InsertRow(0) ll_rowsw = dw_search.getrow() ls_find = "product_id = '" +...

Can you just tell me where I'm wrong with this??? string ls_tmp, ls_tmp1, ls_find long ll_rowsw, ll_rowds dw_size.Reset() dw_size.SetRedraw(false) ll_rowds = dw_size.InsertRow(0) ll_rowsw = dw_search.getrow() ls_find = "product_id = '" + dw_search.GetItemString(ll_rowsw, 'product_id') +...

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