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
_/_/_/_/_/_/_/_/ _/_/_/_/_/_/ _/ _/ _/_/_/_/_/
_/ _/ _/ _/ _/
_/ _/ _/ _/ _/
_/ _/_/_/_/ _/ _/_/_/_/_/
_/ _/ _/ _/
_/ _/ _/ _/ _/
_/ _/ _/ _/_/_/_/_/
