In my solution, I have two forms with the same structure. I pretend to move all entries from one form (old form) to other (actual form).
I executed the following queries via SQL to say to those records which have old key (from old form) and change them to new key (actual form).
--set new form key on old form records
update UFRecords set form = 'NEW FORM KEY' where form = 'OLD FORM KEY'
-- update RecordData field with new keys
update UFRecords set RecordData = cast(replace(cast(RecordData as nvarchar(max)),'034B9219-ADD1-4C6D-A6CD-DD1096802E0','9BB74648-80A9-4FC9-BE98-D808ABA2CB62') as ntext) where id = 619
--update record field -> this is done 4 times to 4 form fields
update UFRecordFields set FieldId = 'NEW Field ID', Alias = 'NEW ALIAS' where record = 619 and FieldId = 'OLD Field ID'
At moment, appeared news records in list of entries from actual form but the values returned as empty .
If I want to see more details from that record, doesn't show any value like you can see in this picture:
Move form records to another form
In my solution, I have two forms with the same structure. I pretend to move all entries from one form (old form) to other (actual form).
I executed the following queries via SQL to say to those records which have old key (from old form) and change them to new key (actual form).
At moment, appeared news records in list of entries from actual form but the values returned as empty .
If I want to see more details from that record, doesn't show any value like you can see in this picture:
What could it be?
is working on a reply...