[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    Re: myODBC, VB6.0 and Update Metho
From:       Ken Menken <menken () teamgenesis ! com>
Date:       1999-10-24 22:59:36
[Download RAW message or body]

We got a similar error -- our workaround was to change to UPDATE sql 
statements --

strSQL = "UPDATE LON_Prequalify SET LON_Prequalify.buying_plans = 
LON_Prequalify.id"
richworksDB.execute  strSQL

Is that what you are trying to do -- set the value in the "buying_plans" 
field to equal the value in the "id" field? I'm not sure if the above will 
work, but that looks right.

Pardon my ignorance -- I've never come across "CreateWorkspace" before. 
What is this?

Ken

At 03:43 PM 10/24/99 -0700, you wrote:
>I get the error "S1109: [TCX][MyODBC]SQLSetPos with lock or refresh is not 
>supported" when I attempt to call the update method in VB's DAO 3.x 
>library. The sample code is below:
>
>     Set wrkODBC = DBEngine.CreateWorkspace("wrkODBC", "root", "", dbUseODBC)
>     Set richworksDB = wrkODBC.OpenConnection("Richworks", 
> dbDriverComplete, False)
>     Set rec.Value = richworksDB.OpenRecordset("SELECT id, buying_plans 
> FROM LON_Prequalify", dbOpenDynaset)
>
>     Do While rec.EOF = False
>         rec.Edit True
>             rec.field("buying_plans").Value = rec.field("id").Value
>         rec.update
>         Debug.Print rec.field("id").Value & " - " & 
> rec.field("buying_plans").Value
>         rec.moveNext
>     Loop
>
>The table does have a timestamp and a primary key...
>
>| TIMSTAMP | timestamp(14) | YES  |     |   ||
>| id       | int(11)       |      | PRI | 0 ||
>
>My ODBC options are as follows:
>         Don't optimize column widht
>         Return matching rows
>         Trace MyODBC
>         Use compressed protocol
>
>What am I doing wrong, or does it just not work?
>
>-JParr
>
>Geocrawler.com - The Knowledge Archive
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail myodbc-thread823@lists.mysql.com
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail myodbc-unsubscribe@lists.mysql.com instead.


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread824@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail myodbc-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]