Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Incorect syntax near onDelete, onUpdate #8

Open
Adviser-ua opened this issue Apr 21, 2016 · 0 comments
Open

Incorect syntax near onDelete, onUpdate #8

Adviser-ua opened this issue Apr 21, 2016 · 0 comments

Comments

@Adviser-ua
Copy link

Hi!
When I try apply changeSet - addForeignKeyConstraint I get error

SAP DBTech JDBC: [257] (at 140): sql syntax error: incorrect syntax near "NO": line 1 col 140 (at pos 140)
Its lines:

onDelete="NO ACTION"
onUpdate="NO ACTION"

I also have tryed :

onDelete='NO ACTION'
onUpdate='NO ACTION'

but its work with single word parameter like "CASCADE"

However I set nothing

onDelete=""
onUpdate=""

It returns me error

Value '' is not facet-valid with respect to enumeration '[CASCADE, SET NULL, SET DEFAULT, RESTRICT, NO ACTION]'. It must be a value from the enumeration.

So, parameter "NO ACTION" exists in options.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant