[V4MD] a couple of problems

Erich Geiersberger erichg at mcmm.com
Mon Jun 27 11:04:44 CDT 2005


>  > Hi Ruslan and list,
>>
>>  we are currently trying to get a project finished which has been
>>  started with version 1.11.
>
>>  It uses picture fields.
>>  We need to know if a picture has been uploaded to the database but it
>>  seems that this does not work with version 1.11. The reference says
>>  that if there is no picture in the field it would return null but it
>>  fact it returns an object reference even if there is no picture in a
>>  field.
>
>Wait. The docs means next:
>
>Let you do query:
>    
>     SELECT fldPicture FROM T
>
>Now you have cursor. To see if current record have picture you can do
>
>    if curs.Field("fldPicture").IsNull()
>        -- there is no picture
>    else
>        -- we have picture so we read it
>        curs.Field("fldPicture").GetPicture()
>    end if
>
>
>So NULL - means the VALUE NULL of database
>You it seems expect NULL for object reference.
>These are different things.


IsNull() does not help.  It returns true in version 1.11 even if 
there is a picture in the database.

I also didn't find a method to delete a picture.
setPicture(myCursor, myPictureField, void)?
setNull(myCursor, myPictureField)?

(Director 8.5.1, OS 9.2, V4MD 1.11)



And the version 2 picture example seems to be broken, too.
Just try your example. If I add and delete a picture, then delete the 
database start the movie and stop it again it suddenly crashes after 
the second or third try.
(Director MX, OSX 10.2.8, V4MD_Carbon 2.0.3)
OK, this one seems to be fixed with the current Beta.

There is also no description in the version 2 docs on how to delete a picture.



Erich


More information about the Valentina mailing list