Hi,

We were having some programming problems with Sesame, and I thought I had them all under control, but now it seems that when we go to add clients into our database, the id defaults to 1 instead of adding to the last client id.  This has happened since the last Sesame Update so it may be our programming is not compatible with the new version.

the programming we have is:  (for on form entry)

var vID as Int
var temp_id as Int

// adding new Client record
if @IsNew or ID="" or @Add then
{
  temp_id=@GlobalValue("next_id");

  temp_id=temp_id+1

   vID=@tonumber(@XLR(@fn,99999999,"ID,"ID")) + 1
   if (temp_id> vID) then
               {
                     ID=temp_id;
  }
  else
   { ID=vID}

    LastMod=@Date

}

GlobalValue("curr_rec", @FormResultSetCurrentPosition("Main"))

// set global var to current client id
GlobalValue("curr_id", ID)

any suggestions?

Thanks alot!
Rebecca

Quote:


Where did you assign the value for "Next_Id"?  I see the globalvalue assigned to Curr_ID and Curr_Rec variables.

temp_id is integer variable and @globalvalue ("Next_Id") will give you string value, so I believe, you will have to use @tonumber to convert it to number just as you did it with @xlr code.

temp_id= @tonumber (@GlobalValue("next_id"));

These are just my initial thoughts before really testing the code.

Hi,

Thanks for your suggestions...

Steve, that was a typo in my post, not the actual code...   my bad.

I actually just changed temp_id=@GlobalValue("next_id") to temp_id=@GlobalValue("curr_id")

and that seems to have fixed it up...  I actually didn't write the original code on this, I'm just taking over for the previous position and learning along the way.

Would there be any foreseeable problems with what I've changed?  Right now it looks like it's working but there could be something that I don't know... just a wonderment on my part.

Thanks again!
Rebecca