I am confused...
From day one I was logging into my system (D1, SybaseSQLAny 5.01) with a
user id and password that were fixed and setup at design time in the
But since I've implemented my login dialog the system behave differently
for the same user... even if the user permisions have not changed nor
the system itself other than the way I login to it.
Here it is.
The user I am talkin about HAD since the begining the following
grant select, insert, delete, update, references for all the tables.
This has never been changed.
Since the login dialog thing... BDE is complaining about the token
'Effort' on line 2 (of the query below) when it creates the
select e.MembreClient, e.CodeService, e.DateJour, e.Duree, e.Note
from dba.Effort e where (e.MembreEmploye like (:CurEmploye)) order by 1
The previous Query used to have RequestLive set to true, but since that
login thing I must set RequestLive to False in order to make it work,
obviously I cannot anymore modify the result set...
Also, I was under the implression that one of the rule to get a live
result set was 'No Order By Clause' But it was working perfectly...
This is confusing...
Question: Could the way I login onto the database requires the query's
RequestLive property be set to False... Is this possible or am I missing
As usual, any help/experience/joke much appreciated.