TntConnect TM
Helping you build powerful connections for a lifetime of ministry...

How can I run an ad-hoc SQL query within TntMPD?

TNT.tips from Bob!

Table of Contents

It is our pleasure to provide this software free of charge to help you in your ministry.  We're so thankful for our partners who make this possible!

About TntWare

Page Details

First published by:
Troy Wolbrink
on 13 Oct 2011
Last revision by:
Troy Wolbrink
on 3 Apr 2014
1 person found this article useful.

100% of people found this useful
How can I run an ad-hoc SQL query within TntMPD?

Under the "File" menu, click on "Utilities", then click on "Run Query...".

(Note:  If you run a query that changes data, you should also update the "LastEdit" field (to the current time) of each record you modify.  Otherwise TntSync won't know the record changed.  Also, if you might also need to run "File | Utilities | Maintenance" and recalculate some contact fields.)

Recent Comments

By: Steve Balzer Posted on 1 Jul 2014 4:11 AM

I have 244 gift records that are incorrectly flagged as AvailableOnWeb. I can identify them via the memo.

SELECT * FROM Gift

WHERE [Gift].[Memo] = "not available" AND  [Gift].[AvailableOnWeb] = TRUE;

Instead of manually going through each record in the GUI and unchecking the box, I was hoping to update this using the following update query.

UPDATE Gift SET Gift.AvailableOnWeb = FALSE, Gift.LastEdit = NOW()

WHERE [Gift].[Memo] = "not available" AND  [Gift].[AvailableOnWeb] = TRUE;

However, after saving this query, why does the Run (and Rename, FWIW) button remain disabled?

By: Steve Balzer Posted on 1 Jul 2014 4:13 AM

Update:

"...I can identify them via the *query..."

By: Troy Wolbrink Posted on 1 Jul 2014 5:10 PM
100% of people found this useful

I didn't want to make Update Queries too easy to run ... safety reasons.  So to run your update query, you have to double-click on its entry in the Queries list to the left.