create table Employees
(
 EmployeeID integer
   generated by default as identity (start with 0, increment by 1)
   not null,
 LastName char varying (20) collate enu not null,
 FirstName char varying (10) collate enu not null,
 Title char varying (30) collate enu,
 TitleOfCourtesy char varying (25) collate enu,
 BirthDate date,
 HireDate date,
 Address char varying (60) collate enu,
 City char varying (15) collate enu,
 Region char varying (15) collate enu,
 PostalCode char varying (10) collate enu,
 Country char varying (15) collate enu,
 HomePhone char varying (24) collate enu,
 Extension char varying (4) collate enu,
 Photo blob,
 Notes clob collate enu,
 ReportsTo integer,
 PhotoPath char varying (255) collate enu,
 constraint pk_Employees primary key (EmployeeID),
 constraint ck_Birthdate check (BirthDate < current_date)
);

insert into Employees
(
 LastName,
 FirstName,
 Title,
 TitleOfCourtesy,
 BirthDate,
 HireDate,
 Address,
 City,
 Region,
 PostalCode,
 Country,
 HomePhone,
 Extension,
 Photo,
 Notes,
 ReportsTo,
 PhotoPath
)
values
(
 'Davolio',
 'Nancy',
 'Sales Representative',
 'Ms.',
 date'1948-12-08',
 date'1992-05-01',
 '507 - 20th Ave. E.'||#13||#10||'Apt. 2A',
 'Seattle',
 'WA',
 '98122',
 'USA',
 '(206) 555-9857',
 '5467',
 null,
 'Education includes a BA in psychology from Colorado State University in
1970.  She also completed "The Art of the Cold Call."  Nancy is a member of
Toastmasters International.',
 2,
 'http://accweb/emmployees/davolio.bmp'
);

create table Employees_2
(
 EmployeeID integer
   generated by default as identity (start with 0, increment by 1)
   not null,
 LastName char varying (20) collate enu not null,
 FirstName char varying (10) collate enu not null,
 Title char varying (30) collate enu,
 TitleOfCourtesy char varying (25) collate enu,
 BirthDate date,
 HireDate date,
 Address char varying (60) collate enu,
 City char varying (15) collate enu,
 Region char varying (15) collate enu,
 PostalCode char varying (10) collate enu,
 Country char varying (15) collate enu,
 HomePhone char varying (24) collate enu,
 Extension char varying (4) collate enu,
 Photo blob,
 Notes clob collate enu,
 ReportsTo integer,
 PhotoPath char varying (255) collate enu,
 constraint pk_Employees_2 primary key (EmployeeID),
 constraint ck_Birthdate_2 check (BirthDate < current_date)
);

Issue 1)

insert into Employees_2
(
 LastName,
 FirstName,
 Title,
 TitleOfCourtesy,
 BirthDate,
 HireDate,
 Address,
 City,
 Region,
 PostalCode,
 Country,
 HomePhone,
 Extension,
 Photo,
 Notes,
 ReportsTo,
 PhotoPath
)
select
 LastName,
 FirstName,
 Title,
 TitleOfCourtesy,
 BirthDate,
 HireDate,
 Address,
 City,
 Region,
 PostalCode,
 Country,
 HomePhone,
 Extension,
 Photo,
 Notes,
 ReportsTo,
 PhotoPath
from Employees

Error:
Access violation at address
0051136A in module 'edbmgr.exe'.
Read of address 00000004

Issue 2)

I've exported the Employees data to a csv file. When importing the data from
Employees_2 using the csv file, I'm getting the following error:

ElevateDB Error #1003 The check constraint ck_Birthdate_2 has been violated
(Check expression evaluated to False)

The csv file has the following content:

1,1,"Davolio","Nancy","Sales
Representative","Ms.",1948-12-08,1992-05-01,"507 - 20th Ave. E.#13#10Apt.
2A","Seattle","WA","98122","USA","(206) 555-9857","5467",,"Education
includes a BA in psychology from Colorado State University in 1970.  She
also completed "The Art of the Cold Call."  Nancy is a member of
Toastmasters International.",2,"http://accweb/emmployees/davolio.bmp"

