I have a Crystal Report with a Command that pulls the data from MS SQL server. I need to update a field if the value is 0. Can I put my update sql statement in a formula field to update the database?
Database: MS SQL Server
Update statement:
UPDATE TEST.dbo.TRACK
SET @maxtrack = @maxtrack+1 , TrackingNumber = @maxtrack
where JobNumber = '40734C'
and TrackingNumber = '0'