Re: calling stored procedures from 4GL

Hi, Ed! I have highlighted the part of stored procedure, which caused the error. If you want to concatenate strings, you should use "|", NOT ",". So the statement shoud be let buf_pattern = '*' | pattern | '*'; Ed Schaefer <olded@ix.netcom.com> wrote in article <5v5bg7$pb@dfw-ixnews6.ix.netcom.com>... > > Greetings: > > Given: > Unix: SCO > Engine: 7.23 Online > 4GL: 6.04 > > I'm new to stored procedures and I'm trying to call a Stored Procedure > from > a 4GL program. I'm trying to call a stored procedure, sp_in_string, > which > checks if a substring is a string. Here's the 4GL stub: ... > > The problem is I'm getting a runtime syntax error: 661 > > The number of variables on the left side of a LET statement does not > match the number of values on the right side. > > CAN ANYONE POINT OUT MY ERROR? Thanks! > > Here's the Stored Procedure. syntax appears correct: > ... > let buf_pattern = '*', pattern, '*'; ^^^^^^^^^^^^^^ here is the evil