I think you intended:
create view lettsource +
as select t1.*, t2.send_letter +
from scellclient t1, sendlett t2 +
where ((#Date - t1.firstletter > 1) and +
(#Date - t1.firstletter <= 5)) +
OR ((t1.followupletter1 = .#DATE) AND +
t1.dateofc is null)
(See parens) But I'm not certain it address's your problem:
<<When I try to update a field in a record either through
a query or a form, it updates all records with that field.>>
Ben Petersen
On 20 Dec 2001, at 15:11, [EMAIL PROTECTED] wrote:
> The following is the code used to create the view.
>
> create view lettsource as select t1.*, t2.send_letter from scellclient t1, sendlett
>t2 where ((#Date - t1.firstletter >1) and (#Date - t1.firstletter <=5) OR
>(t1.followupletter1 = .#DATE)) AND t1.dateofc is null
> PAUSE 3 USING "Looking for letters..."
> select Count(*) into vexists from lettsource
> if vexists = 0 then
> pause 1 using "No First Follow-Up Letters Due."
> else
> pause 1 using "First Follow-Up Letters Found. Go to 'Edit Addresses' if
>necessary."
> endif
> break
>
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
>
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
