RE: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-27 Thread Javier Valencia
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: rbase-l@googlegro

Re: [RBASE-L] - Re: LISTOF question 10.0.4.10913

2018-10-27 Thread Michael Byerley
We aim to please On Saturday, October 27, 2018 at 6:10:41 PM UTC-4, crobbins wrote: > > Love it! Works as advertised. Thanks Mike! > > > > *From:* rba...@googlegroups.com [mailto: > rba...@googlegroups.com ] *On Behalf Of *Michael Byerley > *Sent:* Saturday, October 27, 2018 2:37 PM > *T

RE: [RBASE-L] - Re: LISTOF question 10.0.4.10913

2018-10-27 Thread Claudine Robbins
Love it! Works as advertised. Thanks Mike! From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Michael Byerley Sent: Saturday, October 27, 2018 2:37 PM To: RBASE-L Subject: Re: [RBASE-L] - Re: LISTOF question 10.0.4.10913 OK. Here's a workaround then. In this

Re: [RBASE-L] - GATEWAY

2018-10-27 Thread Bruce A. Chitiea
Jan: Not according to RSYNTAX. Would the intent be to store TableColumnName aliases within the dataset? Example: Table columnname: IMHO First Column Row Value: 'In My Humble Opinion' Bruce -- Original Message -- Sent: 10/27/2018 12:31:58 PM Subject: [RBASE-L] - GATEWAY From: "jan

Re: [RBASE-L] - Re: LISTOF question 10.0.4.10913

2018-10-27 Thread Michael Byerley
OK. Here's a workaround then. In this Zipfile is an Rbase Form with a UserDefinedListBox that behaves like a Choose. You will have to change the table, Expression values, and Where clause to suit your needs. There's a brief remark in the onAfter start EEP. guaranteed to work.. :

[RBASE-L] - GATEWAY

2018-10-27 Thread jan johansen
All, While using GATEWAY IMPORT to a new table from a CSV file, is there an option to use first row as table Column Names? Jan -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups

RE: [RBASE-L] - Re: LISTOF question 10.0.4.10913

2018-10-27 Thread Claudine Robbins
Thanks Mike, that works fine for the LISTOF command. However; the name picked in the subsequent CHOOSE command using the vValueList now contains the company name without the comma (YELLOW JACKET CONSTRUCTION INC.) so EDI USI COMPANIES WHERE COMPANY_NAME = .VCHOOSE command fails the field match.

[RBASE-L] - Re: LISTOF question 10.0.4.10913

2018-10-27 Thread Michael Byerley
It doesn't. Try this instead: (listof((srpl(ColumnWithEmbeddedComma,',','',0 On Friday, October 26, 2018 at 4:07:52 PM UTC-4, crobbins wrote: > > Hello all, > > > > My experience with LISTOF is that it automatically puts quotes around > fields that contain commas but I’m running int