Information générale
Catégorie:
Installation et configuration
Jose,
The app uses an SQL statement (below) to add the data to the table. Have a look!
MySQL = "SELECT agindid, alltrim(Agind.prefix) As Prefix, alltrim(agind.fname) As Firstname, alltrim(agind.initial) as Initial, alltrim(agind.sname) as Surname, "
MySQL = MySQL + " alltrim(agind.position) as position, agind.phone as Phone, agind.fax as Fax, agind.email as eMail, "
MySQL = MySQL + " agencies.agname as Agencyname, agencies.agadd1 as Address1, agencies.agadd2 as Address2, "
MySQL = MySQL + " agencies.agadd3 as Address3, agencies.agadd4 as Address4, alltrim(agencies.county) As County, alltrim(postcode) as Postcode "
MySQL = MySQL + " From agind, Agencies "
MyWhere = " WHERE Agind.agindid IN (" + ctl + ") and agind.agencyid = agencies.agencyid "
thisform.grid2.recordsource = MySQL + MyWhere + " into table " + cLocalPath + "Temp"
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement