Find/Select

[Jeremy Tice]

>
You're trying to select records where the contents of the variable  
equals the clipboard, not what the contents of the field whose name  
matches the contents of the variable.  I'd do what you're trying to  
do with an execute command, like so:

global fieldname
fieldname=info("fieldname")
copy
execute "Select «"+fieldname+"»=clipboard()"

or, to save a few steps:

copy
execute "Select «"+info("fieldname")+"»=clipboard()"


>
> I am trying to do a rather simple task.
>
> When in a database I want to select all records that have the same  
> information as the active field.  I make a variable whose value is  
> the info(“fieldname”).
>
> Global FieldName
> FieldName=info("fieldname")
> Copy
> Select «FieldName»=clipboard()
> Show
>
> Why does the above not work?
> I have also tried
> Select FieldName=clipboard()
> Select «FieldName»=clipboard()
>
> No errors, it just does not work.  What am I missing?  The field  
> name show up correctly as does the field contents when I check.
>
>
> Best Regards,
>
> George Beauchemin
>
> This email was transmitted utilizing solely recycled electrons.  No  
> electrons were harmed or destroyed in the process.  All electrons  
> employed in this transmission were at least 18 years old.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080427/ef0ffec6/attachment.html