how to use a database table in an array?

[wgg]

hi
I have a database table workdates that has holidays with a
type 'h'. HOw do i utilize this table so that my array reads only the holidays? I have used :

beforereadingrecords;
datevar array holidays:=[
date(1983,01,01),
date(1983,11,30),
date(1991,01,01),...]0

and hard coded the dates. there has to be a better way?
Thanks.

 

[synapsevampire]

Why are you using an array?

If you only want holidays returned from the database, use the record selection formula with something like:

{table.field} = "H"

Rather than pigeon holing responses to your architecture, consider posting the requirements, as in:

Crystal version
Database/connectivity used
Example data
Expected output

I have a whitepaper on building a Period table which includes the SQL script, perhaps that will help:

faq767-4532

-k

 

[wgg]

the report is to show the number of vacaction days and within someones vacation days they have public holidays.
Therefore i can not use the record selection to select only the date='h'. It has to be a field to compute the vacation days minus the holidays. I found a piece of code which can do it, but in one of the formulas they hard code the holidays as i mentioned before. In my record selection i already have filtered out the vacation and dates.

Help still needed?