Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

More than one tblsku records found by a unique find.

Status
Not open for further replies.

katie

Programmer
Sep 24, 1999
2
US
help! this simple code generates this annoying error message.<br>
find tblsku where master-id &gt; <p>kate campbell<br><a href=mailto:katecamp@hotbot.com>katecamp@hotbot.com</a><br><a href= > </a><br>dynamite comes in little packages!
 
katie katie katie....yo, try this. use FOR EACH instead of find. FOR EACH is a query like SELECT FROM in SQL. you can return multiple records with it.<br>
i.e. FOR EACH tblsku WHERE master-id &gt;
 
You can also use 'find first....' or 'find last....' to fetch a single record.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top