problem when debug in script

[Anonymous]

Hi all,

I am debugging my script and not able to continue for further step. It got struck when I am doing max(date). Though it is silly, but I couldn't figure ot

I have written like below

Load max(date)

from facte_table.QVD

if I do without max it is working fine when limit records in debug mode. I mean

Load date from

fact_table.QVD.

Can any one tell me what might be the cause.

Thanks in advance.

Kumar

[Anonymous]

Resident table is required when we we do max(date) field. I need only one column, not more than that date column.

[swuehl]

Load max(date)

from facte_table.QVD

If field and file name is correct, this should work, if date is a field showing numbers. Maybe it's just showing text values?

Then Max() won't work (on pure text values).

What error message do you get? Could you be more specific what the issue is you are encountering?

[Anonymous]

actually it is timestamp and i have given name exactly as database.