Devart Forums

This isn't working:

Connection := TMyConnection.Create(nil);
Connection.ConnectString := DBConnect;
SP := TMyStoredProc.Create(nil);
SP.Connection := Connection;
SP.Active := False;
SP.StoredProcName := 'GetTest';
SP.PrepareSQL;
SP.ParamByName('menge1').Value := 1;
SP.ExecProc;

ParamByName is causing an exception "Param not found".

found the problem. no capital letters in the procedure name. everything in lowercase.

It is good to see that the problem has been solved.
Feel free to contact us if you have any further questions about our products.

It is a problem with the privileges. What kind of calls does this "PrepareSql" call?
What schema or table do you access? I have to grant global "select" privileges.

When calling the TMyStoredProc.PrepareSQL method, a query to MySQL system tables is executed: for MySQL server versions lower than 5.0.4 - to the mysql.proc table, otherwise - to INFORMATION_SCHEMA.ROUTINES.