Rocksolid Light

Welcome to RetroBBS

mail  files  register  newsreader  groups  login

Message-ID:  

Bus error -- driver executed.

devel / comp.lang.clipper.visual-objects / My Database won't update...

SubjectAuthor
* My Database won't update...David Linda
`* Re: My Database won't update...Jamal
 `* Re: My Database won't update...Franz Rachbauer
  `- Re: My Database won't update...Karl Faller

1
My Database won't update...

<baf54364-6b68-46fa-bd2c-4eb053ee4b2dn@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=1238&group=comp.lang.clipper.visual-objects#1238

  copy link   Newsgroups: comp.lang.clipper.visual-objects
X-Received: by 2002:a05:620a:146a:b0:6ff:100c:d6f2 with SMTP id j10-20020a05620a146a00b006ff100cd6f2mr4352701qkl.625.1673465070734;
Wed, 11 Jan 2023 11:24:30 -0800 (PST)
X-Received: by 2002:a0d:c481:0:b0:4ad:7104:1f66 with SMTP id
g123-20020a0dc481000000b004ad71041f66mr4363351ywd.53.1673465070375; Wed, 11
Jan 2023 11:24:30 -0800 (PST)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.clipper.visual-objects
Date: Wed, 11 Jan 2023 11:24:30 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=2601:8b:8400:a2c0:6c5c:f40a:1e7f:ea5d;
posting-account=sU18rAoAAABkmMxWPcRa-aD_FCz6Y1Ix
NNTP-Posting-Host: 2601:8b:8400:a2c0:6c5c:f40a:1e7f:ea5d
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <baf54364-6b68-46fa-bd2c-4eb053ee4b2dn@googlegroups.com>
Subject: My Database won't update...
From: dlinda2011@gmail.com (David Linda)
Injection-Date: Wed, 11 Jan 2023 19:24:30 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 2073
 by: David Linda - Wed, 11 Jan 2023 19:24 UTC

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

Re: My Database won't update...

<tq1lkb$1tmt$1@gioia.aioe.org>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=1239&group=comp.lang.clipper.visual-objects#1239

  copy link   Newsgroups: comp.lang.clipper.visual-objects
Path: i2pn2.org!i2pn.org!aioe.org!usMzckGswq/a27BPojtwGg.user.46.165.242.75.POSTED!not-for-mail
From: nospam@example.com (Jamal)
Newsgroups: comp.lang.clipper.visual-objects
Subject: Re: My Database won't update...
Date: Sun, 15 Jan 2023 14:53:47 -0500
Organization: Aioe.org NNTP Server
Message-ID: <tq1lkb$1tmt$1@gioia.aioe.org>
References: <baf54364-6b68-46fa-bd2c-4eb053ee4b2dn@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="63197"; posting-host="usMzckGswq/a27BPojtwGg.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101
Thunderbird/102.6.1
Content-Language: en-US
X-Notice: Filtered by postfilter v. 0.9.2
 by: Jamal - Sun, 15 Jan 2023 19:53 UTC

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

Re: My Database won't update...

<tq2pg8$4oa$1@gioia.aioe.org>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=1240&group=comp.lang.clipper.visual-objects#1240

  copy link   Newsgroups: comp.lang.clipper.visual-objects
Path: i2pn2.org!i2pn.org!aioe.org!F6jVeh8XxA8K/0pr0mqcPw.user.46.165.242.91.POSTED!not-for-mail
From: office@rachbauer.org (Franz Rachbauer)
Newsgroups: comp.lang.clipper.visual-objects
Subject: Re: My Database won't update...
Date: Mon, 16 Jan 2023 07:05:59 +0100
Organization: Aioe.org NNTP Server
Message-ID: <tq2pg8$4oa$1@gioia.aioe.org>
References: <baf54364-6b68-46fa-bd2c-4eb053ee4b2dn@googlegroups.com>
<tq1lkb$1tmt$1@gioia.aioe.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Info: gioia.aioe.org; logging-data="4874"; posting-host="F6jVeh8XxA8K/0pr0mqcPw.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:102.0) Gecko/20100101
Thunderbird/102.6.1
X-Antivirus: Avast (VPS 230116-0, 16.1.2023), Outbound message
X-Antivirus-Status: Clean
X-Notice: Filtered by postfilter v. 0.9.2
 by: Franz Rachbauer - Mon, 16 Jan 2023 06:05 UTC

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
>

Re: My Database won't update...

<kj8ash5tp3nh8fn03q3tch6m2j1quck5ov@4ax.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=1241&group=comp.lang.clipper.visual-objects#1241

  copy link   Newsgroups: comp.lang.clipper.visual-objects
Path: i2pn2.org!i2pn.org!eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: mail_withoutthat_@_drei-f_andthat_.de (Karl Faller)
Newsgroups: comp.lang.clipper.visual-objects
Subject: Re: My Database won't update...
Date: Mon, 16 Jan 2023 11:10:36 +0100
Organization: A noiseless patient Spider
Lines: 54
Message-ID: <kj8ash5tp3nh8fn03q3tch6m2j1quck5ov@4ax.com>
References: <baf54364-6b68-46fa-bd2c-4eb053ee4b2dn@googlegroups.com> <tq1lkb$1tmt$1@gioia.aioe.org> <tq2pg8$4oa$1@gioia.aioe.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
Injection-Info: reader01.eternal-september.org; posting-host="8833c1aea369b7d04be99dbcdf12d763";
logging-data="2839738"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19PoZ+MvAZu8Y3SaChalPPz"
User-Agent: ForteAgent/7.20.32.1218
Cancel-Lock: sha1:qPX79CnZtmTKZVuY0psfu/K5BD0=
 by: Karl Faller - Mon, 16 Jan 2023 10:10 UTC

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

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor