[V4MD] Intermittent setMedia

[Ruslan Zasukhin]

On 5/11/04 8:48 PM, "Scott Runkel" <srunkel at hypix.com> wrote:

Hi Scott,

1) a couple of times such strange glitches was caused by corrupted Director
projector. Director have someway to repair it seems. Please check this
point.

2) this is exactly not an issue with locks.
Because most records work correctly and there is no 363 error code.

3) I wonder why you store into BLOB but not into TEXT field?


> I'm using setMedia in Director to place #text members into BLOB fields. It
> works
> fine about 98% of the time, but a small percentage of the time it fails. There
> is no error reported upon setMedia or getMedia, but when I use getMedia there
> is
> just nothing there sometimes. These failures are totally unpredictable. One
> time
> I will loop through 250 #text members and put them all into the database, and
> certain ones (5 to 10 of them) will be missing. The next time, it will be a
> different set, and ones that were fine are no longer there. These are pretty
> small #text members, less than a page, nothing fancy, Arial, no tables or
> anything.
> 
> Other times there will be one or two members that crash Director completely
> when
> I try to use getMedia on them (DMX, Windows XP).
> 
> I seem to be able to fix both problems by using setMedia again directly on the
> problematic item (as opposed to my loop below). The code is the same, however,
> except for the looping part.
> 
> For the cursor locktype for setMedia, I have tried readwrite (3) and nolock
> (1)
> and both have the same problem.
> 
> The BLOB field settings are segment size 128, no encryption, not indexed, not
> unique, not nullable, not compressed.
> 
> Here's my code for setMedia:
> 
> sql = "select * from sa where year = " & whichYear
> 
> goCursor = new(Xtra "VCursor", GetRef(goDB), sql, 2, 1, 2)
> 
> yearCount = getRecordCount(goCursor)
> 
> repeat with x = 1 to yearCount
>   goToRecord(goCursor, x)
> 
>   critiqueMemberName = "SAC-" & string(whichYear) & "-" & string(pad(x))
> 
>   SetMedia (goCursor, "mediac", member critiqueMemberName)
>   put valentinaError()
> 
>   UpdateRecord(goCursor)
> end repeat
> Flush( goDB )
> 
> Here's my code for getMedia:
> 
> cursor = new(Xtra "VCursor", GetRef(pDB), sql, 2, 2, 2)
> GetMedia (cursor, "mediac", member "TEXT:Current Critique" )
> 
> -SR

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------