Using Trace, the coding below results in the error - "Break in file
EditOrd.rmd at line 116 for - ERROR- Invalid INTEGER value (2418)" . The
"IF vcols =....." line is line 117. Line 116, the error line, is a blank
line. Vcols is, at the point where the error occurs, an integer data type.
--Select a column to identify the order to edit
CHOOSE vcols FROM #VALUES FOR sys_comment, sys_column_id FROM sys_columns +
WHERE sys_table_id = .vtblid AT 10 CENTER TITLE 'Press [Enter] or Click to
select or [Esc] to exit.' CAPTION 'Select The Search Field'
SET VAR vcols INT = .vcols
*(other coding)
IF vcols = sys_column_id IN sys_columns WHERE sys_column_name = 'ordbudgt'
THEN
SET VAR vsearch CURRENCY = NULL
ENDIF
DIALOG .vdia vsearch veky 1 CAPTION 'Define your search'
Once I get this error problem resolved, IF, ELSE, ENDIFs will be added
after the CURRENCY condition to set vsearch to INTEGER, DATE, INTEGER data
types depending on the data type of other vcols (orditem - INTEGER, ordcom -
DATE, and conid - INTEGER), .
Maybe I can't see the forest for the trees, but I can't see what can be
going wrong. Can anyone help?
Thanks
J. Andrus
