Hi Sean,
that's fine I'll google it later the time when I need it.
Sorry but I got another question about my procedure, I have my parameters coming from the access forms which can be left empty (aka null).
I'll need to create handling for when the parameters are null so this would be using if statements. Once I've handled the input parameters the select into queries will be run. Here's the pseudocode code for it so I was wondering if you could tell me the equilivent for it in postgres.
if adviser_id=null then
all records are returned irrespective if the adviser_id
else
find records which the adviser_id matches
endif;
Thanks for your help,
Ben
On 8/17/06, Sean Davis <sdavis2@mail.nih.gov> wrote:
On 8/17/06 9:13 AM, "ben sewell" <mosherben@gmail.com > wrote:
> Hi Sean,
> yup it is. I wasn't expecting things to be smooth even if I did know oracle
> for the migration. It's handy that there is alot of support if you get stuck
> on using it.
>
> One follow up question: as I mentioned before, the procedure is to process
> MS Access reports because of how slow JET takes to generate them (some
> tables have 7k records). How would I create the report once I've finished
> the procedure? I suppose its going to be a VBA coding job after I provide
> the execute reports([parameters]) for the View Report button but would like
> to know exactly what I need to do after the procedure is done.
I don't use Access, so I really can't answer that. You can try posting the
question again when you get a bit closer to needing that functionality.
Sorry.
Sean
