Hey Brian, Welcome to NSB.
Sorry I can't help much on the ADOCE side, but I can give you some tips on the files side. The system I've built using NSB utilizes a similar setup to what you're talking about by using a key number. All I do is append the number to the end of the file name. The number is autogenerated, but other systems I've built have used user input for the key. It's really simple and makes it easy to load/save previous records. I'm not really sure what you mean by "create completes batch files in a similar manner and use the time date function to name them easily, again this is easy to do but my dilemma is with the collating or dynamic data which I cannot afford to lose for legal reasons.." If you're talking about using the date/time stamp as the key field, I'd warn against it as that could complicate opening/editing older files. One thing you can do to guard against losing data is copy the file you're modifying over to a backup spot (another folder, backup card, etc) prior to any edits to the file. If anything happens to the original, there's always a backup to restore from. With as many data writes/deletes as my program does, I have never ran into a problem with losing files/data that wasn't my own making. ;) The one big part of this that you didn't mention in your original post is what is the ultimate goal of this data? Will it reside on a server, stay only on the CE device, etc? This could greatly influence the choice you make in your initial design. If the files are going to remain/grow on the CE device, I'd go with a formal db structure; if however the files are going to be downloaded to a central server, comma-delimited text files are REALLY easy to handle. Hope this helps. Shaun --- In [email protected], "brianm...@..." <brianm...@...> wrote: > > > Hi I am new to ns basic and need a little help? > > I am trying to store some recipes on a system using NS Basic Ce to > develop but I don't understand a couple of things. > > If I use ADOCE and create a database the first time I run the program > is the database that is created automatically stored. If when I > restart the program say after a power down is there the capability to > check if the database already exists? > > I need two tables, one with 10 fields and the other with 25. The > first contains my recipe settings and the other collected data. > > I think the system can do this but I am not familiar enough with CE > devices. > > Alternatively I can write to and read from a file but Is there a > limit on how many times I can do this, potentially I will be doing > this about 5000 times per hour. It is not clear how to create the > array and then store it at a location where I can read and write to > it. > > I also thought of creating my recipes as individual text files and > linking a number to each one so that I could work through them and > store them on the flash disk on the unit. This way It looks very easy > to do and often easiest is best. I can create completes batch files > in a similar manner and use the time date function to name them > easily, again this is easy to do but my dilemma is with the collating > or dynamic data which I cannot afford to lose for legal reasons. > > Can you shed some light on this for me please? > > Regards > > Brian > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nsb-ce" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nsb-ce?hl=en -~----------~----~----~----~------~----~------~--~---
