Comments by Member 11919722

Member 11919722 22-Sep-15 5:27am View

thanks for the response but its not getting downloaded

Member 11919722 22-Sep-15 3:09am View

Can anyone please help me with finding out solution for above query

Member 11919722 21-Sep-15 8:00am View

thaanks for replying but its not getting downloaded?

Member 11919722 21-Sep-15 4:36am View

actually the problem in above query written by me is that inner query is returning null value for date columns to outer query that's why null value constraint error is coming but I don't understand how can it be possible since bith the tables have data in date columns.

Member 11919722 15-Sep-15 3:43am View

update sc_bill_details set dt_open_date =(select dt_bill_date from sc_bill where sc_bill.st_bill_no=sc_bill_details.st_bill_no)where to_char(dt_open_date,'yyyy-mm-dd')in(select to_char(dt_bill_date,'yyyy-mm-dd') from sc_bill where dt_bill_date>'2015-07-01') m trying this way thought not coming where as if we write select statemnet seperately its giving required output but not with update statement??

Member 11919722 15-Sep-15 3:42am View

thanks for your response but ur query also doesnt work with update statement since my requirement is to get dta that from july 1st to till now from sc_bill table to sc_bill_details table

Member 11919722 15-Sep-15 2:41am View

yes Michael i did all possible research actually when inner query is running then its giving null value to date column to outer query i dont know why as per my concern my above query is correct but y inner query is returning null value

Member 11919722 11-Sep-15 4:01am View

thanks sandeep for replying will try to get it ....n mark he solution if got solved.

Member 11919722 11-Sep-15 2:34am View

by the way here is the requirement given to me ...actually i have host machine n database in lan in two separate machines ....but client is at remote place in this case having one static ip address will be working fine in order to access an asp.net application by client?

Member 11919722 11-Sep-15 1:41am View

thanks sandeep actually i have a requirement of running it on wan without static ip address but not getting how come will it b possible.

Member 11919722 11-Sep-15 1:07am View

thanks for your valuable response but is there any alternate solution available for the same issue without using static ip address or dns ?

Member 11919722 7-Sep-15 5:55am View

Deleted

Thanks for replying but i am not grtting it clearly isnt their any alternate way to do it ...through any networking steps?

Comments by Member 11919722 (Top 12 by date)