
4.REFERENCING THE DATABASE USER CUSTOMIZE B-75074EN/04
- 460 -
tSQL = "UPDATE WKPCDspMcnCnd w" & _
" SET LastClockPlan='" & tLtCkPlan & "'" & _
" WHERE w.McnID=" & m_RunLog.McnID
By using the UPDATE command, this SQL statement writes planned
machining end time to LastClockPlan of data with McnID of machining
in-progress log information matching McnID of the progress status
display table.
SetDspMcnCnd_AllLtCkPlan :: DB_McnCnd
This procedure sets planned total machining end time data in the
progress status display table.
Planned total machining end time is calculated as follows:
Remaining machining count = Planned machining count - Normal
end count
Planned machining end time = Machining start time + (Planned
machining time × Remaining machining count)
The following SQL statement is created:
tSQL = "UPDATE WKPCDspMcnCnd w" & _
" SET AllLastClockPlan='" & tAllLtCkPlan & "'" & _
" WHERE w.McnID=" & m_RunLog.McnID
By using the UPDATE command, this SQL statement writes planned
total machining end time to AllLastClockPlan of data with McnID of
machining in-progress log information matching McnID of the progress
status display table.