H Alex, On Thu, Mar 31, 2011 at 2:42 PM, Alexander Burger <a...@software-lab.de> wrote: > Hi Edwin, > >> what's the best way to go about autogenerated keys for Pilog? i've >> been digging around a bit and can't find anything related. > > Hmm, I am not sure what that is. You mean something along autogenerated > keys in JDBC? I find > > JDBC's auto-generated keys feature provides a way to retrieve values > from columns that are part of an index or have a default value > assigned > > > In the PicoLisp DB there are no keys used to "join tables". Instead, > objects are directly linked, i.e. they refer to each other (in > properties) by "containing" other objets, or lists of objects.
check. another insight. thank you. > > The relation maintenance classes for that are '+Link' and '+Joint'. > > > In fact, there is a function 'genKey' which generates keys, but this is > different from how I understand the above autogenerated keys. 'genKey' > simply returns a new number not yet existent in an index. i think this hits the nail squarely. > > Can you give an example what you'd like to do? suppose there is a song entitled "evergreen". one was sung by barbra streisand, the other by will young. different lyrics, but same song title. i'd like to use SongTitle as a key, but it won;t cut it, as in the example above. so i have to revert to something like an autoincrement key. this is it! thank you. > > Cheers, > - Alex > -- > UNSUBSCRIBE: mailto:picolisp@software-lab.de?subject=Unsubscribe > -- UNSUBSCRIBE: mailto:picolisp@software-lab.de?subject=Unsubscribe