Why is there a 255 field limit in MATLAB Database toolkit?
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
I am durrently using MATLAB 2012b. A while back, I noticed that queries that should have returned more than 255 columns only return the first 255, with no error.
You might point out that no actual database table should have that many fields (have you never even heard of normalization?). But I'm frequently staging hourly data (so 8760 or so values a year) by thousands of columns in a spreadsheet. To pull that in via database toolkit, I am forced to define multiple named ranges (each with less than 255 columns), and issue multiple queries, instead of a single named range and query.
I guess this could be a limitation of the Microsoft ODBC drivers, or of the ODBC spec in general?
0 Kommentare
Antworten (0)
Siehe auch
Kategorien
Mehr zu Database Toolbox finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!