Can buttons be dragged and dropped?

Hi,

I have a vendor table, which is of the form VENDOR(vendorid, vendorname, Vendortype). Vendortype is a
2 choice field, i.e either the vendor is a major vendor or it is a minor vendor.

Now I have created a form that has two frames, 1) Major Vendors and 2) Minor Vendors. I would like to
query the Vendor table and based on the entry in the 'VendorType' field, place a button in the relevent frame (major or minor) with the 'VendorName' as the caption for the button. I would like to do something like:

            select vendorname from VENDORNAME
            for each vendorname do
            {
                createbutton;
                set button.caption=vendorname;
                if vendortype == major
                       add and display the button in major frame;
                else if vendortype==minor
                        add and display the button in the minor frame;
            }

This is not PL/SQL since I don't know it very well.

1. But is it possible for me to do this by using the developer 2000 environment and the oracle language? If so, what would a good way to go about it?

2)Can I drag and drop buttons from major to minor frame on the form and be able to associate a drag/drop
trigger that updates the database table accordingly? For example, say we wanted to move Microsoft from being a major vendor to a minor one..we would want to move the Microsoft button from the major frame to the minor frame, and have Microsoft's record change (vendortype goes from major to minor) automatically behind the scene, so that the next time the program runs, the microsoft button automatically gets put on the MINOR VENDOR frame.
This would be great if PL/SQL allows for it! If not, which language DOES allow for the run time drag and drop of buttons?

Thanks for your comments,
Mike Received on Mon Sep 27 1999 - 23:55:03 CDT