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

tomos · « **Reply #625 on:** February 16, 2008, 03:45 PM »

changed the screenshot in last post...
changed "checked" column to "changed" (try saying that fast!)

Armando · « **Reply #626 on:** February 16, 2008, 05:11 PM »

I see. Nice tomos. I'll share what I do in a little while. I'm just busy figuring out everything SQLNotes can do and what it could do better -- when possible.

I'm actually thorned between posting here or at the SQLNotes forum... Posting at the SN forum seems like a better idea (since that's where people tend to go for info about SQLNotes), and that's what I've started to do lately, but it just hasn't become a habit yet.

Armando · « **Reply #627 on:** February 16, 2008, 05:42 PM »

Hummm... I think Pierre is busy changing stuff over there because I haven't been able to start a new thread since last night.

Pierre?

(I'd like to discuss things about categories, etc. I posted in Mantis about this and I found a temporary pretty neat and simple solution that works very well -- still not ideal but, who knows, probably similar to what you're already using)

PPLandry · « **Reply #628 on:** February 16, 2008, 06:05 PM »

I seem to have no problem posting in the SQLNotes forum... No problem posting here though if you want. I'll check it on monday, I'll be offline for 2 days.

Armando · « **Reply #629 on:** February 16, 2008, 06:12 PM »

The problem is creating a new thread in any forum section. Not a new post in a preexisting thread.

This is what I get :

[attach]

Armando · « **Reply #630 on:** February 16, 2008, 06:13 PM »

Quote from: PPLandry on February 16, 2008, 06:05 PM

I'll be offline for 2 days.

OK, see you on Monday!

tomos · « **Reply #631 on:** February 17, 2008, 08:14 PM »

Amando, you mentioned error #91 somewhere
did you get any info on it?

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

Object variable or With block variable not set
---------------------------
OK
---------------------------

and it crashes...
Tom

tomos · « **Reply #632 on:** February 17, 2008, 08:15 PM »

In my WorkDone/Billing grid (source "Projects") this:
File is null
- filters out the files (drawings)

How do I *include* files that have duration i.e. files I have worked on & recorded the time spent:-
Projects and (File and duration>0)
- doesnt work - filters out everything

You say in the wiki page about filters

Filter
The Filter filters the list of items. It can be edited directly, but it also can be set through the Search Form or Quick Search

is there any tips around how to use the Search function to do this?

and, just BTW:-

Saving Filters
Currently you can't named filters, but you can use the history drop-down box to select old filters. Also, Grid's will remember their filter so you can create a multiple Grids - each with its own Filter.

I dont have any drop down box here on the filters?
but if I remove filter text and then click on icon to deactivate filter the text returns (which is fine)

Armando · « **Reply #633 on:** February 18, 2008, 03:30 AM »

Quote from: tomos on February 17, 2008, 08:14 PM

Amando, you mentioned error #91 somewhere
did you get any info on it?

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

Object variable or With block variable not set
---------------------------
OK
---------------------------

and it crashes...
Tom

One Error 91 got fixed : http://mantis.sqlnotes.net/view.php?id=56. (Error 91 is not necessarily linked to a very specific thing -- ie clicking on a specific field -- and it can happen in different contexts).

Is SQLNotes not starting, or is it only that specific grid ?

I'm asking because I had a pretty huge crash yesterday, accompanied by the infamous "run time error 91 (Object variable or with block variable not set)" ... and I got nervous because SQLNOtes couldn't NOT load my database anymore.

But I solved the problem by:
1) uninstalling SQLNotes,
2) reinstalling the older 0.9.21 version (don't know if just reinstalling the new version would've done it... sorry),
3) opening my database (but made a copy before!!!!) with the old version (it worked, but a couple filters didn't -- I didn't really care since I was planing to reinstall the new 0.9.22 version right after!),
4) re-saving it under another name,
5) and then reinstalling the new SQLNotes version, and opening up my database... effortlessly this time! fiouf.

