aggregate function max

[Former Member]

hi evrybdy

can we use MAX aggregate function to pick a field of type char from database table ...if yes thn how ..?

plzzz ans soon .

thank u .

[Former Member]

No You cant use with char data type

field must be numeric type

[Former Member]

can i access the last record from tha database table ..

is it possible? ...

if yes then how ...

its urgent.

thanks & regards

priyank

[Former Member]

Hi,

In DB tables the data will not be saved as we see in Data Dictionary and even we cannot identify the record positions from the database table.

[Former Member]

Hi Priyank,

Do you have a date filed and time field in your table?

Then you can select the records and sort the records in descending order.

Take the first record.

[Former Member]

No. Max is only for numbers. ( even it will not work for NUMC type )

OPENSQL statements will not work as ASCII format.

Cheers

Kothand