topic Re: aggregate function max in Application Development and Automation Discussions

aggregate function max

Former Member — Thu, 10 Jul 2008 12:49:06 GMT

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 — Thu, 10 Jul 2008 12:50:33 GMT

No You cant use with char data type

field must be numeric type

Former Member — Thu, 10 Jul 2008 12:54:18 GMT

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

OPENSQL statements will not work as ASCII format.

Cheers

Kothand

Former Member — Thu, 10 Jul 2008 12:54:52 GMT

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

is it possible? ...

if yes then how ...

its urgent.

thanks & regards

priyank

Former Member — Thu, 10 Jul 2008 13:02:07 GMT

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 — Thu, 10 Jul 2008 13:04:26 GMT

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.