Welcome Guest.   Make a donation to an author on the site December 22, 2014, 06:03:55 AM  *

Please login or register.
Or did you miss your validation email?


Login with username and password (forgot your password?)
Why not become a lifetime supporting member of the site with a one-time donation of any amount? Your donation entitles you to a ton of additional benefits, including access to exclusive discounts and downloads, the ability to enter monthly free software drawings, and a single non-expiring license key for all of our programs.


You must sign up here before you can post and access some areas of the site. Registration is totally free and confidential.
 
The N.A.N.Y. Challenge 2010! Download 24 custom programs!
   
   Forum Home   Thread Marks Chat! Downloads Search Login Register  
Pages: Prev 1 ... 22 23 24 25 26 [27] 28 29 30 31 32 ... 47 Next   Go Down
  Reply  |  New Topic  |  Print  
Author Topic: SQLNotes...what is it exactly?  (Read 415616 times)
Armando
Charter Member
***
Posts: 2,683



see users location on a map View Profile Give some DonationCredits to this forum member
« 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...  embarassed
Maybe could we find a way to not have to send the whole thing in the future?
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
tomos
Charter Member
***
Posts: 8,730



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« 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
Logged

Tom
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« 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.
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
Armando
Charter Member
***
Posts: 2,683



see users location on a map View Profile Give some DonationCredits to this forum member
« 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...  smiley

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

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
tomos
Charter Member
***
Posts: 8,730



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #654 on: February 18, 2008, 11:43:43 AM »

this should happen

Logged

Tom
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« 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
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
Armando
Charter Member
***
Posts: 2,683



see users location on a map View Profile Give some DonationCredits to this forum member
« 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...  Wink
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!)
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« 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) ?
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
Armando
Charter Member
***
Posts: 2,683



see users location on a map View Profile Give some DonationCredits to this forum member
« 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.  Cry
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
Armando
Charter Member
***
Posts: 2,683



see users location on a map View Profile Give some DonationCredits to this forum member
« 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!  smiley
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
Armando
Charter Member
***
Posts: 2,683



see users location on a map View Profile Give some DonationCredits to this forum member
« 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.
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
tomos
Charter Member
***
Posts: 8,730



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« 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... undecided
caused this error:-
---------------------------
Run-time error '-2147024890 (80070006)':

Method '~' of object '~' failed
---------------------------
Logged

Tom
tomos
Charter Member
***
Posts: 8,730



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« 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"
« Last Edit: February 19, 2008, 08:31:56 AM by tomos » Logged

Tom
Armando
Charter Member
***
Posts: 2,683



see users location on a map View Profile Give some DonationCredits to this forum member
« 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 :

[copy or print]
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 :

[copy or print]
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)

Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« 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 :

[copy or print]
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
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
Armando
Charter Member
***
Posts: 2,683



see users location on a map View Profile Give some DonationCredits to this forum member
« 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.)
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« 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
 embarassed
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
Armando
Charter Member
***
Posts: 2,683



see users location on a map View Profile Give some DonationCredits to this forum member
« 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.
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
tomos
Charter Member
***
Posts: 8,730



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« 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 :

[copy or print]
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 thumbs up

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

Tom
Armando
Charter Member
***
Posts: 2,683



see users location on a map View Profile Give some DonationCredits to this forum member
« 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  undecided
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)
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« 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
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
Armando
Charter Member
***
Posts: 2,683



see users location on a map View Profile Give some DonationCredits to this forum member
« 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 ???
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #672 on: February 19, 2008, 01:06:48 PM »

@armando

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

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
Armando
Charter Member
***
Posts: 2,683



see users location on a map View Profile Give some DonationCredits to this forum member
« 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...)  smiley
« Last Edit: February 19, 2008, 02:55:09 PM by Armando » Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
tomos
Charter Member
***
Posts: 8,730



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #674 on: February 19, 2008, 02:29:54 PM »

a couple of minor queries..

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

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

Tom
Pages: Prev 1 ... 22 23 24 25 26 [27] 28 29 30 31 32 ... 47 Next   Go Up
  Reply  |  New Topic  |  Print  
 
Jump to:  
   Forum Home   Thread Marks Chat! Downloads Search Login Register  

DonationCoder.com | About Us
DonationCoder.com Forum | Powered by SMF
[ Page time: 0.045s | Server load: 0.11 ]