Welcome Guest.   Make a donation to an author on the site October 22, 2014, 04:50:59 PM  *

Please login or register.
Or did you miss your validation email?


Login with username and password (forgot your password?)
Why not become a lifetime supporting member of the site with a one-time donation of any amount? Your donation entitles you to a ton of additional benefits, including access to exclusive discounts and downloads, the ability to enter monthly free software drawings, and a single non-expiring license key for all of our programs.


You must sign up here before you can post and access some areas of the site. Registration is totally free and confidential.
 
The N.A.N.Y. Challenge 2012! Download dozens of custom programs!
   
   Forum Home   Thread Marks Chat! Downloads Search Login Register  
Pages: Prev 1 2 3 4 [5] 6 7 8 9 10 ... 47 Next   Go Down
  Reply  |  New Topic  |  Print  
Author Topic: SQLNotes...what is it exactly?  (Read 406854 times)
tinjaw
Supporting Member
**
Posts: 1,926



I'm so glad breakbeat techno isn't an illegal drug

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #100 on: November 16, 2007, 03:10:02 PM »

At the same time, some features are still missing in SQLNotes for now... but they'll be added!

Ooooo Ooooo I want a pony. No! A schrubbery.
Logged

 
jgpaiva
Global Moderator
*****
Posts: 4,710



Artificial Idiocy

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #101 on: November 16, 2007, 04:28:50 PM »

No! A schrubbery.
Ni!!
« Last Edit: November 16, 2007, 04:31:35 PM by jgpaiva » Logged

Darwin
Charter Member
***
Posts: 6,979



see users location on a map View Profile Read user's biography. Give some DonationCredits to this forum member
« Reply #102 on: November 16, 2007, 06:22:33 PM »

Dang! And I was trying to think of a rejoinder - perfect, João  Thmbsup
Logged

"Some people have a way with words, other people,... oh... have not way" - Steve Martin
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #103 on: November 17, 2007, 11:21:58 PM »

Just an update:

A DateFilter toolbar is now available in SQLNotes. It can be used to easily filter on date ranges (day, work week, week, month, year, user-defined length). With it you can:

1- Manage appointments
2- Manage ToDos
3- See information added or modified last week
4- View invoices for July
5- Billable hours done last week
5- etc.


(This would show appointments for the month of october)
« Last Edit: November 17, 2007, 11:29:19 PM by PPLandry » Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #104 on: November 22, 2007, 03:06:12 PM »

A new example was posted on the SQLNotes wiki showing how to link a SQLNotes file to a back-end database, such as SQL Server, local or remote:

http://sqlnotes.wikispaces.com/

(for those technically inclined...)

BTW Many of the advanced features of SQLNotes (including this one) are beyond typical users. So there is a good market for those, technically inclined, that want to become SQLNotes consultants providing turn-key type applications to busy individuals or organisations. Contact me at betasupport@sqlnotes.net for more information.
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #105 on: November 25, 2007, 08:14:07 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).



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)
« Last Edit: November 25, 2007, 08:19:23 PM by PPLandry » Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #106 on: November 26, 2007, 08:29:11 PM »

Version 0.9.20 is released. All users can download a free version at www.sqlnotes.net
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
Armando
Charter Member
***
Posts: 2,680



see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #107 on: November 26, 2007, 10:36:45 PM »

Thanks Pierre! Really haven't got the chance to "play" with it lately...  Sad
I must admit that I'm kind of postponing real testing  for when the calendar (and maybe even palm synchronization) will be ready.
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #108 on: November 26, 2007, 10:44:59 PM »

I can understand  embarassed.

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!
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
Armando
Charter Member
***
Posts: 2,680



see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #109 on: November 26, 2007, 10:51:03 PM »

I can already see that ! The problem is that I still rely on my Outlook/Palm for so many things that when/if I make a move, it'll have to be worth it.  smiley

But that doesn't mean I won't try SQLNotes again and again ! Just because I believe that there must be a way out of Outlook. (I've actually installed a bunch of "daily builds", just for the sake of seeing the progress -- all I can say is that everyday it's getting closer to what I -- and probably others too -- need...)
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #110 on: November 26, 2007, 10:59:55 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  Cool. 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)
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
Armando
Charter Member
***
Posts: 2,680



see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #111 on: November 26, 2007, 11:03:50 PM »

Cooool !! thumbs up
multi-database value-based alarms...OOoooh! sounds REALLY nice. Now that's something Outlook doesn’t have to my knowledge. Or does it?
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #112 on: November 26, 2007, 11:23:21 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.
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
Armando
Charter Member
***
Posts: 2,680



see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #113 on: November 27, 2007, 07:26:28 PM »

This sounds really really nice.
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
superboyac
Charter Member
***
Posts: 5,702


