AndyLin程式生活

[VS 2019]值不能為 null。參數名稱: instance - 開啟DataSet錯誤

1 開啟屬性頁，點選建置

2. 目標Framework => 改為4.7.2

3. 重新啟動VS2019

[PowerBuilder-6.5]COPY Function and select Table change

save as new function

open SQL code

update code

convert to graphice

[PowerBuilder] Error opening DLL library powerprn.dll for external function at line 19 in constructor event of object powerprinter.(R0014)

copy powerprn.dll to sybase folders

打開powerbuilder 6.5出現以下錯誤"在 Windows 程式中開啟說明時發生錯誤：「功能未包含在內」或「說明不受支援」"

這錯誤是winhlp32.exe造成

偷吃步解決方式 => 不要讓它出現

將以下參數改為0，但HELP就是無法使用

[SQL]產生SQLAgent排程LIST

SELECT

-- job.job_id,

-- notify_level_email,

name,

-- Right('00000000' + Cast(steps.last_run_time as varchar),6) as time,--hhmmss

left(substring('000000',1,6-len(next_run_time))+Convert(nchar,next_run_time),2)+':'+substring(substring('000000',1,6-len(next_run_time))+Convert(nchar,next_run_time),3,2)+':'+right(next_run_time,2) as RUNTIME,

enabled,

description,

step_name,

command,

server,

database_name

FROM

msdb.dbo.sysjobs job

INNER JOIN

msdb.dbo.sysjobsteps steps ON job.job_id = steps.job_id

left join msdb.dbo.sysjobschedules as s on job.job_id = s.job_id

WHERE

job.enabled = 1 -- remove this if you wish to return all jobs

order by next_run_time asc

[RedAjax]UpdatePanelRenderMode in RedControl

this.Master.AjaxManager.AjaxSettings.AddAjaxSetting(P_Edit, P_GridMulti, null, UpdatePanelRenderMode.Inline);

this.Master.AjaxManager.AjaxSettings.AddAjaxSetting(P_Edit, P_GridList, null, UpdatePanelRenderMode.Inline);

RadAjaxLoadingPanel loading = (RadAjaxLoadingPanel)this.Master.AjaxManager.FindControl("RadAjaxLoadingPanel1");

this.Master.AjaxManager.AjaxSettings.AddAjaxSetting(P_GridMulti, P_GridMulti, loading, UpdatePanelRenderMode.Inline);

來源參考：

https://docs.telerik.com/devtools/aspnet-ajax/controls/ajaxmanager/how-to/radajax-and-webusercontrols

[SQL]UPDATE 產生流水號

DECLARE @MAX_ACCOLFID INT

SELECT @MAX_ACCOLFID = MAX(ACCOLFID) FROM COIF_1

--以上流水號可承接別的TABLE

UPDATE COIF_2

SET @MAX_ACCOLFID = @MAX_ACCOLFID + 1,

ACCOLFID = @MAX_ACCOLFID