37
Views
6
Comments
[Validation Helper] SQL Error with Oracle
validationhelper
Reactive icon
Forge asset by Hiroyuki Yamagami
Application Type
Reactive

Thank you for providing us a useful tool!


I encountered SQL Error with Oracle. The cause is that "FROM" does not exist in UIParts.Rules.DataAction1.SQL1. We can not omit "From" using Oracle. I had added "From Dual" in this SQL then SQL Error was resolved.


Could you add "From Dual" or something for Oracle user?


ValidationHelper.png
2021-01-01 04-34-20
Hiroyuki Yamagami

Thank you for your feedback.
Sorry... I missed your message completely.
I will fix the points you mention when I support Oracle.

UserImage.jpg
keisuke shoji

Thank you for your feedback. I see. I had mistook Validation Helper supports Oracle already.

2021-01-01 04-34-20
Hiroyuki Yamagami

I have merged your suggestions and released version 1.2.3.

It was first published for SQLServer, but before long it was shown to support all databases.
Now I could not find the option to change it in the project details screen.
Sorry for the misunderstanding.

UserImage.jpg
keisuke shoji

Thank you for updating. I'll check the new version. And I understood the background. I think we can change the Requirements from the Edit button.

2021-01-01 04-34-20
Hiroyuki Yamagami

Wow, thanks for the info!

UserImage.jpg
keisuke shoji

I checked it works completely in our (Oracle) environment. Thank you!

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.