Search results for query: *

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

How abt the original question is there any good & simple way to perform it. Best regards

thanks Himan i had a variable in my trigger declared as x number(10); and it having no space for decimal points was giving the problem. best regards

can u plz tell me how would i get all the date values in between my min and max dates regardless of thier existance into the table. for instance if i get min date as 15-Oct-04 and max 30-Oct-04 then i want to get all the dates in between thse dates i.e. 15,16,17,18,19,20,21,22 ...

thanks both of u Karen & Hoins but my question is 1. i want to show the dates onto my parameter from (starting from the min date to max date) 2. If the user selects a single date in both the DATE FROM & DATE TO , the report should be run for that specific date. any suggessions plz...

how simple, i didnt even have the idea plz reply my 2nd question too i.e. if i use the date between min(date) and max(date) in this case if there is the same value for max & min, it wont return any row. how to resolve this problem. many cardial thanks for ur reply.