Results 1 to 5 of 5

Thread: iSQL Stored Procedure

  1. Jul 1st, 2002, 11:58 AM #1
    tbarnette
    Guest

    iSQL Stored Procedure

    OK.. This is not really C++, but... I'm using the answer to help me develop a C++ program (<G>)...

    I'm using iSQL and am having difficulty executing a stored procedure with parameters. Some parameters have spaces (like time/date fields)..

    I thought you did it like this:
    sp <param 1> <param 2> <param 3>
    go

    StoredProcedure TestData 06/05/2002 07:00 PM MoreTestData
    go

    I've tried putting the dates in single quotes, double quotes, pound signs, brackets, etc.... It doesn't like anything I use to enclose the date.

    Any ideas?
    Reply With Quote Reply With Quote
  2. Jul 1st, 2002, 12:07 PM #2
    jim mcnamara
    Guest
    Have you tried # to enclose the dates?
    Reply With Quote Reply With Quote
  3. Jul 1st, 2002, 12:27 PM #3
    tbarnette
    Guest
    Yep, that didn't work either...... I'm losing my mind.... aaaaaaaaaaa
    Reply With Quote Reply With Quote
  4. Jul 1st, 2002, 12:42 PM #4
    tbarnette
    Guest
    Yep, that didn't work either...... I'm losing my mind.... aaaaaaaaaaa
    Reply With Quote Reply With Quote
  6. Jul 16th, 2002, 08:08 AM #5
    tbarnette
    Guest
    OK... Here's the deal... This is ODBC pointing to SYBASE. In order to fix it, I had to go into the Initialization string on the Advanced settings tab of the ODBC driver and type "SET ANSINULL OFF".

    That cleaned it up.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width