SQL Server Error on Field Rename

sgg

Setting :
Attain 3.70 B Client Running on SQL

Issue :
After Renaming a field in a Table, I could NOT save the Modifications made. I get the following error:

The following SQL Server error(s) occured while accessing the Employee Table:
15333, "42000",[Microsoft][ODBC SQL Server Driver][SQL Server] error: The qualified @oldname reference database(DatabaseName) other that the current database.

DenSter

I've seen that error where the customer was on SQL and we developed on C/SIDE. For some reason there's something that doesn't go together well. I think we just created our own SQL database and redid the development.

sgg

In this case, I am Developing in 1 Database (SQL database).

But I could not save the Table after Renaming the Field.
The system did not allow the modification made.

ara3n

Hello the problem is that when you select your database name, navision is not case sensetive, but when you try to rename a field SQL errors because it's case sensetive.

Please close the database. login again and do a lookup on database and and select the database. This way you have selected the right name with correct case. Now you can rename fields.

sgg

Thanks ara3n
I will try what you suggested.

kine

What about recompile all objects?
Or try to disable all keys, save, enable them... to recreate the SIFT triggers on the table...

sgg

Thanks ara3n,
your suggestion to Login by Using the Lookup to DatabaseName rather than typing the DatabaseName WORKED.
=D>

ara3n

you welcome. Ran into the same problem programming on site, working on sql. It's not the lookup that you have to do. Just make sure the database name is in correct case.

kriki

[Topic moved from Navision forum to SQL General forum]