Page Web Services - AutoSplitKey problem

derrick

Hi buddies,

I created a Card type Page Web Services and used it in the .Net web application to insert new records with Create/CreateMultiple.

I had set the Page properties:
AutoSplitKey = Yes,
DelayedInsert = Yes

The table binding by the Page has only a key: "Name, LineNo".
The problem was the "LineNo" kept on increasing every time I inserted new records even the "Name" was different. For instance,
Record 1: "Jessica, 10000"
Record 2: "Peter, 20000" => #-o I am looking for 10000 for this record's LineNo.

Any suggestion what should I do :?: Thx.

derrick

Pls... anybody has experience this before.

ara3n

autosplitkey are used based on filters. Try to set filter on Name and see if it creates the 10K Line no.

derrick

Thanks ara3n, it didn't work.

Instead of web services, I had also tried it by inserting a new record from the RTC, it resulted the same outcome.

Anyhow, if I make a form and run it in the classic client, record was inserted nicely into the table.

Any ideas?

lvanvugt

Hi Derrick,

Probably you did solve this already ages ago. But for those hitting this post: I ran into a same kind of issue (not using web services, but just running a document page on RTC) where lines cerated on subpage having AutoSplitKey on. And I found out it all was due to the PageType property. It was set to List, but has to be ListPart.

mgm

AutoSplitKey doesn't seem to work if SourceTableTemporary.
The "Line No." of the first record is not 10000, but the next "Line No." of existing records in the table.
Also the "Line No." of the second record is not increased with 10000.
Anyone else who has this experience?