4.0 vs 4.1 INCLUDE differences

Jack Parker <jparker@hpbs2561.boi.hp.com> writes: > In forms 4.0 version you can do > INCLUDE=("", VAL1, VAL2, VAL3...) > this will allow either a null entry or VAL1, VAL2, ... > > in 4.1 the same statement will require an entry for that field. > > (keyword NULL doesn't do it either) I don't know what version of 4.1 you are using, but on our 4.10.UD1 version of 4GL (and SQL for that matter), putting "" in the INCLUDE list *does* allow both null values or an entry listed; on a screen form, we can tab over the field, put one of the entries in it, or even press the spacebar in it (the spaces are converted to null). If you have an earlier version of 4.1 that does not recognize "" for null values, then the only workaround I can suggest is to try including " ". Good luck. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= John Baker, jbaker@bluegrass-emh1.army.mil Directorate of Infor Mgt. Blue Grass Army Depot, Lexington, KY 40511-5109 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=