Unable to rename a Vendor No.

Sabby

We are currently using Navision 4.0 on an SQL 2000 database. We are using
Windows and Database Logins.

I'm trying to rename a "Vendor No." in the Vendor table. When I click YES
to rename the field, the rename process starts. However, it's stops with an
SQL Server error occurs on the "Bank Rec. Line" table. The exact error is: "

The following SQL Server error(s) occurred while accessing the Bank Rec.
Line table:

213,"21S01",[Microsoft][ODBC SQL Server Driver][SQLServer]Insert Error:
Column name or number of supplied values does not match table definition.
(Repeats 20 times)

SQL:
UPDATE "Db_name"."dbo"."Company name_$Bank Rec_Line" SET (Account
No_"='1001TR' WHERE (("Account Type"=2)) AND ((Account No_"='1001TRA'))"

We also did a "Check Syntax" on the "Bank Rec. Line" table trigger and we
get the following error from the Microsoft SQL-DMO (ODBC SQL State: 21S01): "

Error 170: Insert Error: Column name or number of supplied values does not
match table definition.
(Repeats over 50 times)

So we are not able to rename our Vendor No.'s.

Has this happen to anyone else?

Thanks,

kine

Please, can you post the ID of the "Bank Rec. Line" table? I found just table "Bank Acc. Reconciliation Line" in my DB and there is no field connected to the Vendor table. It seems like some customization and the field is not correctly connected to the Vendor table (for example TableRelation to another field than Primary Key)...

Sabby

The Table ID is 10121 - Bank Rec. Line. We did not do any customization in the Bank Rec. Line Table but we did in the Vendor table. However, I get the same SQL error when I try to convert from 4.0 to 4.0 SP1 and it's not because of the Vendor table.

Thanks,

Savatage

Just curious- what is your table 274?

---

20S01
Insert value list does not match column list.

The argument contained an INSERT statement and the number of values to be inserted did not match the derived table.

Sabby

Table 274-Bank Acc. Reconciliation Line

Thanks,

Savatage

Sabby wrote:

The Table ID is 10121 - Bank Rec. Line.

Sabby wrote:

Table 274-Bank Acc. Reconciliation Line

I don't have a table 10121 - that's why I was asking

kine

it seems like this table is part of Canadian localization. Try to ask Microsoft office...

Can you post the Properties of the field from this table which is connected to Vendor table?

Marije_Brummel

Have you tried compiling all objects or doing a db-test. There might be a problem with a tablerelation not set properly.