Paul RobertsBio

146 messages in this archive (135 questions asked, 11 answers given) — 1995-03-19 00:10:03 to 1995-03-19 00:10:03

Threads

• SQL -
• Re: Temp Calendar Table
• Manipulating Interval Datatypes
• Re: NULL computed field
• Simple(?) 4gl question
• Converting between INTERVAL types
• Accessing Temp Tables
• simple but long 4gl question
• numeric sorting on a char field
• Re: Right justify
• datetime query question (2 messages)
• Is there a slick and efficient way to do this query?
• Re: Report Question
• Re: How to show Null expression in SQL query ?
• Re: Informix SQL help needed
• Re: TOP 100 in SQL
• Re: sql syntax
• Re: Query-Question with 4Y2M
• Re: Incrementing a character
• Re: NEED SQL HELP PLEASE, SELECT DISTINCT QUESTION
• Re: Find a duplicate value via SQL
• Re: sql select
• Re: Sorting strings
• Re: datetime conversion help
• Re: Substrings in Informix SQL
• Re: SQL query - help please
• Re: Puzzled by SQL...........can you help
• Re: Group by half-hour intervals?
• Re: SQL query
• Re: Help with SQL/report
• Re: Temporary table and virtual column
• Re: Characteristic functions with Informix?
• Re: ace report?
• Re: Variable Page Lengths in 4GL report
• Re: Problem with performance!
• Re: BOOK's talk about informix 4gl
• Re: ACE report question.
• Re: Multiple queries into a single temp table
• Re: Session Id for program
• Re: Session Id for program
• Re: UPDATE statement...
• Re: Small SQL Puzzle
• Re: Performance question
• SQL puzzle (for entertainment only)
• Re: Umm, almost embarrassed to ask this, but....
• Re: hello world in 4GL
• Re: SQL Doubt
• Re: trouble with exclusionary SQL query
• 4GL - confused about update cursors, transactions, "with hold" and best way to carry out a specific task
• Re: ACE Report Calculation Using DATETIME Type
• Re: dbaccess format question
• Re: Structure of ACE report for totalling
• Re: Code generator
• Why does fgl_drawbox() draw a box made out of "x"s, "q"s, etc?
• Re: SQL query re unions and nulls
• Re: Handling INTERVAL datatypes
• Re: Query question
• Re: Convert Char to Num
• Re: Reading a file with 4GL
• Re: How do I get the median value ?
• Re: Debit / Credit SQL Output - and a new puzzle
• Re: how do i do an ORDER BY with caseinsensitivity?
• Re: SQL count question
• Re: Debit / Credit SQL Output
• Re: Year 2000 is NOT a leap year
• Re: select null ?
• Re: Query for Days Between Dates in Records
• 4GL: any upper limit on what a function can return?
• Re: US- Permanent Employability in Informix
• Re: ACE report advice?
• Re: Divide by zero
• To go from a datetime to an integer number of seconds...
• Re: Date calculation functions : Informix bug?
• Re: SQL question ...
• logic puzzle / 4gl report challenge
• Re: page 1 of x in 4gl reports ???
• Re: DBMONEY values for the world's currencies - anyone have a list?
• DBMONEY values for the world's currencies - anyone have a list?
• Re: -113 ISAM error: - the file is locked (fwd)
• Re: Converting integer column from XXXXXN to XXXXXNN
• Re: Finding missing integers
• Re: Finding missing integers
• Re: Help New User!!
• Re: Problems with DBMONEY or with comma and period
• Re: SQL Question???
• Re: SQL Question???
• Re: Help: Flexible SQL SELECT !!
• Re: sql - first 10 records
• Re: FOREACH syntax error
• How to print graphs in reports?
• Re: Comparing two sets? (challenge!)
• Re: ACE Reports
• Re: Help: update multiply columns in table
• Re: Minus function in Informix/SQL - How?
• Re: Tricky ACE report problem
• Re: Tricky ACE report problem
• This outer join thingy...
• Re: Set an environment variable from within a 4GL program?
• Re: Passing Information from 4ge's?
• Set an environment variable from within a 4GL program?
• Re: CREATE TEMP TABLE LIKE mytable.*
• Re: Things that are hard to do in SQL (datamining?)
• Things that are hard to do in SQL (datamining?)
• Re: DUPLICATE KEYS
• Re: Page Headers in ACE report
• Re: AAAAAAAAAARRRRRRRRRRRGGGGGGGGHHHHHH!
• Re: Unify to Informix conversion
• Re: Names matching
• Re: ACE code question
• Re: missing master records
• Re: table description
• Re: Group by weekday
• Re: Need Function to calculate valid workhours
• Multiple "instances" of a report, all going at once?
• Re: Another Informix programming snag....Need help, please :-)
• Re: 4gl writing to a pure text file
• Re: ACE Report Question (name, books, phone number)
• Re: ACE Report Question
• Re: del dup recs
• Re: del dup recs
• Re: del dup recs
• Re: Date comparison in SQL
• Re: 4GL Newbie: How to do file I/O in 4GL. Create output to file
• Re: Inconsequences in SELECT/ORDER BY
• Re: Puzzler: Finding median value with SQL?
• Re: Ada/Same
• Re: Sacego Sorting Problem
• Re: INTO TEMP clause
• Re: anybody user STORM
• Re: Matrix Reports
• Re: Daily SQL quiz - revisited
• Re: Zipcode database
• Re: problems using subscripts
• Re: Jonathan Leffler; Advice on-line
• Re: A month of beating a dead horse.
• What is 'Database Mining'
• Re: Date Trivia
• Re: Catching output from RUN command (4GL)
• Re: conditional select sum() based on field question
• Re: command line isql row size
• Re: Delimiters again
• Re: SQL query question
• Re: SQL query question
• Re: Table lookup function in isql?
• Re: Table lookup function in isql?