pb with SQLhello,
what does it means?
which solution?
best regards
Re: pb with SQLok, thanksRe: pb with SQLHey,
Just to elaborate slightly:
JMP is "unusual" in that it lets you create two columns in a JMP Data Table whose names differ only by case. It is rare to find a database system that supports this. The database engine that we built into JMP to allow Query Builder to work on JMP data tables (SQLite) does not support two columns in a table whose names differ only by case, and that is why the query cannot proceed.
HTH,
Eric
Re: pb with SQLok, thanks
Re: pb with SQLNot sure if this an SQL or a JMP thing, but based on the error message you have two columns that have the same name with the only difference being "LAIT" for one and "Lait" for the other. If those two columns are necessary then you should try renaming one of them slightly. If they are same and only differ by the capitalization then it seems you will need to remove one of the columns and go from there.