by pbakker » Fri Apr 15, 2005 8:45 am
Servoy doesn't support custom update queries, due to the fact that servoy does datachange braodcasting.
When you would be able to run any custom update query yourself, the cached data would become updated, 'causing who know what kind of trouble.
First option would be: Try using the FoundSet updater (look under the DatabaseManager node). This allows updating multiple records at the same time.
If that doesn't work for you, I guess you have to loop through the records yourself.
Running updates from DB Stored Procedures is the third option. Then you have to take care of refreshing cached data yourself after executing the SP. But, I guess you say mySQL 4.x doesn't support running updates from SP's? mySQL 4.x is not my cup of tea, so I wouldn't know.
A fourth option would be building a plugin to get a connection to the database and perform the update over that. Still then you have to take care of the cached data refresh in Servoy.
Hope this gives you some ideas of the options available.
Paul