Write to more than 256 fields

[nistam]

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.

[nistam]

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.

[tikustanah]

You can also try with SQL. Simply form the SQL command and use the Execute SQL function.

[Michael Aivaliotis]

So really, your problem has nothing to do with databases but the conversion from an array to cluster...