[quote] var GSNextCustRecNo as int

GlobalValue(gsnextcustrecno, 221)

If @IsNew and PatientID = "" then {
PatientID = @tonumber(@GlobalValue("NextCustRecNo")) + 1
GlobalValue("NextCustRecNo", patientId)
}
[/quote]

Bob,

We're not getting your crash, but I'm also not sure that we're actually duplicating your condition.

I see a couple of things in your code:
1. Take it all out of Global Code and put it in an event, probably Form::OnFormEntry considering what you are trying to do.

2.  In your code above, you declare an integer variable. You then set a GlobalValue passing the value of the variable (in this case 0) as the name of the global value. You then retrieve a global value that has a different name, which does not exist and you have never set.

We tried all these things, but Sesame did not crash, so we're not sure what other factor is involved here. Could you send me your dsr so I can put it through debug?

Here's your code snippet redone:
[pre]
var GSNextCustRecNo as int

GSNextCustRecNo = 221
GlobalValue("NextCustRecNo", @Str(GSNextCustRecNo))

If @IsNew and PatientID = "" then {
       PatientID = @ToNumber(@GlobalValue("NextCustRecNo")) + 1
       GlobalValue("NextCustRecNo", @Str(PatientId))
}
[/pre]

We got the files and we see the crash. Thanks for the bug report!

Meanwhile, if you ditch your Global Code and paste the code snippet I gave you above into Form::OnFormEntry you should be fine.

Thanks. That code snippet worked great! 

It was easy to modify so I now have separate auto numbering sequences for customer numbers, order numbers and invoice numbers.

This feature being able to have multiple @number is such an exciting thing to me. :D

Thanks so much!

Quote:


In my case I started with a field I called PatientID the patient id is to be used as the customer number. There will be only one customer number per client.

This code Snippet that Erika was kind enough to post is the mechanism that creates the number and adds it to the record. I will attempt to explain its use the best I can. If I am to far off I am sure a Lantican will jump in and help correct me.

var GSNextCustRecNo as int // This is declaring the variable arbitrarily named GSNextCustRecNo as an integer (number)
 
GSNextCustRecNo = 221 // This is were I am setting my number to start. I arbitrarily picked 221

GlobalValue("NextCustRecNo", @Str(GSNextCustRecNo)) // This applies  results to the global variable holder. This is were // the number to be used resides at this moment.

 
If @IsNew and PatientID = "" then {
    PatientID = @ToNumber(@GlobalValue("NextCustRecNo")) + 1
    GlobalValue("NextCustRecNo", @Str(PatientId))
}

/*
This says that if I am adding a record that is new to the database and the patientid is empty that the patientid will be the globalvalue NextCustRecNo plus 1 and then it is updating the globalvalue so it will be available with the correct number when it is needed next.
*/

If you replace the field PatientID with the field you use as a record number and then put the above snippet in your form  with on form entry execution you should be set. Once you save and reconcile, every time you add a new record it will add the new record number to the form.

You can use the same logic and just change the variable and field names to work with as many forms or @numbers you need. Each one will be totally self contained.

I hope this is somewhat clear. If not let me know.   

Quote:

The mechanism for this is called Global Statics. These are explained beginning on Page 53 of the Programming Guide.