Can't go to table definition and given error

(0) Share

Report

Posted on by Shabir Ahmad

3,124

Hi Experts,

I want to add some fields in cust aging DP class(Standard Report), if i am trying to insert it giving an error(even i made fields in temp table already) as shown in the image. The second thing is if I tried to go to the definition of this temp report it behaves like a map giving an error please check.

Best Regards,

Shabir Ahmad

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Sergei Minozhenko 23,095 on at

Like (1)

Report
Copy link

Link copied!

Hi Shabir,

The error in infolog shows that you added a field to insert_recordset section (SortOrder?), but have not added the source field in select section.

Was this reply helpful? Yes No
Shabir Ahmad 3,124 on at

Like (0)

Report
Copy link

Link copied!

Hi Sergei Minozhenko,

I added fields in tmp table before then i came here to add these fields.

Best Regards,

Shabir

Was this reply helpful? Yes No
Verified answer

Sergei Minozhenko 23,095 on at

Like (1)

Report
Copy link

Link copied!
Hi Shabir,

The number of fields in insert_recordset section should be the same as in select section

You have the same case as below: field3 is missing from select section. You need to review all fields in insert_recordset * select statement and find what field is missing in select.

insert_recordset myTable ( field1, field2, field3) ) select field1, field2 // field3 is missing from myTable1

Was this reply helpful? Yes No
Shabir Ahmad 3,124 on at

Like (0)

Report
Copy link

Link copied!

Hi Sergei Minozhenko,

First thanks for your suggestion that worked, one point is there why temp table behave like MAP if I want to go to its definition it doesn't work check-in the image in the post.

Best Regards,

Shabir Ahmad

Was this reply helpful? Yes No