On 20 Apr 2001, at 11:04, Tom Grimshaw wrote:
> Now this may seem fundamental to most of
> you so I apologise for wasting space,
> but if it save anybody 10% of the frustration
> it has caused me it's worth it.
Tom,
Appreciate your grace. Every heads up is a big help!
Ben Petersen
> G'day,
>
> I have been arm wrestling with a couple of problems for far longer than
> I thought I should so it's a REAL pleasure to be able to report the death
> and destruction of a couple of bugs in my code, despite the pain of
> knowing it was my fault. But then again, I'm the programmer. It is
> always my fault. <g>
>
> I had some code that gave users the opportunity of selecting a column
> directly from the SYS_COLUMNS table:
>
> LABEL SSAddCol
> CLS
> MAXIMIZE
> SET VAR vLine1 TEXT = +
> ('This is a list of columns in the table ' + .vTableName)
> WRITE .vLine1 AT 1,11
> WRITE 'To sift the data in this table click on one of the' AT 2,11
> WRITE 'columns and on the next screen choose how to sift' AT 3,11
> WRITE 'or filter the records on that column.' AT 4,11
> SET VAR vColName TEXT = NULL
> CHOOSE vColName +
> FROM #VALUES +
> FOR (LJS(sys_comment,50) & LJS(sys_column_name,20)),sys_column_name +
> FROM sys_columns +
> WHERE sys_table_id = .vSysTableID +
> ORDER BY sys_comment +
> AT 12,10 +
> TITLE 'Column Descriptions and Names' +
> CAPTION 'Click a column to sift on or press [Esc] when done' +
> LINES 20 +
> FORMATTED
> CLS
> MINIMIZE
>
> Sometimes it would work, other times it would bum out. Sometimes I would
> get an
> error message and sometimes not. The error message was not specific
> enough for
> me to trace the source of the bug but I cognited after a recent post that I
> should
> maybe set the variables required by views (even though I have taken Bill's
> advice
> and all variables in view definitions are enclosed in parenthesis) .
>
> I did that and it did not solve the problem (interestingly enough the CHOOSE
> took FAR longer to display by setting the var first) BUT it did give me a
> different
> error message - I had a permanent view based on a temporary table that was not
> defined. I deleted the view and voila! No more crashes!
>
> Now this may seem fundamental to most of you so I apologise for wasting space,
> but if it save anybody 10% of the frustration it has caused me it's worth it.
>
>
> Warmest regards,
>
>
> Tom Grimshaw
> coy: Just For You Software
> tel: 61 (0)2 9552 3311
> fax: 61 (0)2 9566 2164
> email: [EMAIL PROTECTED]
> mobile: 0414 675 903
> street: 3/66 Wentworth Park Rd Glebe NSW 2037
> post: PO Box 470 Glebe NSW 2037 Australia
>
> _/_/_/_/_/_/_/_/ _/_/_/_/_/_/ _/ _/ _/_/_/_/_/
> _/ _/ _/ _/ _/
> _/ _/ _/ _/ _/
> _/ _/_/_/_/ _/ _/_/_/_/_/
> _/ _/ _/ _/
> _/ _/ _/ _/ _/
> _/ _/ _/ _/_/_/_/_/
>
>
