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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. chrismcaniff

    Pervasive 9.5 Stored Procedure with Date Parameter

    Hi, Trying to create stored procedure with a date parameter. call sp_aginginvoice ('2008-10-15'); appears to run correctly but when I query the view created I get an expression error. I have narrrowed error down to datediff :input clause If I substitute :input for ('2008-10-15') in the...
  2. chrismcaniff

    Parameter with Multi Numeric Range

    Hi, I am trying to make a paramter with following choices Category Range Parameter Mens (cat number in inventory.cat table is 0 to 9) Womens(cat number in ineventory.cat table is 10 to 19) Kid's (cat in inventory.cat is 20 to 29) Main categories (Men's, Women's, etc) have no link to the...
  3. chrismcaniff

    Record Selection based on parameter

    Hi, I have a parameter with these choices Dept 1 Dept 2 Dept 3 If user selects Dept 1, then I want the record selection to only show items in Category 000 to 250. If selects Dept 2, then only show items in Category ranging from 251 to 500. Category is a String field in the database...
  4. chrismcaniff

    SQL Query to create view

    Hi, I have one table called comments that looks like this recordno lineno comment 100 1 Joe Smith 100 2 Room 408 I cannot modify this table but would like to create a view which looks like this: recordno guestname roomno 100 Joe Smith Room...

Part and Inventory Search

Back
Top