[mdb-dev] mdb-sql, select WHERE with _'s

[Francois B. <fb...@sp...>]

Hi All,

I'm in the process of disecting our company's  security system which 
runs on a Acesss'97 database, I have a problem using mdb-sql to do a 
query, a describe on the db:

1 => describe table Transack
2 => go

+------------------------------+--------------------+----------+
|Column Name                   |Type                |Size      |
+------------------------------+--------------------+----------+
|CLOCK_SQ                      |Long Integer        |4         |
|CLOCK_DATE                    |Long Integer        |4         |
|CLOCK_TIME                    |Long Integer        |4         |
|CLOCK_TAGCODE                 |Long Integer        |4         |
|CLOCK_READERNO                |Long Integer        |4         |
|CLOCK_SET                     |Integer             |2         |
|CLOCK_STATUS                  |Integer             |2         |
|CLOCK_DIRECTION               |Text                |1         |
|CLOCK_LEVEL                   |Text                |1         |
|CLOCK_JREF                    |Long Integer        |4         |
|CLOCK_PROCESSED               |Text                |1         |
+------------------------------+--------------------+----------+

I seem to have difficulty selecting from anything...

fbotha@bleat:/download$ mdb-sql TRANSACK.MDB
1 => select * from Transack where CLOCK_SQ = 1
2 => go
Error at Line : syntax error near _
Couldn't parse SQL

etc.

I've tried using []'s, 's, "'s, etc to no avail.

Anybody have any idea how I can use WHERE? (;

Regards,
Francois