jtlaser
Member
Hello,
I may be misunderstanding how to use the Delete functionality here, but all I want to do is delete from a custom table. I've tried a few things, I really just needed to delete everything with the Record Identifier. I only added the event variables, when I couldn't get the Record Identifier to work.
Every Column in this table is listed in the Fetch Single.
If it's not this, then maybe it's the way I created the table? I went back and added a separate key for just Record Identifier, thinking that may be the issue if I didn't use REID and DWK, which is my primary key to find a cell in the grid. I regenerated the Indices and the Table after I did this.
Any help would be appreciated.
-Jonathan
I may be misunderstanding how to use the Delete functionality here, but all I want to do is delete from a custom table. I've tried a few things, I really just needed to delete everything with the Record Identifier. I only added the event variables, when I couldn't get the Record Identifier to work.
Every Column in this table is listed in the Fetch Single.
Code:
0162 ! F596116P.Select
! VA evt_mnRecordIdentifier = TK Self Service Record Identifier
0163 ! F596116P.Fetch Next
! VA evt_AddressNumber <- TK Address Number
! VA evt_DtWorkJulian <- TK Date - Worked
! VA evt_HoursWork <- TK Hours Worked
! VA evt_RtHourly <- TK Rate - Hourly
! VA evt_PayDeductBenAccType <- TK DBA Code
! VA evt_FlsaExemptYN <- TK FLSA Exempt Y/N
! VA evt_StatusFlag <- TK Time Entry Status Flag
! VA evt_ProgramId <- TK Program ID
! VA evt_UserId <- TK User ID
! VA evt_DateUpdated <- TK Date - Updated
! VA evt_TimeLastUpdated <- TK Time - Last Updated
0164 F596116P.Fetch Single
VA evt_AddressNumber <- TK Address Number
VA evt_mnRecordIdentifier = TK Self Service Record Identifier
VA evt_DtWorkJulian <- TK Date - Worked
VA evt_HoursWork <- TK Hours Worked
VA evt_RtHourly <- TK Rate - Hourly
VA evt_PayDeductBenAccType <- TK DBA Code
VA evt_FlsaExemptYN <- TK FLSA Exempt Y/N
VA evt_StatusFlag <- TK Time Entry Status Flag
VA evt_ProgramId <- TK Program ID
VA evt_UserId <- TK User ID
VA evt_DateUpdated <- TK Date - Updated
VA evt_TimeLastUpdated <- TK Time - Last Updated
0165 If SV File_IO_Status is equal to CO SUCCESS
0166 While SV File_IO_Status is equal to CO SUCCESS
0167 F596116P.Delete
VA evt_AddressNumber = TK Address Number
VA evt_mnRecordIdentifier = TK Self Service Record Identifier
VA evt_DtWorkJulian = TK Date - Worked
VA evt_HoursWork = TK Hours Worked
VA evt_RtHourly = TK Rate - Hourly
VA evt_PayDeductBenAccType = TK DBA Code
VA evt_FlsaExemptYN = TK FLSA Exempt Y/N
VA evt_StatusFlag = TK Time Entry Status Flag
VA evt_ProgramId = TK Program ID
VA evt_UserId = TK User ID
VA evt_DateUpdated = TK Date - Updated
VA evt_TimeLastUpdated = TK Time - Last Updated
0168 F596116P.Fetch Single
VA evt_AddressNumber <- TK Address Number
VA evt_mnRecordIdentifier = TK Self Service Record Identifier
VA evt_DtWorkJulian <- TK Date - Worked
VA evt_HoursWork <- TK Hours Worked
VA evt_RtHourly <- TK Rate - Hourly
VA evt_PayDeductBenAccType <- TK DBA Code
VA evt_FlsaExemptYN <- TK FLSA Exempt Y/N
VA evt_StatusFlag <- TK Time Entry Status Flag
VA evt_ProgramId <- TK Program ID
VA evt_UserId <- TK User ID
VA evt_DateUpdated <- TK Date - Updated
VA evt_TimeLastUpdated <- TK Time - Last Updated
0169 ! F596116P.Fetch Next
! VA evt_AddressNumber <- TK Address Number
! VA evt_DtWorkJulian <- TK Date - Worked
! VA evt_HoursWork <- TK Hours Worked
! VA evt_RtHourly <- TK Rate - Hourly
! VA evt_PayDeductBenAccType <- TK DBA Code
! VA evt_FlsaExemptYN <- TK FLSA Exempt Y/N
! VA evt_StatusFlag <- TK Time Entry Status Flag
! VA evt_ProgramId <- TK Program ID
! VA evt_UserId <- TK User ID
! VA evt_DateUpdated <- TK Date - Updated
! VA evt_TimeLastUpdated <- TK Time - Last Updated
0170 End While
0171 End If
If it's not this, then maybe it's the way I created the table? I went back and added a separate key for just Record Identifier, thinking that may be the issue if I didn't use REID and DWK, which is my primary key to find a cell in the grid. I regenerated the Indices and the Table after I did this.
Any help would be appreciated.
-Jonathan