Eiline kreivai suprojektuota duombaze speju.. siaip jei pamatot koks nors default value ne toks koks reikia tai pataisykit geriau greiciau, o ne kaupkit neteisinga info...

> aciu, uzvedei ant reikiamo kelio ;)
> 
> -- 
> Honda Civic '00 EK3 1.5 Vtec-E
> 
> "Linas Petkevičius" <linas@NONONOinfonova.lt> wrote in message news:hjsdre$6ll$1@trimpas.omnitel.net...
>> Neturiu Access po ranka, bet jei gerai pamenu sintakse, tai:
>> 
>> SELECT ArtGroup.ID, ArtGroup.Code, ArtGroup.Description, IIF 
>> (isnull(artGroup.fkBitmap);0;1)  FROM ArtGroup;
>> 
>> 
>> 
>> "Kaksht" <kaksht@cianetikrasmuilas.com> parašė naujienų 
>> news:hjscs7$5i3$1@trimpas.omnitel.net...
>>> jei nesunku uzmesk aki ar taip ar dar selecta reiktu rasyti? cia 
>>> supaprastintas variantas tik isrinkimo
>>>
>>> SELECT ArtGroup.ID, ArtGroup.Code, ArtGroup.Description, (IF 
>>> (ArtGroup.fkBitmap = NULL) OR (ArtGroup.fkBitmap = '0')) '1' ELSE 
>>> (ArtGroup.fkBitmap) )
>>> FROM ArtGroup;
>>>
>>> -- 
>> 
>> 
>>