MySQL (ODBC) and PROP:SQL

21

That’s what I’m thinking as well. Stored procedures would be the optimal solution really and easier to maintain

22

I don’t use stored procedures for 2 reasons:

  1. I like to have all the code visible where I work, so it’s easy (for me) to find any problem. I don’t use Clarion IDE for CLW but UltraEdit.
  2. I use similar code for many tables and different conditions, for example, sometimes I have different order, different conditions (WHERE …) etc. It is too complicated to write so many procedure parameters.
23

But, it seems you have it declared in text strings, buried within your hand-written code … Debugging must be incredibly difficult !

1 Like