Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Sequencing of form submissions

3 posts in General Discussion Last posting was on 2004-10-28 14:53:01.0Z
Andreas Bruckner Posted on 2004-07-21 09:06:51.0Z
From: "Andreas Bruckner" <abruckne@sybase.com>
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Sequencing of form submissions
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 158.76.33.113
X-Original-NNTP-Posting-Host: 158.76.33.113
Message-ID: <40fe322b@forums-1-dub>
Date: 21 Jul 2004 02:06:51 -0700
X-Trace: forums-1-dub 1090400811 158.76.33.113 (21 Jul 2004 02:06:51 -0700)
X-Original-Trace: 21 Jul 2004 02:06:51 -0700, 158.76.33.113
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:112
Article PK: 8722

Hello!

Is there a way to sequence several form submission?

I want to enter typical master-detail data offline whereas I have one row
for the master and several rows for the detail.
Altough I submit my forms in the correct order (master, detail-1, detail-2,
...) the synchronization process seems to submit the forms in a random order
which sometimes results in an ForeignKey-error when the a detail-row is
inserted before the master-row has been inserted.

I tried to submit the forms using JavaScript (myForm.submit()) and the
PODSSubmissionMgr.
The Forms-Manager of the M-Bussiness Client displays the Submissions in the
correct order.

Thanks,
Andreas


Marcin Zastawny Posted on 2004-10-28 14:53:01.0Z
Reply-To: "Marcin Zastawny" <marcinz@infocon.pl>
From: "Marcin Zastawny" <marcinz@infocon.pl>
Newsgroups: ianywhere.public.mbusinessanywhere.general
References: <40fe322b@forums-1-dub>
Subject: Re: Sequencing of form submissions
Lines: 36
Organization: Infocon
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: hg126.internetdsl.tpnet.pl
X-Original-NNTP-Posting-Host: hg126.internetdsl.tpnet.pl
Message-ID: <418107cd$1@forums-1-dub>
Date: 28 Oct 2004 07:53:01 -0700
X-Trace: forums-1-dub 1098975181 80.53.84.126 (28 Oct 2004 07:53:01 -0700)
X-Original-Trace: 28 Oct 2004 07:53:01 -0700, hg126.internetdsl.tpnet.pl
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:183
Article PK: 8759

Thats correct - mbusiness sends these in random order.
An easy way to sort this out is to do a unique timestamp on every generated
form, and in your backend application, capture all the forms, sort them (in
a database for example) and THEN process them in timestamp order.

Marcin



U¿ytkownik "Andreas Bruckner" <abruckne@sybase.com> napisa³ w wiadomo¶ci
news:40fe322b@forums-1-dub...

> Hello!
>
> Is there a way to sequence several form submission?
>
> I want to enter typical master-detail data offline whereas I have one row
> for the master and several rows for the detail.
> Altough I submit my forms in the correct order (master, detail-1,
detail-2,
> ...) the synchronization process seems to submit the forms in a random
order
> which sometimes results in an ForeignKey-error when the a detail-row is
> inserted before the master-row has been inserted.
>
> I tried to submit the forms using JavaScript (myForm.submit()) and the
> PODSSubmissionMgr.
> The Forms-Manager of the M-Bussiness Client displays the Submissions in
the
> correct order.
>
> Thanks,
> Andreas
>
>


John.Karabaic Posted on 2004-07-21 17:07:57.0Z
From: John.Karabaic@ianywhere.com
Subject: Re: Sequencing of form submissions
Newsgroups: ianywhere.public.mbusinessanywhere.general
MIME-Version: 1.0
References: <40fe322b@forums-1-dub>
X-Newsreader: Lotus Notes Release 6.5 September 26, 2003
X-MIMETrack: Serialize by Notes Client on John Karabaic/SYBASE(Release 6.5|September 26, 2003) at 2004/07/21 13:01:11, Serialize complete at 2004/07/21 13:01:11
Content-Type: text/plain; charset="US-ASCII"
X-Original-NNTP-Posting-Host: vpn-dub-047.sybase.com
Message-ID: <40fea3dd$1@forums-2-dub>
X-Original-Trace: 21 Jul 2004 10:11:57 -0700, vpn-dub-047.sybase.com
Lines: 13
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 21 Jul 2004 10:01:16 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 21 Jul 2004 10:07:57 -0700
X-Trace: forums-1-dub 1090429677 10.22.108.75 (21 Jul 2004 10:07:57 -0700)
X-Original-Trace: 21 Jul 2004 10:07:57 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:113
Article PK: 17583

M-Business Anywhere does not guarantee the order in which forms are
subitted to the back-end server. All form submissions are given to a
multi-threaded process and the order is indeterminate. This is in line
with forms being stateless (except for cookies) in web applications.

If you think about it, this would slow down syncs tremendously to do it
the way you'd like.

You should rearchitect your back end so that form submissions are
stateless or make all the different screens on the device modify a single
form submission in the Forms Manager.