Find/Select

[Sam Rutherford]

Would you mind explaining the expression «+fieldname+».
It's the + signs surroundng the variable name I'm curious about?

________________________________________________________________

On Apr 27, 2008, at 4:14 PM, Jeremy Tice wrote:

>>
> 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.
>
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna

________________________________________________________________
Sam Rutherford
Music City Metals
615/255-4481
samrutherford at musiccitymetals.net


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