Question 1, and now I have to connect the WPS ODBC database, also can extract the data, but each time you refresh all need to input password? Excuse me where need to set the saved password? Is in the WPS inside or in the odbc setting? Or can be added to the statements below password related statements?
DSN=Thai; UID=Thai;; DBQ=THAI; The DBA=W; APA=T; EXC=T; FEN=T; QTO=T; FRC=10; FDL=10; LOB=T; RST=T; BTD=F; BAM=IfAllSuccessful; NUM=NLS; DPM=F; The MTS=T; MDI=F; CSR=F; FWC=F; FBS=64000; TLO=O;
Question 2: select the subcode, sum (tddrbal)/100 out1, sum (tdcrbal)/100 out2 FROM "THAI". "AFGNLED" where file_date='20210331' and currtype='001' group by subcode order by subcode;
I want to make this statement file_date='20210331' this parameter is dynamic, for example I add a text box in the WPS, the parameter selection is the text frame's value, how to realize the need?
