All the more reason to select the data from the sys tables into tables of
your own design. then use that data to drive app. I never rely on sys table
working beyond simple select to populate other tables.
-- Dennis McGrath
mailto:[EMAIL PROTECTED]
-- Productivity Tools for R:Base Programmers
http://www.enteract.com/~mcgrath/dennis
-- Full time consultant with:
SQL Resources Group
Steve Hartmann
Oak Park, IL
mailto:[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Tom Grimshaw
Sent: Thursday, April 19, 2001 8:04 PM
To: [EMAIL PROTECTED]
Subject: HAD A WIN!!
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
_/_/_/_/_/_/_/_/ _/_/_/_/_/_/ _/ _/ _/_/_/_/_/
_/ _/ _/ _/ _/
_/ _/ _/ _/ _/
_/ _/_/_/_/ _/ _/_/_/_/_/
_/ _/ _/ _/
_/ _/ _/ _/ _/
_/ _/ _/ _/_/_/_/_/
