|
sel all from prepaid where
xxxxxxxxxxxxxx
using your where clause, does that give you any results at the
R prompt?
-----Original Message-----
From:
Benjamin Strickland <[EMAIL PROTECTED]>
To:
Multiple recipients of list witango-talk <[EMAIL PROTECTED]>
Date:
Sunday, August 25, 2002 4:16 PM
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 -----
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
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
|
