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


Groups > comp.lang.clipper.visual-objects > #2085 > unrolled thread

Update fields in MySQL (FieldPut)

Started bySzepi <szepligeti@gmail.com>
First post2011-09-27 10:45 -0700
Last post2011-09-30 04:20 -0700
Articles 10 — 5 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

#2085 — Update fields in MySQL (FieldPut)

FromSzepi <szepligeti@gmail.com>
Date2011-09-27 10:45 -0700
SubjectUpdate fields in MySQL (FieldPut)
Message-ID<72993498-345c-4cca-9886-7902fa674353@p11g2000yqe.googlegroups.com>
Hi,

To repeat an old question:
I use AdoServer:FieldGet and it works, but if I use AdoServer:FieldPut
and it does not work.

I set adLockOptimistic in AdoServer and the file is not Read Only.
Just wonder what's wrong with it.

I can use AdoCommand to specify the SQL statment and do the updating,
but it's not convenient. If I can use DBF syntax FieldPut / Assign, it
will be much easier.


The problem for me is the same. If you leave the field blank, the
upgrade will work, otherwise the error message:

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

Any suggestion.

Thanks.

Szepligeti

[toc] | [next] | [standalone]


#2086

From"Willie Moore" <williem@wmconsulting.com>
Date2011-09-27 15:02 -0500
Message-ID<j5ta3j$ska$1@speranza.aioe.org>
In reply to#2085
Hey,

What is the exact error message and what is the type field / vo type that 
you are having a problem with. I use the ADORecordset directly in most of my 
apps but there are still a couple that I use ADOServer and I haven't had any 
issues with it. I will be happy to help.

Regards,
Willie

"Szepi"  wrote in message 
news:72993498-345c-4cca-9886-7902fa674353@p11g2000yqe.googlegroups.com...

Hi,

To repeat an old question:
I use AdoServer:FieldGet and it works, but if I use AdoServer:FieldPut
and it does not work.

I set adLockOptimistic in AdoServer and the file is not Read Only.
Just wonder what's wrong with it.

I can use AdoCommand to specify the SQL statment and do the updating,
but it's not convenient. If I can use DBF syntax FieldPut / Assign, it
will be much easier.


The problem for me is the same. If you leave the field blank, the
upgrade will work, otherwise the error message:

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

Any suggestion.

Thanks.

Szepligeti 

[toc] | [prev] | [next] | [standalone]


#2087

FromFerenc Szépligeti <tuzxesz@gmail.com>
Date2011-09-28 01:10 -0700
Message-ID<463e9b2f-906b-4ba8-b50f-8ef1c2016466@g23g2000vbz.googlegroups.com>
In reply to#2086
Hi,

Ado_Connection:

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

    self:ConnectionString 		:= cConn

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

[toc] | [prev] | [next] | [standalone]


#2088

FromFerenc Szépligeti <tuzxesz@gmail.com>
Date2011-09-28 01:26 -0700
Message-ID<e4fdf97f-3901-4064-91e5-22d6c8ea0e56@hd1g2000vbb.googlegroups.com>
In reply to#2086
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

[toc] | [prev] | [next] | [standalone]


#2092

From"Willie Moore" <williem@wmconsulting.com>
Date2011-09-28 08:16 -0500
Message-ID<j5v6mv$kas$1@speranza.aioe.org>
In reply to#2088
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 

[toc] | [prev] | [next] | [standalone]


#2099

FromFerenc Szépligeti <tuzxesz@gmail.com>
Date2011-09-28 23:11 -0700
Message-ID<44498a54-faa5-4f45-b142-3a62f9bcdba8@n36g2000yqb.googlegroups.com>
In reply to#2092
Hi,

Nobody works in MySQL, using Vo2Ado?
:-(

Szepligeti

[toc] | [prev] | [next] | [standalone]


#2104

From"Willie Moore" <williem@wmconsulting.com>
Date2011-09-29 13:35 -0500
Message-ID<j62dpk$n5i$1@speranza.aioe.org>
In reply to#2099
Szepligeti,

I do work with mySQL but not in VO. I use it in some web apps using PHP. 
With VO I am using MS SQL.

Regards,
Willie

"Ferenc Szépligeti"  wrote in message 
news:44498a54-faa5-4f45-b142-3a62f9bcdba8@n36g2000yqb.googlegroups.com...

Hi,

Nobody works in MySQL, using Vo2Ado?
:-(

Szepligeti 

[toc] | [prev] | [next] | [standalone]


#2106

FromPilks <richardp@lukhozi.co.za>
Date2011-09-29 23:45 -0700
Message-ID<40a21ddf-16f5-4bde-bfdc-88c6632d973f@t11g2000yqk.googlegroups.com>
In reply to#2099
Ferenc

I work in MySQL with Vo2Ado. I use the ODBC interface.

I do not use it like a dbf though. I query the database and use the
resulting recordset to populate fields in a form. To save I generate
an update (or insert) statement from the changed fields and execute
the statement. I have not had problems with this way of working for
the last 6 years. My software is specialized engineering stuff and not
your day to day transactional software.

Richard

On Sep 29, 8:11 am, Ferenc Szépligeti <tuzx...@gmail.com> wrote:
> Hi,
>
> Nobody works in MySQL, using Vo2Ado?
> :-(
>
> Szepligeti

[toc] | [prev] | [next] | [standalone]


#2107

From"andrej Terkaj" <aterkaj@task.si>
Date2011-09-30 11:56 +0200
Message-ID<j643oe$164$1@news.siol.net>
In reply to#2088
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
>
> 


[toc] | [prev] | [next] | [standalone]


#2108

FromFerenc Szépligeti <tuzxesz@gmail.com>
Date2011-09-30 04:20 -0700
Message-ID<68336044-14f5-4994-b5b0-a5f5324601b5@dk6g2000vbb.googlegroups.com>
In reply to#2107
Hi Andrej!

Thank you very much for your help! It works!
:-)

Szepligeti Ferenc



On szept. 30, 11:56, "andrej Terkaj" <ater...@task.si> wrote:
> 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" <tuzx...@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
>
>

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web