Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #13739 > unrolled thread
| Started by | David Linda <dlinda2011@gmail.com> |
|---|---|
| First post | 2023-01-11 11:24 -0800 |
| Last post | 2023-01-16 11:10 +0100 |
| Articles | 4 — 4 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | David Linda <dlinda2011@gmail.com> |
|---|---|
| Date | 2023-01-11 11:24 -0800 |
| Subject | My 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]
| From | Jamal <nospam@example.com> |
|---|---|
| Date | 2023-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]
| From | Franz Rachbauer <office@rachbauer.org> |
|---|---|
| Date | 2023-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]
| From | Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> |
|---|---|
| Date | 2023-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