[Emerald] SQL Guru needed (again)

Alexander Blauvelt ( online@olg.com )
Wed, 10 Feb 1999 12:51:01 -0500

I'm trying to do the following update query from my old access database
to update the information in emerald.

UPDATE (dbo_MasterAccounts INNER JOIN MasterAccounts ON
(dbo_MasterAccounts.Address1 = MasterAccounts.Address1) AND
(dbo_MasterAccounts.FirstName = MasterAccounts.FirstName) AND
(dbo_MasterAccounts.LastName = MasterAccounts.LastName)) INNER JOIN
SubAccounts ON MasterAccounts.CustomerID = SubAccounts.CustomerID SET
dbo_MasterAccounts.PayPeriod = "Anually", dbo_MasterAccounts.PayMethod =
"Invoice"
WHERE (((SubAccounts.[Billing Option])=101));

I get an ODBC error "[Microsoft][ODBC SQL Server Driver]String data,
right truncation (#0)" Does this mean anything to anyone ? I don't see
any reason why I wouldn't be able to insert those into the emerald
database. This may be a tad off topic, but I appreciate anything the
gurus here have to offer.

Alex Blauvelt
Online Gateway

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html