[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 140
  • Last Modified:

ODBC Problem with Oracle

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
navgup
Asked:
navgup
  • 2
  • 2
1 Solution
 
HemanthaKumarCommented:
Instead of using execute status. Use row status

status% = odbcResultSet.GetRowStatus

~Hemanth
0
 
navgupAuthor Commented:
What advantage that is going to buy me ? Is it more reliable ?

Thanks !
0
 
HemanthaKumarCommented:
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
 
navgupAuthor Commented:
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now