?
Solved

ODBC Problem with Oracle

Posted on 2003-03-10
4
Medium Priority
?
139 Views
Last Modified: 2013-12-18
Has anyone encountered or heard of a problem with

returncode% = result.Execute

returning True instead of False even though the table has not been updated with the information it needs to update.

Thanks !
0
Comment
Question by:navgup
[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
4 Comments
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 8104447
Instead of using execute status. Use row status

status% = odbcResultSet.GetRowStatus

~Hemanth
0
 

Author Comment

by:navgup
ID: 8104705
What advantage that is going to buy me ? Is it more reliable ?

Thanks !
0
 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 150 total points
ID: 8105207
Yes it is.

Execute status will tell you whether the execution of the SQL Statement was success/failure. Bu if you want to know if the row is changed/updated then you use this.
0
 

Author Comment

by:navgup
ID: 8106162
Can i use both in the same piece of script one after another ? Something like -

returncode% = result.Execute
if returncode = True then
status% = odbcResultSet.GetRowStatus
Select Case status
Case DB_Updated :
Msgbox "Row Updated"
Case DB_Unchanged :
Msgbox "Row Unchanged"
.
End Select
endif
etc



0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

770 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