serial number -- Order of Vstudio MAC

[Ruslan Zasukhin]

On 6/27/08 6:01 PM, "william humphrey" <shoreagent at gmail.com> wrote:

Hi William,

> Sorry I figured out how to see RecID
> 
>  
> select d_phones_clients_ref from data_phones where RecID = 3182
> 
>  
> this results in "i_clients_id" = 3 and that record exists so why am I getting
> the error for RecID 3182 when I try to add a foreign key?
> 
>  
> SQL
> select i_clients_id from info_clients where i_clients_id = 3
> results in record found was "3"

Hmm, this is first letter on this issue?
I just do not see full picture I think.


Please note that RecID should be used in pair with ObjectPtr.

But if you want use Foreign Key link, then better have in the ONE table a
normal KEY field, exactly like in any other RDBMS.

Or I have not catch question?



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]