Recent Posts

9851

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 19, 2008, 03:11 PM »

durn
showed the FileName field, made it hyperlink, decided to hide it again,
was resizing columns and got
---------------------------
SQLNotes
---------------------------
Run-time error '9':

Subscript out of range
---------------------------
OK   
---------------------------
I can report it proper if you want but gotta go now
it restarted fine..

9852

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 19, 2008, 02:46 PM »

Value-> Sub-items
....
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]

-tomos (February 19, 2008, 03:59 AM)

I've found this behaviour quite helpful today actually - dont know was it intentional !!? 
but if you want to standardise it it's (obviously) no problem to use the properties pane to change stuff

9853

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 19, 2008, 02:43 PM »

in the item field, hyperlink wasnt ticked
works now

-tomos (February 19, 2008, 02:37 PM)

I would not recommend setting hyperlink on the item field, it may complicate editing this all-purpose field

-PPLandry (February 19, 2008, 02:38 PM)

now it's working in item field (without hyperlink ticked) - just needed a kick-start

9854

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 19, 2008, 02:41 PM »

hmmm
in my files grid, all the other fields at the moment are tick boxes,
guess I could create one for this - I'm sure I could find other uses for it too!

9855

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 19, 2008, 02:37 PM »

in the item field, hyperlink wasnt ticked
works now

9856

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos 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

9857

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos 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)

9858

Living Room / Re: Castro calls it quits

« Last post by tomos on February 19, 2008, 08:34 AM »

wow

would be a great place to visit if they relax things there a bit
(like allow the locals to interact with tourists)

9859

General Software Discussion / Re: Best program to manage information collections?

« Last post by tomos on February 19, 2008, 05:29 AM »

hmm,
quick comments -
I'm using Evernote, Surfulater and now, SQL-Notes

Evernote more for ideas, uncategorisable stuff, scanned/photographed text cause you can search the text, notes on projects in progress (work), writing (scraps of things - I want to start using wikidpad for writing and ideas though but havent had the time to really get into it)

Surfulater is super when you're organising things, you can "clone" stuff but not tag (yet) e.g. perfect for "fitness routines and tips, recipes"

SQL-Notes (beta) if you've got a lot of overlapping areas of interest I reckon it wont be beaten. Armando thinks it's not difficult, I'll just say it's getting easier as beta progresses - it's very usable now btw.
Could possibly replace the other two here but when stuff is clearcut I actually like having it on different programmes -
e.g. in Surfulater I have:- info on software from web, photoshop tutorials, info about setting up new pc, etc. and even thoughSQL-Notes could already easily do this...well, I have a liscence for Surfulater and it's actively developed so nice to be involved there, also I have a nice colour scheme on it )

9860

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos 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"

9861

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos 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
---------------------------

9862

Found Deals and Discounts / Re: NovaPDF Professional Desktop on Bitsdujour today

« Last post by tomos on February 18, 2008, 04:33 PM »

Definitely a case of either too much or too little caffeine today.

-Darwin (February 18, 2008, 03:30 PM)

[latenight/offtopic] sounds like a tough state of affairs when you dont know the difference there Mike

9863

General Software Discussion / Re: Can't open old CorelDraw (v4?) file - help please!

« Last post by tomos on February 18, 2008, 04:17 PM »

Freehand 9 says it can open *.cdr but not this one...

9864

Post New Requests Here / Re: IDEA: ACRONYM database

« Last post by tomos on February 18, 2008, 03:28 PM »

Hello everyone, after a quite bit of work, AcroSuite is here, and with it comes some new features, which I think you all will enjoy.  For some reason the readme did not update despite the fact I edited it, I apologize and the next updated version will include it.  Also ahead of time I apologize for any lack of updates.  Ideas for AcroLiminator are very short at this point. But on to the program.

AcroSuite

You may ask, what is AcroSuite? And why isnt it AcroLiminator anymore?  AcroSuite, is the combination of the old what I considered unpopular tool, AcroDictionary, and AcroLiminator.  Why have 2 programs, one to change the acronyms, and one to look them up, why not 1 streamlined program?  Well AcroSuite now does that.  Along with it comes a few new cool features.  For example the tray menus, you will find 3 seperate tray menus, AcroLiminator, AcroDictionary, and Donate.  AcroLiminator, and AcroDictionary display submenus which allow you to perform various commands within the programs.  Donate, well of course it allows you to donate.  Please don't feel obliged to donate because of this, we believe this makes it easier on you, and puts the message of donating out there a bit more.  We do not require donations, and do not beg for them.  It is simply optional, and we will never make a dumbed down program for users that don't donate.  I apologize for rambling, its late and im tired hehe.  Anyways, on to the change log.

Change log
- Added AcroDictionary
- Renamed to AcroSuite
- Added organized tray menu with more menus
- Added help files
- Added more options in tray menu
- Added new icon

Also I plan to create a custom icon soon, so be prepared.  Well I believe this is it, so please give any feedback you can.  I hope to provide a bug report system in the next release, which I am aiming for, the keyword being aiming for, I do not guarantee anything, Next week around this time.  If you have any suggestions, please let me know, if you think its dumb, please still tell me.  A suggestion is often only dumb in the eyes of the one with the suggestion.  Anyways, feedback, and bug reports are gladly taken.  Thanks everyone!!

-Loki15 (September 30, 2007, 04:26 AM)

havent used it but go have a look at that thread and see what you think

9865

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 18, 2008, 11:43 AM »

this should happen

9866

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos 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

9867

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 18, 2008, 10:20 AM »

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

-PPLandry (February 18, 2008, 10:09 AM)

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

9868

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 18, 2008, 10:06 AM »

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

-PPLandry (February 18, 2008, 09:58 AM)

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

9869

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 18, 2008, 09:26 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).

-Armando (February 18, 2008, 02:19 AM)

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!

9870

Post New Requests Here / Re: bigger screen area than monitor size - with quick scroll features

« Last post by tomos on February 18, 2008, 08:54 AM »

or dragscreen as opposed to -queen?

9871

Living Room / Re: The Longest Joke in the World

« Last post by tomos on February 18, 2008, 08:51 AM »

I enjoyed the joke
after the first paragraph when I saw how long it was I skipped to post two - but I didnt read the punchline
read it properly later

9872

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 18, 2008, 02: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

* 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

-tomos (February 18, 2008, 01:56 AM)

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.

-Armando (February 18, 2008, 02:19 AM)

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

9873

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 18, 2008, 01: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

9874

Living Room / Re: about to switch to a Widescreen LCD.

« Last post by tomos on February 17, 2008, 02:23 PM »

using a CRT for the color advantage is quite arguable.

-Lashiec (February 17, 2008, 01:00 PM)

do you mean you would argue against it ?

9875

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 17, 2008, 02: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)