🚀 go-pugleaf

Hello all,
 
  Im creating a simple application in BCB6 in charge of authenticating
users by means of retrieving information from MS Access using ADO
components.

The table in the DB comprises several fields: username,password and
privileges and so far I have used only one TADOQuery with these 3
persistent fields.

Using this TADOQuery I want to make 2 different queries changing the
SQL property: The first query should retrieve only information about
the username and privileges and a second query should retrieve only
the password for a given username.

Because the first query doesnt retrieve any information about the
password, the program halts and gives an error. After removing the
password persistent field from the TADOQuery everything works
perfectly for the first query.

Do I have to use a different TADOQuery to retrieve the password
information?

Can I use the same TADOQuery to do everything?

Is this related with the fact that Im using persistent fields?

I hope I made myself clear, I would appreciate any feedback from you,

Juan Luis Medina