We just purchased Customer Modifier and Combiner and are getting an error message "error converting varchar to float". If the customer number is a varchar in the table(s) then why would the program try to convert the new customer number to a float.
We are using GP10.4
*This post is locked for comments
Hi Michael,
I am trying to help a customer troubleshoot a similar issue using Customer Modifier and Customer Combiner in GP 2010. I believe what the message is saying is that it is trying to put a varchar into a column that is set up as float, meaning you have a table with a CUSTNMBR column that is set up with a type of float.
Can you run the following script against your company database in SQL and see if any of the data types are anything other than char?
SELECT
TABLE_NAME, COLUMN_NAME, DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME in
(SELECT name
FROM sysobjects
WHERE xtype = 'U')
and COLUMN_NAME = 'CUSTNMBR'
ORDER BY COLUMN_NAME, TABLE_NAME
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (