Skip to Content
0
Jan 26, 2022 at 02:55 AM

Update sql statement

380 Views

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'