MSS U5.0 driver producing a CAST error | Bugs, Issues and Errors | Forum

Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

—  Results per page  —








— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters
For a group of consecutive words like 'end of support' use Match phrase

sp_Feed Topic RSS sp_TopicIcon
MSS U5.0 driver producing a CAST error
01 Aug 2017
10:15 am
Avatar
PaoloLovati
Member
Forum Posts: 13
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Hi all,

a table has its primary key defined as numeric so it has NOT NULL in the database.

The key has to be filled by a db SEQUENCE, so it is left empty in the component.

When the WRITE applies the MSS drivers tries to store spaces instead of NULL in the field, producing a CAST error.

The ORA driver handles this correctly.

It looks like a bug (BUG 29424) solved for DB2 driver…

 

Uniface : [MSW] 9.6.08.02, X801

SQLServer System Information :
————————————————
Driver : sqlncli11.dll 11.00.3000
ODBC Version : 03.80.0000
Driver ODBC Version : 03.80

SQLServer2 Database Information :
————————————————
DBMS name : Microsoft SQL Server
DBMS Version : 11.00.3156

 

Thanks for any reply.

Paolo

15 Aug 2017
9:52 am
Avatar
rogerw
Member
Forum Posts: 228
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Hi,

do you execute your SEQUENCE in the write-trigger before write?
If thats your scenario, then the trick is to set the length of the field to 0, eg.
Syntax: NED,NPR,LEN(0-0)

or as it works, you will probably set the syntax to
Syntax: HID,LEN(0-0)

Regards RogerW.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 131

Currently Online:
19 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

ulrich-merkel: 1677

Iain Sharp: 596

Theo Neeskens: 333

gianni: 237

rogerw: 228

lalitpct: 195

istiller: 191

-GHAN-: 171

Knut: 168

sochaz: 165

Member Stats:

Guest Posters: 3

Members: 4727

Moderators: 0

Admins: 8

Forum Stats:

Groups: 1

Forums: 62

Topics: 1980

Posts: 8555

Newest Members:

RonnieArror, MashaEcs, CeccilCet, etcuvuqe, TotaluTwino, ueemporuveson, Kvas, Ernestastor, Roxbo, Aliafah

Administrators: admin: 23, Adrian Gosbell: 268, diseli: 786, Bob Maier: 2, Nico Peereboom: 58, Michael Rabone: 4, richiet: 406, JanCees: 25