Updating database from Infoview does not work

[evdhout]

Hello,

I want to update some fields in an Oracle database when printing a Crystal Report. I did the following :

1. Database expert
2. Create New Connection
3. Oracle Server
4. 'Add Command'

I entered the following SQL command :

UPDATE CUS_LOC
SET NAME = 'B'
WHERE NAME = 'A'

When I execute the report from Crystal Reports XI Release 2 (version 11.5.3.417) this works fine. However, when I save the report to Infoview the database is not updated after the report.

Does anyone know why this is not working?

Thanks.

 

[SantaMufasa]

evdhout,

I do not see a COMMIT command anywhere in your code. If you do not commit, then none of the changes take effect.

Please advise.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]