Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Non inserting of data
Sat, Dec 29 2007 11:41 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Why does this not insert any records

insert into fred select * from "nlh-live".users

when there are 8 rows in users?

Roy Lambert
Sat, Dec 29 2007 4:05 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Why does this not insert any records

insert into fred select * from "nlh-live".users

when there are 8 rows in users? >>

It's inserting the rows here, but reporting back an affected row count of 0,
which is a bug.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sun, Dec 30 2007 4:37 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

>It's inserting the rows here, but reporting back an affected row count of 0,
>which is a bug.

I thought I'd looked at the table and couldn't see any (just double checking the affected row count of 0). Maybe I need to refresh the table first. I'll have another go and report back if there's still a problem.

Roy Lambert
Image