nn unique column reference Nodbc

bimo88
bimo88 Member Posts: 22
hi,

i'm using a php script to get data from nav.
i have a message error like this : nn unique column reference

i searched and i founded that there is two cases.
1- if two of ur fields have the same caption
2- if there is many fields in your table.

for the first ,i have no fields with the same caption.
for the second when i delete some fields its works.

what i want to know if there is a way to bypass this because i can't delete fields from the table

hope anyone could help me
thanks a lot.

Comments

  • ara3n
    ara3n Member Posts: 9,258
    I don't think how you can bypass the second issue. You can upgrade to sql or create views in MS access for the tables and then access the views from your php script.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n