Do not let any software impress you!

Only let it convince your intellect.
Slider img 1
Do not look for a business paradise!

It is a waste of time.
Slider img 2
Only yourself can push you uphill.

There is no easy road to prizes.
Slider img 3
Productivity is the name of the game.

And you have to conquer it.
Slider img 4
As long as you understand it,

you will start to build your know-how.
Slider img 5
We can help with that.

We have the tools and the method.
Slider img 6

Name
First Name
Middle Name
Last Name
Language
Street No
City
PO Box
Studies
Office Telephone
Mobile Telephone
Email Address
PO Area

Title : Contact

Toolbars

call CloseForm(True)
call send_mail()
call CloseForm(False)

Buttons

Fields


Name (AU_CONTACT.DISP_NAME)
First Name (AU_CONTACT.FIRSTNAME)
 (AU_CONTACT.SALUTATION)
Middle Name (AU_CONTACT.MIDDLENAME)
Last Name (AU_CONTACT.LASTNAME)
Language (AU_LANGUAGE.AU_LANGUAGE_D)
Street No (AU_CONTACT.STREET_NO)
City (AU_CONTACT.CITY)
PO Box (AU_CONTACT.POBOX)
Studies (AU_CONTACT.CSTUDIES)
Office Telephone (AU_CONTACT.OFFICE_TEL)
Mobile Telephone (AU_CONTACT.MOBILE_TEL)
EMail Address (AU_MAILADDRESS.MADDRESS)
Status (AU_CONTACT.SM_STATUS)
PO Area (AU_CONTACT.POSTCODE)
 (AU_CONTACT.SUFFIX)


AutoScript

lib

proc Form_Start()

     f = TopForm()
     call SetCaption("Contact")
     task = FormTask(f)

     p = PByName(f,"AU_CONTACT")
     t = TByName(p,"AU_CONTACT")

     call CbLoad("SM_STATUS","Prospective Partner","Sent Mail")
     call CbLoad("SM_STATUS","Dennied Mail","Opened Mail","Forwarded Mail")
     call CbLoad("SM_STATUS","Contacted By Mail","Contacted By Telephone")
     call CbLoad("SM_STATUS","Next Attempt for Sale")
     call CbLoad("SM_STATUS","Partner","Customer")

     if (task = ptAppend) then

        sql = strcatln("SELECT AU_LANGUAGE.AU_LANGUAGE, AU_LANGUAGE.AU_LANGUAGE_D")
        sql = strcatln(sql,"FROM AU_COMPANY INNER JOIN AU_LANGUAGE ON AU_COMPANY.AU_LANGUAGE = AU_LANGUAGE.AU_LANGUAGE")
        str = SelectFrom(sql)
        lang_id = GetSQLSelectItem(str,1)
        lang_d = GetSQLSelectItem(str,2)

        call TEdit(t)
        call TSetFld(t,"SM_STATUS","Partner")
        call TSetFld(t,"AU_LANGUAGE",lang_id)
        call TSetFld(t,"F_AU_LANGUAGE_AU_LANGUAGE_D",lang_d)
        call TPost(t)
        call ReLoadEditFields(f)
     endif
end

{ =================================== showmails ==================================}

proc showmails()

     call OpenFormTop("ptBrowse","AU_CONTACT_MAILS.FM","QRY.DATA",contact)

end

{================================== send_mail ================================}

proc send_mail()

     answer_addr = TGetFld(tt,"F_AU_MAILADDRESS_MADDRESS")
     call OpenNewMailForm ( answer_addr, False, 0 )
end

{=================================== start_campain ============================}

proc start_campain()

     nomails = TGetFld(t,"NOMAILS")
     if (nomails = 1) then
        call message("The contact does not like to receive mails!")
     else
        call OpenFormTop("ptAppend","AU_MAILCAMP_E.FM","WORK.AU_MAILCAMP",1,"?=AU_MAILCAMP","FROM_CONTACT",t,tt)
     endif

end