Insert values using Macros

(0) Share

Report

Posted on by Community Member

Hi people,

What I am trying to do in making an insert using values from a method in my class, but I have some problems with the parameters. The macro that I have done is something like this.

#LOCALMACRO.InsertGroupValues

%1.clear();

%1.ItemId = %2;

%1.insert()

#ENDMACRO

public void InsertMethod()

{

Table1 table1;

#InsertGroupValues(table1, "00001")

}

And, in the class method I send the table I want to insert in. The problem is, when I declare the macro, it shows me a syntax error, that means it is not possible to send the table as a parm and insert values in, or I have an error that I haven't seen.

Thank you.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Verified answer

Mea_ 60,286 on at

Like (1)

Report
Copy link

Link copied!

Hi Kevin Sanchez,

you missing ";" after %1.insert() in your macro.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks, I haven't seen it.

Was this reply helpful? Yes No
Martin Dráb 239,385 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

But why would you ever use code like this? It's very difficult to debug; the fact that you weren't able to find your bug is a proof.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I want to use it because I will insert values in three different tables, but every table has the same fields, so if I have to insert in one of them, according to a condition that I have in the method, it will send as a parm the table of that specific case.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,385 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Your requirement can be implemented without abusing macros.

Probably the best option is using a table map. Map all three tables to the map and write code against the map.

YourTableMap tableMap = ... // Assign your table buffer here tableMap.clear(); tableMap.ItemId = itemId; tableMap.insert();

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks my friend, that's another good way to do that, I'll use it in my project.

Thank you.

Was this reply helpful? Yes No