Vb6 row cannot be located for updating

Hi guys, I am using VB6 SP5, ADO 2.8 and SAPDB I have a table as follows CREATE TABLE "DBA"."TBL_USERS" ( "USERID" Integer NOT NULL, "LOGONID" Varchar (20) ASCII NOT NULL, "USERNAME" Varchar (30) ASCII, "USERSURNAME" Varchar (30) ASCII, "LASTLOGGEDIN" Timestamp, "LASTCHANGED" Timestamp, "ISACTIVE" Smallint, "XPASSWORD" Integer, "CANEDIT" Smallint, "CANSYSADMIN" Smallint, "LOGGEDIN" Smallint, PRIMARY KEY ("USERID") ) I run the following VB code Private Sub Command1_Click() Dim s Sql As String Dim ors As ADODB.

Recordset s Sql = "select userid, username from TBL_USERS where LOGONID = 'ND'" ' get recordset with Lock Type= ad Lock Optimistic, ' Cursor Location= ad Use Client, Cursor Type = ad Open Dynamic Set ors = Open Me ARecordset(go Connection, s Sql) ors! Update Set ors = Nothing End Sub When I run it, I get a "Row cannot be located for updating" error on the o Rs. If I switch the cursor to serverside, I get a SAP error "Syntax error or access violation; -3014 POS(15) Invalid end of SQL statement".


Some values may have been changed since it was last read." The values looked up have not changed, the only change might be price or quantity.mick yes, i used My SQLQuery Brower to retrieve the data and can even update it.



  1. Pingback:

  2. eric   •  

    The system today's young men and women have inherited for finding and marrying a future spouse leaves a lot to be desired.

  3. eric   •  

    With a wide variety of different girls, boys, milfs, couples and shemales that strips, masturbates, pleasures themselves with toys, sucks and fucks in the free public chat rooms, no matter what time it is, you can always find incredibly hot webcam porn shows to watch.

  4. eric   •  

    Many of them have sexually explicit photos posted on their profiles and they don't want these pics being spread.

  5. eric   •  

    Although everyone likes their privacy sometimes, if you use the first option and get the whole room involved it can be a lot more fun, especially if you get a bunch of people doing it. Because you can view at least 5 live streams from other people at the same time, so you can imagine how crazy and fun things can get! Earlier I mentioned credits, well, you're probably wondering what are they and what can you do with them?

  6. eric   •  

    Purely for the sake of clarity in communication I will re-present it in full. Second, as that which is formless (as in, timeless and spaceless, ethereal and supernal, immaterial and incorporeal and so on) is not only neither existent nor non-existent, but is not neither existent nor non-existent either, then my lustrous pearl analogy serves to convey the ethereal radiant beauty of that which is devoid of any personality whatsoever – utterly non-egoic in any way, means or manner (aka, void) – and, thus, totally ‘other’, resplendently supreme, sacred and absolute. What I need to do is have a word count that includes only the text of the story and not the headings and title page text count.

  7. eric   •  

    Night Exchange is where adults come to share their most intimate desires and have fantasy chat.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>