🚀 go-pugleaf

On Thu, 08 Oct 1998 20:44:16 -0700, David Jones
<106510.502@compuserve.com> wrote:

>I've tried to use the following SQL code in VdB 7.01, where Companies is 
>a DBF table and Contacts is a Memo field and contact is a character 
>variable with upper-case values:-
>
>UPDATE Companies SET Tempflag1=0 WHERE UPPER(Contacts) NOT LIKE 
>'%'+:contact+'%'
>
>This results in the error 'Type mismatch in expression'.
>
>However, the same code without the UPPER() function works OK but is, of 
>course, case-sensitive.

Dave,

For some reason, an 'upper(<memo field>)' field cannot be used in an
sql filter or 'where' command; need to use a canGetRow routine. The
following, which I use in a search routine to allow users to collect
records based on the contents of memo fields, I got from Bowen
Moursund as far as the essentials go:

  form.rowset.canGetRow := {|| pcSearchValue $
upper(this.fields['Notes'].value)} // 'Notes' is a memo field
  form.rowset.first()
  u = new UpdateSet()
  u.source := form.rowset
  u.destination := '\PigByte\VdB\print_stuff.dbf'
  u.append()
  form.rowset.canGetRow := null
  form.rowset.first()

Ned