Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Public Beta Tests » View Thread |
Messages 1 to 8 of 8 total |
Insert issues |
Wed, Jan 10 2007 12:50 PM | Permanent Link |
"Ole Willy Tuv" | 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 |
Wed, Jan 10 2007 2:50 PM | Permanent Link |
"Herbert Sitz" | "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 |
Wed, Jan 10 2007 5:26 PM | Permanent Link |
Steve Forbes Team Elevate | 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 > > |
Wed, Jan 10 2007 5:59 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | |
Wed, Jan 10 2007 9:28 PM | Permanent Link |
"Herbert Sitz" | "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 |
Thu, Jan 11 2007 3:21 AM | Permanent Link |
"Ole Willy Tuv" | 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 |
Thu, Jan 11 2007 6:34 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, Jan 11 2007 3:41 PM | Permanent Link |
"Herbert Sitz" | "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 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |