Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #2092

Re: Update fields in MySQL (FieldPut)

From "Willie Moore" <williem@wmconsulting.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Update fields in MySQL (FieldPut)
Date 2011-09-28 08:16 -0500
Organization Aioe.org NNTP Server
Message-ID <j5v6mv$kas$1@speranza.aioe.org> (permalink)
References <72993498-345c-4cca-9886-7902fa674353@p11g2000yqe.googlegroups.com> <j5ta3j$ska$1@speranza.aioe.org> <e4fdf97f-3901-4064-91e5-22d6c8ea0e56@hd1g2000vbb.googlegroups.com>

Show all headers | View raw


Szepligeti,

I did not notice in the first message that you were using mySQL. There are a 
lot of problems using ADO with mySQL. You would be better off using an ODBC 
connection or write an interface in dotNet and use that as a proxy. The 
mySQL dotNet provider does not have the issues that the ADO driver did.

Regards,
Willie

"Ferenc Szépligeti"  wrote in message 
news:e4fdf97f-3901-4064-91e5-22d6c8ea0e56@hd1g2000vbb.googlegroups.com...

Hi,

Ado_Connection:
class Ado_Connection inherit AdoConnection

method INit() class Ado_Connection

local cConn as string
cConn:="Provider=MSDASQL;Persist Security Info=false;Data
Source=IktatOk_MySql;"

    self:ConnectionString               := cConn

   self:Open(nil,nil,nil,nil)


Update:
   if !oS:EoF
  uRet := oS:FIELDPUT(cField, uValue)
  oS:Commit() //!!!
    endif

The exact error message:
The line could not find the update. The last reading has some value
should be changed.

Field: Varchar(50)
Collation: utf8 - utf8hungarian_ci
Engine:InnoDb

If you leave the field blank, you okay, otherwise an error.

Szepligeti 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Update fields in MySQL (FieldPut) Szepi <szepligeti@gmail.com> - 2011-09-27 10:45 -0700
  Re: Update fields in MySQL (FieldPut) "Willie Moore" <williem@wmconsulting.com> - 2011-09-27 15:02 -0500
    Re: Update fields in MySQL (FieldPut) Ferenc Szépligeti <tuzxesz@gmail.com> - 2011-09-28 01:10 -0700
    Re: Update fields in MySQL (FieldPut) Ferenc Szépligeti <tuzxesz@gmail.com> - 2011-09-28 01:26 -0700
      Re: Update fields in MySQL (FieldPut) "Willie Moore" <williem@wmconsulting.com> - 2011-09-28 08:16 -0500
        Re: Update fields in MySQL (FieldPut) Ferenc Szépligeti <tuzxesz@gmail.com> - 2011-09-28 23:11 -0700
          Re: Update fields in MySQL (FieldPut) "Willie Moore" <williem@wmconsulting.com> - 2011-09-29 13:35 -0500
          Re: Update fields in MySQL (FieldPut) Pilks <richardp@lukhozi.co.za> - 2011-09-29 23:45 -0700
      Re: Update fields in MySQL (FieldPut) "andrej Terkaj" <aterkaj@task.si> - 2011-09-30 11:56 +0200
        Re: Update fields in MySQL (FieldPut) Ferenc Szépligeti <tuzxesz@gmail.com> - 2011-09-30 04:20 -0700

csiph-web