Author Topic: SQLNotes...what is it exactly? (Read 1,173,506 times)

Armando · « **Reply #50 on:** November 02, 2007, 07:17 PM »

Quote from: PPLandry on November 02, 2007, 07:12 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?

PPLandry · « **Reply #51 on:** November 02, 2007, 07:28 PM »

A good place to double-click is on the first column, the item number

tomos · « **Reply #52 on:** November 02, 2007, 07:28 PM »

Quote from: PPLandry on November 02, 2007, 07:12 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

Quote from: PPLandry on November 02, 2007, 07:15 PM

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.net/Forums/tabid/54/forumid/-1/threadid/2086/scope/posts/Default.aspx

It's nice to see an application of the programme

EDIT: just got that last post

PPLandry · « **Reply #53 on:** November 02, 2007, 07:30 PM »

Quote from: PPLandry on November 02, 2007, 07:28 PM

A good place to double-click is on the first column, the item number

bump

Armando · « **Reply #54 on:** November 02, 2007, 07:36 PM »

Quote from: PPLandry on November 02, 2007, 07:30 PM

Quote from: PPLandry on November 02, 2007, 07:28 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 · « **Reply #55 on:** November 02, 2007, 07:40 PM »

Quote from: Armando on November 02, 2007, 07:36 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)

brett · « **Reply #56 on:** November 03, 2007, 09:20 PM »

Ok, I have got past the initial fear and I too am impressed.

Suggested alternative names
- TaskSheets

Brett

PPLandry · « **Reply #57 on:** November 03, 2007, 09:24 PM »

Quote from: brett on November 03, 2007, 09:20 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.

Armando · « **Reply #58 on:** November 03, 2007, 09:34 PM »

note2plan ? (nothing on google for this one)
Sounds a bit like tag2find... Oh well.

Darwin · « **Reply #59 on:** November 03, 2007, 09: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

Armando · « **Reply #60 on:** November 03, 2007, 09:46 PM »

devizer ?

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

PPLandry · « **Reply #61 on:** November 03, 2007, 09:58 PM »

Quote from: Darwin on November 03, 2007, 09: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

You're welcomed. I'm updating the SQLNotes wiki (all can contribute BTW) to add real-life examples and applications: http://sqlnotes.wikispaces.com/

Darwin · « **Reply #62 on:** November 03, 2007, 10:10 PM »

Cool! Thanks for the link - I probably wouldn't have noticed it otherwise. Reading through it now.

PPLandry · « **Reply #63 on:** November 03, 2007, 10:13 PM »

Quote from: Darwin on November 03, 2007, 10:10 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

Darwin · « **Reply #64 on:** November 03, 2007, 10: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 · « **Reply #65 on:** November 03, 2007, 10:21 PM »

Quote from: Darwin on November 03, 2007, 10: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...

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)

tinjaw · « **Reply #66 on:** November 04, 2007, 02:16 AM »

What about "Everyone's Database"?

PPLandry · « **Reply #67 on:** November 04, 2007, 04:37 AM »

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

Darwin · « **Reply #68 on:** November 04, 2007, 12:57 PM »

Wow - thanks Pierre

. I'll work my way through these tutorials.

PPLandry · « **Reply #69 on:** November 04, 2007, 05:26 PM »

Quote from: Darwin on November 04, 2007, 12:57 PM

Wow - thanks Pierre . 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.net/public/download/SQLNotes/sql-notes.zip

J-Mac · « **Reply #70 on:** November 04, 2007, 07: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 · « **Reply #71 on:** November 04, 2007, 08:19 PM »

Quote from: J-Mac on November 04, 2007, 07: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!
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!

PPLandry · « **Reply #72 on:** November 05, 2007, 03:04 AM »

The SQLNotes wikispace was updated to include documentation on how to use equations:
http://sqlnotes.wikispaces.com/Equations

superboyac · « **Reply #73 on:** November 06, 2007, 10: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 · « **Reply #74 on:** November 07, 2007, 05:19 AM »

Quote from: superboyac on November 06, 2007, 10: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.

I've updated the wikispace to include a detailed step by step tutorial on how to do this:
http://sqlnotes.wikispaces.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