Lantica User Forum - Searching using and/or retrieves together

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Searching using and/or retrieves together

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Pages: 1

Searching using and/or retrieves together (Read 307 times)

dhopkins Member Offline Posts: 47 Joined: Aug 20^th, 2007	Searching using and/or retrieves together Jan 8^th, 2008 at 3:41pm	Print Post
	Hi, I need to mix 'and' & 'or' searches in one retrieve. For example Get all records where Name = Smith and Num_Balls >0 or Num_Bats > 0 According to the manual, this can't be done in a single retrieve spec and I need to program the report to get the results. In other words, you can't mix 'Retrieve All' and 'Retrieve Any' types of searches. The manual is for Sesame 1.5 and I just want to make sure thats still the case in Sesame 2.0+ before I start down that road. I'd always rather click a box and let Sesame do the work rather than slave over code. Thanks, D


	IP Logged

The Cow YaBB Administrator Offline Posts: 2530 Joined: Nov 22^nd, 2002	Re: Searching using and/or retrieves together Reply #1 - Jan 8^th, 2008 at 4:56pm	Print Post
	Put the word "Smith" in the name element in the retrieve spec. Then in any other element in the retrieve spec, put: "{Num_Balls > 0 or Num_Bats > 0}" This works in both 1.x and 2.x.

	Mark Lasersohn&&Programmer&&Lantica Software, LLC
	WWW IP Logged

Pages: 1

‹ Previous Topic | Next Topic ›