topbanner_forum
  *

avatar image

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

Login with username, password and session length
  • Tuesday March 19, 2024, 2:42 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

Last post Author Topic: SQLNotes...what is it exactly?  (Read 832136 times)

Armando

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,727
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #50 on: November 02, 2007, 02:17 PM »
A single-click on the text and a double-click to launch, or
A double-click on an empty space in the cell

should be all that's necessary. I'll fix it if it is not behaving correctly

It works, but the "empty space" portion of the cell is difficult to click on.
Is it possible to launch the file with the keyboard?

« Last Edit: November 02, 2007, 02:22 PM by Armando »

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #51 on: November 02, 2007, 02:28 PM »
A good place to double-click is on the first column, the item number
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,958
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #52 on: November 02, 2007, 02:28 PM »
A single-click on the text and a double-click to launch, or
A double-click on an empty space in the cell

should be all that's necessary. I'll fix it if it is not behaving correctly
with Ver.0.9.20
A double-click on an empty space in the cell worked a couple of times but then no more
now it's back to just edit item name

For those interested, a typical application of SQLNotes could be as a task management, work done/billing solution for consultants paid by the hour (can include lawyers)

See this link for a detailed description:
http://www.sqlnotes....e/posts/Default.aspx
It's nice to see an application of the programme  :up: :)

EDIT: just got that last post  :up:
Tom

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #53 on: November 02, 2007, 02:30 PM »
A good place to double-click is on the first column, the item number
bump
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

Armando

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,727
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #54 on: November 02, 2007, 02:36 PM »
A good place to double-click is on the first column, the item number
bump

It doesn't work when I double click on the first column (and there is no item number in the column when the item consists of a linked documents.)

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #55 on: November 02, 2007, 02:40 PM »
It doesn't work when I double click on the first column (and there is no item number in the column when the item consists of a linked documents.)
Fixed. Clicking on the number column now works even if empty (it should not be empty, that is a long-standing bug that I need to fix. F5 to refresh and you'll get the number)
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
« Last Edit: November 02, 2007, 02:58 PM by PPLandry »

brett

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 125
  • Australia
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #56 on: November 03, 2007, 04:20 PM »
Ok, I have got past the initial fear and I too am impressed.

Suggested alternative names
- TaskSheets

Brett

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #57 on: November 03, 2007, 04:24 PM »
Ok, I have got past the initial fear and I too am impressed.

Suggested alternative names
- TaskSheets

Brett
Thanks! While it can, SQLNotes is much more than to manage tasks. It is a flexible database and as such can handle all sorts of information management.
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

Armando

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,727
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #58 on: November 03, 2007, 04:34 PM »
note2plan ? (nothing on google for this one)
Sounds a bit like tag2find... Oh well.

Darwin

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,984
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #59 on: November 03, 2007, 04:43 PM »
Ironically, I find that I quite like the name SQLNotes! I seem to be in the minority... I'm slowly playing around with it and like what I see so far. Thanks for letting us in on this, Pierre  :Thmbsup:

Armando

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,727
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #60 on: November 03, 2007, 04:46 PM »
devizer ?

Darwin : SQLNotes is not bad at all. Maybe just a bit geeky for some... I guess

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #61 on: November 03, 2007, 04:58 PM »
Ironically, I find that I quite like the name SQLNotes! I seem to be in the minority... I'm slowly playing around with it and like what I see so far. Thanks for letting us in on this, Pierre  :Thmbsup:
You're welcomed. I'm updating the SQLNotes wiki (all can contribute BTW) to add real-life examples and applications: http://sqlnotes.wikispaces.com/
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

Darwin

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,984
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #62 on: November 03, 2007, 05:10 PM »
Cool! Thanks for the link - I probably wouldn't have noticed it otherwise. Reading through it now.

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #63 on: November 03, 2007, 05:13 PM »
Cool! Thanks for the link - I probably wouldn't have noticed it otherwise. Reading through it now.
Next ones will be How to generate bills using the HTML Export template feature and how to use SQLNotes to run a B&B
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

Darwin

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,984
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #64 on: November 03, 2007, 05:16 PM »
This is getting more and more interesting. My wife runs her own business and we're frequently trying to come up with ways to generate bills and invoices. Of course, she's a lot less geek oriented than I am so she may not be as excited as me...

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #65 on: November 03, 2007, 05:21 PM »
This is getting more and more interesting. My wife runs her own business and we're frequently trying to come up with ways to generate bills and invoices. Of course, she's a lot less geek oriented than I am so she may not be as excited as me...
Once set-up, it should not feel too geek for her, I'm sure.
I've got many customers with little experience with PC and can use it quite effectively.
I'll also be adding a locked down mode (or user vs design mode) where users will not be able to change too many things (i.e. not screw things up) (fields, grids, etc)
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

tinjaw

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 1,927
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #66 on: November 03, 2007, 09:16 PM »
What about "Everyone's Database"?

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #67 on: November 03, 2007, 11:37 PM »
The SQLNotes wikispace has been updated to include an example of how SQLNotes can be used to easily generate invoices, using it "mail-merge" capabilities (we call it HTML template based exports):
http://sqlnotes.wikispaces.com/Invoices
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

Darwin

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,984
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #68 on: November 04, 2007, 06:57 AM »
Wow - thanks Pierre  :Thmbsup:. I'll work my way through these tutorials.

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #69 on: November 04, 2007, 11:26 AM »
Wow - thanks Pierre  :Thmbsup:. I'll work my way through these tutorials.
Don't forget to download the latest build (and copy to the app folder) to get the updated template which includes this sample
http://www.sqlnotes....LNotes/sql-notes.zip
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

J-Mac

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 2,918
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #70 on: November 04, 2007, 01:53 PM »
Pierre,

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!

Thanks.

Jim

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #71 on: November 04, 2007, 02:19 PM »
Pierre,

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!
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #72 on: November 04, 2007, 09:04 PM »
The SQLNotes wikispace was updated to include documentation on how to use equations:
http://sqlnotes.wikispaces.com/Equations
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

superboyac

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,347
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #73 on: November 06, 2007, 04:07 PM »
PPLandry, I'm ready to continue trying out my basketball database...do you think you can send me that file you set up?  Thanks.  I was trying to follow what you wrote earlier but I got confused, and now I've run out of time (here at work).  Thanks.

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #74 on: November 06, 2007, 11:19 PM »
PPLandry, I'm ready to continue trying out my basketball database...do you think you can send me that file you set up?  Thanks.  I was trying to follow what you wrote earlier but I got confused, and now I've run out of time (here at work).  Thanks.
I've updated the wikispace to include a detailed step by step tutorial on how to do this:
http://sqlnotes.wiki....com/BasketballStats

Don't forget to get the latest SQLNotes build. That sample is now part of the default template. File > New to create a new file based on the template
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
« Last Edit: November 06, 2007, 11:41 PM by PPLandry »