Results 1 to 3 of 3

Thread: how to update data base

  1. #1
    souza is offline Sugar Community Member
    Join Date
    Mar 2007
    Posts
    11

    Default how to update data base

    I need apdate one table on datatabase that after insert a new contact, the field that I need update is a custom fild criated by me, but must be set automaticly (its my contact number, created by me and it was a auto increment field.)
    please hlp me

    thanks

  2. #2
    pblag's Avatar
    pblag is offline Sugar Community Member
    Join Date
    Jul 2006
    Location
    Ukraine (Chernivtsy)
    Posts
    347

    Smile Re: how to update data base

    Hi souza!

    if you use windows i can recommend you to use SQLYog for managing your database.
    If you use linux please email to me and explain what exactly do you need and I hope we will help you.
    Petro Blagodir
    petro@blagodir.ua
    http://www.blagodir.com
    Blagodir Ltd.( SugarCRM - Consultations, Development and Support)

  3. #3
    pblag's Avatar
    pblag is offline Sugar Community Member
    Join Date
    Jul 2006
    Location
    Ukraine (Chernivtsy)
    Posts
    347

    Smile Re: how to update data base

    Quote Originally Posted by souza
    Thanks,

    I am using windows and mysql data base, I thing I don’t need use SQLYog, because I have mysql database work and what I need is when I create a new contact I need know How I do to put sugar creating a value for a field in my table contacts_.cstm, but in these field the user don’t write anything sugar must update de field automatically, so please tell me where I need put the query to update my field
    Hi!
    You have to change the file "modules/Contacts/ContactFormBase.php"
    there you can update function handleSave
    you have to put your code before function save(

    BTW: if you need auto incremented field you just have to alter your table field to auto increment.

    Hope it will help you
    Petro Blagodir
    petro@blagodir.ua
    http://www.blagodir.com
    Blagodir Ltd.( SugarCRM - Consultations, Development and Support)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Mysql - MSSql
    By Proware in forum Help
    Replies: 15
    Last Post: 2009-10-05, 01:27 PM
  2. Update custom fields with ERP data
    By mteixeira in forum General Discussion
    Replies: 0
    Last Post: 2007-03-12, 12:54 PM
  3. update the data base to 4.2.1
    By cubach in forum Help
    Replies: 1
    Last Post: 2006-09-08, 11:43 PM
  4. Replies: 1
    Last Post: 2006-05-31, 01:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •