Need some Sqlupdate advice

Discuss using and your tips/tricks for CATraxx
Post Reply
User avatar
Rene
Posts: 19
Joined: Sun Aug 23, 2015 4:15 pm
Location: Netherlands

Need some Sqlupdate advice

Post by Rene » Thu Nov 09, 2017 10:47 am

Hi,
I now use track.custom04 for the sample rate and track.custom05 for the bits per sample of the attached audiofiles with default value of '44100' and '16' resp. I also created some filters for this. Works fine!

But I need some Sqlupdate advice how to insert the default values for the already attached audiofiles: in ' pseudocode' if track.custom04 is empty, then insert '44100' and if track.custom05 is empty, then insert '16'.

Thanks in advance for any advice, hints, tips, warnings (yes, I'll backup my database first)... etc.

René

User avatar
DougWilliams
Site Admin
Posts: 241
Joined: Thu May 22, 2014 11:36 am
Location: Wisconsin, USA
Contact:

Re: Need some Sqlupdate advice

Post by DougWilliams » Thu Nov 09, 2017 5:41 pm

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 246 times
Record Collector
"You Mean I'm Supposed To Listen To 'Em?!?!?!?"

User avatar
Rene
Posts: 19
Joined: Sun Aug 23, 2015 4:15 pm
Location: Netherlands

Re: Need some Sqlupdate advice

Post by Rene » Fri Nov 10, 2017 9:26 am

Hi Doug,

Thanks for this indeed easy solution! I was not aware of this functionality within CATraxx.

Great to have this forum of FNPRG specialists!

Regards,
Rene

Post Reply