Error cannot select a record in items groups(InventItemGroup)???

(0) Share

Report

Posted on by Chomchanok

282

Hi All,

I require your assistance with an issue. There's an existing customization that used to function properly, but I'm uncertain about its reliability over time.

Today, I discovered that it is not working. As a result, I attempted to investigate and debug the problem.

I found an error originating from the AxTable_inventItemGroupItem within the class /inventItemGroupItem/ (which appears to be a standard function).

The error message reads, /Cannot select a record in Item groups (InvenItemGroup). Item group: AA. The SQL database has issued an error./
Could someone please provide guidance on how to proceed?

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Mohamed Amine Mahmoudi 26,803 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Please try to add the RecId field to the select statement :

e.g.

select RecId,ItemGroup from inventItemGroup where ...

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Chomchanok 282 on at

Like (0)

Report
Copy link

Link copied!

DearMohamed Amine Mahmoudi,

Thak you for your reply when I try to follow up your guideline by "select recid ,itemgroup ,* from inventItemgroup"

Field "Itemgroup" is not available in database.

But when I check a code that relate Table "inventItemgroup" but it not refer to field "Itemgroup" it refer to field "ItemgroupID".

workflow that I try to debug but it's not hit my code but show error(I think it's error before access to my code??)

Was this reply helpful? Yes No
Verified answer

Chomchanok 282 on at

Like (0)

Report
Copy link

Link copied!

Update my case:

1. I miss focus on my code that I need to debug on this function but after I debuging then application is work normally. I don't know why but for now I can continue to run application with out error.

Was this reply helpful? Yes No