StoredProc component not optimised for certain SQL dialects
Brought to you by:
ttm
Menu
▾
▴
#9 StoredProc component not optimised for certain SQL dialects
The current StoredProcedure component is not optimised for non Interbase components. The default builder function generates syntax "select * from procedurename()" which will not wall in Microsoft SQL server database "EXECUTE procedurename()" or MySQL "CALL procedurename()"
Other cases may exist for other database platforms. Other databases may support the existing syntax.
The component needs to be modified so that the command string builder function takes into account the name of the database driver and adapts accordingly.
Note the IBStoredProc and StoredProc components use identical build() functions.
