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

(0) Share

Report

Posted on by Chomchanok

253

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?

All responses (3)

Answers (1)

Verified answer

Chomchanok 253 on at

Like (0)

Report

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

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.
Chomchanok 253 on at

Like (0)

Report

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

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??)
Suggested answer

Mohamed Amine Mahmoudi 17,027 Super User 2025 Season 1 on at

Like (0)

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

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