Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

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

Login with username, password and session length
  • September 04, 2015, 06:10:36 PM
  • Proudly celebrating 10 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 440795 times)

Armando

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,708
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #650 on: February 18, 2008, 10:56:48 AM »
> Databases that won't open.

When that happens again, please send me the file (if possible) to betasupport@sql... . It must be a very small thing (in need for a definite fix).

Sure. I still have my original database that didn't want to open. I can send it to you... I don't think that there are to many sensitive info in there...  :-[
Maybe could we find a way to not have to send the whole thing in the future?

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 9,524
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #651 on: February 18, 2008, 11:12:15 AM »
... And I'm still not able to export to Web pages...

sorry Armando, forgot to try that -
it works here but only saves what is selected in the grid -
if I'm in the html pane it simply saves contents of that

EDIT/ so to export the whole grid I select it all
Tom

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 691
    • View Profile
    • InfoQube Information manager
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #652 on: February 18, 2008, 11:22:53 AM »
EDIT/ so to export the whole grid I select it all
@armando: Perhaps this is it.

Before, if only one item was selected, it would assume that you wanted to export the whole grid. Hence there was no way to really export just an item. This was changed. To select the whole grid, you now need to explicitely select all items.
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,708
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #653 on: February 18, 2008, 11:32:31 AM »
Many thanks Tomos and Pierre.

GRRRRRRR....!!! But it still doesn't it work here. I feel alone...  :)

So what happens ? Normally you just select some items (or all of them) and press the "export to a web page" button and then it just save s it in your sqlnotes folder (with the grid's name)? (That's what it does with the export to excel.)

Nothing happens here, at all-- I tried selecting items in different ways, etc.. I even did a global search on my HD to see if the export file went somewhere unexpected. Nothing. Nada. Bizarre.

OK, see you later in the afternoon. I REALLY have to go now.

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 9,524
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #654 on: February 18, 2008, 11:43:43 AM »
this should happen

SQLnotes13.png
Tom

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 691
    • View Profile
    • InfoQube Information manager
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #655 on: February 18, 2008, 03:12:24 PM »
I was changing the colours for a grid in options and you have to restart for them to take effect (sometimes anyways) and now it wont start,
well, it starts up but then I get
---------------------------
SQLNotes
---------------------------
Run-time error '91':
Thanks tomos and armando. I've isolated the problem and updated the installer (same version).

The database had little to do with it. It had to do with a fix to the HTML editing pane (the famous Enter key bug). In certain cases, an unhandled error would occur. Fixed
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,708
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #656 on: February 18, 2008, 07:07:05 PM »
Thanks Pierre. Nice job.

- I still can't create a new thread in the SQLNotes Forum... I really really have no idea what's going on! I always receive the error message :

"An error has occurred.
Error: Add/Edit Post is currently unavailable."

 :huh:

My guess is that someone is blocking me...  ;)
Seriously, what could it be ??

- And I still can't use the export to Web page. (I'm really jealous because the HTML export looks damn good!)

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 691
    • View Profile
    • InfoQube Information manager
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #657 on: February 18, 2008, 08:53:45 PM »
@armando,

