Valentina for Director fails to update db on OSX

[Jonkman, Mark]

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