Cannot update record when table fields name contain hyphen or slash characters
Cannot update record when table fields name contain hyphen or slash characters
Hi,
I am creating an admin portal and I am using the Editor (.NET) to do all CRUD actions but I am having issues updating records.
I am working with an existing table (I cannot alter) that has fields name like "MainProvince/State".
I was able to load the values in the form but when I try to update the record I get the following error: "Incorrect syntax near '/'."
I guess this error is coming from the update statement Update [table] set [MainPROVINCE/STATE] = @MainPROVINCE/STATE
Is there a way to change the update parameters?
Thank you,
Answers
Thanks for letting me know about this - a
/
is not something I'd tested for!I've sent you a PM with an updated dll to address that.
Regards,
Allan