1- The SQLNotes forum posting problem should be fixed.
2- HTML Export: Do you get the Export form (as shown by tomos) ? Did you uninstall before installing 0.9.22 (as required) ?
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,708
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #658 on: February 18, 2008, 10:04:01 PM »
Hi Pierre. Thanks for keeping in touch!
1- I'll check the SQLNotes forum in a few minutes.
2a- Yes, I uninstalled before installing (but I didn't check out if everything was really gone -- maybe I'll try that right away, erase the folder, etc.).
2b- No, I don't get the export form.  :'(

Armando

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,708
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #659 on: February 18, 2008, 10:44:54 PM »
OK Pierre, the SQLNotes Forum works for me now. I just posted an enormous... post on categories, tags etc (sorry if it's too long). And I'm about to start a new thread on something else. Yippee!  :)

Armando

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,708
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #660 on: February 18, 2008, 11:45:52 PM »
I tried uninstalling and reinstalling SQLNotes again, cleaning up the folder etc. but the "export to a web page" feature still doesn't work, and I tried with different databases (even the sample one).

The weirdest thing is that I don't even see a thing : no "export form" whatsoever, no error message. I also did a  search on C (system partition) and E  (document partition) and didn't find any newly created  html document.

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 9,524
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #661 on: February 19, 2008, 03:48:53 AM »
ehh,
going back to the filter bar...

Found a better solution
"Projects" is source
"FIN is null" shows files which arent ticked "FIN" (i.e. they're not finished/in progress)

I want to show "Projects" and ONLY files that have a "ChangeRequest" that arent "Changed"
So,
"Projects" and files ("file" ticked) where "ChangeRequest" is ticked AND "Changed" is not ticked
Projects and (file and ChangeRequest and Changed is null)
shows only main items which have been ticked Projects
doesnt show any subitems (should probably get "Projects" to apply to sub-items as well)

I've tried many other variations in Source and filter bar but cant quite get there...

BTW, this:
(file and ChangeRequest and Changed is null)        - pretty silly I guess to leave the brackets... :-\
caused this error:-
---------------------------
Run-time error '-2147024890 (80070006)':

Method '~' of object '~' failed
---------------------------
Tom

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 9,524
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #662 on: February 19, 2008, 03:59:49 AM »
(should probably get "Projects" to apply to sub-items as well)

Value-> Sub-items works for new items, is there a way to get it to work for all current subitems ?*
I can just select all and apply too...

EDIT/-
* I suppose you could say I want here to apply it retrospectively, I know you mentioned this somewhere but I couldnt find it

the behaviour seems a bit unpredictable here - (or is that just my understanding agin!)
With "Value-> Sub-items" ticked for "Projects",
If I tick "Projects" for an item, subitems are now ticked as well
If I untick it all are unticked, as expected
But,
if I tick the same item again, sub-items are NOT now selected...

[edit again]also when I add files as sub-items to an item ticked "Projects" they dont automatically get ticked[/edit again]

from the wiki
Quote
Value -> sub-items: Enables inheritence. If checked, if an item has a value in this field, sub-items will automatically inherit this value too. Users can change this inherited value if desired. Updates to the parent item will update all sub-items that have the same value as the parent (if you've changed an inherited value, it will be preserved)
I dont understand the part in bold -
"Updates" meaning refresh? That would mean retrospectively, hmm, dont think it's that.
It probably means, if I make parent XYZ children will be XYZ? and
referring to fields with info in them I guess, when that's changed it's changed in subitems as well ?

and cant figure this either - "if you've changed an inherited value, it will be preserved"
Tom
« Last Edit: February 19, 2008, 08:31:56 AM by tomos »

Armando

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,708
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #663 on: February 19, 2008, 09:41:57 AM »
I want to show "Projects" and ONLY files that have a "ChangeRequest" that arent "Changed"
So,
"Projects" and files ("file" ticked) where "ChangeRequest" is ticked AND "Changed" is not ticked


I'm REALLY not an expert. But if I understand what you want, this should work :

Code: [Select]
projects AND files AND changerequest AND changed is null
meaning : show me the items which have something in the fields "projects", "files" and "changerequests", but nothing in the the field "changed".
 
You could also add "is not null" to each field -- except "changed" -- but it's not necessary. I would be like that :

Code: [Select]
projects is not null AND files is not null AND changerequest is not null AND changed is null
(Check the orthography for the fields though as I just recopied the fields names from your post and I don't know exactly if I'm accurate)


PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 691
    • View Profile
    • InfoQube Information manager
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #664 on: February 19, 2008, 09:44:44 AM »
You could also add "is not null" to each field -- except "changed" -- but it's not necessary. I would be like that :

Code: [Select]
projects is not null AND files is not null AND changerequest is not null AND changed is null
I got lost in this thread (will read it more carefully later on), but...

"is not null" is optional. Entering the field name is the same
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,708
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #665 on: February 19, 2008, 09:54:39 AM »
Yes, thanks pierre (I was actually just mentioning it to make the logic appear more clearly in the syntax.)

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 691
    • View Profile
    • InfoQube Information manager
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #666 on: February 19, 2008, 10:54:31 AM »
@ All...

Anyone else having Armando's problem with the HTML Export ?

1- select a few items (say those in the Welcome grid of a new file)
2- Grid > Export to a web page
3- Select Settings tab
4- Click Save and preview
 :-[
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,708
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #667 on: February 19, 2008, 11:51:22 AM »
This is a real mystery. WHY doesn't it work for me? Is the HTML export (export to a web page) depending on some external component (that would be absent/damaged)?

Could I maybe try reinstalling an older daily build from version 0.9.21 and see if the HTML export works (without the export window, of course -- I don't think that I ever saw that previous builds)? It did work in the past.

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 9,524
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #668 on: February 19, 2008, 12:17:04 PM »
I want to show "Projects" and ONLY files that have a "ChangeRequest" that arent "Changed"
So,
"Projects" and files ("file" ticked) where "ChangeRequest" is ticked AND "Changed" is not ticked

I'm REALLY not an expert. But if I understand what you want, this should work :

Code: [Select]
projects AND files AND changerequest AND changed is null
meaning : show me the items which have something in the fields "projects", "files" and "changerequests", but nothing in the the field "changed".

thanks Armando,
that got it for me after making it "Projects OR files and..."

the "changed is null" with all "and" ruled out all other items where that not ticked (not what I wanted)
I just wanted to rule out files where "ChangeRequest" is ticked AND "Changed" is not ticked

I had to make sure files were not ticked as "projects" too
Thanks :up:

you do have to think a bit about how to organise fields to make search/filters easier (I enjoy that actually :))
also just thinking it probably would be difficult for a filter pane to pick up on the subtleties of a search like that  :-\
THIS and (THAT-where-OTHER-is-selected)
Tom

Armando

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,708
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #669 on: February 19, 2008, 12:26:41 PM »
also just thinking it probably would be difficult for a filter pane to pick up on the subtleties of a search like that  :-\
THIS and (THAT-where-OTHER-is-selected)

Exactly, but it's probably feasible. (I just hope that the "simple" filter entry zone will also remain available if such a GUI solution is going to be created)

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 691
    • View Profile
    • InfoQube Information manager
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #670 on: February 19, 2008, 12:32:40 PM »
Exactly, but it's probably feasible. (I just hope that the "simple" filter entry zone will also remain available if such a GUI solution is going to be created)
I'll never, never reduce the SN capabilities. I use that filter textbox alot and am a little bit allergic to complicated UI's
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,708
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #671 on: February 19, 2008, 01:02:04 PM »
Glad this is the way you're thinking!

Could I maybe try reinstalling an older daily build from version 0.9.21 and see if the HTML export works (without the export window, of course -- I don't think that I ever saw that previous builds)? It did work in the past.

OK, I tried that, and the html export works with version 0.9.21 of SQLNote -- downloaded on 11 jan 2008. Even the export window was there (I didn't remember seeing it before...).

BUT... I reinstalled v 0.9.22 and it still doesn't work.

Could it be registry related ???

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 691
    • View Profile
    • InfoQube Information manager
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #672 on: February 19, 2008, 01:06:48 PM »
@armando

Did you try the version I've sent to you privately?
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,708
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #673 on: February 19, 2008, 01:41:51 PM »
When and how did you send it ? I didn't receive anything... yet. (received it... eventually...)  :)
« Last Edit: February 19, 2008, 02:55:09 PM by Armando »

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 9,524
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #674 on: February 19, 2008, 02:29:54 PM »
a couple of minor queries..

BUT
what I would really like :) would be a Control+Mouse Click or some other key+click combo
Double clicks kill me :-[
Fixed. CTRL-Click will now open the link (file, email, web)

is this implemented ? - not working here...0.9.22
Tom