If I try to import all columns in one go then approx the first 60 columns (or so) get imported into the list BUT ALL columns are shown in the SELECT query at the bottom.
Seems like a bad database design to me, maybe not applied the database relation theory optimally or do you really have so much properties for each item to store.
Hi George, just to give you an idea, each row represents a report, and the columns are each field entry.
The report is made up of a minimum of 3 pages similar to this (some could be 7 or 8 pages), areas in red represent data manually entered, stored and pulled from the database. 53 elements indicated on this screenshot alone.
Calm down, calm down!
Unfortunately I have been around these forms and processes for 25 years so I know them inside out. They have always been created as Microsoft Word Templates and I am trying to make them web based. The job is taking a lot longer than originally estimated but getting close now.
I have an E36 328is and E39 M540i back in the UK, straight six and the V8! Had a couple of M3’s in the past but really do prefer the 328 with an LSD and mapped! De-badged of course, both motors are BMW Arctic Silver!
Sorry to disappoint Dave, this is a dummy report and I’m not really a fan of BMWs. Saying that M540i is nice, as is a 740i which I used to drive. The chap for whom I am doing this site used to have an E36 M3 in blue and it was his pride and joy. Currently I’m in a Cupra ST 4Drive Stage 1 and absolutely love it.
I’m not aware of any limits, will try to figure out where that limit is. If you need all columns then you could use * instead of selecting them all, or are you excluding some?
It seems that the 150 limit is related to the grid component we use, it has a limit of 150 records that it initially shows, but it should add 15 more each time you scroll down. I will investigate further why our implementation isn’t loading the extra records or maybe we could just increase the initial records that are shown.
From what I see at this moment is that the columns are probably all added but it only shows the first 150 records in the grid component. Did the remaining columns show up in the query preview?
