Showing related tags and posts across the entire site.
-
question: how can i select regardless of upper and lower cases? background: i use the following select statement to filter a table: select * from myTable where textField == myTextVariable; issue: sometimes the text field is uppercase and the text variable is lower case: example: textField: "some...
-
Hi, i have the following Table myString 10 100 20 30 40 i need to retrieve the highest (integer!) value and increment by 10. It took me a while to figure out that it is sorted (10,100... and not 10,20,...,100) that's why the following code breaks: SELECT maxof(myString as int) FROM myTable; this...
-
Hi, i had to add a new numeric sequence to each new record of my table. So i had to override the createrecord() method of the corresponding form: public void createRecord(str _formDataSourceName, boolean _append = true) { R_FeasabilitySequence r_feasabilitySequence; ; super(_formDataSourceName, _append...
-
I can not find any documentation about the order when standard form or table methods are fired. i figured, with the help of the debugger, that table methods are run in the order InitValue, ValidateWrite, Insert. A map / diagram about all methods would be very helpful. the following source only describes...