I have gone along the file route for ease of programming. The device doesnt support ADOCE but does SQLITE and it is very easy to implement.
The report produced from the device can be stored on the devices removable memory on either SD card or usb memory stick. Each report is only 1 KByte long so I have plenty of room for many years worth. The recipe structure is written to file as a string and is stored again on removable media. I have almost finished the programing, and have been on the whole impressed with NS Basic but I cant get my head around these "installers", Windows looses them on power off. The system controls a machine and so on power up the device is set to autorun and will only ever run the program I have written for it. I assumed you made either a .exe file or an installation program would be included like VB has. Anyway I can make the unit run when the program is finished, I am sure somebody out there has done this! Regards Brian --- In [email protected], Harold Wood <hwoody2w...@...> wrote: > > While sqlite doesnt support customized reports generating reports is pretty easy, there is a code tutorial on the website that explains it. > > Woody > > --- On Mon, 2/16/09, Shaun <phill...@...> wrote: > > From: Shaun <phill...@...> > Subject: [nsbasic-ce] Re: Storing data on the ce device > To: [email protected] > Date: Monday, February 16, 2009, 8:49 PM > > > > > > > Brian, > > Based on the fact that you have to summarize data, I'd be inclined to > go to a RDB, either SQLite or ADOCE. It's kind of a pain to have to > open and close several files to get that data (if you were to do it > through flat files) as opposed to simply summing a column and > dividing by the number of records. Also, I'm not sure if they do, > but if either SQLite or ADOCE support customized reports, that's > another reason to use those with your printing needs. > > Again, I'm not much help when it comes to either of these, but there > are plenty of folks around here who are. Also take a look through > the tech notes and samples. > > The only reason I use flat text files for my on-device data storage > is the data doesn't exist for very long on there (at most a few days) > and the data isn't manipulated at all once it's saved > (summarizing, etc). All of that happens once the data gets downloaded > and imported into a full MySQL server in our office. Your needs are > quite a bit different and therefore require a different strategy. > > Shaun > > --- In nsbasic...@yahoogro ups.com, "brianmeek@ .." <brianmeek@ ..> > wrote: > > > > Shaun > > > > Thanks for the advice. The device is part of a machine that checks > > the weights of packs on the fly, we weigh every pack. Data is > > collated every hour to prove the average weight of the batch is > above > > a certain level.Once the data is stored it will only either be > > printed locally or be transferred to a server. I would only need to > > look at very recent historical data normally on the device perhaps > > the last weeks or so. The device is connected to a PLC to operate > the > > machine and aquire the weights etc. > > > > My background is with PLC and not this type of device so I am > unsure > > if the CE device is the same as a PC, from what I can make out it > is > > and so I should be able to program up the unit to work. I have also > > taken on the job with an extremely short lead time! > > > > I think I would like to go along the file method because I am more > > used to this with other projects. > > > > Regards > > > > Brian > > > > > > > > --- In nsbasic...@yahoogro ups.com, "Shaun" <phill214@> wrote: > > > > > > 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 nsbasic...@yahoogro ups.com, "brianmeek@" <brianmeek@> > > > 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 -~----------~----~----~----~------~----~------~--~---
