Boris J. Lipsman

In developing various report systems, I found it necessary to recall the ad hoc query tool (based on a concept by Sean Rhody discussed in SYS-CON Publications' Secrets of the PowerBuilder Masters 5.0). For those of you who haven't read about it I'll take a minute to describe it briefly. Cartesian product n (1958) : a set that is constructed from two given sets and comprises all pairs of elements such that the first element of the pair is from the first set and the second is from the second set (Merriam Webster's Collegiate Dictionary, Tenth Edition) Overview of the Existing System The ad hoc query tool can be described as a tab control that has five tab folders. These folders allow a user to create a report sequentially (including its definition and serialization for certain RDBMSs). Folder 1: Allows users to select columns they would like to include in the report d... (more)

No More Headaches with the Cartesian Product

In developing various report systems, I found it necessary to recall the ad hoc query tool (based on a concept by Sean Rhody discussed in SYS-CON Publications' Secrets of the PowerBuilder Masters 5.0). For those of you who haven't read about it I'll take a minute to describe it briefly. Cartesian product n (1958) : a set that is constructed from two given sets and comprises all pairs of elements such that the first element of the pair is from the first set and the second is from the second set (Merriam Webster's Collegiate Dictionary, Tenth Edition) Overview of the Existing Syste... (more)