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


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

Re: Update fields in MySQL (FieldPut)

From "Willie Moore" <williem@wmconsulting.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Update fields in MySQL (FieldPut)
Date 2011-09-27 15:02 -0500
Organization Aioe.org NNTP Server
Message-ID <j5ta3j$ska$1@speranza.aioe.org> (permalink)
References <72993498-345c-4cca-9886-7902fa674353@p11g2000yqe.googlegroups.com>

Show all headers | View raw


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 

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