Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Tue, Feb 20 2007 6:53 AM	Permanent Link
	Tim, When trying to add a column of type Interval Minute to Millisecond I got the following error: --------------------------- ElevateDB Manager --------------------------- ElevateDB Error #700 An error was found in the statement at line 2 and column 35 (Expected SECOND, MSECOND but instead found MILLISECOND) --------------------------- OK --------------------------- I understand, that you are formatting SQL incorrectly and it should actually say MSECOND, not MILLISECOND. Regards, Michael
Tue, Feb 20 2007 6:55 AM	Permanent Link
	Tim, To my previous post: information schema table returns type as "Interval Minute To MilliSecond". Regards, Michael <support@contextsoft.com> wrote in message news:6975321E-E5FE-40CA-ABD7-42C2E3977258@news.elevatesoft.com... > Tim, > > When trying to add a column of type Interval Minute to Millisecond I got > the following error: > --------------------------- > ElevateDB Manager > --------------------------- > ElevateDB Error #700 An error was found in the statement at line 2 and > column 35 (Expected SECOND, MSECOND but instead found MILLISECOND) > --------------------------- > OK > --------------------------- > > I understand, that you are formatting SQL incorrectly and it should > actually say MSECOND, not > MILLISECOND. > > Regards, > Michael >
Tue, Feb 20 2007 7:29 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Michael, << To my previous post: information schema table returns type as "Interval Minute To MilliSecond". >> Okay, that's an error. It should read MSecond instead. -- Tim Young Elevate Software www.elevatesoft.com