Ole Willy Tuv

"Ole Willy Tuv" <owtuv@online.no> wrote in message
news:928DB9FC-7BF2-43B7-B46E-80EAE5122041@news.elevatesoft.com...
> values
> (
>   'Davolio',
>   'Nancy',
>   'Sales Representative',
>   'Ms.',
>   date'1948-12-08',
>   date'1992-05-01',
>   '507 - 20th Ave. E.'||#13||#10||'Apt. 2A',
>   'Seattle',
>   'WA',
>   '98122',
>   'USA',
>   '(206) 555-9857',

Ole --

It's funny to see someone using some of my old sample data!!!    

No problem, of course, anything you got from me is all "non-real" data.

Cheers,

Herb

Hi Herb,

I think that data is actually from the SQLServer "Northwind" sample
database.

--
Best regards

Steve

"Herbert Sitz" <hsitz@nwlink.com> wrote in message
news:D89A0A29-13A1-4C79-9962-90A67E14CF7F@news.elevatesoft.com...
> "Ole Willy Tuv" <owtuv@online.no> wrote in message
> news:928DB9FC-7BF2-43B7-B46E-80EAE5122041@news.elevatesoft.com...
>> values
>> (
>>   'Davolio',
>>   'Nancy',
>>   'Sales Representative',
>>   'Ms.',
>>   date'1948-12-08',
>>   date'1992-05-01',
>>   '507 - 20th Ave. E.'||#13||#10||'Apt. 2A',
>>   'Seattle',
>>   'WA',
>>   '98122',
>>   'USA',
>>   '(206) 555-9857',
>
> Ole --
>
> It's funny to see someone using some of my old sample data!!!    
>
> No problem, of course, anything you got from me is all "non-real" data.
>
> Cheers,
>
> Herb
>
>

Ole,

Noted.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Steve Forbes" <ozmosys@spamfreeoptusnet.com.au> wrote in message
news:1ADB8865-E369-4F5A-9A6C-15552D6FDE0F@news.elevatesoft.com...
> Hi Herb,
>
> I think that data is actually from the SQLServer "Northwind" sample
> database.
>
> --
> Best regards
>
> Steve
>

Steve -- Haha, I'm sure you're right. Funny how my brain works.  I put these
few factoids together and assumed it was from my own sample data:

1.  Ole had access to some of my sample data a long time ago to diagnose
some issues.
2.  I had created some person names and had a strange last name beginning
with 'D' that I used a lot.  (Turns out I was thinking of my 'Dalinada'
name, and Ole's was 'Davolio'.)
3.  I used to live in the 98122 zip code a few blocks away from the address
of Ole's Nancy Davolio, and I created a lot of sample data with addresses in
that zip code.  (Of course, Microsoft is located not far from there, too.)

Thanks for the correction.

Cheers,

Herb

Hi Herb,

<< I used to live in the 98122 zip code a few blocks away from the address
of Ole's Nancy Davolio, and I created a lot of sample data with addresses in
that zip code.  >>

If you're visiting your old neighborhood, please say hello to Nancy from me


Ole

Ole,

This is all fixed.  There were several issues at play here, including the
import/export still using the RowID column (note the two 1's in the export
file).

--
Tim Young
Elevate Software
www.elevatesoft.com

"Ole Willy Tuv" <owtuv@online.no> wrote in message
news:1709E7C7-06B3-4864-840F-B6B948969D96@news.elevatesoft.com...
> Hi Herb,
>
> << I used to live in the 98122 zip code a few blocks away from the address
> of Ole's Nancy Davolio, and I created a lot of sample data with addresses
in
> that zip code.  >>
>
> If you're visiting your old neighborhood, please say hello to Nancy from
me
>
>
> Ole
>

Will do.  

I've been stuck in the hinterlands of Nebraska for the last year, but I'm
hoping to move back to Seattle soon.

-- Herb