How can I add character length in a field on Informix 4GL. I have a description column, and I want to enforce a minimum length 10 characters in this field; if the entered string is less than 10 characters, send the user back to re-enter the data.
Enforcing a minimum character length on a form field in I4GL
401 Views Asked by MJJ3 At
1
There are 1 best solutions below
Related Questions in INFORMIX
- Warnings in Informix database log
- How to release Informix lock from Java
- Informix - select from a temp table created in a 4gl with Interactive debugger?
- Informix throw internal error when creating new transaction in existing one
- How do I split a time range into days using stored procedure in informix 11.5?
- Informix PDO connection : Error SQLSTATE=HY000, SQLDriverConnect: -329 sqlerrm(systables)
- Informix database connection in Play framework
- What may cause connection to be null and How to reuse null reference object?
- SQL query if not null enter field value
- How to backup a single database residing in a dbspace in Informix?
- select for update in stored procedure (concurrently increment a field)
- Informix database issue: Changing the datatype format
- Unable to save dataframe on HDFS for Informix database
- Informix weekday calendar function not working
- SQL sum column in one table where value in another table is 'S'
Related Questions in 4GL
- Progress 4GL - Define variable month/year
- OpenEdge - Progress ABL: How to open a web browser inside a dialog window
- SAS 4GL - multiple informats
- sas 9.3 user deleted and created again Users Folders
- how to use Array of decimal in 4GL
- Concurrency Operation in Progress 4GL
- file movement from one directory to another
- Why does the Informix 4GL compiler complain about unknown option -fwritable-strings?
- how to make function in react js.with function definition and function call
- how set code page to export xml file ion progress 4gl
- How do I reference a TEXT type in Informix 4gl?
- Enforcing a minimum character length on a form field in I4GL
- Informix 4GL and triggers
- is it possible to write record as NO-UNDO in transaction?
- form-only lookup
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
To enforce that constraint, you would need to use an AFTER FIELD clause, check the length of the entered data, and send the user back if it is not long enough:
I'm assuming it is a field that does not allow nulls; if it does allow nulls, you need to allow for that in the testing.
Incidentally, you can seriously expect to have to deal with descriptions like 'Aaaaaaaaaa' and 'asdfasdfasdf' if you put this requirement on users. They may also get more creative; you can fit a couple of 4-letter words and an exclamation mark into a 10-character limit.