Hi.
I`m testing the DB BC try to detect the finally result into a DB table. In the next table I resume the results:
| isNull attribute
| Variable value
| Result
|
| <EMPTY> | <EMPTY> | Error, es necesario asignar un valor a la variable
|
| "" | Error, it is neccesary to assign a value (except with string type)
|
| valor | valor
|
| FALSE | <EMPTY> | Error, es necesario asignar un valor a la variable
|
| "" | Error, it is neccesary to assign a value (except with string type)
|
| valor | valor
|
| TRUE | <EMPTY> | NULL
|
| "" | NULL
|
| valor | valor
|
All this test cases are used in an ASSIGN NODE when for each column field we have an attribute "isNull" too.
Note: With string types the value '' (empty string) it is supported, but with other types throws an error.
When I receive a non-empty value I want to insert this value (then association with variable value in never <EMPTY> and we discard the first global column of the table) and when it is empty I want to insert NULL.
Then, if I want to assign a null into non-string types I need to put
isNull = true and variable value '' ALWAYS and this dirt my bpel.
For example: Null Assign to integer volumn in DB depending from a input value
NullAssing.bmp
Why if I assign '' to non-string types it doesn`t insert a null value?
Regards. Bye.
