Valentina for Director fails to update db on OSX

[Jonkman, Mark]

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

Sincerely
Mark R. Jonkman

-----Original Message-----
From: Ruslan Zasukhin [mailto:sunshine at public.kherson.ua]
Sent: Thursday, November 13, 2003 4:31 PM
To: valentina at lists.macserve.net
Subject: Re: Valentina for Director fails to update db on OSX


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

> Hi
> 
> I've been trying all day to work around a problem where the a Valentina
> Database running from Director using the v4md.xtr version 1.9.8 fails to
> allow updates and deletes to the database if the OSX user is not the OSX
> user that owns the .vdb file. If I change the owner of the file to the
user
> using unix commands then I can read and update the database without a
> problem. Regardless of who the database owner is, I can always add records
> to the database, just not updates or deletes. Has anyone else seen this
> problem, know of a workaround? The database is a part of an application
> installed into the global applications folder.

Hi Mark,

No I have not hear about such problem.
Sounds strange. Add works, delete no...

Any error code that Valentina return?


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