(I'll post the details of the error on the SQLNotes forum when I'll be able to create a new thread! From now on I'm going to try to post about SQLNotes matters over there instead... just because I find that info on SQLNotes is starting to get a bit scattered between here, Mantis and SQLNotes Forum. Unless Pierre prefers to keep both places active... dunno.)

I get this error 91 at least once a day. It usually happens when I drag and drop something or click on something... at the wrong time it seems! But I must say that it doesn't prevent me to literaly love SQLNOtes anyway. This software is REALLY addictive.

Armando · « **Reply #634 on:** February 18, 2008, 03:54 AM »

Quote from: tomos on February 17, 2008, 08:15 PM

How do I *include* files that have duration i.e. files I have worked on & recorded the time spent:-
Projects and (File and duration>0)
- doesnt work - filters out everything

Why do you put parenthesis ? Unless the "File" field has a numeric value? Otherwise I guess I'd just remove them... or put them like that : (duration>0)

Quote from: tomos on February 17, 2008, 08:15 PM

You say in the wiki page about filters
Filter
The Filter filters the list of items. It can be edited directly, but it also can be set through the Search Form or Quick Search

is there any tips around how to use the Search function to do this?

What do you mean ? I don't know if that would answer your question, but by pressing ctrl+f (or by opening the Find panel, in the view menu), you just get a window with different fillable fields. These act as filters and the results appear in the search Grid OR -- and that might be the answer to your question -- directly in one of your already made grid, if you fill "source view" field with a Grid name you choose (in a drop down menu). VERY convenient.

Quote from: tomos on February 17, 2008, 08:15 PM

and, just BTW:-
Saving Filters
Currently you can't named filters, but you can use the history drop-down box to select old filters. Also, Grid's will remember their filter so you can create a multiple Grids - each with its own Filter.

I dont have any drop down box here on the filters?
but if I remove filter text and then click on icon to deactivate filter the text returns (which is fine)

That's a good one and I wanted to mention it to Pierre too as I don't see that drop down menu (which would be VERY convenient, as I have to save my filters manually to remember them right now). There is a drop down menu but for the "source" (which basically lists all available fields, and not previous complex sources/filters either).

Armando · « **Reply #635 on:** February 18, 2008, 06:53 AM »

There are many questions I want to ask Pierre, but there's one thing I'd really like to know... now. Do you guys have problems with the "Export to Web Page" feature? Seems broken here... Or maybe I'm doing something wrong? I thought that before I was just clicking the "Export to Web Page" button or menu option, with an opened Grid.

tomos · « **Reply #636 on:** February 18, 2008, 07:56 AM »

Thanks for those responses Armando,
It's only the first time I've got error #91, but I reckon I dont really use the programme like you

Hey!
I just tried with a backup on my usb stick which was from previous day and it opened
I can now open the databases that wouldnt open
I had been changing colours and had actually made a copy before I changed them - neither file would then open so I thought I had screwed up things rightly, requiring re-install like you suggested

Thanks for the other answers too Armando,
with the find I'll experiment,
but I got the impression from that quote that maybe there was somewhere you could tick all the relevant fields,
e.g. as example I gave of ["File" and "Projects" boxes ticked and Duration>0] and that this would then show in the filter bar *
I tried doing that with the search box, for field I wrote: [Projects,Field,Duration>0] but that didnt work either-or maybe it did but I'm misunderstanding somewhere

In filter bar I've tried:
Projects and File and duration>0
Projects and File and (duration>0)
both coming up empty nada nix...

* that would be a great idea actually
a search/filter pane which shows all the fields - like in the properties pane,
you fill in what you want and it gets shown in the filter bar
So, in this case I'd tick my two fields and fill ">0" in duration field,
click "Find" or "Filter" and off

Armando · « **Reply #637 on:** February 18, 2008, 08:19 AM »

Quote from: tomos on February 18, 2008, 07:56 AM

In filter bar I've tried:
Projects and File and duration>0
Projects and File and (duration>0)
both coming up empty nada nix...

So by that filter I guess that you want all the items which have something (data) in the "projects" and "file" and "duration" fields to appear in the grid... But have you entered something in all of these fields ? in the duration field too???

Try just writing "duration" in the "search grid" 's filter (the one used "exclusively" for searches, so that you don't mess up your other grids...). If nothing comes up, than you don't have any durations entered anywhere.

[attach]

Armando · « **Reply #638 on:** February 18, 2008, 08:46 AM »

(corrected some stupid mistakes)

tomos · « **Reply #639 on:** February 18, 2008, 08:53 AM »

going out the door in 10 mins so brief reply

