> -----Original Message----- > From: [email protected] [mailto:[email protected]] > On Behalf Of Sytze de Boer > Sent: Wednesday, February 09, 2011 3:21 PM > To: [email protected] > Subject: Re: VFP9 - Speed > > Mike (and all others). Thanks for all your help > > I've worked with the sys(3054) function > > Select * From winhst Where trcask=UPPER(serno) Order By invnum Into Table > (myfile) > rushmore returns None > > Select * From winhst Where UPPER(serno)=trcask Order By invnum Into Table > (myfile) > rushmore returns partial > > I guess I'll now have to work on finding out why only partial ......
It's gotta be the UPPER function me thinks... Any chance you can do a REPLACE ALL SERNO WITH UPPER(SERNO) and just be done with it? Maybe copy your table to a different one to play with and see what happens with your speed? Then change your INSERT/UPDATE code to force to UPPER? Thanks, Matthew Jarvis || Business Systems Analyst IT Department McKenzie-Willamette Medical Center 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: 541-744-6145 -------------------------------------------------------------------------- Disclaimer: This electronic message may contain information that is Proprietary, Confidential, or legally privileged or protected. It is intended only for the use of the individual(s) and entity named in the message. If you are not an intended recipient of this message, please notify the sender immediately and delete the material from your computer. Do not deliver, distribute or copy this message and do not disclose its contents or take any action in reliance on the information it contains. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/69f310c05dd83c48a84ba3769ce1ecf804450...@tntriexevs02.triadhospitals.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
