Subject Re: Stored Procedure From Mervyn Bick <invalid@invalid.invalid> Date Sat, 14 Jul 2018 11:23:10 +0200 Newsgroups dbase.getting-started On 2018-07-09 1:50 PM, vari wrote: > Thanks Jaime, > > I tried but not work and the error message is "table does not exist" > As Jaime has pointed out this points to a possible problem in your stored procedure. What does the stored procedure do and what table is it accessing? Is the SP written so that it accepts parameters?  It would help if you showed us the SP code. You are using dBASE 2.21 but what version of Firebird are you working with? Are you accessing Firebird from a server over a network or is Firebird installed on your computer? What version of Windows are you using? Is the Firebird example database employee.fdb installed and do you have a BDE database alias for this database? If Firebird is installed on your computer, for 64-bit Windows you should find the example database for Firebird 2.5 at C:\Program Files (x86)\Firebird\Firebird_2_5\examples\empbuild and for 32-bit Windows it should be at C:\Program Files\Firebird\Firebird_2_5\examples\empbuild What SQL manager are you using.  FlameRobin, IBExpert or EMS SQL manager for Firebird? If you execute the SP in the SQL manager does it return the rows you expect? You will always be able to find help in these newsgroups but remember, the more background you give, the better the help that you will receive. If you have access to the Firebird example database it will be possible to give working examples of code on how to solve a problem.  You will then be able to apply the code to your own tables. Mervyn.