nistam Posted July 22, 2005 Report Share Posted July 22, 2005 Hi folks. I created a database with more than 256 fields on a table. Actually the number is 598! Anyway, the cluster size can be only 256, so i can write only 256 with one call. My problem is that i must write all the 598 at once. I've thought of writing the first 256, then go back to that data row and write the next 256 and so on, but i gets complicated... Has anybody found a solution to such a problem, a workaround or something? And guys, NO, i can't (and won't) split all these fields to 3 tables. Quote Link to comment
nistam Posted July 22, 2005 Author Report Share Posted July 22, 2005 Hi folks.I created a database with more than 256 fields on a table. Actually the number is 598! Anyway, the cluster size can be only 256, so i can write only 256 with one call. My problem is that i must write all the 598 at once. I've thought of writing the first 256, then go back to that data row and write the next 256 and so on, but i gets complicated... Has anybody found a solution to such a problem, a workaround or something? And guys, NO, i can't (and won't) split all these fields to 3 tables. 5373[/snapback] DON'T BOTHER at all! NI has it! Some times i feel so idiot! I could search NIs KB before posting here. Quote Link to comment
tikustanah Posted May 4, 2006 Report Share Posted May 4, 2006 You can also try with SQL. Simply form the SQL command and use the Execute SQL function. Quote Link to comment
Michael Aivaliotis Posted May 13, 2006 Report Share Posted May 13, 2006 So really, your problem has nothing to do with databases but the conversion from an array to cluster... Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.