I am working with a client on a database applicateion. I need a complicated validation for their application that will need to involve a SQL query. Currently I have a dialog entry screen that is triggered on entry or edit. I assume that I can write either custom javascript or xbasic to do what I need but that is honestly a bit over my head.
The validation needs to look at three fields on the entry screen and determine if that combination already exists or is unique. My Idea was to put code in the validation portion of the third field that would do a sql query and see if there were any records returned in the resultset. If there were a record the validation would fail with a message. In this case I need to have a unique combination of DevelopmentName, Unit Number and Time Period. Only one record can exist in the development for the unit number and time period.
This table is used for 8 developments and only two of them require this validation on the record.
I have been combing documentation and looking at examples in the client side and server side functions but haven't come up with anything to help.
I have developed this application without need for any real coding just standard Alpha 5 web components so I am really new to having to write javascript or xbasic.
I did have to write a conversion routine in xbasic to convert data from old system to MS Sql database but not part of a validation.
The validation needs to look at three fields on the entry screen and determine if that combination already exists or is unique. My Idea was to put code in the validation portion of the third field that would do a sql query and see if there were any records returned in the resultset. If there were a record the validation would fail with a message. In this case I need to have a unique combination of DevelopmentName, Unit Number and Time Period. Only one record can exist in the development for the unit number and time period.
This table is used for 8 developments and only two of them require this validation on the record.
I have been combing documentation and looking at examples in the client side and server side functions but haven't come up with anything to help.
I have developed this application without need for any real coding just standard Alpha 5 web components so I am really new to having to write javascript or xbasic.
I did have to write a conversion routine in xbasic to convert data from old system to MS Sql database but not part of a validation.
Comment