(UTC)
  Lantica User Forum › Archived Topics › Archived Topics › does XLR work now?
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic does XLR work now? (Read 828 times)
FSGROUP
Full Member
***
Offline


No personal text

Posts: 179
Location: Edmonton, Alberta, Canada
Joined: Jan 14th, 2004
does XLR work now?
Mar 24th, 2004 at 9:51pm
Print Post Print Post  
I still can't generate a unique ID in v 1.0.2. Has this been fixed?

TIA
  
Back to top
WWW WWW  
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2483
Joined: Aug 20th, 2003
Re: does XLR work now?
Reply #1 - Mar 24th, 2004 at 10:33pm
Print Post Print Post  
FsGroup please try the following. Wrap a @ToNumber() around the Xlookupr statement. ex

ID = @ToNumber(@XLookupR(@fn, 99999999999, "ID", "ID")) + 1

Let me know if this works.
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
FSGROUP
Full Member
***
Offline


No personal text

Posts: 179
Location: Edmonton, Alberta, Canada
Joined: Jan 14th, 2004
Re: does XLR work now?
Reply #2 - Mar 24th, 2004 at 10:44pm
Print Post Print Post  
this is my code. it does not work.

if @IsNew OR ID="" or @Add then
{ 
   
     ID=@tonumber(@XLR(@fn,99999999,"ID","ID")) + 1
   
}   
  
Back to top
WWW WWW  
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2483
Joined: Aug 20th, 2003
Re: does XLR work now?
Reply #3 - Mar 25th, 2004 at 3:13pm
Print Post Print Post  
Hello FSGroup,
Using the database that you sent yesterday to Technical Support, both Client/Server and Standalone your XLR program runs perfectly.

What mode are you in?
How many records did you try to add?
Is XLR returning the same number each time or is it incrementing incorrectly or is it returning nothing?
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: does XLR work now?
Reply #4 - Mar 27th, 2004 at 12:53am
Print Post Print Post  
FYI:

Out of curiousity, I tested this code to satisfy my own confidence in Sesame.

I found that it works perfectly, unless of course, the field type is set for TEXT instead of NUMBER.

(It worked exactly the same for me in standalone and server mode.)
  

Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
WWW WWW  
IP Logged
 
FSGROUP
Full Member
***
Offline


No personal text

Posts: 179
Location: Edmonton, Alberta, Canada
Joined: Jan 14th, 2004
Re: does XLR work now?
Reply #5 - Apr 7th, 2004 at 8:03pm
Print Post Print Post  
I am in Add mode. I tried to add approximately 3 or so records, each new entry giving the exact same ID.
  
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge