Pipe Sql: When querying a multiple column table, e.g. FROM <data table name> SELECT * , only the first column (the key column) returns data, the remaining colums show -- or blank. How do we query when the data table has multiple columns?
I'm not able reproduce this. Running a `select * from <datatable>` returns all the columns available for me. You could run a test of querying select a,b,c from <datatable>` to see if that returns fields as expected. I briefly tried on a range of…
--
Sep 30
I figured it out! I had set the non-PK column to allow repeating values. I misunderstood the purpose of this setting. I though it met, unlike a PK, that the column would allow more than one record with the same value. Instead of multiple values in the same field.... wow, fixed that in my table and now it works!
--
