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


Groups > comp.lang.clipper.visual-objects > #13739 > unrolled thread

My Database won't update...

Started byDavid Linda <dlinda2011@gmail.com>
First post2023-01-11 11:24 -0800
Last post2023-01-16 11:10 +0100
Articles 4 — 4 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

#13739 — My Database won't update...

FromDavid Linda <dlinda2011@gmail.com>
Date2023-01-11 11:24 -0800
SubjectMy Database won't update...
Message-ID<baf54364-6b68-46fa-bd2c-4eb053ee4b2dn@googlegroups.com>
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

[toc] | [next] | [standalone]


#13740

FromJamal <nospam@example.com>
Date2023-01-15 14:53 -0500
Message-ID<tq1lkb$1tmt$1@gioia.aioe.org>
In reply to#13739
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

[toc] | [prev] | [next] | [standalone]


#13741

FromFranz Rachbauer <office@rachbauer.org>
Date2023-01-16 07:05 +0100
Message-ID<tq2pg8$4oa$1@gioia.aioe.org>
In reply to#13740
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
> 

[toc] | [prev] | [next] | [standalone]


#13742

FromKarl Faller <mail_withoutthat_@_drei-f_andthat_.de>
Date2023-01-16 11:10 +0100
Message-ID<kj8ash5tp3nh8fn03q3tch6m2j1quck5ov@4ax.com>
In reply to#13741
FTR, "Single User" does not keep you from harm re concurrency, as
every datawindow has it's own DBServer instance of the table...

On Mon, 16 Jan 2023 07:05:59 +0100, Franz Rachbauer wrote:

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

Karl

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web