SQL Insert, Update and Delete

[rsnell]

Not sure whether this is something on the road map for Valence, or whether it's technically possible, but it would be great if there was some way of running SQL statements to insert, update or delete records from files. Maybe it could be implemented in a similar way to running scripts. While I realize that this can be achieved using RPG, it would be more convenient to be able to run an SQL statement rather than create a new RPG program. It also helps to reduce the reliance on RPG skills.

[robert.swanson]

Is the core Edit Grid functionality, which can already handle inserts, updates and deletes without RPG, not sufficient?

[rsnell]

No, it's not. Invariably, I find I'm using forms for adds and updates with associated RPG programs. Plus I may want to add records to an audit file as records are added, updated or deleted. The update grid is fine for very simplistic file maintenance, but limited if you want to do anything beyond very simple file transactions.

[robert.swanson]

Okay, after some discussion, we've added this to the wishlist for a future release.

[rsnell]

That's great. Thanks