Is it possible to run UPDATE SQL on DB

[pandpp]

Hello,

I am a Crystal person from way back. Not sure about the latest version, but when I looked last time, this wasn't available, in CR at least.

Ultimately we will have access to BO v6.5.3. I have a user asking if it is possible, after (or whilst) running a report, to update a field in a DB?

This would obviously be via some DML.

If I had a system I could check, but I don't. I had a feeling it could be done in BO, but wanted some confirmation.

Thanks,
Peter.

 

[blom0344]

No, the whole idea is to enable users to use read-only queries. But consider what you are proposing.
How can you justify for a user to have update rights on a database?

Ties Blom

 

[pandpp]

Thanks, I suspected this was still the case.

And as to justifcation, VERY simple when the user is a scheduled job resetting a flag that indicates a letter has to be created & sent.

Peter.

 

[blom0344]

Aha, I understand.
Run BO report, print and sent it and then mark this as being handled in the database by throwing a switch.

Used to build small MS Access frontends for such purposes. A little bit daring , but you can go full circle from within there..

Ties Blom

 

[BrianTyler]

It is possible to update using Freehand SQL. In supervisor the restriction on SQL to be 'Select only' must be removed for the user.

I agree with Ties that you must be very careful in allowing this facility to end users.

Brian

 

[blom0344]

Free advice. Don't attempt this!
In the first place you need to know correct syntax and set the proper conditions. Second place you need to actually perform a commit!
You cannot build the SQL from report related data.

If you're really keen to allow a user to perform such actions, then use a tool like WinSQL that lets you update through a grid minimizing the chance that you'll have to correct updates. You can use the autocommit option, so a user will not need to know.

You'll need the developer's edition to perform updates, but the cost is minimal:

http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp

Ties Blom