Help for Insert Query

[sugarcrmster]

Hi all

I required help for Insert Query

I have Develop Custom Module Base on Case

In that Module I have created Serial number Field

While Saving Record i want to insert Serial Number Value as Case Number + Dateof Created For Ex: srno=12/04/12/2009

any solution how to Update Query in Custom module

Thanks

Sugarcrm Developer

[Rajesh Patel]

Use can use Logic Hook to achive the same.
Download editloginchook from sugarforge and you can use it to crete logic hooks

use before_save method and in that assign that value

$bean->srno = 'yourvalue'