Sorry Ken - did not know what else to do. Here is the code generated by
dquery, the odd part is the reference in the query res1 to "res.db"
This is the one that fails. Password1 worked perfect. Even though Dquery
provided the error I posted, the code for res1 was streamed below.
When I run the datamodule - there are no fields in the res1 query. If I
remove the .db from the res1 sql statement - there are no fields either.
** END HEADER -- do not remove this line
//
// Generated on 02/16/04
//
class ETS02DATAMODULE of DATAMODULE
with (this)
left = -1.0
top = -1.0
endwith
this.ETS1 = new DATABASE()
this.ETS1.parent = this
with (this.ETS1)
left = 19.0
top = 135.0
databaseName = "ETS"
active = true
endwith
this.RES1 = new QUERY()
this.RES1.parent = this
with (this.RES1)
left = -1.0
top = -1.0
database = form.ets1
sql = 'Select * from "res.db"'
endwith
this.PASSWORDS1 = new QUERY()
this.PASSWORDS1.parent = this
with (this.PASSWORDS1)
left = 125.0
top = 45.0
width = 114.0
height = 128.0
database = form.ets1
sql = 'Select * from "passwords"'
active = true
endwith
endclass
--
Thanks.
Glenn Johansen
Software Architects, Inc.
Post by Ken Mayer [dBASE, Inc.]I have created a new database connection to an Access 2000 or greater .mdb.
There are five tables in the database. I can access all but one table.
Any help would be very much appreciated.
Please don't give us screen shots, but instead, provide the exact
wording *and steps* needed to see the error.
(See the message "Guidelines for Posting Bug Reports", posted in this
newsgroup January 1, 2004.)
Ken
---
Ken Mayer [dBASE, Inc.]
** Please respond ONLY in the newsgroups **
"Think OOP"
dBASE, Inc. website: http://www.dbase.com