topbanner_forum
  *

avatar image

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

Login with username, password and session length
  • Tuesday November 11, 2025, 6:32 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: prev • 1 ... 10 11 12 13 14 [15] 16 17 18 19 20 ... 28 • next
351
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 18, 2008, 09:58 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
-tomos (February 18, 2008, 01:56 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
352
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 18, 2008, 09:28 AM »
> SQLNotes forum not functioning

Seems fine now...
353
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 18, 2008, 09:25 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).
354
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 18, 2008, 09:16 AM »
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)
-tomos (February 17, 2008, 02:15 PM)
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.
355
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 18, 2008, 09:07 AM »
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 (February 17, 2008, 02:14 PM)

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.
356
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 16, 2008, 12: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.
357
General Software Discussion / Re: Why is my computer hiccuping every 60 seconds?
« Last post by PPLandry on February 15, 2008, 09:47 PM »
Does even your mouse refuse to move during that short time? I had this for months. Sporadically, for a couple hours a day, every 10 sec, the HD would be active for a short time and the mouse would lock.

Trying to move, point, click was very difficult. I never really found a fix, it simply went away (I think, I did fiddle with numerous settings, but I don't recall it having an effect)

If it just started, you can try to go back to a previous system restore point. I seem to recall that this sometimes fixed it (for a while anyway)

Good luck...
358
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 15, 2008, 06:37 PM »
BTW Version 0.9.22 is out  8)
359
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 15, 2008, 02:15 PM »
Speaking of which I cant seem to filter yes/no fields atall -
for "Checked" I get nothing
for "Checked is null" I get everything

Checkboxes are a little different than you might expect (unless you know SQL). For example, for the Checkbox field Followup you would use Followup if you want to search for checked or Followup is null if you want to search for unchecked.
-from the wiki
-tomos (February 15, 2008, 02:02 PM)
Keep in mind that in your grid MegSurvey, there is only 1 fullly qualified item. All others are subs of it. If you put a filter Checked and your only grid item is not checked, you get 0 items.

You can do either:
1- Change the grid source to Project or Drawing, or whatever will return your current list, or
2- Use the grid filter (not the source bar filter). It works on all displayed items. Grid > Column filter buttons (also a sub-menu allows for some options). Little bug, this setting is not saved. I'll fix it today, in time for rel 0.9.22  (hourra!)
360
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 15, 2008, 01:30 PM »
but going back to the colour thing is there a way to say:

change the colour when ticked IF "Approved" is NOT selected
-tomos (February 15, 2008, 01:28 PM)
Sure, but you need to use user-code for that!  :D
361
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 15, 2008, 01:16 PM »
No rush.

You can make a copy and delete most (or all) items
-PPLandry (February 15, 2008, 11:20 AM)

sent it to Support@ - before I make it unintelligible !!
you'll have to extract it from the database -is that difficult to do?
-
I made a temp database to experiment and was surprised by some of the goodies in there
I wouldnt mind getting some stuff from it to my current database if not too difficult
-tomos (February 15, 2008, 01:11 PM)
Got it thanks! Very very interesting ! Some advanced stuff in there... you're progessing well!  :Thmbsup:
Database merge is scheduled for version 0.9.23. Superboyac (and others surely) is waiting on this feature.
362
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 15, 2008, 12:05 PM »
>it would be nice if it automatically went back to previous colour - is there an equation for that in the “Auto-assign rules”

You can have as many colors as you wish. See Options. Can also enter Hex color directly
It the workflow is know and fixed, you can add it to the auto-assign. Add E:ItemColor=xxx

Otherwise, you'll need to wait for the multi-level undo.  :-[
363
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 15, 2008, 11:20 AM »
No rush.

You can make a copy and delete most (or all) items
364
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 15, 2008, 10:12 AM »
Now I have this setup

I add files as I start working on them
When ticked Done they go blue
When Change Requested is ticked they go Yellow and the date gets added to notes field
When I tick Checked (i.e. changes made) they go Purple and the date gets added to date field

which I'm quite happy with
-tomos (February 15, 2008, 10:07 AM)
Great! If you think that this solution can help other, do not hesitate to send it to me, I'll put it in the download area.

some queries

when filtering do I use the Actual name of field or the column heading?

In the “Auto-assign rules” how do I change the date to just date as opposed to date/time?

