Author Topic: SQLNotes...what is it exactly? (Read 902267 times)

Armando · « **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
-PPLandry (November 02, 2007, 02:12 PM)

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, 02:28 PM »

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

tomos · « **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
-PPLandry (November 02, 2007, 02:12 PM)

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
-PPLandry (November 02, 2007, 02:15 PM)

It's nice to see an application of the programme

EDIT: just got that last post

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

A good place to double-click is on the first column, the item number
-PPLandry (November 02, 2007, 02:28 PM)

bump

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

A good place to double-click is on the first column, the item number
-PPLandry (November 02, 2007, 02:28 PM)
bump
-PPLandry (November 02, 2007, 02:30 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.)

PPLandry · « **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.)
-Armando (November 02, 2007, 02:36 PM)

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, 04: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, 04:24 PM »

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

Suggested alternative names
- TaskSheets

Brett
-brett (November 03, 2007, 04:20 PM)

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, 04:34 PM »

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

Darwin · « **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

Armando · « **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 · « **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
-Darwin (November 03, 2007, 04:43 PM)

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, 05: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, 05:13 PM »

Cool! Thanks for the link - I probably wouldn't have noticed it otherwise. Reading through it now.
-Darwin (November 03, 2007, 05:10 PM)

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, 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 · « **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...
-Darwin (November 03, 2007, 05:16 PM)

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 03, 2007, 09:16 PM »

What about "Everyone's Database"?

PPLandry · « **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

Darwin · « **Reply #68 on:** November 04, 2007, 06:57 AM »

Wow - thanks Pierre

. I'll work my way through these tutorials.

PPLandry · « **Reply #69 on:** November 04, 2007, 11:26 AM »

Wow - thanks Pierre . I'll work my way through these tutorials.
-Darwin (November 04, 2007, 06:57 AM)

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

J-Mac · « **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 · « **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
-J-Mac (November 04, 2007, 01:53 PM)

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 04, 2007, 09:04 PM »

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, 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 · « **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.
-superboyac (November 06, 2007, 04:07 PM)

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