Is your software in my list?

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #114 on: November 28, 2007, 03:24:05 PM »

OK, PPL, I finally got a chance to try out your program.  By the way, thanks for the wiki, it's very helpful.

I'm giving up on the basketball one and trying something more simple and useful for myself, as a beginner.  What I want to do is create my own database for my favorite music/albums.  They will have my personal comments/reviews associated with each entry.  So far, here is the layout of my database, as far as the fields:
--Album
--Artist
--SongTitle
--Notes (I just used the default SQL field for this one)

So, for each item, I will have a review of it associated with it.  However, I have a question.  Should I write my review in the Notes field, or in the HTML pane?  I'm leaning on doing it in the HTML pane to take advantage of the formatting options.  Besides, it's too hard to control paragraphs and multiple lines in a regular field, because if you press Enter, it doesn't start a new line, but assumes you're finishing the editing (like a spreadsheet).  The only thing I'm worried about is what is the property of the HTML pane?  Is it considered a specialized field?  Or is it something else?  If I wanted to export the database to excel or something, would the html content be associated with the item, like the other fields would be?

Anyway, I'm pretty sure writing the reviews in the HTML pane is the way to go, but I wanted to make sure.

Thanks.
Logged

PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #115 on: November 28, 2007, 03:35:13 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?
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
superboyac
Charter Member
***
Posts: 5,702


Is your software in my list?

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #116 on: November 28, 2007, 04:02:04 PM »

OK, I understand.  I think I'm going to go with the HTML pane.  Each entry is going to have a lot of text in it, so it will be easier to read in the pane, rather than a field up in the grid.  Don't worry about exporting to excel, I was just thinking out loud.  If anything, once I'm done, I'd like to be able to export it to my website.  I just want to be sure that the HTML pane content is associated to each item like fields are.

Yeah, I saw the basketball template.  it was cool!  But truth be told, I'm kind of over that idea for the time being.  The music database will be much more useful for me.  But it was nice seeing how you set that up with the custom fields and everything.
Logged

PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #117 on: November 28, 2007, 04:07:24 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!
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
superboyac
Charter Member
***
Posts: 5,702


Is your software in my list?

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #118 on: November 28, 2007, 04:12:25 PM »

Oh yeah!  I forgot about that.  How can I get rid of all the saving prompts?  It's a little annoying when it asks me if I want it to save every time I change something in an item.
Logged

PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #119 on: November 28, 2007, 04:13:47 PM »

In HTML pane menu>File>AutoSave
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
superboyac
Charter Member
***
Posts: 5,702


Is your software in my list?

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #120 on: November 28, 2007, 04:46:37 PM »

Thanks.

Here's a screenshot of what I've done so far:


What determines which field the expand/collapse button appears on?  It automatically appeared on the "ALbum" field, but I think I would prefer it on the Artist field.  Also, the column on the left labeled "#" is automatically numbering each entry.  What determines the numbers and how to I edit this field or tweak it?
Logged

superboyac
Charter Member
***
Posts: 5,702


Is your software in my list?

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #121 on: November 28, 2007, 05:24:10 PM »

OK, more questions (is it appropriate to ask all these specific questions here?  If not, let me know.)

I found out about the "set tree column" option, so disregard the question in the previous post.

Now, I'm going to take advantage of the tree outline.  I want the Artist to be the main topic (album and songtitle fields blank).  Then I will make a subtopic which will include the Album (other two fields blank).  Then, I will make one more subtopic for the songtitle field.  Is there a way for suptopics to automatically fill their parent fields?  For example, if I leave the suptopic field for Artist blank, because it's parent has the Artist field already, can it detect that and automatically fill in the artist for the subtopic?  Here's a screenshot:


OR

Instead of organizing the heirarchy manually, I will fill all the fields manually with no subtopics, and then I'll use a pivot table to sort the items according to album, artist, etc.
Logged

PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #122 on: November 28, 2007, 05:34:14 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
« Last Edit: November 28, 2007, 05:38:07 PM by PPLandry » Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
superboyac
Charter Member
***
Posts: 5,702


Is your software in my list?

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #123 on: November 28, 2007, 05:50:05 PM »

Thanks, this program is awesome.  It's like Access except easier to use.

What's the plan for user-defineable keyboard shortcuts?
« Last Edit: November 28, 2007, 05:52:18 PM by superboyac » Logged

PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #124 on: November 28, 2007, 06:25:15 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 ...
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
Pages: Prev 1 2 3 4 [5] 6 7 8 9 10 ... 47 Next   Go Up
  Reply  |  New Topic  |  Print  
 
Jump to:  
   Forum Home   Thread Marks Chat! Downloads Search Login Register  

DonationCoder.com | About Us
DonationCoder.com Forum | Powered by SMF
[ Page time: 0.05s | Server load: 0.17 ]