Hi,
When we need this, I never use database NULL value for PK, instead I use a String initiated with 'NULL' then the Querys can change
from:
SELECT * FROM table1 WHERE field1 IS NULL AND field2 = '0001'
to:
SELECT * FROM table1WHERE field1 = 'NULL' AND field2 = '0001'
This idea work on any Database, only you must to do is define what is your constant to NULL value.
Hope this help
Clóvis
Nathan Smith wrote:
Hi all,
LabPro 2000 Ltd is a specialist provider of information management
systems including LIMS (Laboratory Information Management Systems). We
here at www.labpro2000.com currently use OJB as part of our eQual
application development (http://demo.labpro2000.com). This is a
redevelopment of the current application Labpro. To put it simply
LabPro, is a QA solution for any testing.
We use an RDBMS developed by a little known company called Progress (http://www.progress.com/progress/index.ssp). The RDBMS is a very good database but not many people have heard of it, so it is not really mainstream.
The problem is this RDBMS allows records to be inserted with blank or null values for fields of the primary key. For example we have a table that uses 7 fields/columns as part of the PK. A record could be inserted with 6 of those fields blank or null. The use of the table is a special case as it defines range limits that testing results must fall within for a particular product to be assigined a quality code. One of the records in this table depending on what fields are blank can used for multiple products. We also have another table which is used in similar fashion
The proposal: Can the repository.xml contain some property or database specific metadata element which can be used to determine whether NULL's or blanks can be used as ligitimate values for PK fields. Or maybe another way would be to enable some sort of callback that can be implemented through the Platform interface.
Look forward to hearing your ideas.
Nathan Smith
Software Developer LabPro 2000 Limited Phone: +64 4 586 6840 Facsimile: +64 4 586 6841 <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] <http://www.labpro2000.com/> www.labpro2000.com
Level 6, Riverside Tower on Daly, 15 Daly Street
Lower Hutt, New Zealand
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]