EasyFlow 電子表單精靈設計的表單要刪除 需刪除掉哪些資料

若要刪除電子單表精靈所產出的表單,需做下面這些動作:

登入EFNETBD資料庫 進行操作

1. 資料表resca,將resca001=表單代號的資料刪除

2. 在由 EFormWizard 開頭的資料表中查詢,將FormID欄位=表單代號的資料刪除

3. 如果已經有送出測試的資料,那流程資料也需要一併空除,資料表為resda、resadb、resdc、resdd、resde、resdf,將這些資料表001的欄位=表單代號的資料刪除

4. resdz為表單單號記錄檔,將resdz001=表單代號的資料刪除

刪除電子表單精靈設計的表單的T-sql執行檔,記得要將’ADM01’換成你要刪除的電子表單代號喔!

--刪除電子表單相關資料,自動執行程式
declare @FormID as nvarchar(30) = 'ADM01';

delete from resca where resca001=@FormID
delete from EFormWizardCond where FormID=@FormID
delete from EFormWizardEvent where FormID=@FormID
delete from EFormWizardField where FormID=@FormID
delete from EFormWizardFile where FormID=@FormID
delete from EFormWizardGrid where FormID=@FormID
delete from EFormWizardHead where FormID=@FormID
delete from EFormWizardOuterDB where FormID=@FormID
delete from EFormWizardTable where FormID=@FormID

delete from resda where resda001=@FormID
delete from resdb where resdb001=@FormID
delete from resdc where resdc001=@FormID
delete from resdd where resdd001=@FormID
delete from resde where resde001=@FormID
delete from resdf where resdf001=@FormID

發表迴響

在下方填入你的資料或按右方圖示以社群網站登入:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 變更 )

Twitter picture

You are commenting using your Twitter account. Log Out / 變更 )

Facebook照片

You are commenting using your Facebook account. Log Out / 變更 )

Google+ photo

You are commenting using your Google+ account. Log Out / 變更 )

連結到 %s