Re: PREPARED Statement use in Query Browser (BUG?)

[Donald West]

Hi Willian

The problem is not with user defined variables in the Query Browser. You can get around that by using Transactions as I did in my example code ie, START TRANSACTION; and COMMIT; or you can use the buttons on the toolbar on top of the screen.

The problem is in using variables in the LIMIT with the use of PREPARE. If this also does not work in the Query Browser, perhaps there is a workaround as there is with user defined variable usage. Or if not, do you have any suggestions as to how to accomplish the equivalent of using a LIMIT with a variable number of rows?

Thanks,
Don