Hi, I am a new user (purchased today).

Do you have SQL that I can use to change the value of a DNN profile element?

I have found SQL to retrieve a profile field, but not to update it, and my SQL is a bit too shaky to want to mess with DNN's DB without being sure I know what Im doing.

Thank you for responding so quickly.

I do understand that I can tie a dynamic field to a DNN core field. 

However, I want to be able to access profile fields from modules OTHER than yours, modules which allow programming (specifically listx and open smart module).

I want to use DR to update these fields when people sign on, but at other times I may need to change them myself. I just basically want to have control over them, inside or outside of DR.

So I need SQL to update a DNN core field.  Or, if that isnt possible, I will not link the fields to the core and I would need SQL to update one of YOUR core fields.

Actually,  before I bought, I thought I understood from an email to your support yesterday that this was not a big deal. Hope so, cause I have a small brain.

Again, thanks again for your really fast response.

Having DR to adjust default user properties is really simple. Say you want to have a value “mother’s maiden name” on a user and you want the user to be able to insert/view this value both using DNN built in profile editor and in a form using DR.  

So create it in the core DNN user properties editor, make it “visible” and your users should be able to view it and change it using the built in user profile.

Then you want a form somewhere where this value should be updated/created, here is where DR makes it simple. Drop a DR form on a page; use the wizard to create first three fields, username, password and password reminder, maybe hide this three fields to already logged in users by a setting in the form core integration advance settings.  Continue create a textbox question; in textbox question advanced settings connect this question to the core field, your done!

Now you have a form where the user can change this value, this form can now be modified in gazillion ways to accomplish additional things you want but the core “mother maiden name” field will always be viewed/changed from this additional form together with the core DNN default user profile editor.

Two ways to change “mother maiden name” is accomplished, no “sql code” is necessary.