Before I report this as a bug can someone confirm it please.

I thought I'd see if I could help Steve with his phone number formatting question so I created a table

CREATE TABLE "Phone"
(
"Entered" VARCHAR(20) COLLATE "ANSI_CI",
"Modded" VARCHAR(20) COLLATE "ANSI_CI" COMPUTED ALWAYS AS Entered
)


To start with I thought I'd just use Entered as the computation just to get something to work with.

Opened the table in EDBManager and entered 1 into Entered - wallop

---------------------------
ElevateDB Manager
---------------------------
Access violation at address 005ECF95 in module 'edbmgr.exe'. Read of address 00000040.
---------------------------
OK  
---------------------------

Using 2.19b2

Roy Lambert

If I alter the table to



CREATE TABLE "Phone"
(
"Entered" VARCHAR(20) COLLATE "ANSI_CI",
"Modded" VARCHAR(20) COLLATE "ANSI_CI" COMPUTED ALWAYS AS COALESCE(Entered,'')
)

It works but I don't think I should have to do that.

Roy Lambert

Hi Roy,

> Before I report this as a bug can someone confirm it please.

I can reproduce this here on my side as well.

---------------------------------------
Terry Swiers
Millennium Software, Inc.
---------------------------------------

Roy,

<< To start with I thought I'd just use Entered as the computation just to get something to work with. >>

That was the issue - EDB isn't handling a single column reference properly.  Believe it or not, it's never been tried, apparently.

Tim Young
Elevate Software
www.elevatesoft.com

Tim


><< To start with I thought I'd just use Entered as the computation just to get something to work with. >>
>
>That was the issue - EDB isn't handling a single column reference properly. Believe it or not, it's never been tried, apparently.

Oh yes I do believe it. The number of times I've been bitten by the "nobody in their right minds would...." . Lets just say I'm glad its not a midge doing the biting.

Roy