http://www.sqlpower.ca/forum/forums/show/2.page JForum - http://www.jforum.net
I'm using Power Architect (PA) to design data models, however I'm not soing it by myself. So I use git, the VCS I use for many other stuff, to share the files and maintain history and editors. So far so good.

The issue is when there is a conflict, which, in the case of PA format, happens if a user touches the same file I'm about to edit. This other user does not have to had made any changes to the file, just opening the file alter a lot of the structure.

So I have to improvise a locking system to no other user edit the same file I'm working on. Seams a little ancient this technique and at the same time totally breaks the development workflow.

Anyone has any suggestion on how to achieve what I want?

Does SQL Power plans to do something in the future to avoid this situations? Like trying to make a cleaner file format, if possible?

Thanks in advance

Best regards,

RS]]> http://www.sqlpower.ca/forum/posts/preList/2808/6360.page http://www.sqlpower.ca/forum/posts/preList/2808/6360.page GMT
For the non windows folks, normally when you connect to a SQL Server named instance, you specify the SQL Server like this

mywindowsserver\mysqlservernamedinstance

This is not a firewall or sql server issue, all other windows-friendly client applications can connect to the sql server instance both locally and remotely.

Thanks

[img]
http://matthewjamesbriggs.com/imghost/SqlServerNamedInstance.PNG
[\img]
]]> http://www.sqlpower.ca/forum/posts/preList/2807/6355.page http://www.sqlpower.ca/forum/posts/preList/2807/6355.page GMT
I have a problem with foreign keys. I tried to search, but couldn't find any solutions.

Maybe I'm doing something wrong, but sometimes when I add a relationship SQL power architect adds all foreign keys from referenced table.

Let's say I have comment_rating table and comment table. In comment_rating table I have cmnt_id which is foreign key of column cmnt_id in comment table. But when I want to make FK of the cmnt_id, I end up with usr_id FK, st_id FK and ent_id FK which are foreign keys from comment table...

Is this some kind of bug, or am I doing something wrong? Please help me, 'cos otherwise SQL Power Architect rocks]]> http://www.sqlpower.ca/forum/posts/preList/2806/6354.page http://www.sqlpower.ca/forum/posts/preList/2806/6354.page GMT
Note I also had an anomaly with a column -- I created a new (non-PK) column on a table, and later noticed that it was in several tables, including in the original table as both a PK and a non-PK column. It took me a while to clear this bad column out -- it would not let me delete. Instead, I found I could create a dummy table, move the column to that table, and then delete the dummy table. I repeated that until it was gone everywhere, and then recreated the column in the table where it should have been.

Is my data model corrupt now? Any way to fix it if so?

Thanks,
ken

Error stack trace for compare:

[code]java.lang.NullPointerException
at ca.sqlpower.architect.ddl.GenericDDLGenerator.addRelationship(GenericDDLGenerator.java:341)
at ca.sqlpower.architect.swingui.CompareDMFormatter.sqlScriptGenerator(CompareDMFormatter.java:276)
at ca.sqlpower.architect.swingui.CompareDMFormatter.formatForSQLOutput(CompareDMFormatter.java:190)
at ca.sqlpower.architect.swingui.CompareDMPanel$StartCompareAction$1.cleanup(CompareDMPanel.java:1373)
at ca.sqlpower.swingui.SPSwingWorker$1.run(SPSwingWorker.java:114)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)[/code]]]> http://www.sqlpower.ca/forum/posts/preList/2799/6343.page http://www.sqlpower.ca/forum/posts/preList/2799/6343.page GMT it's my first use of power architect
and i am trying to connect to sql server 2005 (Express) db on a remote machine (i can connect to it successfully from Microsoft sql server management studio express)

here's what i tried:

Database Type: SQL Server 2005
Hostname: 192.168.1.56
Port:1433
JDBC URL:jdbc:sqlserver://192.168.1.56:1433
Username:***
Password:***

when i try to test the connection, i get following exception:


