Show all posts by user

Re: Auto-increment problem in back-ups

10 years ago, by Praxis in NetWorx Forum

That's good that you kept at it until you found the solution. I have to admit that I had no motivation to get to know that program in depth since I knew of two others that could do what's required. Did you contact the author or discover the solution yourself?

Re: "Ignore LAN traffic" setting became unchecked

10 years ago, by Praxis in NetWorx Forum

W7-64 Pro, did not have your problem The 'exit' worked The box stayed checked Sounds like you may have some other issue that impacts NetWorx

Re: Auto-increment problem in back-ups

10 years ago, by Praxis in NetWorx Forum

You shouldn't attribute human characteristics to inanimate things by saying that databases behave and programs get confused. Programs simply do what their author has defined/designed them to do and databases simply exist as defined by the person creating them. All browsers are programs but not all programs are browsers. Do you say 'browser' when refering to Excel, since Excel lets you browse th

Re: Auto-increment problem in back-ups

10 years ago, by Praxis in NetWorx Forum

Well it might make sense to ask the author of the browser why his program does what it does. Right now all we know is it doesn't work properly and we can guess all kinds of things but he's the one to debug his program

Re: Auto-increment problem in back-ups

10 years ago, by Praxis in NetWorx Forum

QuoteRod Hi again, I opened a copy of Networx.db in the browser and pressed the button and the same thing is happening as with the back-up file. Table: 'usage' Last Record No.: 30, Name, 42404, 22, 0, 0, 0 -------------------------------- Pressed button and got the following error message: Error adding record: CHECK constraint failed: usage (INSERT INTO 'usage' ('USER_NAME','DAY','

Re: Auto-increment problem in back-ups

10 years ago, by Praxis in NetWorx Forum

I decided to see what the sqlitebrowser can do and found that when I tried to add a record to the usage table by clicking on the button that it tries to add/insert a record with incorrect values for record number, day and hour. I have no idea how it picks those values, it certainly doesn't open up an input window to allow me to specify the values which is what I'd expect, so in my opinion the

Re: Auto-increment problem in back-ups

10 years ago, by Praxis in NetWorx Forum

QuoteWith a new database created in the browser, I can manually add records ad infinitum true if you haven't specified a unique index on the database table but not true when there's a unique index specified for the database table... which is what networx is doing with user day hour. Unique means that there cannot be multiple records with the same values in all key fields. J

Re: Auto-increment problem in back-ups

10 years ago, by Praxis in NetWorx Forum

QuoteHope all this makes sense. Yes, now it does. As Andrew points out, sqlite doesn't know about networx and that Netwrx is using hour is a 'time' field, after all the values are simple integers, there's no tell-tale format such as "yyyy.mm.dd.hh.mm.ss". Same for the day field So it simply adds 1 to the hour value in the 'last' record, and that's not wrong for it to do that.

Re: Auto-increment problem in back-ups

10 years ago, by Praxis in NetWorx Forum

Quote That's exactly what I'm doing. are you really sure? "backup.DB" is smaller than "networx.db" on my system Why would you want to modify the backup? Were you intending to import it back into the "main" file?

Re: Auto-increment problem in back-ups

10 years ago, by Praxis in NetWorx Forum

Quote Bearing in mind I know next to nothing about SQLite databases, I think there may be a problem with Networx back-ups which are now in SQLite database format. well it wasn't clear which file that you meant, you said your 'backup' which is a static file concept i.e. at a specific time. and you commented that it was now in the sqlite format. So I assumed that you weren't talking about a 'cop

Re: Auto-increment problem in back-ups

10 years ago, by Praxis in NetWorx Forum

First, you shouldn't be updating your backup file, you should be updating the main file (or a copy). There's only one record per user + day + hour, i.e. that's a 'unique key', you can't have multiple records with the same key so what you're doing is wrong. If you want to 'update' a specific record/unique key then you can do that with sqlite very easily by clicking on the value and then editi