Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #2092
| 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> |
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
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