|
Home > Archive > SQL Anywhere database > December 2005 > sqlcode after update
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
sqlcode after update
|
|
| Ian Brouwer 2005-12-27, 11:23 am |
| Hi,
It looks like that the returned sqlcode after an update SQL-command with no
satisfying rows differs. Should it return 100 ? -1 ?.
It seems not to be consistent, does it have to do with ODBC-settings /
country related issues (Italy) ?
We're using ASA 8.03.
Anybody out there having the same experiences ?
Ian
| |
| Greg Fenton 2005-12-27, 1:23 pm |
| Ian Brouwer wrote:
>
> It looks like that the returned sqlcode after an update SQL-command with no
> satisfying rows differs. Should it return 100 ? -1 ?.
Can you show us the code where you are getting different SQLCODEs?
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| Rob Waywell 2005-12-27, 8:23 pm |
| What SQLCode values are you getting returned?
There is no SQLCode value of -1.
ASA Error Messages
Database Error Messages
Error messages indexed by Adaptive Server Anywhere SQLCODE
--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional
Sybase's iAnywhere Solutions
Please respond ONLY to newsgroup
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
"Ian Brouwer" <i_bNOrouwSPAMer@tsd.nl> wrote in message
news:43b16749$1@foru
ms-1-dub...
> Hi,
>
> It looks like that the returned sqlcode after an update SQL-command with
> no satisfying rows differs. Should it return 100 ? -1 ?.
> It seems not to be consistent, does it have to do with ODBC-settings /
> country related issues (Italy) ?
> We're using ASA 8.03.
> Anybody out there having the same experiences ?
>
> Ian
>
>
| |
| Pavel Karady 2005-12-28, 7:23 am |
| The SQLCODE 100 for UPDATE statement is returned when UPDATE performed
successful, but no row was updated. If at least one row was successfully
updated, SQLCODE is 0.
Pavel
"Ian Brouwer" <i_bNOrouwSPAMer@tsd.nl> wrote in message
news:43b16749$1@foru
ms-1-dub...
> Hi,
>
> It looks like that the returned sqlcode after an update SQL-command with
> no satisfying rows differs. Should it return 100 ? -1 ?.
> It seems not to be consistent, does it have to do with ODBC-settings /
> country related issues (Italy) ?
> We're using ASA 8.03.
> Anybody out there having the same experiences ?
>
> Ian
>
>
|
|
|
|
|