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

Armando · « **Reply #650 on:** February 18, 2008, 10:56 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).
-PPLandry (February 18, 2008, 09:25 AM)

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 · « **Reply #651 on:** February 18, 2008, 11:12 AM »

... And I'm still not able to export to Web pages...
-Armando (February 18, 2008, 10:47 AM)

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

PPLandry · « **Reply #652 on:** February 18, 2008, 11:22 AM »

EDIT/ so to export the whole grid I select it all
-tomos (February 18, 2008, 11:12 AM)

@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.

Armando · « **Reply #653 on:** February 18, 2008, 11:32 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 · « **Reply #654 on:** February 18, 2008, 11:43 AM »

this should happen

PPLandry · « **Reply #655 on:** February 18, 2008, 03:12 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':
-tomos (February 17, 2008, 02:14 PM)

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

Armando · « **Reply #656 on:** February 18, 2008, 07:07 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."

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 · « **Reply #657 on:** February 18, 2008, 08:53 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) ?

Armando · « **Reply #658 on:** February 18, 2008, 10:04 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 · « **Reply #659 on:** February 18, 2008, 10:44 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 · « **Reply #660 on:** February 18, 2008, 11:45 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 · « **Reply #661 on:** February 19, 2008, 03:48 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)
-tomos (February 18, 2008, 09:26 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
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
---------------------------

tomos · « **Reply #662 on:** February 19, 2008, 03:59 AM »

(should probably get "Projects" to apply to sub-items as well)
-tomos (February 19, 2008, 03:48 AM)

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

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"

Armando · « **Reply #663 on:** February 19, 2008, 09:41 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
-tomos (February 19, 2008, 03:48 AM)

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

[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 :

[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 · « **Reply #664 on:** February 19, 2008, 09:44 AM »

You could also add "is not null" to each field -- except "changed" -- but it's not necessary. I would be like that :

[Select]
projects is not null AND files is not null AND changerequest is not null AND changed is null
-Armando (February 19, 2008, 09:41 AM)

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

Armando · « **Reply #665 on:** February 19, 2008, 09:54 AM »

Yes, thanks pierre (I was actually just mentioning it to make the logic appear more clearly in the syntax.)

PPLandry · « **Reply #666 on:** February 19, 2008, 10:54 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

Armando · « **Reply #667 on:** February 19, 2008, 11:51 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 · « **Reply #668 on:** February 19, 2008, 12:17 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
-tomos (February 19, 2008, 03:48 AM)

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

[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".
-Armando (February 19, 2008, 09:41 AM)

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

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)

Armando · « **Reply #669 on:** February 19, 2008, 12:26 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)
-tomos (February 19, 2008, 12:17 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)

PPLandry · « **Reply #670 on:** February 19, 2008, 12:32 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)
-Armando (February 19, 2008, 12:26 PM)

I'll never, never reduce the SN capabilities. I use that filter textbox alot and am a little bit allergic to complicated UI's

Armando · « **Reply #671 on:** February 19, 2008, 01:02 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.
-Armando (February 19, 2008, 11:51 AM)

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 · « **Reply #672 on:** February 19, 2008, 01:06 PM »

@armando

Did you try the version I've sent to you privately?

Armando · « **Reply #673 on:** February 19, 2008, 01:41 PM »

~~When and how did you send it ? I didn't receive anything... yet.~~ (received it... eventually...)

tomos · « **Reply #674 on:** February 19, 2008, 02:29 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
-tomos (February 14, 2008, 07:20 AM)
Fixed. CTRL-Click will now open the link (file, email, web)
-PPLandry (February 14, 2008, 10:23 PM)

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