Re: conecting with a MsAcces DB by dao

luis wrote:

My problem was opening a query (not a table) on mdb file

1) If the query includes a where clause type
field1="edf" and field2=3
, for example, no problem, Access can retrieve a not empty recordset
and my python code too.

2) But if the Access's query includes a LIKE clause, for example
field1="e*"
, Access can retrieves a not empty recordset but my python code
retrieves a empty recordset.

Which is exactly what it _should_ return on that query, unless you have
records with "e*" in column field1.

The proper SQL clause is:

... WHERE field1 LIKE 'e*' ...

But, you did not include that part of the program, so you wound up
crippling those who were willing to try to help you, because you
thought you kinda-sorta knew what was going on (but not enough to
fix it). Find "smart questions" and read it a couple of times.


--
--Scott David Daniels
scott.daniels@xxxxxxx
.

Relevant Pages

  • Re: mysql-question
    ... many players playing at the same time, ... "COUNTis optimized to return very quickly if the SELECT retrieves from ... There is a WHERE clause here, hence the optimization is lost. ...
    (comp.lang.php)
  • Re: conecting with a MsAcces DB by dao
    ... def append_from_Access: ... def Update(self, query, function): ... , for example, no problem, Access can retrieve a not empty recordset ... Access can retrieves a not empty recordset but my python code ...
    (comp.lang.python)
  • Re: Only showing 20 lines per page...
    ... results to an array and looping through that way. ... retrieves from one table, no other columns are retrieved, and there is no ... WHERE clause." ... database, which will mean less resource use with both database & PHP. ...
    (alt.php)
  • Re: Strange behavior...Open an ADOTable fetch all records
    ... It's normal behavior for a table component. ... Select * retrieves all records. ... If you want just one or a few records, you must include a where clause in ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Re: Accessing sorted records via VB
    ... Why not include an ORDER BY clause as part of your SELECT statement that retrieves the data from the database? ... That is a lot of data to return to a client! ...
    (microsoft.public.sqlserver.programming)