Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #13741

Re: My Database won't update...

From Franz Rachbauer <office@rachbauer.org>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: My Database won't update...
Date 2023-01-16 07:05 +0100
Organization Aioe.org NNTP Server
Message-ID <tq2pg8$4oa$1@gioia.aioe.org> (permalink)
References <baf54364-6b68-46fa-bd2c-4eb053ee4b2dn@googlegroups.com> <tq1lkb$1tmt$1@gioia.aioe.org>

Show all headers | View raw


I think with Append the rec is automatically locked
Single User DB = SetExclusive(TRUE)
Franz

Am 15.01.2023 um 20:53 schrieb Jamal:
> Hi David,
> 
> I do not see any record locking?
> 
> What is the DBServer:ConcurrencyControl setting?
> This may affect the saving of the records.
> 
> Jamal
> 
> On 1/11/2023 2:24 PM, David Linda wrote:
>> Hello Everyone,
>>
>> First I want to say thank you for your help in the past!  I  have now 
>> come across something that is confusing me.  I have a datawindow 
>> displayed in browseview.  I can see my data (1000 records) with no 
>> problem, I can append a blank record with the code:
>>
>>   IF oSFSuub_Form2:Append() = TRUE
>>       oSFSuub_Form2:FIRST_NAME := odcFName:CurrentTest
>>
>>
>>      IF oSFSuub_Form2:Commit() = FALSE
>>          ErrorBox{NIL,"Commit Error!"}:Show()
>>      ENDIF
>> ELSE
>> ErrorBox{NIL, "Append Error"}:Show()
>> ENDIF
>>
>> So I see the bland record added, I step through the code and I see the 
>> data in  my controls, but the data in my controls never get written to 
>> the database.  The South Sea Adventure sample uses the same 
>> technique.  I also tried fieldput() to no avail.  This is a single 
>> user database, so no update conflicts are possible.  Also no 
>> errors/crashes are shown or happen.
>>
>> Does anyone and any questions or suggestions?
>>
>> Thanks,
>>
>> David
> 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

My Database won't update... David Linda <dlinda2011@gmail.com> - 2023-01-11 11:24 -0800
  Re: My Database won't update... Jamal <nospam@example.com> - 2023-01-15 14:53 -0500
    Re: My Database won't update... Franz Rachbauer <office@rachbauer.org> - 2023-01-16 07:05 +0100
      Re: My Database won't update... Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2023-01-16 11:10 +0100

csiph-web