Is it possible to add many files at once ? Say select 20 in filemanager, drag n drop to grid -
I'm afraid to try that in case it really screws things up
-tomos (February 15, 2008, 10:07 AM)
1- Actual Field name must to be used everywhere. Heading is a display friendly caption, particularly useful as the number of fields grows
2- Auto-assign: use int(date) to get just the date
3- You can drag-drop as many files as you wish. Try it on a scrap item first (or better still in a temp database)
365
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 15, 2008, 10:03 AM »
It is a Feature. (multi-row display of headers)
-PPLandry (February 15, 2008, 09:42 AM)

I cant figure out how it's activated?
-tomos (February 15, 2008, 10:01 AM)
As you change the column width, just about when the caption no longer fits it, it is moved to another level. If you make it really narrow, it returns to the normal level, to allow you to cram lots of checkboxes
366
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 15, 2008, 09:42 AM »
It is a Feature. (multi-row display of headers)
367
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 14, 2008, 10:23 PM »
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)
368
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 14, 2008, 11:37 AM »
Nice one guys. It is fixed. This was only happening on fields marked as hyperlink (which Notes is for no reason).

New release will include another new feature: hyperlinks in items. Format will be something like:

Code: HTML [Select]
  1. <a xyz>Link text</a>

where xyz can be any of the following:
  • ItemID
  • ItemIDs, comma separated
  • WikiTag
  • WikiTags, comma separated
  • href=Local file
  • href=URL (www, email)

If the link points to an item in the grid, focus will move to that item. If not or if the link returns more than one item (i.e. ItemIDs, WikiTag, WikiTags), the item(s) will be displayed in the scratchpad grid.

A hyperlink editor will come later, but you'll already have the wiki style of hyperlink insertion: [URL;Text] + spacebar will create the hyperlink for you

It will function the same way in the grid and the HTML pane. Furthermore, "normal" URLs will be enabled on HTML Export.
369
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 13, 2008, 10:08 PM »
The count show the number of fully qualified items (those that meet the grid criteria) A number of items may be added:
  • Context parent
  • Sub-items

I'll fix it to show the actual number of items, which is more in line with the current trend (introduced by superboyac) which is to display and work with the actual items displayed, not with those that meet the criteria [edit] this is now fixed [/edit]

p.s. I you set Grid>Save item state = off, and refresh, there will be only 1 item.
370
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 13, 2008, 09:42 PM »
1- Item copy / paste used to work, but doesn't anymore. Needs fixing

2- What item should be in Todo? Also, drag-dropping across grids is one way to assign an item to more than 1 parent. (BTW Drag-drop does needs improvements)
371
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 13, 2008, 06:21 PM »
BTW : pierre : thanks for fixing the error 91 bug so fast!
-Armando (February 13, 2008, 05:50 PM)
It was so clearly defined and easy to reproduce. The reason I did not catch it myself is that it occurs only when Grid>Select mode is Item. I don't use this mode (prefer multi-column mode)  :Thmbsup:
372
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 13, 2008, 04:27 PM »
If you like your grid starting from Artists, you could simply create a yes/no field with that name and use that as the source.

(BTW Most of this way of doing is inherited from Ecco)
373
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 13, 2008, 04:10 PM »
>Everthing was fine.  THen I don't know what happened, but all the subitems now appear outisde the hierarchy no matter what.

Nothing happened. As I said earlier, there is a bug (fixed in the coming release) that silently did not apply the hierarchy if the number of items was more than 500.

[edit]
>Because my source for the Music grid says "MusicItem" which doesn't make sense to me because that was the old field I used to use for the data, but now I'm just using the regular Item field.  Furthermore, any new entries in the grid get added to the Item field, and there is nothing in the MusicItem field.

If the source is MusicItem, then a " " is being added for each item in that field. Check the field properties which show the number of items in each field. Send me the file if you wish!
374
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 13, 2008, 03:00 PM »
Is there a way to have a colour highlight on an item when a yes/no field is selected and
that the highlight will go/disappear if the yes/no field is deselected?

This doesnt work for the "Done" field:-
AM: ItemColor="red"
-tomos (February 13, 2008, 02:57 PM)
You're close: try AM: ItemColor="red" | E:ItemColor=
375
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on February 13, 2008, 02:49 PM »
OK, how about this. All items in the billing grid have the Project field filled. You could put the auto-assign on that field...

Do you want this for both Estimates and Work Done items/subs ? Or just Estimates ? I need to know a bit more how you want to work...

p.s. no you are not driving crazy  :D
Pages: prev • 1 ... 10 11 12 13 14 [15] 16 17 18 19 20 ... 28 • next