-
I've a problem, who can help me? I've a SQLServer table sorted by a type code field that show the following records A A2 A3 B B2 C Why the same table called like a temporary table, containing the same record and ordered with the same key, show records ordered like the following? A B C A2 A3 B2...
-
Hi friends I have changed the back end from Nav native DB to SQL sever 2005 . I open the sql DB and check the flow fields in customer ledger ex:- Amount, Original Amt. (LCY), Remaining Amt. (LCY), Original Amt. (LCY) . there are not there where can I find them . how this fields are exsist . for the purpose...
-
Hello. Temporary tables are sorted based on Navision native sorting. I suggest to use a new field with a key and as you are inserting into the temp table, increment this new field. Then set the key on this new field.
-
Check http://dynamicsuser.net/forums/p/21522/103596.aspx You could also use another PK values.