Can't go to table definition and given error

(0) Share

Report

Posted on by Shabir Ahmad

3,090

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

All responses (4)

Answers (1)

Shabir Ahmad 3,090 on at

Like (0)

Report

RE: Can't go to table definition and given error

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
Verified answer

Sergei Minozhenko 23,091 on at

Like (1)

Report
RE: Can't go to table definition and given error

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
Shabir Ahmad 3,090 on at

Like (0)

Report

RE: Can't go to table definition and given error

Hi Sergei Minozhenko,

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

Best Regards,

Shabir
Suggested answer

Sergei Minozhenko 23,091 on at

Like (1)

Report

RE: Can't go to table definition and given error

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.