Hello Gianluigi,
Have one question regarding your new extension Import/export tools (haven�t bought it yet).
I use ACCESS as a desktop database for parts in stock (invoice and other stuff)in a application and then export it as xml, there are several columns in the table with a unique key column that only is a row ID and the part number is in an other column (indexed).
If i will use the xml import i need to empty the table every time before i import it because there will be partnumber that will not be in stock anymore and therefor can not be left in the MySql database on the internet.
Is it only to insert this delete command below before the xml import code to make it work? <%
Set DeleteParts = Server.CreateObject ("ADODB.Command") DeleteParts.ActiveConnection = MM_cnSql_STRING DeleteParts.CommandText = "DELETE * FROM PARTS" DeleteParts.CommandType = 1 DeleteParts.CommandTimeout = 0 DeleteParts.Prepared = true DeleteParts.Execute()
%>
Klas |
|
|