Hello,

I am using Delphi3.02, BDE 5.01 and the new Sql Links(for Sql 7.0)
ditributed by Inprise and are still having problems with Stored Procedures.

In Design Time we do not have any problem reading the Stored Procedures, we
see all the names with the ';1' suffix

Example :dbo.storedprocedurename;1

In RunTime we get the message thea the Stored Procedure was not found with
the name above; If we define the name without the ';1' suffix , everything
works fine!

Why this happens?

Regards,

Leonardo

This should have been directed to the SQL 7 field test newsgroup, but I'll
answer it anyway.  It is a Microsoft bug they have told us they would fix.
You'd have to ask them for the timeframe.  For now, get rid of the ;1
suffix.

;1 is the Stored Procedure group info. and is a valid syntax. MS broke this in
SQL 7. Try the
same Stored Proc in 6.5 and it will work. It a known MS bug. Contact MS.

T.Ramesh.

Leonardo Borges de Morais wrote: