On Nov 10, 2008, at 11:20 PM, Roger Lovelock wrote:
> The problem I reported with the table drop down list not being
> poulated in the ClassDesigner when creating controls from a data
> environment appears to be because of some strange behaviour with the
> Connection Editor. I noticed that an empty sqlite database (no
> tables) had been created in the ide directory within dabo (which I
> guess is where the connection editor is being run). If the class
> designer is accessing this database it would explain the behaviour
> being observed.
This is a problem (feature?) of sqlite. If you specify an incorrect
location for the file, sqlite will happily create a brand-new database
file in that location. This is what you're seeing.
That, IMO, is a serious flaw with using a file-based database. It
makes pathing so much more difficult, requiring absolute path
specifications to work consistently, and these are fragile
> When I created the connection I put in the full path fom c: to the
> actual location of the database (in my projects db directory). When
> I go back in to the connection editor the path has changed to the
> path of the dabo ide directory!
> I will try running both the connection editor and the class
> designer from within the project directory (and perhaps also using
> relative paths).
The connection editor stores relative paths, as this is more
portable. If you were to create an app and install it on another
machine, hard-coded paths would break. The only workable, non-brittle
solution for file-based databases is to keep the database file in the
same directory as the .cnxml file.
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
