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


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

Re: Update fields in MySQL (FieldPut)

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>

Show all headers | View raw


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


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