Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #2085 > unrolled thread
| Started by | Szepi <szepligeti@gmail.com> |
|---|---|
| First post | 2011-09-27 10:45 -0700 |
| Last post | 2011-09-30 04:20 -0700 |
| Articles | 10 — 5 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | Szepi <szepligeti@gmail.com> |
|---|---|
| Date | 2011-09-27 10:45 -0700 |
| Subject | Update 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]
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Date | 2011-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]
| From | Ferenc Szépligeti <tuzxesz@gmail.com> |
|---|---|
| Date | 2011-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]
| From | Ferenc Szépligeti <tuzxesz@gmail.com> |
|---|---|
| Date | 2011-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]
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Date | 2011-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]
| From | Ferenc Szépligeti <tuzxesz@gmail.com> |
|---|---|
| Date | 2011-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]
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Date | 2011-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]
| From | Pilks <richardp@lukhozi.co.za> |
|---|---|
| Date | 2011-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]
| From | "andrej Terkaj" <aterkaj@task.si> |
|---|---|
| Date | 2011-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]
| From | Ferenc Szépligeti <tuzxesz@gmail.com> |
|---|---|
| Date | 2011-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