Using Datamaker to publish a subset on Sybase ASE, a test was performed. It encountered an error regarding foreign keys.
If there is an error when publishing the data, the standard internal procedure is to perform a rollback. When evaluating the resulting rollback command, the delete command is malformed.
Datamaker wrong command line:
DELETE FROM dbo.TbPessoaSobAnalise WHERE [CdPessoaSobAnalise] = '242060179'
ASE Valid command Line:
DELETE FROM dbo.TbPessoaSobAnalise WHERE [CdPessoaSobAnalise] = 242060179
It is putting single quotation marks on the field, but it is a numeric field which does not require single quotes. Why?