Re: Can buttons be dragged and dropped?

There is a "drag"/"drop" package comes with Developer 2. Check the sample FMBs

Mike Phillips <mlp_at_swsdot.com> wrote in message news:2DXH3.2794$w8.57823_at_wbnws01.ne.mediaone.net...
> 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 Tue Sep 28 1999 - 08:42:23 CEST