search

erdomke / InnovatorAdmin

A tool for managing Aras Innovator installations focusing on improving the import/export experience.
http://erdomke.github.io/InnovatorAdmin/
MIT License
58 stars 42 forks source link

Exceptions when invoking context menu in grid for SQL queries #165

Closed rneuber1 closed 8 years ago

rneuber1 commented 8 years ago

Query issued:

select C.id as 'CAD ID',F.id as 'File_ID',C.item_number,C.locked_by_id as 'CAD LOCK',F.filename,F.locked_by_id as 'File Lock' from innovator.CAD as C inner join innovator.[File] as F on F.id=right(C.thumbnail,32) where (F.locked_by_id is not null and C.locked_by_id is null) or (F.locked_by_id is null and C.locked_by_id is not null) or (F.locked_by_id not like C.locked_by_id)

When invoking context menu on the grid, this happens:

image

if you omit the column naming ("as 'CAD ID'...), the message changes slightly:

image