TD-23562: Gibberish characters returned fetching ROWID from SQL Server

Post found bugs and possible workarounds.
Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 396
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

TD-23562: Gibberish characters returned fetching ROWID from SQL Server

Post by Dave Rabelink » 30 Aug 2017, 10:32

Article ID: KB6679833
TD-23562: Gibberish characters returned when fetching ROWID (timestamp) from SQL Server

Applies to
Gupta Team Developer (TD) 7.0.2

Summary
When fetching ROWID (timestamp) from SQL Server, gibberish characters are returned.

Workaround
Convert the returning ROWID data to Unicode by using SalStrToWideChar( sInRowId, sOutRowId, ENC_ANSI ).

Cause
The issue occurs because timestamp data type are binary(8) and TD fails to convert the binary data to a Unicode string.
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

Return to “Bug Reports”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests