General question on Database behaviour/SQL

[Ivan Smahin]

Hello Florian,

Tuesday, November 7, 2006, 10:57:55 AM, you wrote:

>> 
>> > And advice?
>> 
>> Do you have the link between KUNDENtable and  KUNDENKARTENtable ?
>> If so you can use valentina's sql-extension such as "->" operator.
>> 

> I guess no, because this just returns ALL records from KUNDENtable. I did
> not explicitly link the tables, I just store the KD_ID from KUNDENtable in
> the KUNDENKARTENtable as well as CRD_KD_ID and this is how I link the
> tables.

> Must I change this to ObjectPtr Links? Can I do this with existing records?

> Best, FLorian

>> Something like this:
>> SELECT * FROM KUNDENtable WHERE  KD_ID !=0  AND KD_ID->CRD_KD_ID = KD_ID
>> 

It could be any link type for make "->" working. RDB-link - for example.

BTW, I guess we talk about Valentina 2.x?


-- 
Best regards,
 Ivan                            mailto:ivan_smahin ÎÁ valentina-db.com