Jump to content
Sign in to follow this  
habitude

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,

Habitude

Share this post


Link to post
Share on other sites

There is a Set Next Serial Value script step, in the Fields section.

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

hello,

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.

Regards:

Coolbdy.

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:

Coolbdy

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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