RE: Witango-Talk: Running a taf

[Steve Smith]

Title: Message

Just out of curiousity, do you have a primary key field for the prepaid table? It doesn't look like it, and that could be where your problem is. The update is trying to find a record that matches all of that criteria and can't do it. The main problem field could be the inputdate field, especially if it is a timestamp field and not a date field but that is not the only problem. By not having a primary key field, you are asking alot from the database and will put added drain on the performance of the database if it has to match all those fields each time you want to use an update.   If you don't understand the concept of a primary key field, I'd be happy to help explain it to you.   Hope this helps,   Steve Smith Skadt Information Solutions Office: (519) 624-4388 GTA:    (416) 606-3885 Fax:    (519) 624-3353 Cell:   (416) 606-3885 Email:  [EMAIL PROTECTED] Web:    http://www.skadt.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Benjamin Strickland Sent: August 25, 2002 7:13 PM To: Multiple recipients of list witango-talk Subject: Re: Witango-Talk: Running a taf The update line below is what the Debug produced.  But when I run this in R:Base is returns "no rows exist".   UPDATE PREPAID SET SURNAME='Mr.',FIRSTNAME='Benjamin',LASTNAME='Strickland, CPA',EMAILADDRESS='[EMAIL PROTECTED]',+ ADDRESS1='197 Torrence Street, N. W.',ADDRESS2=NULL,CITY='Atlanta',STATE='GA',ZIPCODE='30314',LEGALPROBLEMS='TEST',+ HPHONE='404 792-7231',CPHONE=NULL,BESTTIME='None',LEGALTYPE='Preventive Law' WHERE (INPUTDATE=08/25/02 AND + FIRSTNAME='Benjamin' AND LASTNAME='Strickland' AND EMAILADDRESS='[EMAIL PROTECTED]' AND + ADDRESS1='197 Torrence Street, N. W.' AND SURNAME='Mr.' AND ADDRESS2=' ' AND CITY='Atlanta' AND + STATE='GA' AND ZIPCODE='30314' AND LEGALPROBLEMS='TEST' AND HPHONE='404 792-7231' AND CPHONE='' AND + BESTTIME='None' AND FULLNAME='Mr. Benjamin Strickland' AND FULLADDRESS='Atlanta, GA 30314' AND + INPUTTIME=12:17 PM AND LEGALTYPE='Preventive Law') ----- Original Message ----- From: Buddy Walker To: Multiple recipients of list witango-talk Sent: Sunday, August 25, 2002 3:41 PM Subject: RE: Witango-Talk: Running a taf Benjamin      Turn the debug on and check the section for the update. Sometimes if I can't find any clear answers there I cut and paste the update command from the browser debug into a file. I then run this file from the R:> with messages and error messages on. This should tell you if anything is wrong with your update command.   Buddy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Benjamin Strickland Sent: Sunday, August 25, 2002 2:58 PM To: Multiple recipients of list witango-talk Subject: Witango-Talk: Running a taf I developed an input .taf that works fine but my Search .taf will not update my database and is not giving me an error.  I am using Witango 3.6 with an R:Base database.   Benjamin Strickland