相信很多人都碰到這樣的問題與尋找完美的解決方案
關於tt要如何做到stand by 的實時備援ap+db機制
其實只要從基本系統面來下手 簡單不過的幾道手續就可以完成
隨時切換操作使用都不用再擔心機器或軟體故障產生額外費用的問題
有興趣的看版讀者可以加入我一起討論解決方案
- Apr 21 Sat 2012 21:39
-
TIPTOP GP ERP 備援AP建置(FOR 1.x~5.x)
- May 05 Thu 2011 16:48
-
EIP Portal Site 企業入口站台 Web 2.0
- May 05 Thu 2011 16:48
-
集團合併銷貨客戶統計表 (SQL 範例)
/* Formatted on 2011/04/21 14:25 (Formatter Plus v4.8.8) */
SELECT plant, '2011' cyear,
CASE
WHEN plant IS NULL
THEN '全部合計'
- May 05 Thu 2011 16:47
-
集團應收帳齡資訊一覽表(SQL 範例)
/* Formatted on 2011/04/21 14:24 (Formatter Plus v4.8.8) */
SELECT oma00, 'ds01' plant, ar_no, ar_dat, cust_no, sal_no, gp_no, gp_nm,
ar_amt x, upy_dat, cust_nm, sal_nm, curr
FROM (SELECT oma00, oma01 ar_no, oma02 ar_dat, oma03 cust_no, oma14 sal_no,
occ02 cust_nm, gen02 sal_nm, occ43 gp_no, oab02 gp_nm,
- May 05 Thu 2011 16:47
-
未結工單明細表(SQL 範例)
/* Formatted on 2011/04/21 14:22 (Formatter Plus v4.8.8) */
SELECT sfb01 x1, sfb28 x2, nsfb02 x3, nsfb03 ps, sfb05 x4, ima021 x5,
sfb04 x6, sfb13 x7, sfb15 x8, sfb25 x9, ROUND (sfb08) x10,
ROUND (sfb081) x11, ROUND (sfb09) x12,
DECODE (srg16, 'X', '未報工', '已有報工單') x13,
- May 05 Thu 2011 16:46
-
集團即將逾期應收帳款統計表(SQL 範例)
/* Formatted on 2011/04/21 14:20 (Formatter Plus v4.8.8) */
SELECT oma00, t1.plant, ar_no, ar_dat, cust_no, sal_no, gp_no, gp_nm, ar_amt,
upy_dat, cust_nm, sal_nm, curr, x, t2.occ01, t2.occ02, t2.userid,
t2.username
FROM (SELECT oma00, 'ds01' plant, ar_no, ar_dat, cust_no, sal_no, gp_no,
- May 05 Thu 2011 16:46
-
集團逾期應收帳款資訊一覽表(SQL 範例)
/* Formatted on 2011/04/21 14:18 (Formatter Plus v4.8.8) */
SELECT oma00, t1.plant, ar_no, ar_dat, cust_no, sal_no, gp_no, gp_nm, ar_amt,
upy_dat, cust_nm, sal_nm, curr, x, t2.occ01, t2.occ02, t2.userid,
t2.username
FROM (SELECT oma00, 'ds01' plant, ar_no, ar_dat, cust_no, sal_no, gp_no,
- May 05 Thu 2011 16:46
-
集團AR應收帳款彙總表(SQL 範例)
/* Formatted on 2011/04/21 14:15 (Formatter Plus v4.8.8) */
SELECT plant, TO_CHAR (oma11, 'yyyy/mm/dd') oma11, oma03, oma032, oma23,
SUM (x) ans
FROM (SELECT 'ds' plant, oma11, NVL (oma03, '無代號') oma03,
NVL (oma032, '無名稱') oma032, oma23,
- May 05 Thu 2011 16:46
-
集團AP應付帳款彙總表(SQL 範例)
/* Formatted on 2011/04/21 14:16 (Formatter Plus v4.8.8) */
SELECT plant, apa07, YEAR (apa12) years, TO_CHAR (apa12,
'yyyy/mm/dd') apa12,
apa12 cdate, apa13, SUM (x2 + x1 - x3) ans
FROM (SELECT 'ds01' plant, apa00, apa06,
- May 05 Thu 2011 16:45
-
BOM產品結構尾階料價格分析表(SQL 範例)
SELECT plant,XPATH,x1,x2,x3,x4,x5,x6,to_char(cdate,'yyyy/mm/dd') cdate,D1,D2,D3,D4,D5,D6,D7,D8,D9,D10,D11,D12,p0a,p1a,1,p2a,p3a,p4a,p5a,p6a FROM ( SELECT DISTINCT 'ds' plant,XPATH,x1,x2, x3, x4, x5,x6,cdate, p0a, p1a, p2a, p3a, p4a, p5a, p6a,D1,D2,D3,D4,D5,D6,D7,D8,D9,D10,D11,D12
FROM (SELECT bmb02 as x1,XPATH,to_char(bmb02) AS x2, bmb03 AS x3, x21 AS x4, x22 AS x5,x23 AS x6,bmb04 cdate,bmb06 AS p0a,
D1,D2,D3,D4,D5,D6,D7,D8,D9,D10,D11,D12,
ds.fnd_last_pmj07 ('ds',
bmb03,
- May 05 Thu 2011 16:45
-
TIPTOP GP 5.x 雙檔維護作業範例 - 職工福利委員會公告資料維護作業 [4GL檔] - Part 6
FUNCTION i901_out()
DEFINE
l_i LIKE type_file.num5, #No.FUN-680136 SMALLINT
sr RECORD
tc_votea01 LIKE tc_votea_file.tc_votea01, #單據編號
- May 05 Thu 2011 16:44
-
TIPTOP GP 5.x 雙檔維護作業範例 - 職工福利委員會公告資料維護作業 [4GL檔] - Part 5
FUNCTION i901_delall()
SELECT COUNT(*) INTO g_cnt FROM tc_voteb_file
WHERE tc_voteb01 = g_votea.tc_votea01
IF g_cnt = 0 THEN # 未輸入單身資料, 是否取消單頭資料
CALL cl_getmsg('9044',g_lang) RETURNING g_msg
