topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Tuesday November 11, 2025, 2:49 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Recent Posts

Pages: prev1 ... 20 21 22 23 24 [25] 26 27 28next
601
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 30, 2007, 01:40 PM »
Yes you should remove the equation (as in my previous instructions). The values will stay of course. The equation was just to do the copy.
602
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 30, 2007, 01:12 PM »
Notice the top-left box. It is the folder (or field) being viewed.
If nothing is shown in the grid, it is because the field has no values.

What you want, is to see the values from MusicItem. Select that field in that box and hit enter to refresh!
603
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 30, 2007, 12:30 PM »
OK, i did that, and I saw the status bar go through the items and update everything, but the column in the grid is still blank.  How do I fill in the column with the values that are now stored in the field?
Not sure I follow you here, but you can try to refresh (F5) or close the grid and re-open.... Can you post an image if this does not help you
604
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 30, 2007, 12:14 PM »
In field properties:
Screen 00011.jpg
605
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 30, 2007, 11:58 AM »
Is there a way to transfer the contents of one column of one grid into the column of another grid, even though the columns represent different fields?

Yes there is an easy way:
1- set Item field equation to:  = SongTitle
2- Click update (next to the equation)
3- remove the Item field equation and save it

p.s. remember, columns are simply a display of the field. You want to operate on fields, not columns. As to grids, they are not related to fields. They serve as a window of your data (items and fields values)
606
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 29, 2007, 06:49 PM »
OK, I found out what the problem was.  For album and artist fields, i had the "auto-update" box checked, which is bad apparently.  Can you tell me what that is for?
Auto-calc is for fields that have equations which depend on todays date (Urgency is a good example). It tells the system to update the value on a change of day.

I'll check if this can be the cause of the display problem you observed (I doubt it, but...). It definitely should be safe to use.

[edit] After checking, yes, this is the cause of the problem you observed. I'll fix it immediately. Please download the daily build. [edit] It is now fixed.
607
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 29, 2007, 06:46 PM »
Oh No!  Disaster!  I just opened up the database I made yesterday, and on the bottom of the screen is was saying something about auto-calc fields, and now all of the album/artist fields disappeared!  This is bad.
This was certainly just a display problem. In 3 years of using SQLNotes, I've never lost anything!. I'll check on this issue
608
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 29, 2007, 06:45 PM »
You know, I just realized that the itemparent way is better.  My only issue is this: does the position in the hierarchy determine whether the item is album/artist/song?  Is that going to be an issue if I try to use the same data in a different grid?  How will I be able to filter out albums, artists, and songs if I don't have those distinct fields and they all go into the same field?

If you want to be able to filter on artist, album and/or song, it is best to either have a text field (dropdown type) where you enter the type of info, or use 3 checkbox fields (isArtist, isAlbum, isSong). Your original method will work too.

