Lowyat.NET: Latest topics by n00bz

Fujifilm XT1 + Samyang 10mm 2.8

n00bz — Mon, 04 Nov 2019 15:32:51 +0800

Item(s): Whole system

Package includes: XT1 Complete set + Batt Grip (2 Batt) + Samyang 10mm 2.8

Price: RM2500(all)

Warranty:

Dealing method: COD

Location: Shah Alam/Cyberjaya

Contact method/details: 012-6509886
---

Item(s) conditions: XT1: 8/10

Samyang 10mm: 8/10

Picture: later.

Reason for sale: quitting photography.

[WTS] Fujifilm XF 35mm f1.4 lens

n00bz — Mon, 27 Mar 2017 13:37:07 +0800

Item(s): Fujifilm XF 35mm f1.4 lens

Package includes:Complete box.

Price: rm1300

Warranty: n/a

Dealing method: COD

Location: Shah Alam\Cyberjaya

Contact method/details: 012 697 1512
---

Item(s) conditions: Good condition.

Picture: [attachmentid=8648210][attachmentid=8648211]

Reason for sale: Seldom used.

WTS> Fujifilm XE-1 + 35mm 1.4

n00bz — Mon, 23 Nov 2015 03:47:17 +0800

Item(s): WTS> Fujifilm XE-1 + 35mm

Package includes: Complete set

Price: Offer me ur best price.

Warranty: n/a

Dealing method: COD

Location: Shah Alam

Contact method/details: 012-6971512
---

Item(s) conditions:Used. GOOD condition.

Picture: Contact me.

Reason for sale: Upgrade.

<WTS>Fujifilm XF18-55mm f/2.8-4 R LM OIS

n00bz — Thu, 11 Sep 2014 15:56:20 +0800

Item(s): Fujifilm Fujinon XF 18-55mm f/2.8-4 R LM OIS

Package includes: Lens, Lens hood, Lens front cap, Lens rear cap

Price: RM1000

Warranty: March 2015

Dealing method: COD

Location: Shah Alam

Contact method/details: 012-6509886 (Call\SMS\Whatsapp)

Item(s) conditions: 95% Still in good condition

Picture: n/a

Reason for sale: Upgrade.

SELECT statement prob.

n00bz — Wed, 07 Sep 2011 21:06:59 +0800

SQL

select distinct client_cd &client_cd1
a.client_name || a.client_name_ext &clt_name1
a.cds_acct_num &cds_acct_num1
rtrim(ltrim(a.def_addr_1)) &clt_addr11
rtrim(ltrim(a.def_addr_2)) &clt_addr21
rtrim(ltrim(a.def_addr_3)) &clt_addr31
a.post_cd &post_cd1
a.staff_cd &staff_cd1
substr(d.staff_name_abbr,1,19) &cl_staff_name1

do 1_print_letter_head
position (+2)
let #rec = 1
do l_get_data1
do 1_print_letter_tail

from comh_client a, comh_staff d
where a.staff_cd = d.staff_cd and d.staff_cd <> 'ZZZ' and rtrim(a.client_cd) = 'ABU'
order by client_cd

SQL

select distinct a.div_amt_alloc &amt_paid1
b.payment_dt &pay_dt1
substr(c.stk_desc,1,38) &stk_name1

if #rec > 10
do 1_print_letter_tail
do 1_print_letter_head
let #rec = 1
position (+2)
else
do l_print_data1
let #rec = #rec + 1
end-if

from noth_stock_alloc a , nomh_announcement b , comh_counter c
where a.ann_num = b.ann_num and substr(a.ann_num,5,1) = 'C' and b.stk_cd = c.stk_cd and rtrim(a.client_cd) = 'ABU' and b.payment_dt between to_date(''{i_pay_dt_fr}'',''dd/mm/yyyy'') and to_date(''{i_pay_dt_to}'',''dd/mm/yyyy'')'
order by b.payment_dt
end-select

this is the syntax to show client code that the staff has so probably 1 client to 1 staff.. how bout to show the 1 staff to all(many) his client?..really2 need any sifu help plss.

SQR prbblem

n00bz — Sat, 03 Sep 2011 23:11:11 +0800

SQL

Begin-procedure l_main begin-select
client_cd &client_cd
a.client_name || a.client_name_ext &clt_name
a.acct_num &acct_num
rtrim(ltrim(a.def_addr_1)) &clt_addr1
rtrim(ltrim(a.def_addr_2)) &clt_addr2
rtrim(ltrim(a.def_addr_3)) &clt_addr3
a.post_cd &post_cd
a.staff_cd &staff_cd
substr(b.staff_name_abbr,1,19) &cl_staff_name

do 1_print_letter_head
position (+2)
let #rec = 1
do l_get_data
do 1_print_letter_tail

from tbl_client a, tbl_staff b
where a.staff_cd = d.staff_cd and b.staff_cd <> 'ZZZ' and a.client_cd = ''{i_client_cd}''
order by client_cd
end-select

End-procedure l_main Begin-procedure l_get_data

begin-select
distinct a.div_amt_alloc &amt_paid
b.payment_dt &pay_dt
substr(c.num_desc,1,38) &num_name

if #rec > 10
do 1_print_letter_tail
do 1_print_letter_head
let #rec = 1
position (+2)
else
do l_print_data
let #rec = #rec + 1
end-if

from noth_stock_alloc a , nomh_announcement b , tbl_counter c
where rtrim(a.client_cd) = '{i_client_cd}' and a.ann_num = b.ann_num and substr(a.ann_num,5,1) = 'C' and b.num_cd = c.num_cd and b.payment_dt between to_date(''{i_pay_dt_fr}'',''dd/mm/yyyy'') and to_date(''{i_pay_dt_to}'',''dd/mm/yyyy'')
order by b.payment_dt
end-select

End-procedure l_get_data

this procedure to retrieve client code that enter by user from noth_stock_alloc a , nomh_announcement b , tbl_counter c..how can i retrieve staff code from tbl_staff on procedure l_main that using same text box with client code..help me pls..the problem is i cant add another syntax like rtrim(staff_cd) = '{i_client_cd}'..help me pls...

PL/SQL error msg

n00bz — Tue, 09 Aug 2011 10:11:38 +0800

SQL

BEGIN SELECT client_cd, global_sell_lim
INTO l_client_cd, i_global_sell_lim
FROM comh_client WHERE rtrim(client_cd) = rtrim(substr(c1_rec.client_cd,3,9)) AND client_type_3 <> 'N' AND susp_stat <> 'C';
EXCEPTION
WHEN No_data_found THEN
o_error := 'Y' ;
o_err_msg := 'Error Select from client master ' ||sqlerrm;
raise exit_loop ;

WHEN OTHERS THEN
o_error := 'Y' ;
o_err_msg := 'Error Select from client master ' ||sqlerrm;
raise exit_loop ;
END;

how can i show only susp_stat that has value 'C' row in error msg?..any1 can help me pls.