Re: [RBASE-L] - Limit inserts to one of many

2018-08-03 Thread Bill Downall
Hi, Doug! What about: INSERT into Inventory (ItemCode,Description) SELECT *DISTINCT* ItemCode,Description + FROM Orders + WHERE ItemCode in (SELECT ItemCode from NewItems) (sent from Moto Z) On Fri, Aug 3, 2018, 9:00 PM Doug Hamilton wrote: > My SQL brain cell is stumped. > > We have a

[RBASE-L] - Limit inserts to one of many

2018-08-03 Thread Doug Hamilton
My SQL brain cell is stumped. We have a bunch of orders coming in, most of the items are already in the db, but, naturally, sometimes they are not and I want to add them on the fly. Incoming orders might look like: Order#  ItemCode  Description 101 AAA   Framus 102 BBB  

Re: [RBASE-L] - Setting Custom EEP of object created with CREATEOBJECT

2018-08-03 Thread 'Lawrence Lustig' via RBASE-L
Doesn't work but, looking more carefully at the help file I notice that only a small number of components (variable and DB fields) and a small number of EEPs (Enter, Exit, and Click) are eligible for custom set-up like this.  So I think I'm out of luck with this technique.--Larry On