topbanner_forum
  *

avatar image

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

Login with username, password and session length
  • Monday June 23, 2025, 8:49 pm
  • 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 ... 13 14 15 16 17 [18] 19 20 21 22 23 ... 28 • next
426
General Software Discussion / SQLNotes: the next generation information organizer
« Last post by PPLandry on January 22, 2008, 10:52 PM »
Just a heads-up regarding a feature request by a number of users: Items with HTML Pane Export

  • Can now select to export the HTML pane content with the items (when using Export with settings).
  • Option to append a (...) at the end of the tree-column (normally the items column) to allow for expand/collapse of the HTML content.
  • Per level Item font size and HTML prefix added (to bold, italic, etc. items).

Example available here (taken from the Welcome grid of the default template): http://www.public.sq...hHTMLPaneExample.htm
Version 0.9.21 + daily build.
427
General Software Discussion / Re: Inventory Software
« Last post by PPLandry on January 22, 2008, 10:32 PM »
Our school is looking for a good piece of software to help with inventory.  It must be able to record details about anything from a desk to a computer, printer, or even a bus!  If it could also record service info that would be good also.  I am thinking it needs to be able to work with bar codes and print out labels.  Printing reports would also be good.  it wouldn't have to be free but should be reasonable.

What have you guys used in the pass??  No, databases and me do not get along very well.
-techidave (January 22, 2008, 12:58 PM)
I'm the developer of SQLNotes (www.sqlnotes.net) which has been discussed here at DC. It is half way between an information organizer and a database. It is based on a multi-user database and can easily be configured to perform inventories. It is very flexible, so extra stuff like service info can be recorded. It can also print summarizing reports and charts. The one missing feature is bar code printing, but this could be added if desired. Finally, data can be read by (and exported to) MS Office applications (Word, Excel, Access) and other ODBC-enabled applications.
428
Coding Snacks / Re: What language is the best for a new programmer to start with?
« Last post by PPLandry on January 22, 2008, 04:18 PM »
VB, C#, VB6, Delphi... All of these are strictly Windows, aren't they ? If one is thinking portability-compatibility (with Linux, for instance...), I guess one has to go more with... java, python or ruby ??
-Armando (January 22, 2008, 02:04 PM)
Both Mac and Linux now have Windows emulation which works very well. .Net can also be compiled for other platforms.
http://en.wikipedia..../wiki/Cross-platform
429
Coding Snacks / Re: What language is the best for a new programmer to start with?
« Last post by PPLandry on January 22, 2008, 01:52 PM »
So, what would the expert coders here recommend? Any consensus?  :) C# ?
-Armando (January 21, 2008, 11:14 PM)
A large part of a program is the UI and coding a UI in C++ MFC, etc is not easy at all. If you are interested in Windows programming, I'd recommend a .Net language (VB, C#) if you want to go the .Net route, or VB6 or Delphi for the COM route. For web dev. I'd go ASP.Net or VWG (http://www.visualwebgui.com)
430
General Software Discussion / SQLNotes: the next generation information organizer
« Last post by PPLandry on January 21, 2008, 03:36 PM »
Have fun Pierre, you deserve a break!

I can't help it, here are some topics for you when you get back:
What is the Scratch Pad for and does it function any differently from any other grid?
What is the timeframe for adding the import feature which will allow me to import grids from other SQLNotes databases into the current one.  I have some grids I work on at work, and I have some I work on at home.  Eventually, I'd like to combine them.
-superboyac (January 17, 2008, 12:38 AM)
Thanks!

ScratchPad: Armando described it perfectly
Import: this week
431
General Software Discussion / SQLNotes: the next generation information organizer
« Last post by PPLandry on January 20, 2008, 10:51 PM »
Glad you like it. Notice how the HTML content gets indented with the item (as items are deeper into the tree stucture)... I think it is a nice effect.

It isn't perfect though, if you've collapsed some items, collapsing and expanding will restore all items fully expanded  :(

BTW, expand/collapse does not work well in FF. If someone fluent in FF can fix my expand.js, it'd be great  :)
432
General Software Discussion / SQLNotes: the next generation information organizer
« Last post by PPLandry on January 20, 2008, 09:51 PM »
I'm now adding a (...) after the item text to toggle display of the HTML text
433
General Software Discussion / SQLNotes: the next generation information organizer
« Last post by PPLandry on January 20, 2008, 07:16 PM »
Images should show. They show when I try it...
434
General Software Discussion / SQLNotes: the next generation information organizer
« Last post by PPLandry on January 20, 2008, 06:00 PM »
Remember that it is an option to show the HTML text in the export ... I updated the latest build with this new option (untested... hey this is sunday after all)
435
General Software Discussion / SQLNotes: the next generation information organizer
« Last post by PPLandry on January 20, 2008, 05:43 PM »
Well, it looks good to me! Especially if it's still possible to expand-collapse the hierarchy.

But would it be possible to also collapse the "HTML note" inside each item, maybe with an extra button/link saying "see text"... Would be possible? That would probably be the best (depending on how big is the item list, and how much text/image is in each item's "HTML pane").
-Armando (January 20, 2008, 05:17 PM)
I knew that the minute I added this option, someone would ask to be able to collapse the HTML section. It is more complicated, but of course feasible. Will do  :-[

Trip was outstanding. City is beautiful, B&B was charming and the food was memorable (3 service breakfast and lunch at Le Saint-Amour, miam miam). Now fasting! [edit Quebec city was preparing for next saturday's extreme sport: Red bull's downhill staking. Extremely dangerous! http://www.redbullcr...shedice.ca/video.php)
436
General Software Discussion / SQLNotes: the next generation information organizer
« Last post by PPLandry on January 20, 2008, 04:26 PM »
A few posts mentioned HTML pane export. I'm proposing to expand the current HTML export feature to include a check box to add the HTML pane text below the item as in this screenshot. Expand-collapse buttons will continue to work to show/hide sub-items
ExportPlusHTML.jpg

What do you think ? :tellme:
437
General Software Discussion / SQLNotes: the next generation information organizer
« Last post by PPLandry on January 16, 2008, 11:46 PM »
I've got the Mantis bug-tracking software working. So users will be able to post bug and suggestion. However I'll be off-line for a few days. We're going to beautiful Quebec city for a few days.

I'll activate the bug-tracking early next week. Cheers to all!
438
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on January 16, 2008, 05:27 PM »
Then, when I rename a grid, how do I know which checkbox is associated with that grid in cases where I want to include that grid's data into another grid?
-superboyac (January 16, 2008, 04:34 PM)
If you show the grid source bar, you'll see the source criteria. If it is a single field, then it's easy, you see items in that field, otherwise, it is all items which meet those criteria. From http://sqlnotes.wikispaces.com/Filtering :
---------
Source takes more than just an Property name, in fact its a filter also. Its the query that indicates what items are selected for the current Grid. For example, instead of just AddressBook you could put AddressBook and Archived is null to only show unarchived contacts.
The reason why Source and Filter are kept separate is so you can keep the Source constant as you tweak the Filter as described above
---------

Also, a weird thing has been happening with my HTML Pane content the last few days.  The text inside appears in random places.  Like, just now, I got the pane content I wrote in another grid show up in one of the items of my transcript grid.  Something is buggy about it.
-superboyac (January 16, 2008, 04:34 PM)
I'll check it some more
439
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on January 16, 2008, 04:22 PM »
OK, thanks.  By the way, if I rename the grid, does the field name (the field with the check box) for it get automatically updated also?
-superboyac (January 16, 2008, 04:20 PM)
No. There is no connection between field name and grid name (this is by design)
440
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on January 16, 2008, 12:49 PM »
OK, I did some changes to the field parsing and you need to include the source with [  ] due to the underscore in the field name. I'll fix that issue.
-PPLandry (January 16, 2008, 12:18 PM)
Fixed in the latest build
441
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on January 16, 2008, 12:18 PM »
OK, I did some changes to the field parsing and you need to include the source with [  ] due to the underscore in the field name. I'll fix that issue.
442
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on January 16, 2008, 11:58 AM »
I'll check it, did you try a repair ?
443
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on January 15, 2008, 10:24 PM »
I think this is a small bug. 12 jan + 1 day duration does give 13 jan but it should be < 13 jan, I use <=13 jan.

It is now fixed.
444
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on January 15, 2008, 10:11 PM »
You probably have week view or month view set. Read Todo < week of xx jan 2008
445
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on January 15, 2008, 09:51 PM »
Using IE or Gecko is messy stuff. I'm using a wrapper to isolate me from that. I would not want to write such a wrapper for the Gecko engine  :(. So it will be IE or Word (or a third party)

re: licences: If word is installed, anybody can call it
446
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on January 15, 2008, 09:34 PM »
It is fully integrated. Instead of the HTML IE based editor, it is Word in the window. Word is not seen as a running app in the taskbar (but visible in the processed of course)
447
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on January 15, 2008, 08:23 PM »
Access violation at address 7C901010 in module 'ntdll.dll'. Read of address 0000004C.
-tomos (January 15, 2008, 04:50 PM)
I don't use that dll directly, but it is used by IE and the HTML Edit is also based on IE. Googling shows that many things can cause such errors, including
- Windows XP without SP2
- IE add-ons

I'll keep an eye open for this.
448
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on January 15, 2008, 06:25 PM »
For a quick and easy printout with the HTML pane info, best is to:
1- Add the HTML field to the grid (right-click on column heading, check ItemHTML field
2- Select items to print
3- HTML export, use the settings tab
4- There are numerous options. Play around with them.

As for the grey panel, it is a bug in the menu toolkit I'm using. Update have been published. I'll update my version for the next release (0.9.22).
449
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on January 15, 2008, 04:37 PM »
Does the Excel export work yet?  I've tried it but it's not working for me.  Part of the problem may be that I don't have administrator access to my program files directory, so whatever file it's trying to create may be being prevented.

Also, as far as printing, is there a way to be more selective in the printing?  Like, I would like to print only selected items of a grid (with/without children items), along with their html panes.
-superboyac (January 15, 2008, 04:31 PM)

1- Export to Excel works fine here. Writes to the same folder as the database, name=gridname.xls. We can examine why it doesn't work for you.
2- To print with the HTML pane info, best is to do a template based HTML export. See this link:
http://sqlnotes.wikispaces.com/Invoices
450
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on January 15, 2008, 04:23 PM »
or toggle the filter (left of the filter edit box)
Pages: prev • 1 ... 13 14 15 16 17 [18] 19 20 21 22 23 ... 28 • next