[code]com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 192.168.1.56, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1049)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:833)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:716)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:841)
at ca.sqlpower.sql.JDBCDataSource.createConnection(JDBCDataSource.java:296)
at ca.sqlpower.swingui.JDBCDataSourcePanel$1.actionPerformed(JDBCDataSourcePanel.java:168)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)[/code]

please advise.
]]> http://www.sqlpower.ca/forum/posts/preList/2798/6341.page http://www.sqlpower.ca/forum/posts/preList/2798/6341.page GMT It should be noted that I am very new to SQL and Power Architect. I'm working on a simple project in which we are simply improving a classmates logical model. While completing this process I somehow messed things up huge. I get the following error code-

"Could Not Launch the SQL Power Architect

Exception type: ca.sqlpower.sqlobject.SQLObjectException

Detail string: There is an XML parsing error in project file at LIne:9 Column:41

Root Cause: Error at (9, 41:null

Followed by...

ca.sqlpower.sqlobject.SQLObjectException: There is an XML parsing error in project file at Line:9 Column:41
at ca.sqlpower.architect.ProjectLoader.load(ProjectLoader.java:209)
at ca.sqlpower.architect.swingui.SwingUIProjectLoader.load(SwingUIProjectLoader.java:195)
at ca.sqlpower.architect.swingui.ArchitectSwingSessionContextImpl.createSession(ArchitectSwingSessionContextImpl.java:211)
at ca.sqlpower.architect.swingui.ArchitectFrame$11.run(ArchitectFrame.java:819)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: org.xml.sax.SAXParseException; lineNumber: 9; columnNumber: 41; Error at (9, 41: null
at org.apache.commons.digester.Digester.createSAXException(Digester.java:2540)
at org.apache.commons.digester.Digester.createSAXException(Digester.java:2566)
at org.apache.commons.digester.Digester.startElement(Digester.java:1276)
at ca.sqlpower.xml.UnescapingDefaultHandler.startElement(UnescapingDefaultHandler.java:235)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at ca.sqlpower.xml.UnescapingXMLReader.parse(UnescapingXMLReader.java:99)
at org.apache.commons.digester.Digester.parse(Digester.java:1567)
at ca.sqlpower.architect.ProjectLoader.load(ProjectLoader.java:198)
... 17 more
Caused by: java.lang.NullPointerException
at ca.sqlpower.sqlobject.SQLDatabase.setDataSource(SQLDatabase.java:464)
at ca.sqlpower.architect.ProjectLoader$TargetDBFactory.createObject(ProjectLoader.java:472)
at org.apache.commons.digester.FactoryCreateRule.begin(FactoryCreateRule.java:429)
at org.apache.commons.digester.Digester.startElement(Digester.java:1273)
... 31 more

Anyone have any ideas on A. What I did wrong? B. How to fix it?

Thank you for help.

Edit: where the emoticon appears should read (ProjectLoader.java:198.) (without the period after the 8.)

Edit 2: Trying to attach files, but Attach Files Button is not responding, not sure if I lack sufficient clearance to post files, but if anyone is able to help I can send those to you.

After searching some more, it seems that this solution might be some help
http://www.sqlpower.ca/forum/posts/list/2136.page

However I am still struggling a bit in finding the empty table-ref ]]> http://www.sqlpower.ca/forum/posts/preList/2797/6337.page http://www.sqlpower.ca/forum/posts/preList/2797/6337.page GMT
is their a possibility to connect the Power Architect with a Firebird embedded Database?

Thanks for your help.

