|
Home > Archive > Programming with dBASE > May 2005 > Comparing
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| daisy_polly 2005-05-04, 3:23 am |
|
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.
Thanks to anyone who helps.
Daisy
+----------------------------------------------------------------+
| Attachment filename: picture.gif |
|Download attachment: http://www.webservertalk.com/attach...?postid=2707031 |
+----------------------------------------------------------------+
--
daisy_polly
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message1046297.html
| |
| Jean-Pierre Martel 2005-05-04, 7:23 am |
| 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
| |
| David Kerber 2005-05-04, 7:23 am |
| In article <MPG. 1ce287137f1136c29897
3f@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).
| |
| daisy_polly 2005-05-04, 8:23 pm |
|
David Kerber wrote:
> *In article <MPG. 1ce287137f1136c29897
3f@news.dbase.com>,
> nospam@nospam.com says...
> should
> posted
> order to
>
> 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 could 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
--
daisy_polly
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message1046297.html
| |
| daisy_polly 2005-05-04, 8:23 pm |
|
daisy_polly wrote:
> *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 could 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 *
--
daisy_polly
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message1046297.html
| |
| David Kerber 2005-05-05, 7:23 am |
| 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).
| |
| daisy_polly 2005-05-07, 3:23 am |
|
David Kerber wrote:
> *In article <daisy_polly.1ohykz@mail.webservertalk.com>,
> daisy_polly.1ohykz@mail.webservertalk.com says...
> look
> the
> sooner
> and I
> a
>
> 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
--
daisy_polly
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message1046297.html
|
|
|
|
|