Get Error Messages BSFN

[jdebill]

Hi all,

I've been searching without success for a BSFN that will get the message text associated to an error message number. I'm sure there is one out there but I just haven't hit on the right "magic" combination of words.
Can anyone help?



Thank You,
Bill
Windows NT, SQL 7, XE 17.0

 

[Zoltan_Gyimesi]

Hi Bill,

Use the B9200002 Retrieve Data Dictionary Alpha Desc business function. The usage of it do not requires any explanation.

Other solution could be to FetchSingle it from the F9203 Data Item Alpha Descriptons table. This way you can retrieve the Language Override variant too, using the current language based on the SL LanguagePreference system literal.

Hope, could be a bit of help.

Regards,

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[jdebill]

Zoltan,
Thanks for the info, it worked great. The BSFN name does make perfect sense once you see it, although I sure couldn't guess close enough to "find it".



Thank You,
Bill
Windows NT, SQL 7, XE 17.0