Hi all! I have problem with duplicate table, when i do it i can’t explore it and sql call error - invalid object name… This table is in axpapta but i don’t see it in sql database… and maybe it’s important if sholud try to compile axapta code - aplication call SHRINK ERROR …NAVISION\AXAPTA CLIENT\BIN\GridEx20.ocx (3.4) - Dispatcher initialisation error trapping exeptions Have someone problem like this? Thx for help
Hi, Please note that the error message is from a 3rd party ActiveX control and not from a table. Please see whether this helps - http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=14134#50770 Good luck [:)] Harish Mohanbabu
Yes, a found this topics… But this resolve only one problem… Still when i do duplicate of the table in axapta - a get sql error… after synchronization and compilation…
And, i saw that when i duplicate table - and next i made synchronization - i can open the table - but no one record copied…
Yes, it is true, the feature is only duplicating the structure of the object, but not also the data. You have to do a custom routine to achieve that goal.
Hi, The duplicate table in Axapta is a straight forward way of doing the same through EM in MS SQL Server. And yes - it will just copy the structure and not the underlying data. But usually Axapta would not throw any error message in such instances. I am not sure but perhaps the error could be somewhere else. Have you tried running Consistency check under Basic → Periodic ? Regards, Harish Mohanbabu