The SQL In parameters ask:
Optimise Records – this asks the number of entries processed in one loop.
IP Address – enter the IP Address of the SQL server
Database – enter the database name on the SQL server
Username – enter the user name for the database on the SQL server
Password – enter the password for the database on the SQL server
Server Type – enter the server type i.e. mysql for Jshop webserver
SHP-XMO path – enter the database file (including path) that is to be updated
The SQLMGR.INI contains additional entries which define the tables that are accessed within the database
key=orderID
from=FROM `df_orders_lines` INNER JOIN `df_orders_headers`
where=ON `df_orders_lines`.orderID = `df_orders_headers`.orderID
orderby=ORDER BY `df_orders_lines`.lineID ASC
tables=df_orders_headers,df_orders_lines
This defines the primary table being read as the df_order_lines but then links it to the header table.
Article ID: 1722
Created On: Thu, Jul 5, 2012 at 10:53 AM
Last Updated On: Mon, Jun 12, 2023 at 2:44 PM
Online URL: https://kb.datafile.co.uk/article/sql-in-1722.html