I think it does, I haven't finished playing with it yet. I'm still trying to understand how all the data works together in the program, I don't have my head around it yet.

Think of it as:1- a large spreadsheet. The grid is used to filters which row are displayed and which column is displayed, and/or2- As a filing cabinet. You place items in folders (fields here). Selecting a field as a grid source, displays items in the folder (This is the Ecco Pro metaphor)

I'm looking at SQLNotes now for the document tracking database, as we discussed in another thread. I must say, though, the proposed pricing is more than I had expected. That's not to say it is out of line with what it should be -- I guess I just didn't know the price range for this type of application. I might have to take another hard look at Access for my database since I already own that!Jim

It all depends on how you value your own time... Also the price is very approximate and will be in line with comparable products. May end-up being less. Finally, contributing beta testers, translators and solution providers get a free licence!

Thank you Pierre. Maybe I will give it a try using a relatively small sample of my data.

Sorry not to have seen your reply earlier. I most likely did get the DC email notification, but I was overloaded with a lot of spam - my ISP's server spam filter died (or broke down?) and I was getting literally a few hundred spam messages dropped into my inbox daily! Had to do some major adjusting to my own spam filters to compensate and I'm sure I missed responding to a lot of good messages in the rush.

Think of it as:1- a large spreadsheet. The grid is used to filters which row are displayed and which column is displayed, and/or2- As a filing cabinet. You place items in folders (fields here). Selecting a field as a grid source, displays items in the folder (This is the Ecco Pro metaphor)

Hope this helps!

this is helpful

I've been struggling with the underlying conceptnot having used database type software before is probably a handicap...

If I follow the logic and metaphor of point one - lets see... using SQL-Notes, I dont understand (yet) how (exactly) you filter things so it's probably too soon to be asking questions -but I'll have a go anyways

Would it be possible to filter one item+subitems (i.e. one of many items) for example from ToDo to another grid?

Is it possible to make new columns - I see there's a long list of them already.

If I follow the logic and metaphor of point one - lets see... using SQL-Notes, I dont understand (yet) how (exactly) you filter things so it's probably too soon to be asking questions -but I'll have a go anyways

Would it be possible to filter one item+subitems (i.e. one of many items) for example from ToDo to another grid?

Is it possible to make new columns - I see there's a long list of them already.

Is it possible to open a new "spreadsheet" ?

1- To uniquely filter a single item put [Edit] "IDItem = xxx" [/Edited] in the source of a grid. ID Item of the item is seen in the properties pane. The source is the left-most box on the source bar (Grid > View source bar to show it)2. Columns are fields. Fields can be displayed as a column in a grid, or in one or many forms. View>Manage fields to add a new. Once created, in your grid: Grid > Displayed column to display it (or drag-drop from the properties pane to the grid)3. To create a new grid: View > Grids > New Grid

The SQLNotes wikispace is being enhance to include beginners guide to introduce new users (especially those without Ecco Pro expertise) to the SQLNotes concept:http://sqlnotes.wikispaces.com/

It is open to all! No need to register to view, comment and make changes. You are all welcomed to visit and contribute. A new Q & A page was added specifically for users questions:http://sqlnotes.wikispaces.com/Q+%26+A

Don't we all have zillions of digital photos. And each camera we buy comes with this semi-useless software to manage your photos...

Long time ago, I added an image viewer to SQLNotes. It was not updated and hence disabled. Well it's back:

* Drag-drop files from Explorer to create items with links to the files. * In a grid, you have user-defined columns to describe the photo (date, who's there, where, rating, etc) * You can add additional information as sub-items (click on the + to see the details, as in Windows Explorer) * You can sort, filter, group easily * A built-in image viewer, which rotates to show constant size (portrait vs landscape) * Double-click on the image will lock the viewer on this photo. Open another viewer to view other photos. You can open as many as you wish (Now you'll like that 21" screen!) * If many viewers are opened, as you scroll in the photo list, a different viewer is selected to show the photo. So the last few photos are always visible. Great when a group of people are looking at them.

* Image file is not imported, SQLNotes creates a link, so the SQLNotes file remains real small * No imaging editing tool included (would be second rate anyway). You use the editing tools that you prefer! Double-click the item in SQLNotes to open it. * You can create many grids where you see some or all of your pictures. Great to view the same photo in different contexts (without making copies) i.e. The grid of the best photos of my 4 year-old and the grid of photos of our trip to the east-coast, some of the photos will be the same. No problem!

Plus, coming soon 3 additions which will be useful for this task:

* Automatic folder monitoring. Tell it which folders (i.e. my pictures/*.jpg) to monitor and any new files will be added to your SQLNotes database automatically, in a separate grid so you know that they need to be documented. * File date will be imported into the database (currently only file name and path are imported). * Option to create a windows shortcut when linking to the file. Hence moving the file will not break the link (Windows monitors shortcuts automatically)www.sqlnotes.net

File date will be imported into the database (currently only file name and path are imported)

If you want this feature to be really useful, I'd suggest allowing for the import of EXIF/IPTC data from image formats that support tagging. (I'm pretty sure there's code on CodeProject.com for this, to save you some time)

Pierre... you're giving birth to a monster. A friendly one, of course. I find that the multimedia aspect is lacking from other free-form databases/organizationnal tools (for instance, I don't think that asksam has any direct support for images -- but I might be wrong -- jimdoria could probably tell). So, at first sight, it seems good to have image support in... SQLNotes (oups, caution! caution! semantically streched name ).

* Automatic folder monitoring. Tell it which folders (i.e. my pictures/*.jpg) to monitor and any new files will be added to your SQLNotes database automatically, in a separate grid so you know that they need to be documented. * File date will be imported into the database (currently only file name and path are imported). * Option to create a windows shortcut when linking to the file. Hence moving the file will not break the link (Windows monitors shortcuts automatically)

SQLNotes (or whatever it is finally called) aim at helping you manage your information. And nowadays, picture files are one hell of an information nightmare. Integrating that with your other information (people, calendar, tasks) is a win-win situation.

Did you try the multi-viewer? Open 4 and as you change picture item, each window gets updated in rotation (best on dual-screen, my second screen is 21" !). No more will you have people say: "Wait, go back to that last one!". And the auto-rotation (portrait-landscape)? (Double-click to lock a window on an image. )

1- SQLNotes is now capable of printing 1-many relationship data. Examples are sales receipt (sale - sale details), Consultant billing (Client - Work done), etc. You can even print multiple invoice, for different clients, in 1 step. Use syntax Parent.Fieldname to show the parent value

2- I'm now working on a Date Filter toolbar. This will allow SQLNotes to be used to manage time (i.e. a calendar) and tasks (i.e. todos) more effectively (View schedule for today, this week, this month, etc, view undone todo's due this week, etc). But it could be used to filter any date related field (want to see items created last month, sales in July, etc)

(in this screenshot, appointments from oct 1 to 22 will be shown -- 21 days as set in the duration box)

That's very generous of you, I might have to take you up on that. However, before I do, I have to give it an honest effort. I just haven't tried all that hard yet, I'm too freakin busy. But I'll get around to it.

I'm in more or less the same boat as superboyac. I'll try to give it a more comprehensive appraisal this weekend.

If you want to see what inspired SQLNotes, you can download Ecco Pro 4.0, which is now freeware (discontinued since 1997).You'll get a calendar, phonebook and notepads (which are like SQLNotes Grids)http://www.compusol.org/ecco/

Of course, SQLNotes is NOT a clone of Ecco. It can handle rich text and data much better. Plus Ecco's I/O was limited. At the same time, some features are still missing in SQLNotes for now... but they'll be added!