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

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

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

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

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

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

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

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)