by There's a bug in Visual Interdev that affects
saving or creating stored procedures.
The problem is that stored procedures that get
created fine in ISQL generate ODBC errors in
Visual Interdev (this really seems to be an ODBC
bug since the error message says ODBC and the
exact same behavior can be found in MS Access 97).
The answer is in the quotes:
Create Procedure test
As
print "this doesn't work"
return (0)
Create Procedure test
As
print ' but this does work!'
return (0)
ODBC doesn't like double quotes on the outside:
Create Procedure test
As
print ' "this" does work too!'
return (0)
And if you need a single quote just double it to
escape - use:
Create Procedure test
As
print ' this ain''t no problem neither!'
return (0)
enjoy the interdev - I think its great but man was
this bugging me.
aaron goldman