Balian]]> http://www.sqlpower.ca/forum/posts/preList/2790/6324.page http://www.sqlpower.ca/forum/posts/preList/2790/6324.page GMT
ca.sqlpower.sqlobject.SQLObjectException: Couldn't connect to database: JDBC Driver "oracle.jdbc.OracleDriver" not found.
at ca.sqlpower.sqlobject.SQLDatabase.getConnection(SQLDatabase.java:685)
at ca.sqlpower.sqlobject.SQLDatabase.populateImpl(SQLDatabase.java:153)
at ca.sqlpower.sqlobject.SQLObject.populate(SQLObject.java:186)
at ca.sqlpower.sqlobject.SQLObject.getChildCount(SQLObject.java:332)
at ca.sqlpower.architect.swingui.DBTree$PokeDBWorker.pokeDatabase(DBTree.java:814)
at ca.sqlpower.architect.swingui.DBTree$PokeDBWorker.doStuff(DBTree.java:799)
at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:104)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: JDBC Driver "oracle.jdbc.OracleDriver" not found.
at ca.sqlpower.sql.JDBCDataSource.createConnection(JDBCDataSource.java:309)
at ca.sqlpower.sql.JDBCDSConnectionFactory.createConnection(JDBCDSConnectionFactory.java:42)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1140)
at ca.sqlpower.sqlobject.SQLDatabase.getConnection(SQLDatabase.java:683)
... 7 more
Caused by: java.lang.ClassNotFoundException: Could not locate class oracle.jdbc.OracleDriver in any of the JDBC Driver JAR files: []
at ca.sqlpower.sql.JDBCDataSourceType$JDBCClassLoader.findClass(JDBCDataSourceType.java:239)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at ca.sqlpower.sql.JDBCDataSource.createConnection(JDBCDataSource.java:274)
... 11 more


I am facing above error while connecting to oracle 10g server using SQL power Architect ,pls advise in this regard.]]> http://www.sqlpower.ca/forum/posts/preList/2786/6319.page http://www.sqlpower.ca/forum/posts/preList/2786/6319.page GMT
Is there a way to define a default of these settings, for all new models? I don't see anything under the Preferences.

thanks.]]> http://www.sqlpower.ca/forum/posts/preList/2783/6314.page http://www.sqlpower.ca/forum/posts/preList/2783/6314.page GMT

This is with 1.0.6]]> http://www.sqlpower.ca/forum/posts/preList/2782/6313.page http://www.sqlpower.ca/forum/posts/preList/2782/6313.page GMT
I tried to reverse engineer an exisiting MySQL schema by dragging it to the work area. Power Architect displays all the entities but not any of the referential constraints. Is this normal? Thank you.

Cheers,
Xiao

SQL Power Architect 1.0.6
Copyright 2003-2010 SQL Power Group Inc.

Operating System:
Windows 7 6.1 (amd64)

Runtime Environment:
Java(TM) SE Runtime Environment
1.6.0_25-b06

VM info:
Java HotSpot(TM) 64-Bit Server VM
20.0-b11
Sun Microsystems Inc.

Memory:
27MiB allocated (580MiB max); 15MiB free]]> http://www.sqlpower.ca/forum/posts/preList/2777/6303.page http://www.sqlpower.ca/forum/posts/preList/2777/6303.page GMT
I cannot understand how the tool can be connected successfully, show the tables/properties, etc, but not able to profile the same tables?
The fully-qualified table names listed in the errors are correct in every case.

What am I missing here?

Thanks in advance!

Configs and details on the error below:

I followed the instructions on JDBC driver installation and connected to the database successfully using URL:
jdbc:sqlserver://127.0.0.1:1433;integratedSecurity=true;


Software used:
SQL Power Architect 1.0.6
Copyright 2003-2010 SQL Power Group Inc.

Operating System:
Windows 2003 5.2 (x86)

Runtime Environment:
Java(TM) SE Runtime Environment
1.6.0_25-b06

Microsoft SQL Server Management Studio 9.00.4035.00
Microsoft Analysis Services Client Tools 2005.090.4035.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 6.0.3790.3959
Microsoft .NET Framework 2.0.50727.1433
Operating System 5.2.3790

