?
Solved

Sybase sqldbcode values

Posted on 2010-08-17
5
Medium Priority
?
3,366 Views
Last Modified: 2013-12-26
Can anyone guide me to all the sqldbcode values returned from the Sybase server? I need to code for those values in pfc - dberror event - so that I can display some meaningful errors to the users.
0
Comment
Question by:4Learning
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 18

Expert Comment

by:diasroshan
ID: 33462108
0
 

Author Comment

by:4Learning
ID: 33512299
Thankyou diasroshan, but my original question was asking about sqldbcodes and NOT sqlcodes. So the link really does not help.
I need to quote in my script the action to be taken on  certain sqldbcodes values - this happens when sqlcode is negative.
And since sqldbcode is vendor specific, the error codes from one vendor will be different from another.
Hope someone is able to help me out with this.
 
Thanks,
 




 
0
 
LVL 18

Accepted Solution

by:
diasroshan earned 1000 total points
ID: 33518946
Hi,

As far as i understand, the above 2 links shud serve your purpose, since ur looking specific for Sybase Database.
SQLCodes in the Sybase link are same as the sqldbcodes of PB. But vendor specific. Oracle will have it different.

ill put the screenshots from both the links to illustrate my point.

For eg.
Powebuilder sqldbcode = -195
As per Sybase -195 is ---> "Column '%1' in table '%2' cannot be NULL"

If u are still facing problems, give me an example of error u want to trap and ill explain with these 2 links.

Cheers,
Rosh
DBError.JPG
SybaseErrorCode.JPG
0
 
LVL 14

Assisted Solution

by:sandeep_patel
sandeep_patel earned 1000 total points
ID: 33611948
0
 

Author Comment

by:4Learning
ID: 33628473
Thanks diasroshan for the info. I didnt know that in case of Sybase, the sqlcode and sqldbcode values are the same.

Thanks also to sandeep_patel for the link.

Regards,
4Learning
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into. One of these problems is selecting and deleti…
Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
Suggested Courses
Course of the Month13 days, 18 hours left to enroll

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question