Delete all rows from Workfile

EONECNC

Well Known Member
I have a custom application which is designed to delete all rows from the custom work table when OK button is Clicked. When OK button is pressed i am getting yellow warning message "Delete from table f554311A failed. my code is given below

0013 VA frm_mnCounterMaxRows_COUNT = "0"
0014 VA frm_mnRecordCounter_COUNT = "0"
0015 Get Input Output Env Handles
SL LoginEnvironment -> BF szInputEnvironment
VA frm_idInputHandle_GENLNG <- BF idInputEnvHandle
SL LoginEnvironment -> BF szOutputEnvironment
VA frm_idOutputHandle_GENLNG <- BF idOutputEnvHandle
SL LoginEnvironment -> BF szLoginEnvironment
0016 Delete All Rows From Table
"F554311A" -> BF szTableName
VA frm_idOutputHandle_GENLNG -> BF idOutputEnvHandle
0017 Free Input Output Env Handles
SL LoginEnvironment -> BF szInputEnvironment
VA frm_idInputHandle_GENLNG <- BF idInputEnvHandle
SL LoginEnvironment -> BF szOutputEnvironment
VA frm_idOutputHandle_GENLNG <- BF idOutputEnvHandle
SL LoginEnvironment -> BF szLoginEnvironment
0018 Get Max Grid Rows(FC Grid, VA frm_mnCounterMaxRows_COUNT)

I checked with DELETEALLROWSFRMTABLE (B76C114) and getting same warning

Can anyone tell me why i am getting warning message. How do i suppress it

JDE 9/8.98.4.4/Windows 2008R2
 
Without seeing a jde.log or debug log, we can't tell which function is returning the warning. But, after looking at the delete BSFN, you should not need to call the Get Input Output Env handles functions. Just the delete should work fine.

A side note/question to all ... I ran this as a test in DEMO 9.0 (8.98.4.5 Oracle DB). The resulting SQL was a TRUNCATE command followed by ANALYZE TABLE JDEData900.F7603B1 COMPUTE STATISTICS. Is that new with the tools release or just done when using an Oracle DB? (Haven't been at an Oracle DB customer in a while).

Craig
 
Hi EoneCNC,

Can you please,let me know, what is the warning message, you are getting.?

your code looks fine.

you can also delete workfile table using Delete option in Table I/O.

Thanks
Raj
JDE Technical Consultant
 
Hi Craig and Raj

Thanks for your reply.
Raj, i am getting "Delete from table f554311a failed" warning message. The logic behind the application is first delete all records from the table f554311a (even if its empty) and then insert record.
Regards

Eonecnc
 
Hi Eonecnc,

I tried on my system, I am able to delete the table before inserting any data in the table.

can you tell me, which event, are you using for deleting table?

can you send me log file? which form you are using?

It seems its very specific issue.

Thanks
Raj
JDE Technical Consultant
 
Back
Top