GetNextSerialValue ???

[xoomaster]

I am trying to get the next serial value as :

GetNextSerialValue ( Get(FileName) ; Billing cases::Case )

But no value is returned ??

Also SetNextSerialValue is not seting the value either ? Anyone has this problem with FMP 8.5 Advance ??

[Ocean West]

What is your field type text or number?

[Fenton]

You need to put the name of the field in quotes. The GetNextSerialValue() is a Design function, and most of those functions only accept a text value.

Edited June 7, 2007 by Guest
Deleted Quote()

[xoomaster]

Thank you for your responses.

This is driving me crazy. I have tried to change the field type to Text and back to number with no help. Also I used :

Quote( Tabel1::serial) with no help. The function just returns nothing !!

[comment]

The field name must be enclosed in quotation marks:

GetNextSerialValue ( Get ( FileName ) ; "YourTable::SerialField" )

Using the Quote() function is NOT the same as enclosing the field name in quotation marks:

Quote ( YourTable::SerialField )

returns the CONTENT of the field enclosed in quotation marks.

[Fenton]

Oops! Sorry.

[xoomaster]

Thank you so much guys. I got it !