🚀 go-pugleaf

No happiness.  I have had almost the identical code work before, but
suddenly it just goes blank in the component, which is what the OLH says
will happen if there is a mistake in the SQL.  Ohhh Well.
-- 
   Tom 
   Bena, VA

Romain Strieff [TeamB] wrote:
> 
> In article <34DE42C7.B79@inna.net>, tarnold@inna.net grudgingly admits...
> > Can anyone see why my LookUpSQL statement doesn't work?  Can't seem to
> > get a calculated field to work even though seem to be following the OLH
> > exactly.
> >
> >      SELECT LAST, FIRST FROM NAME                   <== This works, but
> >      SELECT LAST, FIRST || LAST AS FULLNAME FROM NAME     <== This
> > Doesn't
> >
> > When I say works, I get no errors from the FD, but when the code is run
> > it does not show in a ComboBox.  No other changes made in form.
> >
> Mmm, you are using FIRST in your calcfield and you don't have it in the
> field selections, try:
> 
>       SELECT LAST,FIRST, FIRST || LAST AS FULLNAME FROM NAME