🚀 go-pugleaf

Nedim Buyukmihci wrote:
> 
> 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,

Thanks for the advice. I guess that SQL has it's limitations!

My code was part of a multiple-criteria search routine, which could 
result in commands that are too long for the normal filtering methods. 
Now I know that SQL won't do the job, I can fall back on my alternative 
method of directly changing the flag field values in a DO WHILE loop, 
which works OK but is slower than the SQL UPDATE command. By the way, the 
other alternative of using xDML's REPLACE command also seems to be 
slower.

I'm still experimenting with VdB 7 and haven't yet looked at CanGetRow, 
so your sample code is of great interest.

Dave