Cannot update record when table fields name contain hyphen or slash characters

Cannot update record when table fields name contain hyphen or slash characters

pcrobinsonpcrobinson Posts: 1Questions: 1Answers: 0

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

  • allanallan Posts: 63,455Questions: 1Answers: 10,465 Site admin

    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

This discussion has been closed.