Invent Batch New Column Create throws error

(0) Share

Report

Posted on by Community Member

Hello,

there is a problem when i create a new in invent batch table it complies and gives no error while as i synchronize it with database it shows error as Cannot execute a data defination language command () ALTER TABLE INVENTBatch nvarchar(100) not null. Neither it let me drop the column. gives same error as Cannot execute a data defination language command () while synchronization. Please tell what could be the problem.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Ivan (Vanya) Kashperuk on at

Like (0)

Report

RE: Invent Batch New Column Create throws error

Can you paste a screenshot or the entire text of the error message?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Invent Batch New Column Create throws error

I am share error info

Was this reply helpful? Yes No
Suggested answer

Ivan (Vanya) Kashperuk on at

Like (0)

Report

RE: Invent Batch New Column Create throws error

That's the statement it was trying to execute. the error is one message above it.

But I can see you are trying to use a name for the column "DESC". That's a reserved SQL keyword, and thus cannot be a name of a column in a table.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Invent Batch New Column Create throws error

Thanks

Was this reply helpful? Yes No
Ivan (Vanya) Kashperuk on at

Like (0)

Report

RE: Invent Batch New Column Create throws error

can you mark the thread as answered then? tnx

Was this reply helpful? Yes No