Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #2107
| From | "andrej Terkaj" <aterkaj@task.si> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Update fields in MySQL (FieldPut) |
| Date | 2011-09-30 11:56 +0200 |
| Organization | news.siol.net Planet9 d.o.o. |
| Message-ID | <j643oe$164$1@news.siol.net> (permalink) |
| References | <72993498-345c-4cca-9886-7902fa674353@p11g2000yqe.googlegroups.com> <j5ta3j$ska$1@speranza.aioe.org> <e4fdf97f-3901-4064-91e5-22d6c8ea0e56@hd1g2000vbb.googlegroups.com> |
Hi Ferenc !
I am working with MySQL using VO without problem using read, append, delete
..... cmds. Probably you didn't make :
A) an accurate connection. I am using ODBC Connector 3.51 with advanced tab
/Flags
Try and be carefull on OPTION and STMT sequence in connection string
oConn := AdoConnection{}
cConn := "Provider=MSDASQL.1;DSN=YOUR_DSN_SYSTEM;"+; //
your .DNS
"UID=Your_UserID;PWD=Your_PSWD;PORT=;OPTION=1+2+32+16384;STMT=set names
greek" // set names Hungarian ??????
oConn:ConnectionString := cConn
// first OF all you have TO specify into the ConnectString the OPTION=1
which IS equivalent TO the "Don't optimize column width" OF the ODBC
Connector 3.51 see Advanced tab / Flags 1 into your System DSN created FOR
MyDSQL ODBC entry).
// some OF the OPTION settings:
// Don't optimize column width = 1
// Return Matching Rows = 2
// Allow Big Results = 8
// Enable dynamic cursors = 32
// Enable MySQL Commpresed protocol = 2048
// Convert LongLong to Integer = 16384
B) You can also have problems with collation, and I think that you are
trying to put (Fielput) a value with a unadequate collation
yourvalue := CAST(yourvalue AS VARCHAR(10)) COLLATE SLOVENIAN_CI_AS
// AdoCommand statement HUNGARIAN_CI_AS ??????
Regards Andrej Terkaj
"Ferenc Szépligeti" <tuzxesz@gmail.com> 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