Recent content by ixnay5

thx cLFlaVA.

hi - i have a reset button with an onclickto reset some radio buttons. the radio buttons will not reset, but the other lines in the reset function definition execute correctly. what the heck am i doing wrong? here's the html for the reset button: <input type="button" name="fromresetbutton"...

p.s. if you live in the San Diego area, i'd like to buy you a beer! thanks again for all your help!

hey ed, looks like it's working. besides than building the variable string the way you've suggested all along, the only other thing done differently was to define the variables as varchar, like this: define myord varchar(10) define mysono varchar(10) build up the variable...

ok so doing it this way (below) solves passing a literal string into the variable: display mysono let myord = "" let myord = mysono display myord insert into tmpship select indoc,apart,inlots,cpart,serln from inbos where indoc...

thanks again ed, the compile error has gone away, but building the matches string as prescribed just the literal string "*sono*" into the myord variable, not the value.

there's only one schema needed: table inbos Column name Type Nulls cpart char(16) no serln char(18) no apart char(16)...

myord is defined as: define myord char(10)

thx ed. i can tell you this. if i remove these lines: let myord = "" let myord = ord.sono the line immediately above them: display ord.sono ...successfully displays the value of ord.sono at run time, telling me that table sonos gets good data. i don't understand...

--begin create order record define ord record sono char(10) end record --end create order record --begin selecting orders display "Selecting Orders..." insert into sonos select distinct(sono) from sodetl where soladat > p_yest and sono[5,5] not in ('E','M','N') and sono[4,4] not in...

thx ed. i found out you can build it into a cursor statement and it will work. but if try to use it in a SQL statement contained in a foreach cursor loop, it won't. still having trouble doing wildcard matches in SQL statements in foreach cursor loops tho... thanks again for all your help!

thx ed. i tried that and some other variations with no luck. turns out the value i'm feeding into the variable is coming out of the table with some leading spaces which need to be removed. it's char(10) but we're storing values with 6 or 8 meaningful chars. i thought CLIPPED would take care...

hi ed - it looks like you've assigned a literal (with wildcards) to myvar. in my case, i have to use a 4gl variable that is part of a previously defined record, and the whole thing is in a cursor loop. would this be different? here's how it goes: define dat record indoc char(10)...

hi - is there special syntax for handling a wildcard search if the value i'm matching on is a 4gl variable? the basic statement is: select something from somewhere where something like my.value something could be a large field and my.value could be anywhere in it. so i tried: select...

i just pulled the isNAN(q) from the function and put this: function tst_qty(fieldobj) { //if the value entered isn't acceptable, bail out var v = parseFloat(fieldobj.value); if (isNaN(v)) { errors = "Please enter a number"; alert(errors); return false; } return true; } as an...