I used CxnEditor to create a connection file to my Sqlite database. I selected Edit Name for the connection name and gave it the name ChartAccountsConnection. I Selected Test to verify and then Save under name ChartAccountsConnection.cnxml. The ChartAccountsConnection.cnxml contains inside. Note: <database>ChartAccounts.sqlite</database>
<?xml version="1.0" encoding="utf-8" standalone="yes"?> <connectiondefs xmlns="http://www.dabodev.com"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://www.dabodev.com conn.xsd" xsi:noNamespaceSchemaLocation = "http://dabodev.com/schema/conn.xsd";> <connection dbtype="SQLite"> <name>ChartAccountsConnection</name> <host></host> <database>ChartAccounts.sqlite</database> <user></user> <password></password> <port></port> </connection> </connectiondefs> When I run the ClassDesigner just like in the ScreenCast Building a Database Application Part 1 where you select "Add Controls to Data Environment" the window Select Data Connection I select "Open a Connection File: then I select ChartAccountsConnection. When I select Next > Select Fields to Add Window in the Select Table there is no tables shown. To fix the problem I had to change in my ChartAccountsConnection.cnxml file the line: <database>ChartAccounts.sqlite</database> To the new line: <database>/home/bob/00Project/ChartAccounts.sqlite</database> This solved the problem. I also found but can't dupplicated the problem that one time the line was: <database>../ChartAccounts.sqlite</database> Then in the ClassEditor I got the message could not make connection. Bob _______________________________________________ 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]
