
B-75074EN/04 USER CUSTOMIZE 4.REFERENCING THE DATABASE
- 459 -
", NormNum)" & _
" VALUES" & _
" ('" & m_RunLog.McnID & "'" & _
", '" & m_RunLog.WorkID & "'" & _
", '" & m_RunLog.FirstClock & "'" & _
", '" & m_CntWkPc(0).Count & "')"
When O number data is present
tSQL = "INSERT INTO WKPCDspMcnCnd" & _
" (McnID" & _
", WorkID" & _
", ONum" & _
", FirstClock" & _
", NormNum)" & _
" VALUES" & _
" ('" & m_RunLog.McnID & "'" & _
", '" & m_RunLog.WorkID & "'" & _
", '" & m_RunLog.ONum & "'" & _
", '" & m_RunLog.FirstClock & "'" & _
", '" & m_CntWkPc(0).Count & "')"
By using the INSERT INTO command, this SQL statement writes
acquired machining in-progress log information and normal end count
to the progress status display table.
SetDspMcnCnd_WkPcPlan :: DB_McnCnd
This procedure sets planned machining count data in the progress status
display table.
The following SQL statement is created:
tSQL = "UPDATE WKPCDspMcnCnd w" & _
" SET w.PlanNum='" & m_CntWkPcPlan(0).Count & "'"
& _
" WHERE w.McnID=" & m_RunLog.McnID
By using the UPDATE command, this SQL statement writes planned
machining count to PlanNum of data with McnID of machining
in-progress log information matching McnID of the progress status
display table.
SetDspMcnCnd_LtCkPlan :: DB_McnCnd
This procedure sets planned machining end time data in the progress
status display table.
Planned machining end time is acquired by adding planned machining
time to the machining start time of machining in-progress log
information.
Planned machining end time = Machining start time + Planned
machining time
The following SQL statement is created: