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, Jun 15 2010 4:09 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	I mistyped a simple sql statement select * from calls wherte _lastdialed is null and received an error message ElevateDB Error #700 An error was found in the statement at line 1 and column 28 (Expected end of expression but instead found _lastdialed) Shouldn't it have at least mentioned "wherte"? Roy Lambert
Tue, Jun 15 2010 4:28 AM	Permanent Link
Charles Tyson	Wherte was interpreted as a legal alias for calls, so it couldn't see an error there. On 6/15/2010 1:09 AM, Roy Lambert wrote: > I mistyped a simple sql statement > > select * from calls wherte _lastdialed is null > > and received an error message > > ElevateDB Error #700 An error was found in the statement at line 1 and column 28 (Expected end of expression but instead found _lastdialed) > > Shouldn't it have at least mentioned "wherte"? > > > Roy Lambert
Tue, Jun 15 2010 4:54 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Charles Very good point and it shows how often I use aliases. Roy Lambert