Problems setting file position

[DelEngUK]

Hi,

Thanks to everyone who has helped me so far. Its very much appreciated.

I have a problem setting file position.

What i'm doing is performing a test and saving rows of data to a database (lvm). Those results some times fail and they are marked as such.

I can then search my data and reload the data (as a full row) at a later date (after reworking product) and retest the failed section.

I want to resave the data (as a full row with ammended results) over the top of the old. The data array is the same dimension as earlier, just replacing FAIL with an actual pass result.

Thing is when i hit save, it either saves it to the end of the file or the beginning of the file. I can understand this as that is how i have file position set, but when i set it to current it save it at the top but second column in.

I am trying to set the position of where it saves as the same index point as where it found the data in the first place.

Can someone tell me what i'm doing wrong?

Here is a sample set of data.

[P@Anand]

You can do that in another way. I see the file is small in size only so read the whole file keep it in momory read the data you want to change , change it and then write the whole data again into the same file.

[DelEngUK]

Hi,

i did think of doing it this way, but the file obviously grows in size as we do tests. I don't want to have unmanagable arrays going backwards and forward into the program.

I assumed i could just over write the data, which i can actually do....just not in the right place it seems.

Its the figuring out of the position i am struggling with.

[David. B]

Hello,

The way you currently have the application set up I think the only way to do this would be as was suggested above. Currently are you only using the Write to Spreadsheet VI to write the data? I think if you were to use the Report Generation Toolkit and write to Excel then you find it a lot easier to edit data within the spreadsheet, is this a possibility?

Kind Regards

[DelEngUK]

Hi

i am worknig on this in another way and started an alternative thread as its technically a seperate subject.

This thread here....but again, not working correctly and i'm struggling to sort this.

http://forums.ni.com/t5/LabVIEW/String-format/m-p/1971113