Before the end of 2017 the board will be down for a brief period of time for an upgrade.
Past experience says less than 30 minutes but I can't predict the future.
Also, there is a high probability that the forum will move to a different host, but that will not happen in 2017.
Thanks,
Doug

Search found 213 matches

by DougWilliams
Fri Nov 17, 2017 1:30 am
Forum: General Discussion
Topic: Hello
Replies: 2
Views: 85

Re: Hello

Hello Bret_B, welcome to the forum!

Health was the reason development and sales were stopped but as far as I know Fredrik is still alive. Though you may be privy to new information, which would be very sad information.
by DougWilliams
Wed Nov 15, 2017 2:10 am
Forum: General Discussion
Topic: Note to self...
Replies: 0
Views: 67

Note to self...

Note to self.. after testing a SQL Update for someone, be sure to restore your backed up database before doing an Auto-Organize on your images... I was able to recover, not just from the backup but I had to link the old database (SQL Update tested) and the new database (Auto-Organized image) on the ...
by DougWilliams
Tue Nov 14, 2017 11:22 am
Forum: Using CATraxx
Topic: adding values to a custom field
Replies: 4
Views: 118

Re: adding values to a custom field

Something like SET AlbumCustom.Custom01 = "The Greatest Album:" +[album].[Title]+" is my favorite" (it might be single quotes instead of the double quotes. I'm not able to test) Other fields can be done but becomes more complicated if the field is in a different table. If you can...
by DougWilliams
Sun Nov 12, 2017 11:36 pm
Forum: Using CATraxx
Topic: adding values to a custom field
Replies: 4
Views: 118

Re: adding values to a custom field

You will need to use the utility SQLUpdate: http://www.fnprg.com/index.html BACKUP YOUR DATABASE BEFORE USING THIS QUERY. This will update EVERY CUSTOM01 with the Album Title regardless of whether or not there is already data in the field. UPDATE Album INNER JOIN AlbumCustom ON Album.AlbumID = Album...
by DougWilliams
Sat Nov 11, 2017 3:46 pm
Forum: General Discussion
Topic: New Forum member, old CAT User
Replies: 1
Views: 92

Re: New Forum member, old CAT User

Welcome Charlie McD!
by DougWilliams
Thu Nov 09, 2017 5:41 pm
Forum: Using CATraxx
Topic: Need some Sqlupdate advice
Replies: 2
Views: 70

Re: Need some Sqlupdate advice

There is an easier way.
Create a Track View with the two fields, sort, and then use the SET FIELD VALUE feature.
Search HELP for "Set field value"
Capture.JPG
Capture.JPG (76.89 KiB) Viewed 62 times
by DougWilliams
Tue Sep 05, 2017 10:34 am
Forum: Using CATraxx
Topic: Hamsen Files
Replies: 3
Views: 192

Re: Hamsen Files

You can start here ( http://hamsen.synology.me/HAP/index.html ) to get the program descriptions. The downloads page's "Home" points to a broken link.
by DougWilliams
Mon Sep 04, 2017 4:34 pm
Forum: Using CATraxx
Topic: Auto Organize Audiofiles
Replies: 5
Views: 138

Re: Auto Organize Audiofiles

You can use any of the fields in CATraxx. From the Help file: In addition to the standard codes, you can reference any field using the format %table.field%, for example %album.referenceno% or %track.custom01%. Be sure there is no spaces in the variable name. Also, I was going by memory from my previ...
by DougWilliams
Mon Sep 04, 2017 2:43 pm
Forum: Using CATraxx
Topic: Auto Organize Audiofiles
Replies: 5
Views: 138

Re: Auto Organize Audiofiles

Hello Peer, Greetings for Wisconsin, USA. It should work. I tweaked what you did a little bit. My only concern is when Released and/or Reissue Date are not filled in. Also "/" cannot be used for a file/folder name. I used "-". PLEASE BACKUP YOUR DATABASE AND AUDIO FILES BEFORE RU...
by DougWilliams
Wed Aug 16, 2017 11:37 pm
Forum: Using CATraxx
Topic: sql-Question
Replies: 4
Views: 189

Re: sql-Question

Hi Cally, While it's likely a sql query could do what you're asking, I'm wondering if a custom Track View for the Copy Track Data be a better idea. The problem I have with the sql query is there could be unexpected variances. The song title "Heaven" has many artists. How would you determin...

Go to advanced search