Jump to content
Sign in to follow this  

Programically Change Serial Number

Recommended Posts

In the Define Fields Options Auto Enter - Serial Number Dialog Box, you can assign a number, such as 1.

Let's say you have an "x" amount of records, and you want to delete all, and reimport a new set of records.

Is there a way to programically reset that field option back to 1, so the newly imported records start with a value of 1?

I know its unorthodox way of doing things, however, it needs to be done somehow.

Can anyone help?

Thanks in advance,


Share this post

Link to post
Share on other sites

Fenton, thanks for responding so quickly. I was thinking the same thing.

That should do the trick

Edited by Guest

Share this post

Link to post
Share on other sites


I am not getting u in right way.......

why u want to change the Serial Number programically?

But i have a query for u?

can i apply Fields Properties (Auto Enter, Validation Storgae etc)

programically on a field for FM database.

i have to need query for this (apply fields Options properties) and i using FM ODBC.

can u help me about this for me for strike at the point.

Thanks to u ......................Have a great day.



Share this post

Link to post
Share on other sites

Hi fenton,

Have u any idea about the Apply properties programmatically on Fields( AutoEnter , Validation , Furigana etc)

on a FM database.

I am using FM database for this & execute the query for apply the property.

I have applied only index property on the FM database.

can u give me the trick for this?

if u have please do favour for me.

Have a nice day............

thanks & regards:


Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.