Andrew Baltino wrote: > Thanks JT. Sorry I am a little late in getting back to this. I wish > I knew more about the structure and format of log_transaction. The > query I use in the query tag decrements an inventory count, and it is > decrementing the count in the local table, and not the remote table. > > However when put the query tag in a different part of the script, > basically further down in the script, or use a usertag to encapsulate > my query I get the error I sent. > Also, the tables with the same exist in both DBs the local and remote. > If I DROP the local table IC complains when I restart it. So you have a table called 'itemstat' in both the local DB and the remote one? That could be your problem. The Interchange code abstracts the tables and tends to refer to them as hash indexes and the like, so its behavior could indeed be confusing as the database is called in different ways. Perhaps consider re-naming the tables so that their names are less ambiguous? JT _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.