Thank you for this very timely advice, Razzak.
I was just starting to look at the form I have that uses a Variable List Box
and which MikeB had shown me how to use multi-select a few years back. I had
intended to change it to use the now built-in multi-select option.
One of the problems that I have always had with this menu form was that I
could never see what I had multi-selected and another was that I had never
found a way to edit pre-existing items so I always had to select everything
I wanted again when editing (first time entry was fine).
Having looked at these examples, #2 in particular, I thought how nice it
would be to use the double list box concept and so be able to see my
selections. So, yesterday, I set about changing the example form which I
copied into my database. Once I had realised that the On Drop EEPs were the
other way around to the Double Click EEPs since they work on the drop and
not the act of selection - obvious, yes, once the penny dropped - I was up
and running.
My main change was to use two temporary tables with the driving table
populated from my menu table. This was firstly because I have a computed
column in my menu table that CREATE TABLE objected to since it was
pre-defined and, secondly, I could move items in and out of the temporary
version at will.
Then I thought I ought to be able to populate the chosen items table with
whatever is currently in the database for the record in use and also delete
those from the selection/driving table.
And, finally, I thought that I also ought to be able to ensure that if no
records were in the chosen table the form would automatically append the
"Unknown" entry or delete the "Unknown" row if another record was dropped
into it and put it back into the selection table.
Since the example form gave me all the clues I needed I now have a form that
always shows me the unselected choices on one list and the chosen ones on
the other one that is populated with the current data when the form is
called and with "Unknown" chosen whenever no other items have been selected.
My only question is: where else can I use this magic concept now?
I'll answer myself: all over the place!
Thanks again, Razzak - and to Michael Sinclair for asking the question that
prompted your response as well as to MikeB for the original multi-selection
solution.
Regards,
Alastair.
----- Original Message -----
From: "A. Razzak Memon" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, December 24, 2007 11:57 PM
Subject: [RBASE-L] - Re: Getting Started with Drag and Drop
At 06:17 PM 12/24/2007, Michael Sinclair wrote:
I know that Drag and Drop has been added to Rbase 7.6, but I
can't seem to get started. Could somebody show me the basics
of how this is done?
Mike,
Ask and you shall receive!
Take a look at the following sample application to demonstrate
the use of Drag&Drop feature in R:BASE 7.6, C/S:I 7.6 and Turbo
V-8 for Windows.
Sample Applications: http://www.razzak.com/sampleapplications/
Applications: Implementing Drag and Drop Features in Forms
Database: DragDrop
Command File: DragAndDrop.DAT
I also suggest taking a look at the cool "Grocery List Manager"
application posted on R:BASE Community by Bill Downall, to
demonstrate the use of "Drag and Drop" feature.
http://www.rbasecommunity.com
Should you require further assistance, feel free to ask on the
RBG7-L list (mailto:[EMAIL PROTECTED]). You'll get more feedback
and help from the dedicated and current users and developers of
R:BASE.
And, don't forget to download the latest and greatest updates,
help files, as well as the current version of Running R:BASE
Your Way! (Part 14). http://www.rupdates.com/rbg76/
Enjoy and make sure to have fun!
Very Best R:egards,
Razzak.
--
No virus found in this incoming message.
Checked by AVG Free Edition. Version: 7.5.516 / Virus Database:
269.17.7/1194 - Release Date: 23/12/2007 17:27
--- RBASE-L
================================================
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)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
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.
================================================
