-
Notifications
You must be signed in to change notification settings - Fork 22
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
Inserting data does overrides columns with defaults or autoincrement set. #8
Comments
Hi @PAPutzback. If you are trying to only insert rows, then you can just leave those columns out. If you do that it will not explicitly set those columns to anything, so the defaults should work. You won't be able to do an insert and update in the same 'upload' function though. |
@PAPutzback Is there any improvements that we can do to help? Maybe I'm not completely understanding the issue. |
@PAPutzback Was there anything I can help with on this issue? If not I'd like to close it out. |
Sorry for not getting back to you. I got pulled off to another project.
Please close the ticket,
…On Tue, Mar 23, 2021 at 11:37 AM Steven Segal ***@***.***> wrote:
@PAPutzback <https://github.com/PAPutzback> Was there anything I can help
with on this issue? If not I'd like to close it out.
Thanks.
Steve
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
<#8 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ACXNWYR4JKNGISEOXEP4WLDTFCYSTANCNFSM4VMNE6TA>
.
|
Thanks! |
If I insert a row and leave the Primary key field empty since it is supposed to autogenerate the id on insert and\or I leave another column with the default set to CURRENT_TIMESTAMP(). Neither the ID or the date gets set. They end up being set to empty strings. Without the key this also makes deletes a bit of an issue and the user will need rules to add additional key fields.
Great Addin though. I'll just have to add some instructions for the users to look up the last ID and increment it by 1 and type in the date and time for the CREATE DATE field.
The text was updated successfully, but these errors were encountered: