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

    Incorrect prompt syntax for string value = ''

    Yes, in the CMC for this prompt I've set Set to NULL value = checked (I've also tried this unchecked) Clear the current parameter value = unchecked Prompt the user = checked
  2. carbona

    Incorrect prompt syntax for string value = ''

    Thanks for the quick response, TurkBear. I'm using MSSQL 2000 and in my stored procedure I specify a null default for the input parameter, incase it doesn't get passed: @promptname VARCHAR(20)= NULL, also I handle an empty string ('') if that gets passed: If @promptname = '' SET...
  3. carbona

    Incorrect prompt syntax for string value = ''

    I have a report in CE that accesses a stored procedure with multiple input parameters. When I try to run the report from eportfolio (activeX viewer), I am forced to enter a value for all NUMBER datatype parameters. However for STRING datatype params, I am not forced to enter a value, but anytime...

Part and Inventory Search

Back
Top