Re: hyperscript tool

adel@q8petroleum.com.kw (Adel Al-jouhar) writes: >what the maximum sql statment you can write it >in script language..!! I've not found any limits (but can research it if needed), provided you are using arrays to specify the selects. If you are using simple strings, however, there is a limit of 256 characters, the same as the maximum length of any single variable. So, try formating the data like: DECLARE IMMEDIATE CURSOR "foo_curs" FOR "SELECT lname, fname", <- The comma says this is an array type " FROM customer", " ORDER BY 1,2" Instead of DECLARE ........ "SELECT lname, fname " & <- Note ampersands concatenate strings " FROM..... If you declare as an array, the only limit HST will place is that you have no more than 32,768 lines of code per single SQL statement. I think that's pretty reasonable, actually. ;-> Cheers, David David Coburn coburn@informix.com Informix Software, Inc. ...uunet!infmx!coburn ========================================================================= Any opinions expressed here are not necessarily those of Informix (or for that matter, anybody else). =========================================================================