Commit unlock wit VISTA
in [Visual Objects]
|
From: Lucas_be on 6 Apr 2008 07:24 I changed my program from VO2.7 to 2.8sp1. I have problems with dbserver:commit() unlock sequence. I always set set Dbserver at CCNONE so I 'm in charge of everything. For example editing a comment field and the saving it I get Errorcode 29 Illlegal reference - Ignore gives a 5333. I never had this before DBFCDX rdd Thanks in advance for all help
From: John Martens on 6 Apr 2008 07:42 Lucas, Changing from 2.7 to 2.8 I had several problems with SetOrder and unlock. Now I'm having a SetOrder and Unlock method for each dbServer like this: METHOD Unlock(nRecordNumber) CLASS myDbServer SELF:Commit() RETURN SUPER:Unlock(nRecordNumber) METHOD SetOrder(uOrder, cIndexFileName) CLASS myDbServer SELF:__OptimisticFlush( ) RETURN SUPER:SetOrder(uOrder, cIndexFileName) It doesn't seem to have much influence on the speeds and I'm not losing data. John Lucas_be schreef: > I changed my program from VO2.7 to 2.8sp1. I have problems with > dbserver:commit() unlock sequence. > I always set set Dbserver at CCNONE so I 'm in charge of everything. > For example editing a comment field and the saving it I get > Errorcode 29 Illlegal reference - Ignore gives a 5333. I never had > this before > DBFCDX rdd > > Thanks in advance for all help
From: Massimo Bighelli on 7 Apr 2008 05:50 John, is your workaround necessary only in optimistic mode ? Massimo "John Martens" <adsl672100(a)tiscali.nl> ha scritto nel messaggio news:47f8b70c$0$24409$5fc3050(a)news.tiscali.nl... > Lucas, > > Changing from 2.7 to 2.8 I had several problems with SetOrder and unlock. > > Now I'm having a SetOrder and Unlock method for each dbServer like this: > > METHOD Unlock(nRecordNumber) CLASS myDbServer > SELF:Commit() > RETURN SUPER:Unlock(nRecordNumber) > > METHOD SetOrder(uOrder, cIndexFileName) CLASS myDbServer > SELF:__OptimisticFlush( ) > RETURN SUPER:SetOrder(uOrder, cIndexFileName) > > It doesn't seem to have much influence on the speeds and I'm not losing > data. > > John > > > Lucas_be schreef: >> I changed my program from VO2.7 to 2.8sp1. I have problems with >> dbserver:commit() unlock sequence. >> I always set set Dbserver at CCNONE so I 'm in charge of everything. >> For example editing a comment field and the saving it I get >> Errorcode 29 Illlegal reference - Ignore gives a 5333. I never had >> this before >> DBFCDX rdd >> >> Thanks in advance for all help
From: John Martens on 7 Apr 2008 08:34 Massimo, I use no explicit setting for locking. So I think I'm on optimistic. John Massimo Bighelli schreef: > > John, > > is your workaround necessary only in optimistic mode ? > > Massimo > > > > "John Martens" <adsl672100(a)tiscali.nl> ha scritto nel messaggio > news:47f8b70c$0$24409$5fc3050(a)news.tiscali.nl... >> Lucas, >> >> Changing from 2.7 to 2.8 I had several problems with SetOrder and unlock. >> >> Now I'm having a SetOrder and Unlock method for each dbServer like this: >> >> METHOD Unlock(nRecordNumber) CLASS myDbServer >> SELF:Commit() >> RETURN SUPER:Unlock(nRecordNumber) >> >> METHOD SetOrder(uOrder, cIndexFileName) CLASS myDbServer >> SELF:__OptimisticFlush( ) >> RETURN SUPER:SetOrder(uOrder, cIndexFileName) >> >> It doesn't seem to have much influence on the speeds and I'm not >> losing data. >> >> John >> >> >> Lucas_be schreef: >>> I changed my program from VO2.7 to 2.8sp1. I have problems with >>> dbserver:commit() unlock sequence. >>> I always set set Dbserver at CCNONE so I 'm in charge of everything. >>> For example editing a comment field and the saving it I get >>> Errorcode 29 Illlegal reference - Ignore gives a 5333. I never had >>> this before >>> DBFCDX rdd >>> >>> Thanks in advance for all help >
From: Lucas_be on 7 Apr 2008 12:21 On 6 apr, 13:42, John Martens <adsl672...(a)tiscali.nl> wrote: > Lucas, > > Changing from 2.7 to 2.8 I had several problems with SetOrder and unlock. > > Now I'm having a SetOrder and Unlock method for each dbServer like this: > > METHOD Unlock(nRecordNumber) CLASS myDbServer > SELF:Commit() > RETURN SUPER:Unlock(nRecordNumber) > > METHOD SetOrder(uOrder, cIndexFileName) CLASS myDbServer > SELF:__OptimisticFlush( ) > RETURN SUPER:SetOrder(uOrder, cIndexFileName) > > It doesn't seem to have much influence on the speeds and I'm not losing > data. > > John > > Lucas_be schreef: > > > I changed my program from VO2.7 to 2.8sp1. I have problems with > > dbserver:commit() unlock sequence. > > I always set set Dbserver at CCNONE so I 'm in charge of everything. > > For example editing a comment field and the saving it I get > > Errorcode 29 Illlegal reference - Ignore gives a 5333. I never had > > this before > > DBFCDX rdd > > > Thanks in advance for all help I found the reason for the problem! Writing to a filtered database gave me this problem I have to: Suspendnotification() Clearfilter() Commit() Unlock() Resetnotification() Setfilter() Never had this with VO 2.6 Thanks for the advice.
|
Pages: 1 Prev: How to use Bitmap-File with ComboBoxEx? Next: Basic Ado questions |