Search results for query: *

I am using Version 9.5 I get the Invalid Argument Error when I use Date instead of Char or VarChar as the Stored Procedure Parameter This is why I changed the Stored Procedure Parameter to text and then convert it to date in the Procedure This appears to work fine, the stored procedure...

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

Okay I resolved my above error message by adding a Default statement after the last case which got rid of the error message One last problem is I just realized my inventory.catno is a string field and not a numeric field as I originally thought. So above formula by LB doesn't work since it is...

Okay I got rid of the above error message in my post by setting my string Category Parameter to Allow Multiple Values: True Other Category Parameter options are - Allow Custom Values: False - Allow Discrete Values: True - Allow Range Values: Fales I now get an error "the word else is missing"...

Hi, I am using Crystal XI with ODBC RDO connection Having trouble with the parameter selection formula I want to be able to select any combination of Men, Women, Kid's and have the formula select the corresponding numberic category in the inventory table. I did make a string parameter with...

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

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

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