Ramiro
What I have done is ask what the textcolumn begins with or what the textcolumn
contains by using Dialog
DIALOG 'Enter 1st few char of textcolumn' VTextColumn VEndKey 1
SET VAR VMany = (CVAL('MANY'))
SET VAR VQ = (CVAL('QUOTES'))
SET VAR VTextColumn = (.VQ+.VTextColumn + .VMany+.VQ)
CHOOSE textvar FROM #VALUES FOR DISTINCT textcolumn FROM bigtable WHERE +
textcolumn like &VTextColumn
Buddy
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 8:51 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Choose distinct on a big table
I have the following command:
CHOOSE textvar FROM #VALUES FOR DISTINCT textcolumn FROM bigtable
The bigtable is about 17.000 rows,
using RBWIN-65 (1.866xRT03)
the following message is displayed: "Insufficient memory to continue this
function".
How can I manage the memory to avoid this problem?
Thanks in advance, cordially,
Ramiro M�ndez
Superintendencia General del SIRESE
La Paz
Bolivia - South America
--- RBASE-L
=======================3D=======================
D=
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [EMAIL PROTECTED]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
=======================3D=======================
D=
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: INTRO
=======================3D=======================
D=
TO UNSUBSCRIBE:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: UNSUBSCRIBE
=======================3D=======================
D=
TO SEARCH ARCHIVES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
=======================3D=======================
D=
