SQL for Blitz Custom Types

The forum is locked. These are the original blitzbasic.com forums, kept so they can still be read. No new topics, replies or edits can be made here. To join in, head over to the Blitz3D+ forums.

fall_x

Using SQL queries would be pretty cool, but why would you need id's when you can do the relations between types like this :

Type Category
    Field catName$
End Type

Type Item
    Field cat.Category
    Field itemName
End Type

c1.Category=new Category
c1\catName$="First Category"

i1.Item=new Item
i1\itemName="An Item"
i1\cat=c1

If you use an ID, you will need to loop every category to find the one maching your item, like this you can just access it directly. Or am I missing something?