Hi,

I have a little database I have attatched a little picture of the database. 
What I am trying to do is First The "Appln" number and look in the field act
_type to see if it is "RSA" If it is then look for the same "Appln" number a
nd see if it has "REP" or "AFA" with a date sooner than "RSA" date. Could so
me one please help me I am new to dBase and I have to make this program inor
der to to get the data and then write a report for me boss.

Thanks to anyone who helps.

Daisy

[ Post a follow-up to this message ]

In article <daisy_polly.1ohykz@mail.webservertalk.com>,
daisy_polly.1ohykz@mail.webservertalk.com says...
>
> What I am trying to do is First The "Appln" number
> and look in the field act_type to see if it is "RSA"
> If it is then look for the same "Appln" number and
> see if it has "REP" or "AFA" with a date sooner
> than "RSA" date.
> http://www.webservertalk.com/attach...?postid=2707031

If you request is not just a trick to harbour email addresses, why should
we give you our e-mail address in order to see the image you have posted
on your site? In other words, why is registration _necessary_ in order to
help you?

About your problem, you could the beforeGetValue() method of the field
object to check anything you want about the value of other fields of that
rowset or the value of the fields of any rowset in the datamodule.

Jean-Pierre Martel, editor
The dBASE Developers Bulletin
Blue Star dBASE Plus Core Concepts Graduate

[ Post a follow-up to this message ]

In article <MPG.1ce287137f1136c298973f@news.dbase.com>,
nospam@nospam.com says...
> In article <daisy_polly.1ohykz@mail.webservertalk.com>,
> daisy_polly.1ohykz@mail.webservertalk.com says... 
>
> If you request is not just a trick to harbour email addresses, why should
> we give you our e-mail address in order to see the image you have posted
> on your site? In other words, why is registration _necessary_ in order to
> help you?

It looks to me like she posted this on another message board of which
she is a member, and *it* requires the registration.  I certainly agree
with your concern, though.

...

--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

[ Post a follow-up to this message ]

quote:
Originally posted by David Kerber 
In article <MPG.1ce287137f1136c298973f@news.dbase.com>,
nospam@nospam.com says...
> In article <daisy_polly.1ohykz@mail.webservertalk.com>,
> daisy_polly.1ohykz@mail.webservertalk.com says... 
>
> If you request is not just a trick to harbour email addresses, why should
> we give you our e-mail address in order to see the image you have posted
> on your site? In other words, why is registration _necessary_ in order to
> help you?

It looks to me like she posted this on another message board of which
she is a member, and *it* requires the registration.  I certainly agree
with your concern, though.

....

--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible). 
 

Hi,

Thanks alot for your replies I am not trying to take anyones email I posted 
this image as an attatchment and don't know why it requires you to log in co
uld someone please give a little sample code so I know where should i start 
with.

Thanks a bunch again I will post the image on my host and the link to that is http
://irum897.freeownhost.com/picture.GIF

[ Post a follow-up to this message ]

quote:
Originally posted by daisy_polly 
Hi,

Thanks alot for your replies I am not trying to take anyones email I posted 
this image as an attatchment and don't know why it requires you to log in co
uld someone please give a little sample code so I know where should i start 
with.

Thanks a bunch again I will post the image on my host and the link to that i
s 
http://irum897.freeownhost.com/picture.GIF 

[ Post a follow-up to this message ]

In article <daisy_polly.1ohykz@mail.webservertalk.com>,
daisy_polly.1ohykz@mail.webservertalk.com says...
>
> Hi,
>
> I have a little database I have attatched a little picture of the
> database. What I am trying to do is First The "Appln" number and look
> in the field act_type to see if it is "RSA" If it is then look for the
> same "Appln" number and see if it has "REP" or "AFA" with a date sooner
> than "RSA" date. Could some one please help me I am new to dBase and I
> have to make this program inorder to to get the data and then write a
> report for me boss.

And then what do you want to do with it?  A code-snippet for this might
be (this is XDML, not OODML):

if act_type = "RSA"
nAppLn = AppLn
dRSADate = Act_Date
locate for Appln = nAppln and (act_type = "REP" or act_type = "AFA"
and Act_date < dRSADate )
if found()
** do whatever
endif
endif


If you just want to display these records, then put this code (modified
as needed for your needs) in a canGetRow() as Jean-Pierre suggested, and
return TRUE if it was found().


--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

[ Post a follow-up to this message ]

quote:
Originally posted by David Kerber 
In article <daisy_polly.1ohykz@mail.webservertalk.com>,
daisy_polly.1ohykz@mail.webservertalk.com says...
>
> Hi,
>
> I have a little database I have attatched a little picture of the
> database. What I am trying to do is First The "Appln" number and look
> in the field act_type to see if it is "RSA" If it is then look for the
> same "Appln" number and see if it has "REP" or "AFA" with a date sooner
> than "RSA" date. Could some one please help me I am new to dBase and I
> have to make this program inorder to to get the data and then write a
> report for me boss.

And then what do you want to do with it?  A code-snippet for this might
be (this is XDML, not OODML):

if act_type = "RSA"
nAppLn = AppLn
dRSADate = Act_Date
locate for Appln = nAppln and (act_type = "REP" or act_type = "AFA"
and Act_date < dRSADate )
if found()
** do whatever
endif
endif


If you just want to display these records, then put this code (modified
as needed for your needs) in a canGetRow() as Jean-Pierre suggested, and
return TRUE if it was found().


--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible). 
 

Thanks so much for your help.

DAisy

[ Post a follow-up to this message ]