Main Area and Open Discussion > General Software Discussion
SQLNotes...what is it exactly?
superboyac:
OK, I understand how the program works now. I still have questions:
1) Is there a way to remove an item from the grid without removing it from the database?
2) Is it possible to copy an item in a grid and place it in another point of the grid (duplicated), without creating 2 separate items (they are the same, they just appear in two different places)? If so, how would I know if an item that has been duplicated is a duplicate and not a stand-alone item? Ideally, when you edit an item and that item appears in other places, you want to know that you are going to be changing it in all those places.
PPLandry:
>removing an item from the grid
Item appear in the grid if (1) they meet the grid criteria and/or (2) they are sub-items of items that meet the grid criteria. Like I said earlier:
In your example, you are viewing the MusicItem field (or folder if you like the folder metaphor). Any item that have something in this field will be shown. If on line 96 you erase the MusicItem cell (=Alien), that item will no longer be shown in that grid (F5 to refresh)
>Copying items
Top level items (TLI) position is determined by the sort criteria. Sub-items can automatically be sorted if Grid>Sort criteria applies to sub-items is checked. Otherwise, you can drag-drop (or use buttons) to move sub-items up/down or right-click on the parent and click sort ascending or descending.
The same item can appear more than once in a grid for a number of reasons:
1- It has multiple parents. If these parents are displayed in the grid, opening each parent will reveal the sub-item
2- If hierarchy is not checked and both a parent and the item meet the criteria, then the item will be displayed in the grid (as a TLI) and as a sub-item of the parent (if the parent is opened)
If you want the same item to appear in 2 different places in a grid, you can assign it 2 or more parents. If the parents are shown, each will show the item.
To know if two items are really just one, you can look at the itemID (or other info, such as parents, values, etc)
I prefer not to use the word duplicate which can be confusing. The same item can appear in different grid (of course) but as explained just now above, in the same grid also. 2 different items may have the same text for a field, but they are totally distinct.
superboyac:
Well, PPL, I think I'm pretty much sold on your program. I think SQLNotes is pretty revolutionary. I don't know if you're aware, but a while back, I wrote the big notetaking review here:
https://www.donationcoder.com/Reviews/Archive/NoteTakers1/index.php
SQLNotes definitely belongs on top of that list. It offers features and flexibility that are truly unique as far as I can tell. I will say one thing; it's not for everyone. I'm not saying it's difficult to use, but it's not what you expect from a notetaker. I don't even think I would call it a notetaker. It's more of an outliner than a notetaker, but it does notetaking as well as any notetaker. Furthermore, it's Access for normal people.
superboyac:
Well, now that I'm going to commit to SQLNotes, I'm going to have lots of suggestions for it. Here's my first one.
Searching should be an essential feature of the program. Other notetaking software like EverNote and Zoot have awesome searching capabilities. If SQLNotes is used like I'm thinking it's going to be used, it's going to have a ton of information, and it should be easy to find what you're looking for, especially if you don't remember where you put it. RIght now, SQLNote's search doesn't work at all for me, but I think it's because I deleted the Search grid that came default. For some reason, it doesn't work in the default database for me, I don't know why. Anyway, I'm sure PPL will beef up the search, it's pretty important.
superboyac:
OK, I hate to say it, but I just lost all my data again. I get an error saying "error opening grid. check grid source criteria". All the backups say the same thing, so it looks like I lost everything. This is a concern for me. I love the program, but I'm going to be putting a lot of time into my grids, and I can't really afford to lose that information.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version