Details on the error:
java.lang.Exception: java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'CorporateSuppression'.
at ca.sqlpower.architect.profile.RemoteDatabaseProfileCreator.doProfileImpl(RemoteDatabaseProfileCreator.java:225)
at ca.sqlpower.architect.profile.AbstractTableProfileCreator.doProfile(AbstractTableProfileCreator.java:54)
at ca.sqlpower.architect.profile.ProfileManagerImpl$ProfileResultCallable.call(ProfileManagerImpl.java:246)
at ca.sqlpower.architect.profile.ProfileManagerImpl$ProfileResultCallable.call(ProfileManagerImpl.java:188)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'CorporateSuppression'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:611)
at ca.sqlpower.sql.jdbcwrapper.StatementDecorator.executeQuery(StatementDecorator.java:117)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at ca.sqlpower.architect.profile.RemoteDatabaseProfileCreator.doTableProfile(RemoteDatabaseProfileCreator.java:265)
at ca.sqlpower.architect.profile.RemoteDatabaseProfileCreator.doProfileImpl(RemoteDatabaseProfileCreator.java:210)
... 8 more

at ca.sqlpower.dao.session.SessionPersisterSuperConverter.convertToComplexType(SessionPersisterSuperConverter.java:304)
at ca.sqlpower.architect.profile.generated.AbstractProfileResultPersisterHelper.commitProperty(AbstractProfileResultPersisterHelper.java:49)
at ca.sqlpower.architect.profile.generated.TableProfileResultPersisterHelper.commitProperty(TableProfileResultPersisterHelper.java:66)
at ca.sqlpower.dao.SPSessionPersister.commitProperties(SPSessionPersister.java:1198)
at ca.sqlpower.dao.SPSessionPersister.commit(SPSessionPersister.java:478)
at ca.sqlpower.dao.SPPersisterListener.commit(SPPersisterListener.java:529)
at ca.sqlpower.dao.SPPersisterListener.transactionEnded(SPPersisterListener.java:374)
at ca.sqlpower.dao.SPPersisterListener.persistObject(SPPersisterListener.java:252)
at ca.sqlpower.architect.profile.ProfileManagerImpl$ProfileResultCallable$1.run(ProfileManagerImpl.java:267)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
]]> http://www.sqlpower.ca/forum/posts/preList/2774/6295.page http://www.sqlpower.ca/forum/posts/preList/2774/6295.page GMT
Please help
thanks
Raj]]> http://www.sqlpower.ca/forum/posts/preList/2771/6288.page http://www.sqlpower.ca/forum/posts/preList/2771/6288.page GMT
[code]CREATE TABLE t_establishment (
estab_id INT AUTO_INCREMENT NOT NULL,
estab_name VARCHAR(200) NOT NULL,
estab_company VARCHAR(200),
estab_taxnumber VARCHAR(100),
estab_numlike NUMERIC(6) DEFAULT 0 NOT NULL,
PRIMARY KEY (estab_id)
);

ALTER TABLE t_establishment MODIFY COLUMN estab_numlike NUMERIC(6) COMMENT 'my comment';
[/code]
As you can see, the alter table statement wipes out the NOT NULL and DEFAULT setting, so in the database the column can be null and has no default value.

SQL Power Architect 1.0.6

Thanks]]> http://www.sqlpower.ca/forum/posts/preList/2769/6284.page http://www.sqlpower.ca/forum/posts/preList/2769/6284.page GMT Columns id: INTEGER and device_id: INTEGER related by FK constraint have different types, scale, or precision
The cause is that the foreign key allows NULLs which is valid in at least MySQL (right now I'm exporting to postgres which seems to take it fine as well). Not sure if this is valid SQL in the pure sense but it makes a lot of sense to have a zero or one mapping implemented this way (i.e. if it is not NULL it points to the PK of another table.
Version: 1.0.6 on Windows
Database Postgresql version 9 on ubuntu (not connected -- copying sql files around)
Thanks. And by the way, you have done a great job.]]> http://www.sqlpower.ca/forum/posts/preList/2767/6281.page http://www.sqlpower.ca/forum/posts/preList/2767/6281.page GMT