Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Problem with TDBISamQuery and TDBISamDatabase
Wed, Jun 4 2008 3:34 AMPermanent Link

"Adam H."
Hi,

I'm having a wierd problem with one of my projects. The mainform has a
TDBISamdatabase and TDBISamsession component, along with a number of forms
that are created and destroyed as required.

These forms may have a number of queries and tables on them, which have all
worked fine, however I've designed a new form with a wierd problem.

Whenever the new form is created in runtime, it has no link to the
TDBISamdatabase component. The Query.Databasename property is populated, but
Query.Database = nil.

Once I run the query, the query 'links' to the database and all is fine.

The problem I have is that the query refers to a password protected table.
The TDBISamsession on my mainform already has the password assigned to it,
but because the query on this form is not linked to the database and
session - it asks me for the password first, before opening (and therefore
linking to the table).

This is the first time I've come across this problem. I've had no problems
with it in the past.

I've checked to make sure that the form and query is not created prior to
the mainform (so the link should be valid).

I've also checked to make sure that the mainform still exists.

I'm stumpted as to what could be causing this. Has anyone an idea?

(Delphi 2007, dbisam 4.26b1)

Thanks & Regards

Adam.
Wed, Jun 4 2008 4:03 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Adam


Set the sessionname for the query before running it. If you leave it blank it will assume the default session which will not have your password linked in.

Roy Lambert [Team Elevate]
Wed, Jun 4 2008 9:03 AMPermanent Link

"Adam H."
Hi Roy,

Thanks for your reply. (Noticed that I've posted this in the wrong NG, so
will move over to dbisam.general).

However, the sessionname for the query has already been set. (Sorry - should
have mentioned that in original post).

Cheers

Adam.

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:6556BC77-2120-41EC-A5F0-7A73FFFC09D3@news.elevatesoft.com...
> Adam
>
>
> Set the sessionname for the query before running it. If you leave it blank
> it will assume the default session which will not have your password
> linked in.
>
> Roy Lambert [Team Elevate]
>
Image