One further comment on this. You can blackbox the form solution in a
couple of ways, one being to put the form inside of a stored procedure so
you can call it from there,
then using property commands to change the table name and colum spec for
the listbox, or simply utilize the CAPTION string that is the argument of
Edit Using or Enter Using to contain an argument of the elements you want
to change in the onAfter start of the form.
If you have ever used my RBase form based Calendar, you will see its'
procedure there.
So by doing that, you could change the properties of the pseudo Choose
box on the fly, and reuse it anytime the need arises in lieu of having a
separate form for each problem.
Over the course of time since the humble 7.0, RBase has provided many
pathways to problem solution and when there is none apparent, there is
always a reasonably willing RDCC.. :)
On Saturday, October 27, 2018 at 10:53:57 PM UTC-4, javier.valencia wrote:
>
> Claudine,
>
>
>
> Try the following:
>
>
>
> SELECT LISTOF('''' + your column + '''') into xxx from your_table WHERE …
>
>
>
> All the items should have single quotes and the comma should be inside the
> quotes.
>
>
>
> Javier,
>
>
>
> Javier Valencia, PE
>
> O: 913-829-0888
>
> H: 913-397-9605
>
> C: 913-915-3137
>
>
>
> *From:* [email protected] <javascript:> [mailto:
> [email protected] <javascript:>] *On Behalf Of *Claudine Robbins
> *Sent:* Friday, October 26, 2018 3:08 PM
> *To:* [email protected] <javascript:>
> *Subject:* [RBASE-L] - LISTOF question 10.0.4.10913
>
>
>
> Hello all,
>
>
>
> My experience with LISTOF is that it automatically puts quotes around
> fields that contain commas but I’m running into a situation where it does
> not.
>
>
>
> One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the
> space plus INC. as a separate value.
>
>
>
> However, it correctly returns 3 for the ITEMCNT variable.
>
>
>
> What am I overlooking?
>
>
>
> R>sho v vValueList
>
> YELLOW JACKET CONSTRUCTION,
>
> INC.,YELLOW JACKET
>
> OILFIELD,YELLOWHOUSE
>
> MACHINERY CO.
>
>
>
> [image: cid:[email protected]]
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected] <javascript:>.
> For more options, visit https://groups.google.com/d/optout.
>
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
