Select acct_id, GEMDEBTO.NAME, clt_id, DEBT.Status, GEMDEBTO.INSURANCE, GEMDEBTO.SSN,DEBT.INSURPLAN,orig_princ,princ_paid,Adj_princ,gemclien.collector; FROM debt,GEMDEBTO,GEMCLIEN Into Cursor mikedebt; &wherethunk
Wherethunk= "where (DEBT.STATUS="110").and.DEBT.STATUS="110".AND.Gemclien.COLLECTOR="2 ".AND.LASTWORKED<=DATE()-15.and. gemclien.client_id=debt.clt_id .AND. GEMDEBTO.DEBTOR_ID==DEBT.DEBTOR_ID" Tag LASTWORKED is the one reporting damage Ignoring the tag wouldn't do much to slow the query down. I could also do the select without the lastworked tag and then just delete for lastworked>date()-15 ----- Original Message ----- From: Stephen Russell <[email protected]> To: ProFox Email List <[email protected]> Cc: Sent: Monday, October 8, 2012 12:29 PM Subject: Re: error 2066 error on a sql statement On Mon, Oct 8, 2012 at 11:12 AM, Michael Madigan <[email protected]> wrote: > I'm getting a 2066 error on an SQL statement because one of the tags being > used by the where clause is damaged. > > Is there a way to disable the SQL statement from using that particular tag? -------------- Can we see some code on how you are putting the statement together as well as the final text you are sending back? -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell _______________________________________________ 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/cajidmyjqmzdrqzc1jcjsufxbolw+ray6dwvrwx-ob69rczs...@mail.gmail.com ** 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. _______________________________________________ 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/[email protected] ** 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.
