Cannot insert record into custom table

(0) Share

Report

Posted on by Community Member

Hi,

I have created a simple table to store the errors during validation of a file. I am able to insert records in the table when I run it. But when I try to do it through code, nothing happens and I do not get any error either.

Same with the delete, I cannot delete records through code.

I am using simple code as below

MyTable.INIT;

MyTable.No := 1;

MyTable.Error := 'Error Occurred';

MyTable.INSERT;

Any idea what the issue might be? Any help will be appreciated.

Thanks,

Aparna

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (1)

Brad_P 1,549 on at

Like (0)

Report

Is the Temporary property of the MyTable declaration set to true? Are you certain that the code is executing?

Was this reply helpful? Yes No
Tina Menezes 2,582 on at

Like (0)

Report

Hi,

Can you debug your code and check if it shows any error?

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

On which trigger the code is written ? Is it on any action button ??

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

Can you please share the actual code written.

One thing which I think is that you are overwriting the table with a single record and not incrementing the No. field.

Was this reply helpful? Yes No
Suggested answer

Zaid Tariq 2,274 on at

Like (0)

Report

Hi,

- Make sure the code is written in the OnRun Trigger.

- Make sure you are using a valid licence.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Try to send us the complete code, where you have this code and when are you doing it ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The code is in the OnPreXMLPort trigger. It is for validation of a file before it is imported as transfer order.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It is a simple insert code, there are currently no records in the table. When it did not insert any records through my validation routine, so I just tried the code below and it does not do anything. The table variable is not marked as temporary.

MyTable.INIT;

MyTable.No := 1;

MyTable.Error := 'Error Occurred';

MyTable.INSERT;

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Are you getting any error ? Try adding a MESSAGE BOX after insert and check if you get the message ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am not getting any error. Also, I found out that the table is being treated as a temporary table, although I have not set it as temporary. I can use it within the trigger but the data is gone once I get out of it.

Was this reply helpful? Yes No