Fetch current serial number

[Ralph Schwegler]

Good morning

I am currently stucked with a tricky problem. I want to create a script which does following (once for every table)

-get the current serial number (which is also the key) in the database to be updated (old)

-call up all records (old)

-import all records (new)

-set the current serial number in the new version

I have no chance to get that to work. Any hint?

[Søren Dyhr]

Perhaps it's just me being daft as a brush, but I can't really get what you're after? If you import records are you automaticly prompted if you wish autoenters to happen, such as serialnumbers generated!

--sd

[Ralph Schwegler]

sorry for being offline long time and thank you for your answer!

the point is following: i develop off-site, while the database is being used. then i mail an update with auto update ability (well, that's my ain). do you see why i would need it, or did i miss something?

cheers

[Ocean West]

to avoid having to update serial numbers i would recommend using a custom function Base36 to create a Unique ID for your internal keys this way you don't have to "reset" them.

http://www.nightwing.com.au/FileMaker/demos9/demo910.html

You may also want to check this out

http://www.goya.com.au/UpdateManager

Edited March 2, 2009 by Guest

[bcooney]

Or this thread: Updating

Although the discussion concerned runtimes, it applies to all FM solutions. Basically, you sort recs asc and go to the last record (which has the highest serial num) and use SetNextSerial( ).

[Ralph Schwegler]

Hello Barbara

Your post is suiting my need quite perfectly.

Thank you so much.

Cheers from Switzerland

[Ralph Schwegler]

Hello Stephen

Your way of creating keys is really good, but doesn't suit my needs as the key is also a reference for managing cases.

The Update Manager is also a real interesting option, though to expensive in my case (USB 499 if i saw it well).

Thank you for your inputs.

Cheers, it's snowing again here.

[Nicholas Orr]

Ralph,

UpdateManager is $199. We also have discounts for FMPug or Technet members. Contact me if you need any help or more details.

There is a free 30 day demo on the site.

Cheers,

Nick