Lantica User Forum - Search the highst RecNo in externe Database

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Search the highst RecNo in externe Database

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Pages: 1

Search the highst RecNo in externe Database (Read 578 times)

Amor Full Member Members Offline No personal text Posts: 366 Location: Germany Joined: Feb 7^th, 2004	Search the highst RecNo in externe Database Aug 9^th, 2010 at 12:49pm	Print Post
	Hello! Using the @XResultSetSearch, i would like to ask how can I get the highest Record Number in an external database form. Thank you for the help. With best regards Dr. Belhareth

	Dr. med. Amor Belhareth&&Medizin Labor &&Germany
	IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Search the highst RecNo in externe Database Reply #1 - Aug 9^th, 2010 at 2:40pm	Print Post
	Hello Amor, You can use the MAX search syntax to find the highest record number. An example of this in customers is Code vRS = @XResultSetSearch("Data\Samples\Customers.db", "Customers", 0, 2, "!Key=Max 1") You can also do a search for all the records, sort them in descending order based on record number and the first record will be the highest number. -Ray
	« Last Edit: Aug 9^th, 2010 at 5:03pm by Ray the Reaper »
	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Amor Full Member Members Offline No personal text Posts: 366 Location: Germany Joined: Feb 7^th, 2004	Re: Search the highst RecNo in externe Database Reply #2 - Aug 9^th, 2010 at 6:37pm	Print Post
	Hallo ray! This code works beautifully, thank you very much.

	Dr. med. Amor Belhareth&&Medizin Labor &&Germany
	IP Logged

Pages: 1

‹ Previous Topic | Next Topic ›