I am getting this error:

DBISAM Engine Error # 11949 SQL error - 'Right parentheses expected, instead found 'max'
in value expression'


When I run this query:

update Highest_Taste_Value
 set HighestKnownTaste = (select max(TasteValue) from FlavorList where TasteType=1 and
TasteCurrent=1)


How can I make this fly?

Thanks!

Also: Running a recent (within five months) build of DBISAM v4

"Sam Jones" <sjones9@gmail.com> wrote in message
news:546CEB8F-00B8-410A-AC9E-54213F7A7AF2@news.elevatesoft.com...
>I am getting this error:
>
> DBISAM Engine Error # 11949 SQL error - 'Right parentheses expected,
> instead found 'max'
> in value expression'
>
>
> When I run this query:
>
> update Highest_Taste_Value
>  set HighestKnownTaste = (select max(TasteValue) from FlavorList where
> TasteType=1 and
> TasteCurrent=1)
>

Use a script

select max(TasteValue) MaxTaste into memory\temp from FlavorList where etc;
update Highest_Taste_Value
set HighestKnownTaste = Maxtaste
from Highest_Taste_Value, memory\temp;

Robert

Sam,

<< When I run this query:

update Highest_Taste_Value
 set HighestKnownTaste = (select max(TasteValue) from FlavorList where
TasteType=1 and TasteCurrent=1) >>

You can't use sub-queries with anything other than IN in DBISAM.  Robert's
suggestion to use two statements in a script would be the proper workaround.

--
Tim Young
Elevate Software
www.elevatesoft.com