Currently in quickSQL if the column name includes _number then it defaults the column to NUMBER and _date to DATE. Prior to 23.2 _name would defalt to VC255, but that has now gone. I would suggest this is reinstated, but shortened to the length at which the builder creates a Text Field rather than a Text Area. I would do the same for _title.
Implicitly, this should set test_name = vc90, test_description = vc4000, test_number = numeric and test_date = date
vadim-tropashko
commented
9 months ago
Currently in quickSQL if the column name includes _number then it defaults the column to NUMBER and _date to DATE. Prior to 23.2 _name would defalt to VC255, but that has now gone. I would suggest this is reinstated, but shortened to the length at which the builder creates a Text Field rather than a Text Area. I would do the same for _title.
Implicitly, this should set test_name = vc90, test_description = vc4000, test_number = numeric and test_date = date