Re: INITIALIZE 250 variable limit

In article <2038@logsysv.logsys.com> larry@logsysv.logsys.com (Laurence Sigmond) writes: } After moving an application from 4.0 compiled 4.1 RDS I get the } following error: } } INITIALIZE record_name.* TO NULL } } There are too many variables to VALIDATE or INITIALIZE in one } statement. } See error number -4436. } } In the above example, record_name is defined as like a table with } about 300 columns. Informix support reports that there is a 250 } variable limit on INITIALIZE in both 4.0 and 4.1 RDS and compiled, } so it officially shouldn't be working (as it does). Anyway, this } application is peppered with these statements and I will appreciate } any suggestions. I want, of course, to avoid hard coding the names } or numbers of columns into the 4gl source. } Break the INITIALIZE up like this... INITIALIZE record_name.column_1 THRU record_name.column_150 TO NULL INITIALIZE record_name.column_151 THRU record_name.column_300 TO NULL DAS -- David Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.16 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com