Informix ISQL and report ranges (user input)

> I've JUST purchased ISQL and everything looks straight forward enough. > However it's not clear to me how one goes about getting it set up so that the > end user can specify begin and end ranges for a report. > > For example, suppose I set up a report for line items using > a table of all line items. But I want the user to be able to put in > begin and end dates so that only a subset of rows are reported. What > should I > do. I can't easily see how to do this from the manual. But surely the > facility is there... > > Thanks, > > Kate My manuals all got confusing at version 5. I keep the Informix SQL Reference Manual v4.00 still because I can't find where the new manuals talk about ACE reports. You should see if you can get this book. It is officially: Informix-SQL Reference Manual Version 4.0 March 1990 Part No. 000-7042 The format for specifying a date range in an SQL form is earlier_date:later_date and the query assumes that if an odd number of colons appear in the statement that the middle one is a range separator. An alternate form is: earlier_date..later_date which may be used only on DATETIME and INTERVAL types to avoid confusion over the colons. This from page 4-37 of the above book, under "Query Operator Syntax". I saw several other posts, but none that gave quite this answer, so FWIW, here 'tis. (I haven't made a thorough check of the v7 books for this info yet, they may have put the Report and Perform stuff back in. There were some format changes made, but I'm not sure about content.) Good luck, __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|