General information
Category:
Installation, Setup and 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"
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only