> -----Original Message----- > From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] > On Behalf Of Steve Ellenoff > Sent: Friday, February 05, 2010 12:24 PM > To: profoxt...@leafe.com > Subject: How to find out why UPDATE SQL statement is failing > > I have a biz object that is occasionally failing to save data and I'm > trying to understand why. > > Here's an example of the SQL command it generates: > UPDATE webaccess SET lastmod={^2010-02-05 15:07:11}, nloginfail=0 > WHERE uniqueid=='_2UX13CCKE' AND nloginfail==1 > > The biz object uses _TALLY when hitting a VFP datasource to determine > how many records were affected by the update statement, and it's > often coming back as 0. >
I don't want to spread false rumors, but I seem to recall that _TALLY wasn't necessarily reliable for this sort of thing. Or maybe it was when doing things against a non-VFP backend... Could be wrong - pretty brain dead at the moment... 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: ProFox@leafe.com 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/69f310c05dd83c48a84ba3769ce1ecf802cf0...@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.
