Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 266 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
varbinary in RTC
RobySpain
Member Posts: 57
Hi Experts,
I explain my problem. I have a NAV4 sql database. Someone update it to NAV2009 but only to the classic version. Now I am installing the RTC. My first problem was to change some fields from binary to text, because the RCT do not want this fields.
Now, when try to change some data in this table (in NAV or open directly the SQL Manager to do it) give me an Error:
"The following SQL Server error occurred when accesing the Customer table:
257,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]No se permite la conversión implícita del tipo de datos varchar a varbinary. Utilice la función CONVERT para ejecutar esta consulta." Not allowed implicit conversion of data type varchar to varbinary. Use the CONVERT function to run this query
This error appear when use the sentence MODIFY in the trigger OnModify of the table.
I tryed to delete these fields (binary fields) but not solve the problem.
Can you help me?? It looks as the sql server do not update the changes in the table (fields), but in the SQL Manager, the column is Varchar and not Varbinary. Any Idea???
Robyn
I explain my problem. I have a NAV4 sql database. Someone update it to NAV2009 but only to the classic version. Now I am installing the RTC. My first problem was to change some fields from binary to text, because the RCT do not want this fields.
Now, when try to change some data in this table (in NAV or open directly the SQL Manager to do it) give me an Error:
"The following SQL Server error occurred when accesing the Customer table:
257,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]No se permite la conversión implícita del tipo de datos varchar a varbinary. Utilice la función CONVERT para ejecutar esta consulta." Not allowed implicit conversion of data type varchar to varbinary. Use the CONVERT function to run this query
This error appear when use the sentence MODIFY in the trigger OnModify of the table.
I tryed to delete these fields (binary fields) but not solve the problem.
Can you help me?? It looks as the sql server do not update the changes in the table (fields), but in the SQL Manager, the column is Varchar and not Varbinary. Any Idea???
Robyn
0
Comments
Actually change it back the way it was in sql. Go to NAV and make any changes required.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
I've changed the table in NAV from binary to Text or CODE. With TEXT do not appear the SQL DATATYPE property. With CODE, SQL DATATYPE is <Undefined>. In any case, the same error.
I change directly the table properties in NAV. The changes are in SQL. But even if I delete the fields, I receive an error: the name of the column "namedeletecolumn" is not valid.
Thanks for your help. Best regards,
Robyn
Drop the table from sql. Delete the record from sql from object designer.
Import the FOB back.
Dataport the data back.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n