topbanner_forum
  *

avatar image

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

Login with username, password and session length
  • Wednesday November 12, 2025, 3:05 am
  • Proudly celebrating 15+ 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

Recent Posts

Pages: prev1 ... 9 10 11 12 13 [14] 15 16 17 18 19 ... 28next
326
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 27, 2008, 09:48 AM »
Just a heads up: Daily build was updated to include in the properties pane, the parents tree (sometimes called lineage):
327
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 25, 2008, 06:11 PM »
Just a heads up... Latest build is the first version to support Unicode content (in grid, properties pane and rich-text pane) (http://mantis.sqlnot...s.net/view.php?id=78)

Also, grid hyperlinks is partially enabled (http://mantis.sqlnot...s.net/view.php?id=62):
<a xxx>linkText</a>

where xxx can be:
1- an itemID
2- a Field/folder enclosed in [  ]
3- a Wikitag. Wikitags are enclosed in { } and entered in the WikiTag field

If the linked item is in the grid, focus is moved to it. Otherwise or if the link returns more than 1 item, the scratchpad grid is opened with the linked item(s).
328
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 24, 2008, 04:51 PM »
Hi suleika,

I'll answer in more depth later on, but in a nutshell:
1- SQLNotes is based on a relational database
2- Relational databases (i.e. Access and others) can read SQLNotes data
3- Using inheritance, you can arrange SQLNotes data so it it appears relational to other databases to the point that you can base Access reports on SQLNotes data.

329
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 21, 2008, 12:47 PM »
In the latest build, there are now 2 modes for hierarchy. Full hierarchy shows all subs which is what you need for this case.
330
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 20, 2008, 09:20 PM »
The process is quite simple:
Take the flat view with "Save item state off"
You get a list.

When you set hierarchy to ON, it simply re-arranges that list.
331
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 20, 2008, 09:12 PM »
Thanks Pierre. I understand the usefulness of not showing certain subitems, and showing others. But how do I know what's going to show as subitems and what's not? What's the rule?

In my previous example, I still don't understand why "boy John" is not appearing in "mummy Rose"'s children ( ;D I'm starting to feel a bit stupid with my silly characters), but others will. They all obey to the same criterias, they ALL have Mummy Rose as their main parent.
Basically, you take the flat view and re-arrange it. If an item has multiple parents shown in the grid, I believe, it puts the item under the main parent.
332
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 20, 2008, 09:01 PM »
Here is an example where you do not want to see all subs:

You have a list of contacts arranged (sometimes) as Company with your company contacts as subs. This is great since SQLNotes will search the parent when dialing, hence you only need to enter the company number once.

so you have this, but under the company, you also have lots of other info (not related to contacts). If you show all subs, you'll get a list with not just your contacts, but all that other stuff (There is a workaround using filters but still).

It is also much much quicker to simply re-arrange items than generating the grid with all subs, so for large grids, this way is better. Both ways have advantages and disadvantages...

As to Girl Rebecca, I'm sure that Test was not checked for her to show twice

Show hierarchy, simply means, re-arrange the flat list to show parent-child relationship. Better off to leave it off in this case
333
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 20, 2008, 08:33 PM »
Here is why,

The grid starts off with the data source, in this case it is all parents and children. There is only 1 boy john in the database.

In flat view, you'd get that list. Expanding each parent would show all children (grid creates new items for each children)
When you click hierarchy, the grid will arrange the source items under their parent. This works fine when there is 1 parent. It doesn't work when there is 2 parents and both are shown in the grid (since a grid item cannot be in 2 places). You can click "show all children" to display the ones which aren't shown.

There are times where this way is the best and other times where showing all is the best
In the previous version, I had it the other way. I'll need to add an option I guess  :-[
334
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 20, 2008, 08:01 PM »
For this to work fine, the children must not have test checked. Either that or set hierarchy off

I can explain why later if you want.
335
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 20, 2008, 01:15 PM »
what I do is save filters I like for all my grids in a special grid named "filters"; in that grid, filters are organized hierarchically, by grid names and filter types (following the source bar UI) : source, filter, sorting).
Smart idea Armando. (in waiting for an integrated filter management solution)
Planned on this issue are
1- ANDable Named filters
2- Grid history. Move backwards/forwards in the grid setting history
336
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 19, 2008, 08:51 PM »
Pierre, why do you require SQLNotes to have administrator privileges to be installed on a computer?  Why isn't PowerUser status enough?

Congratulations on this thread so far.  It has surpassed the Notetaking thread as far as number of pages (28!).  It might now be the longest thread on DC.  I think the topic is worthy!
Googling indicates that Power User level is sufficient to install ActiveX (used by SQLNotes)... It doesn't work?
[edit] Found this reference:
http://uis.georgetow...oup.permissions.html
A Power User is able to perform everyday computing tasks and can also perform some administrative-type tasks, like creating and managing user accounts, or connecting to a network printer.  Note, however, that Power Users cannot assign themselves or anyone else to the Administrators group. A Power User can install some kinds of software, but most applications will require Administrative permissions to install.
337
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 19, 2008, 04:24 PM »
Users must re-install using the setup program (no need to uninstall)

presume you mean just users that had problems ?
Correct, other had the control already installed (by some other program).

I'm looking at your error 9 right now, so an update is coming
338
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 19, 2008, 04:19 PM »
Congratulations Pierre : it works!  :Thmbsup:
I still don't know what it was, but you certainly do!  ;D
What it was is the following:
The HTML Export will soon support email-merge. I was testing it before 0.9.22 release and decided to postpone it to 0.9.23 and instead added a context menu and email form to quickly generate emails.

Email merge will work much like the HTML template merge but will generate individual emails with personnalized information. I was testing different methods of generating emails and one of them used MSMAPI.OCX, a MS component to send emails. I had forgotten to include that control in the setup program, hence the form would not open. This is now fixed. Users must re-install using the setup program (no need to uninstall)
339
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 19, 2008, 02:57 PM »
@Armando: HTMLExport bug has been found and is being fixed

Great!!!  :)
You can now download the new setup (same version number)
340
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 19, 2008, 02:43 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!
If you drag-drop files, the system Fields FileName and FilePath are filled. Set FileName to a hyperlink if you want. You can use the item to add description, notes, etc

@Armando: HTMLExport bug has been found and is being fixed
341
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 19, 2008, 02:38 PM »
in the item field, hyperlink wasnt ticked
works now :up:
I would not recommend setting hyperlink on the item field, it may complicate editing this all-purpose field
342
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 19, 2008, 02:33 PM »
Should work. Click to edit, then CTRL-click to open it. Also if not in the item (i.e. another column), you can set it's properties to Hyperlink. Then a single-click will open it.
343
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 19, 2008, 01:06 PM »
@armando

Did you try the version I've sent to you privately?
344
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry 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)
I'll never, never reduce the SN capabilities. I use that filter textbox alot and am a little bit allergic to complicated UI's
345
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry 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
 :-[
346
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry 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 :

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
347
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry 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) ?
348
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry 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':
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
349
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 18, 2008, 11:22 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.
350
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 18, 2008, 10:09 AM »
Correct, Imagine a check box to the left of the field name. Check it to include the field in the filter
Pages: prev1 ... 9 10 11 12 13 [14] 15 16 17 18 19 ... 28next