as often think I wasnt clear enough
I want items with projects ticked
there are files which are sub-items - I only want to see ones with duration (they're there all right!)

Duration works kindof but it rules out other items which dont have duration

Quote from: Armando on February 18, 2008, 08:19 AM

Quote from: tomos on February 18, 2008, 07:56 AM
* that would be a great idea actually
a search/filter pane which shows all the fields - like in the properties pane,
you fill in what you want and it gets shown in the filter bar
So, in this case I'd tick my two fields and fill ">0" in duration field,
click "Find" or "Filter" and off

well... If you have 100s of fields (which is very possible), it might be a bit hard to use... But this is already pretty much possible anyways with the "source bar" (alt+s). Just write all the fields and terms you want (with the proper operators, symbols etc.) and bingo.

I disagree - about being hard to use - it could be exactly like the properties pane

You say:
>But this is already pretty much possible anyways with the "source bar" (alt+s). Just write all the fields and terms you want (with the proper operators, symbols etc.) and bingo.

That's my problem - I DONT

find this easy - the opposite in fact, well source is okay but filters...

PS didnt notice the mistakes, runs out the door...

PPLandry · « **Reply #640 on:** February 18, 2008, 03:07 PM »

Quote from: tomos on February 17, 2008, 08:14 PM

Amando, you mentioned error #91 somewhere
did you get any info on it?

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

Object variable or With block variable not set
---------------------------
OK
---------------------------

and it crashes...
Tom

Hello All, back from 2 days off.

Sorry tomos, I could not reproduce it. Tried changing grid colors, etc Will keep an eye open for it.

PPLandry · « **Reply #641 on:** February 18, 2008, 03:16 PM »

Quote from: tomos on February 17, 2008, 08:15 PM

and, just BTW:-
Saving Filters
Currently you can't named filters, but you can use the history drop-down box to select old filters. Also, Grid's will remember their filter so you can create a multiple Grids - each with its own Filter.

I dont have any drop down box here on the filters?
but if I remove filter text and then click on icon to deactivate filter the text returns (which is fine)

Corrected. This page was written by a SQLNotes user, not by myself. It is great to see others write. It sometimes is much clearer than when I write documentation. Different perspective. All users are welcomed to write, correct, comment the wiki. Consider it a community effort to help expose the (I hope) great features of (the about to be renamed) SQLNotes.

PPLandry · « **Reply #642 on:** February 18, 2008, 03:25 PM »

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

tomos · « **Reply #643 on:** February 18, 2008, 03:26 PM »

Quote from: Armando on February 18, 2008, 08:19 AM

the AND operator : the 3 fields must have something in them simultaneously. If that's not what you want, try using the OR operator (place it where you want it... can't help you with that).

hmm,
been messing around again following your advice,
"duration is not null"
shows items where duration is zero "0" as opposed to blank
Not sure why the duration is "0" but I can work with that...

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

EDIT/ Hi Pierre!

PPLandry · « **Reply #644 on:** February 18, 2008, 03:28 PM »

> SQLNotes forum not functioning

Seems fine now...

PPLandry · « **Reply #645 on:** February 18, 2008, 03:58 PM »

Quote from: tomos on February 18, 2008, 07:56 AM

* that would be a great idea actually
a search/filter pane which shows all the fields - like in the properties pane,
you fill in what you want and it gets shown in the filter bar
So, in this case I'd tick my two fields and fill ">0" in duration field,
click "Find" or "Filter" and off

Ecco uses a similar kind of filter definition UI.

What I envision is something very similar to the forms manager with extra spaces to add AND, OR, etc and ( ).
So one would select the field, the value and operators

tomos · « **Reply #646 on:** February 18, 2008, 04:06 PM »

Quote from: PPLandry on February 18, 2008, 03:58 PM

Ecco uses a similar kind of filter definition UI.

What I envision is something very similar to the forms manager with extra spaces to add AND, OR, etc and ( ).
So one would select the field, the value and operators

that looks good

What I had in mind - to make it even more accessible (e.g. to people who dont know about operators

or cant figure them out) - if you had,
lets say you have a field with a tick box - show the tickbox - let me tick it ! and then this gets transcribed/translated to filter-speak on the search/filter bar
i.e. more of a GUI so-to-speak

PPLandry · « **Reply #647 on:** February 18, 2008, 04:09 PM »

Correct, Imagine a check box to the left of the field name. Check it to include the field in the filter

tomos · « **Reply #648 on:** February 18, 2008, 04:20 PM »

Quote from: PPLandry on February 18, 2008, 04:09 PM

Correct, Imagine a check box to the left of the field name. Check it to include the field in the filter

super, that way I can learn how to filter-speak at my leisure

Armando · « **Reply #649 on:** February 18, 2008, 04:47 PM »

Quote from: PPLandry on February 18, 2008, 03:28 PM

> SQLNotes forum not functioning

Seems fine now...

Hi Pierre,
I still can't create a new thread. I saw the thread test at the forum, so I'm starting to think that the problem is really on my side, but, frankly, I've no idea of what it could be (some security settings??). I tried creating a new thread with FF, IE, login in, login out. Nothing goes. Same error mentioned earlier : "An error has occurred. Error: Add/Edit Post is currently unavailable."

Edit :.... And I'm still not able to export to Web pages...