(sorry for the delay, I was at a client's today)
609
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 29, 2007, 07:41 AM »
In your method, there is no way to make inherited value read-only (currently). This feature will be added soon.

If you use the other method (ItemParent, ...), these are always read-only
610
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 28, 2007, 10:10 PM »
Or if you wanted to add a ratings column, to allow filtering (rating>2 for example), it could be:

MusicLibrary2.jpg

[edit] but don't get me wrong, your approach is quite adequate, so stick with it if you want.
611
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 28, 2007, 10:02 PM »
Along the Ecco line, you can create special parent fields (default template has been updated with those fields). The UI would now be:
MusicLibrary1.jpg

Notice that you only enter information in the items column, the other columns are generated automatically and take NO space in the database.

Have fun!
612
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 28, 2007, 09:44 PM »
Your structure will work, but there is redundant information. In the Ecco concept, you could use the Item field (column):
- Author
- - Album 1
- - - Song 1
- - - Song 2
- - Album 2
...

Both are valid ways of doing. It all depends on what you want to do with your info. What kind of analysis you want. Your approach allows better data analysis. The Ecco way is simpler and visually more pleasing, but data extraction/analysis is more limited. But it gets the job done very quickly:
1- Create grid MusicLibrary
2- Start entering singer, album, song. No fields to create. Just use Item.

Either way is good!

613
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 28, 2007, 09:00 PM »
Can I hide that "#" column?  Do I need it?  Does each item have its own ID number that the program keeps track of?  If I start a new grid and want to reference items in another grid, how do link to that item?  I'm sure there has to be a unique ID somewhere for each one.

Also, i couldn't find how to do this, so if there isn't this feature yet, it should probably be added: expand all/collapse all.  There should be a way to expand all the items and collapse them all, to save some tedious clicking sometimes.

I'm loving this program...
- To hide the # column, reduce its size to zero
- Yes all items have an ID. Checkout the properties pane, first line. You can drag it to the grid if you want it displayed
- Items dont belong to a grid. They are displayed in grids. So an item can be displayed in as many grids as you wish. The grid criteria decides which items are shown.
- Expand All: CTRL-9
- Collapse All: CTRL-1
- Check Grid>Save Item State. The grid will always return to the same state

Glad to see that you've seen the light. It takes a while to graps it. Congratulations
614
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 28, 2007, 06:25 PM »
Thanks, this program is awesome.  It's like Access except easier to use.

What's the plan for user-defineable keyboard shortcuts?

That's exactly it. Access but simpler, plus with outline, fonts, HTML, calendar (soon),  plus ...

You can already customize some. All will be customizable. Do same as Office to customize (right-click on toolbar > customize ...
615
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 28, 2007, 05:34 PM »
You probably want to set inheritance for both Artist and Album fields (value-> sub-items checked).

Yes it is fine to ask here!

[edit] if you set inheritance and make a change to the artist, the change will trickle down
616
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 28, 2007, 04:13 PM »
In HTML pane menu>File>AutoSave
617
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 28, 2007, 04:07 PM »
Great!
There is an auto-save mode for the HTML Pane, you probably want it enabled. If you experience any problem with it, do not hesitate to inform me. If editing is problematic, you can resort to writing the content in an email and drag-dropping in the pane. I don't use the pane much, so it is not as well tested.

You can of course, drag-drop web content about the song to this pane.

Any suggestions are welcome!
618
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 28, 2007, 03:35 PM »
You can use either a regular field or the HTML pane.
If you use a regular field, Shift-enter enters a line-return. Shift-F2 opens up a editing window and then Enter works as expected.
If you use the HTML pane, formatting is easier. However exporting to Excel will fill it with the complete HTML code, which may be a problem. I haven't tried that one yet.

The advantage of the regular field, is that you can see it in the grid.

If you go with the HTML pane, let me know, I can make a modification to allow for Excel export of that content

BTW you know that the default template (file>new) includes a fully working sample of your basketball example?
619
XP starts up the application in the same monitor as the last time (if available). If you write the app, you can control this, otherwise, I don't think you can do much.
Interesting.  How do I make an app start on the secondary monitor the first time?

Thanks -- Vincent
You don't need to. You open the program, then drag the window to the second monitor. Close it. It will now open in the second monitor. Different monitor resolutions is no problem. Works for me all the time (I have 1400x1040 on the notebook and 1600x1200 external. Check: Extend my Windows desktop onto this monitor in screen>properties>settings
620
XP starts up the application in the same monitor as the last time (if available). If you write the app, you can control this, otherwise, I don't think you can do much.
621
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 26, 2007, 11:23 PM »
No, Outlook has date/time based alarms only, and only 1 per item (as far as I know)

[value-based alarms]
So when a value is automatically re-evaluated (yes SN does this in background), it can trigger an alarm (project cost going over budget, stock value going under a certain price, etc).

Alarms will be of varying levels too. Some will simply show up in an non-disruptive alarm/reminders window. Other more important ones will show in a message box. The alarm level will be calculated, so the same alarm will display differently, depending on other parameters/values (i.e. appointments can be made to first show up in the alarms window, and later on in a message box). An infinite number of alarms will be possible for each item.

Finally, it will monitor/display alarms from a number of database files (much like Ecco). The process will run independant of SN and it will be possible to load it at startup to have alarm notifications even when SN is not running.
622
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 26, 2007, 10:59 PM »
Great to hear that. I personally was never a beta tester. So I admire those that have/take the time to try work-in-progress software.

I expect to have a first calendar as a X-mas gift to users  8). It will have Outlook-like recurring events and alarms (more advanced versions of these will follow, including multi-database value-based alarms, not just date-based)
623
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 26, 2007, 10:44 PM »
I can understand  :-[.

But even without these, it can be a great information manager. I've been using it for the last 3 years to manage my life and my business. I'd never go back to Ecco. IMHO, the organisational capabilities are huge!
624
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 26, 2007, 08:29 PM »
Version 0.9.20 is released. All users can download a free version at www.sqlnotes.net
625
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on November 25, 2007, 08:14 PM »
You can now use the new formatting toolbar to easily apply formatting to items:
(foreground color, background color, font, size, bold, italic, underline, strikeout).

ItemFormatToolbar2.jpg

Plus since the formatting is simply stored in a field, you can:
* search for items with any given formatting (all red, all italic, bold and green, etc)
* Choose a different field for the format, and instantly change or remove the formatting

SQLNotes is becoming more and more text outliner friendly (it was initially more of a data outliner/grid)
Pages: prev1 ... 20 21 22 23 24 [25] 26 27 28next