Valentina for Director fails to update db on OSX

[Jonkman, Mark]

Ruslan

I appear to have solved the issue. The project was inherited from someone
else. They must have previously been using an older version of the xtra.
When I got the project I went out and grabbed the latest version of the xtra
for all platforms. Interestingly enough all worked well except what appeared
to be a permissions thing on OSX. Turns out that in reading the release
notes, you made an adjustment that required the addition of 3 parameters to
the cursor creating process in order to generate a read-write cursor. What I
don't understand is why the same version of the xtra doesn't generate the
same error on OS9 (I checked on both OSX and OS9 I'm using 1.9.8, but on the
PC I had 1.9.7). But if I add in those 3 parameters, the problem "appears"
to go away - at least on an initial spot check).

I guess I'll have to update all platforms to 1.9.8 and send the project back
through testing and see if the 3 parameters added to each cursor doesn't
cause any unforeseen problems. Or will 1.9.7 ignore the extra parameters and
not throw an error on Windows.

Sincerely
Mark R. Jonkman 

-----Original Message-----
From: Jonkman, Mark [mailto:MJONKMAN at plato.com]
Sent: Friday, November 14, 2003 8:00 AM
To: 'Valentina Developers'
Subject: RE: Valentina for Director fails to update db on OSX


Hi Ruslan

No we have the database split into 3 files:

AdminDB.dat
AdminDB.ind
AdminDB.vdb

Thanks

Sincerely
Mark R. Jonkman


-----Original Message-----
From: Ruslan Zasukhin [mailto:sunshine at public.kherson.ua]
Sent: Friday, November 14, 2003 2:41 AM
To: valentina at lists.macserve.net
Subject: Re: Valentina for Director fails to update db on OSX


on 11/14/03 2:57 AM, Jonkman, Mark at MJONKMAN at plato.com wrote:

Hi Mark,

Okay I need check this.

Question: you keep database in the one file only?
            i.e. You use mode 1 for db, yes?

> Hi Ruslan
> 
> Yes, you can add records with no problems.
> If you attempt to delete or modify records it fails silently. I just
walked
> the code in the Director debugger and ValentinaError() shows no errors on
> database open, the sql select, or on the deletes.
> 
> in pseudo code it looks (don't have the code open at the momement)
> 
> open the database
> create cursor using "Select * From student_record WHERE RecID = 23"
> myCursor.DeleteAllRecords()
> close the database
> 
> ValentinaError() is done after each valentina call.. all calls report no
> error (a 0 is returned)
> 
> On all other platforms, the records are deleted (OS9 and all windows
> platforms). Under OSX if the OSX user is the user that "owns" the vdb file
> then the record is deleted. If not, then the record is not deleted.
Copying
> a vdb file from the cd used to install the courseware and overwriting the
> existing one results in everything working. Log back in as a different
user
> and attempt to run the same application results in the records not being
> able to delete again. Whoever has ownership of the vdb file in OSX
> terminology seems to have the rights to delete records and update but
those
> who do not can only add records but not delete records.
> 
> Its really baffling me. It just doesn't make any sense at all.
> 
> We are using a VISE installer to place the original files on the enduser's
> computer. this is done using file copy from the cd vs files packaged into
> the installer. The cd's are hybrid cd's created on OS X 2 using Toast 5.2

-- 
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
-------------------------------------------------------------

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina