Messages

1

N.A.N.Y. 2011 / Re: NANY 2011 Release: Snap DB

« on: August 30, 2012, 05:33 AM »

Ok, thanks for looking into it. I will probably remove the commas.

I have another query about usage.
I have a number of SnapDB databases and I like to use different fonts and window sizes for each.
The only solution I've come up with is to have a directory for each with its own copy of SnapDB.exe and config.ini.
I could use a wrapper to swap config.ini files but that also seems inelegant.
Is there a better way?

2

N.A.N.Y. 2011 / Re: NANY 2011 Release: Snap DB

« on: August 26, 2012, 11:56 PM »

Thanks for the very quick update.
The totals now agree with the spreadsheet that the data came from.

Re sorting numbers
I've tested under XP and W7.
I get the same results on both.
Column 4 ^
1,000
2,000
3,000
500

Also comparisons using the same data
 |Column 4| |Greater than| 499
Gives only the row with 500

3

N.A.N.Y. 2011 / Re: NANY 2011 Release: Snap DB

« on: August 26, 2012, 12:04 AM »

Thanks Skywire,
I use SnapDB regularly. It is very good for a few hundred records, I haven't tried anything larger yet.
It is very responsive on my very old laptop.

I created a new DB from a spreadsheet CSV export and ran into a small problem.
The DB contains numbers with commas eg 124,256.
These numbers do not sort in numeric order and are not added up correctly.
I could remove the commas but large numbers are hard to interpret without them.

Any chance of ignoring them in otherwise numeric fields?

4

N.A.N.Y. 2011 / Re: NANY 2011 Release: Snap DB

« on: March 30, 2011, 07:14 PM »

2. I understand the reasoning behind this.  However, this would sort of break the mass import you can do by dropping a bunch of CSV onto the list (or multi-selecting them via the file choose dialog).  Did you see the Edit/Context menu option to convert a row to the header?  Maybe a solution/option would be if there was only one file dropped (or selected via the dialog), auto convert the first line into a header.

-skwire (March 28, 2011, 03:49 PM)

Thanks for the quick reponse.
Re 2, yes I have used 'Edit > Convert row to header' several times. I am using SnapDB to publish tables from an SQLite database because it is much easier to use. I havent attempted to load multiple CSV files. Your solution sounds good.
Further use has suggested another possible enhancement:
Numeric fields with different lengths don't sort as I expect. eg 2000 appears before 300 for an ascending sort.
It would be good if SnapDB could somehow recognise a numeric only column and sort it by numeric value.
If the data comes via a delimited file then digits only and no enclosing quotes could possibly be used to indicate numeric.

5

N.A.N.Y. 2011 / Re: NANY 2011 Release: Snap DB

« on: March 28, 2011, 03:00 PM »

Skwire, thanks for your excellent program, I can see many uses.
I have some suggestions that would make it even more useful for me.
1. Don't clear the filter match field when you turn off filter mode - I often want to use it again.
2. A method to import a CSV file, use its first line as header names and delete that row in one operation.
3. More filter types like "doesn't equal", "doesn't contain", "greater than", "less than", regular expression match.