I have it working, Kari, but I have to get the security hooks to the point that the framework is stable before I can release it.  We finished the security editors yesterday, so I believe I'll have the update posted by the end of the weekend.  Sorry for the delay, but the security and these fixes will be worth it.

Hi,

any news on the fix for Oracle? I today (20-JUL-06) downloaded the SF Installation package for DevEx 6.15 and tested the Oracle update. The " AND AND AND " problem is still open, I quess...?

Cheers,

Kari

It's in the works, and I'm running the changes through the unit tests to iron out any other issues.

Hi,

any news relating the Oracle update probkem...?

Cheers,

Kari

Kari,

I am answering this from the floor of Tech-Ed and we will be out of the office all week.  We will get your problem resolve first thing when we get back.  Sorry for any trouble.

Hi,

just downloaded the latest (8.6.2006) version of SF but the problem updating Oracle database still seems to be there....

Any estimate when the final version of 1.4.1 will be available?

Cheers

Kari

Well, Kari, that's what I would call a bug

I'll get it fixed and post you an update ASAP.  Thanks for the help.  I'll have to take a look at my unit tests and figure out why that one wasn't picked up...

Hi Ben,

and thanks for all the help. The new SF showed nicely what was the problem. As I read it,  SF adds a couple of extra "AND"'s into the update's where clause:

UPDATE "RESYS"."EMP" SET "EMP_NAME" = :EMP_NAME WHERE "EMP_NO" = :EMP_NO AND AND AND (("EMP_NAME" = :EMP_NAME_ORG) OR ((:EMP_NAME_ORG IS NULL) AND ("EMP_NAME" IS NULL)))

Here is the SQL for the table

===================================================
-- Table EMP

CREATE TABLE emp
 (
  emp_no                     NUMBER(10) NOT NULL,
  emp_name                   VARCHAR2(50)
 ;

-- Constraints for EMP

ALTER TABLE emp
 ADD CONSTRAINT pk_emp PRIMARY KEY (emp_no);

INSERT INTO EMP (EMP_NO, EMP_NAME) VALUES (1,'Bart Simpson');
=====================================================

Attached is the full debug.html file in PDF format.  What I did was 1) retrieve the data => ok, 2) update the EMP_NAME to 'Bart Simpson testing update' => error. I'm using Oracle 10gR2 running on a WinXP machine.

Hope this helps,

Kari

OK, Kari, here's the maintenance install.  Just let me know what you find.  You'll have to pull the setup exe out of the zip file... the forum won't let you upload executables.

Thanks

Well, Kari, I'm not sure why the debug isn't working, but I'm building you a maintenance release right now that has some additional debugging information.  You can install this one and just leave it installed, don't worry about going back to the pre-release.

Once you get it installed, it should give you more information in the debug file.  Also, if you can get the version of Oracle that you're running, the table structure (screenshot or CREATE TABLE script would be fine), and the .Designer.vb file for the business object and post those with the output from the debug file, it will go a long way towards helping me to reproduce the error. 

Let me know Thanks

P.S.  I'll post the maintenance install here in a second.