Hello, people. I need to convert a varchar field from the index of a table to integer (it has only numbers). If I modify in the Appgini application the data type it keeps/converts the numbers from char to int without losing data?
Thanks!
Convert from varchar to int without losing data
Re: Convert from varchar to int without losing data
Hi,
when you change the field type of a varchar that holds only integers, nothing should be lost. Just make sure you backup your database first
Olaf
when you change the field type of a varchar that holds only integers, nothing should be lost. Just make sure you backup your database first
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: Convert from varchar to int without losing data
Thanks for replying! I did a test with the database with a local copy in the database and it actually worked. I did it with the database in production (fingers crossed and all that) and it did too. What I don't understand is that in Oracle, to do the same thing, I needed to generate field, cast, and replace index... the appgini rebuild fields option works fine but I miss being able to manipulate it.
Great work!
Great work!