Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ixnay5

  1. ixnay5

    radio button reset not working

    thx cLFlaVA.
  2. ixnay5

    radio button reset not working

    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"...
  3. ixnay5

    why is this happening?

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

    why is this happening?

    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...
  5. ixnay5

    why is this happening?

    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...
  6. ixnay5

    why is this happening?

    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.
  7. ixnay5

    why is this happening?

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

    why is this happening?

    myord is defined as: define myord char(10)
  9. ixnay5

    why is this happening?

    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...
  10. ixnay5

    why is this happening?

    --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...
  11. ixnay5

    using a 4gl variable in a sql &quot;like&quot; statement

    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!
  12. ixnay5

    using a 4gl variable in a sql &quot;like&quot; statement

    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...
  13. ixnay5

    using a 4gl variable in a sql &quot;like&quot; statement

    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)...
  14. ixnay5

    using a 4gl variable in a sql &quot;like&quot; statement

    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...
  15. ixnay5

    validate numeric

    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...
See more

Part and Inventory Search

Back
Top