Hello,
I was wondering if it was possible to set the default value of a field so that it would be treated as a function instead of a string literal when sent to a writer.
For example:
<Field default="uuid()" delimiter="," name="OBJ_ID" nullable="false" shift="0" type="string"/>
Here I would to send my data to a MySqlDataWriter which will generate a UUID if needed.
Now I know the DEFAULT clause in Mysql does not allow for functions, I'm just wondering if it is possibly to do this in Cloverelt, without having to resort to DBOutputTable and just adding it to the query.
Thank you.
I was wondering if it was possible to set the default value of a field so that it would be treated as a function instead of a string literal when sent to a writer.
For example:
<Field default="uuid()" delimiter="," name="OBJ_ID" nullable="false" shift="0" type="string"/>
Here I would to send my data to a MySqlDataWriter which will generate a UUID if needed.
Now I know the DEFAULT clause in Mysql does not allow for functions, I'm just wondering if it is possibly to do this in Cloverelt, without having to resort to DBOutputTable and just adding it to the query.
Thank you.
-
Hello, it is not possible. Only functions described on following page are available: Field Pane
Please sign in to leave a comment.
Comments 1