Recent content by tyb

Thanks Santa. Best Regards.

Not yet. but i just wanted not to waste ur further time on this problem. Best Regards

Dear Lewisp Istly thanks for ur response. But the problem here, for which i wanted the solution is that if i have four tables/blocks. the user needs to run into hirarchy i.e. Ist parent then child. but user may like to enter the PO then One style then the Colors in that style and then SIzes...

THANKS SANTA FOR UR PATIENCE U'V CONSUMED MUCH TIME FOR ME AND I REALLY APPRECIATE IT. MANY CARDIAL THANKS.

sorry for i was missing some information i.e. table realtions are as below PO & STYLE is in 1 to many style & COMBO 1 to many style & size 1 to many combo & size many to many e.g. PO# STYLE# COMBO SIZE ____________________________________ 01 159 PAECH X XL...

Dear frends plz help me. i want an order entry form where my order data is as below One PO contains multiple STYLES. style contains multiple COMBOS. and a combo has multiple SIZES. if i do simply normalize it and have four tables. it requires the data entry operator to save the things in...

use the forms function set_item_property('item',enable,property_true); and set_item_property('item',enable,property_false); check it in the forms help for more description. Thanks

couldn't understand ur problem , neither i'm an expert but as for i can get from ur query. u might hav placed both the main and the child into a single repeating frame. try creating the child group into the data model and put it into a seperate reapeating frame which lies into the main...

Hi dear Heres what u've asked for SQLWKS> select min(desp_date), max(desp_date) from despatch; MIN(DESP_DATE) MAX(DESP_DATE) -------------------- -------------------- 18-JUN-03 23-AUG-03 1 row selected. SQLWKS> select min_date+(rownum-1) 2> from...

Hi Santa how could i overlook what u instructed. but i'm sorry for not posting the results i.e. the same as with the simple query. here are the results. SQLWKS> select to_char(min(desp_date),'yyyy-mm-dd hh24:mi:ss')a 2> , to_char(max(desp_date),'yyyy-mm-dd hh24:mi:ss')b 3> from...

i'm using the same code u did post to me i.e. SQLWKS> select min(desp_date),max(desp_date) from despatch 2> MIN(DESP_DATE) MAX(DESP_DATE) -------------------- -------------------- 18-JUN-03 23-AUG-03 1 row selected. SQLWKS> select min_date+(rownum-1)...

Hi santa can u plz give me ur mail, so that i can attatch the data out put ,u've asked for, as a word file. its 19 pages in length. Best Regards

y don' u create a seperate table for department and refer the department to the corresponding qualifications. rgrds

I've min date as 18-jun-03 and max date as 23-aug-03 and with the above query i'm returned with 993 rows i.e. starting from 18-jun-03 to 06-mar-06.

hi santa i'm trying it as select trunc(min(desp_date))+(rownum-1) from despatch where trunc(min(desp_date))+(rownum-1) <= trunc(max(desp_date)) but get the error " GROUP FUNCTION NOT ALLOWED HERE " if i change the "where" with "having" then i get the error " NOT A GROUP EXPRESSION " best...