Subject | Re: [IBO] IBObjects and Intraweb (from Atozed) |
---|---|
Author | Markus Ostenried |
Post date | 2013-01-28T11:43:43Z |
Hi,
I don't have a solution for your problem but I suggest you alter your SQL
statement to consistently use table aliases.
Depending on the Firebird version this might not even be allowed.
select *
from users_options u
where upper(u.value_string_1) = upper(:nickname)
and typeof = 5
If you define a table alias you should always use it:
select u.*
from users_options u
where upper(u.value_string_1) = upper(:nickname)
and u.typeof = 5
In this case the IBO KeyRelation would be "u".
Regards,
Markus
I don't have a solution for your problem but I suggest you alter your SQL
statement to consistently use table aliases.
Depending on the Firebird version this might not even be allowed.
select *
from users_options u
where upper(u.value_string_1) = upper(:nickname)
and typeof = 5
If you define a table alias you should always use it:
select u.*
from users_options u
where upper(u.value_string_1) = upper(:nickname)
and u.typeof = 5
In this case the IBO KeyRelation would be "u".
Regards,
Markus
On Mon, Jan 28, 2013 at 12:13 PM, roPopa <ropopa01@...> wrote:
> **
> ok now I find out more about my problems.
>
>
> After I put a IB_Session on UserSessionUnit work. I mean the project can
> start. until now dosent eaven start.
>
> However now the problem is that I cannot open any query. runtime or
> design time is the same.
>
> All the time the error is "Invalid KeyLinks Entry """"".
>
> http://tinypic.com/r/16gjvxj/6 http://tinypic.com/r/16gjvxj/6>
> http://tinypic.com/r/30d9p2t/6 http://tinypic.com/r/30d9p2t/6>
> http://tinypic.com/r/264pf6d/6 http://tinypic.com/r/264pf6d/6>
> http://tinypic.com/r/25rfbqa/6 http://tinypic.com/r/25rfbqa/6>
>
> explain images:
> 1. database is connectd and trust me has tables.
> 2. Error in the debugger
> 3 and 4 Query (IB and IBO) not see any table.
> Razvan
>
[Non-text portions of this message have been removed]