DieselTalk

DieselEngineTrader's FREE Diesel Engine Forums

new topic search Categories login View Caterpillar Engines

CATEGORY LISTINGS > CATERPILLAR > DVR Parameters [ REFRESH ]
Thread Title:

DVR Parameters


Created On Monday June 21, 2021 10:58 Diesel Talk
Diesel Talk Forum

Apple25180832
Diesel Talk Forum
Posts: 1
Joined: Jun 2021

Note Monday June 21, 2021 10:58 View thread in raw text format
Diesel Talk
Hi All,
Took delivery of a replacement DVR fitted to a 3142. It only has default values set in the parameters. Does anyone know if there are tables out there for easy calculation to adapt the default values to your specific output requirements? Tried calling CAT support, absolutely no help at all. Any help much appreciated. Before anyone asks, no I cant just see a CAT dealer as im in the middle of nowhere.
Diesel Talk Forum
Reply Diesel Talk Forum Quote Diesel Talk Top Diesel Talk Forum Bottom Diesel Talk
Diesel Talk Forum
CATEGORY LISTINGS > CATERPILLAR [ REFRESH ]
SELECT Advert_Number, Size_Type, Banner_Name, FName, LName, CompanyName FROM Advert_Imp a LEFT OUTER JOIN Seller s ON a.Company_ID = s.SellerID WHERE Show_Advert=1 AND Size_Type = 2 ORDER BY Advert_Number
#AltName#
#AltName#
SELECT Imps_Available FROM Advert_Imp WHERE Advert_Number = UPDATE Advert_Imp SET Imps_Available = #Imps_Available1# WHERE Advert_Number = SELECT Impressions FROM Advert_Imp_Trans WHERE Advert_Number = AND Month(Date)=#CurrentMonth# AND Year(Date)=#CurrentYear# UPDATE Advert_Imp_Trans SET Impressions = #Impressions1# WHERE Advert_Number = AND Month(Date)=#CurrentMonth# AND Year(Date)=#CurrentYear# INSERT INTO Advert_Imp_Trans (Advert_Number, Date, Impressions, Clicks) VALUES (#Advert_Number#, #CurrentNow#, 1, 0)
SELECT Advert_Number, Banner_Name, FName, LName, CompanyName FROM Advert_Imp a LEFT OUTER JOIN Seller s ON a.Company_ID = s.SellerID WHERE Show_Advert=1 AND Size_Type=1 ORDER BY NEWID()
#AltName#
SELECT Imps_Available FROM Advert_Imp WHERE Advert_Number = UPDATE Advert_Imp SET Imps_Available = #Imps_Available1# WHERE Advert_Number = SELECT Impressions FROM Advert_Imp_Trans WHERE Advert_Number = AND Month(Date)=#CurrentMonth# AND Year(Date)=#CurrentYear# UPDATE Advert_Imp_Trans SET Impressions = #Impressions1# WHERE Advert_Number = AND Month(Date)=#CurrentMonth# AND Year(Date)=#CurrentYear# INSERT INTO Advert_Imp_Trans (Advert_Number, Date, Impressions, Clicks) VALUES (#Advert_Number#, #CurrentNow#, 1, 0)
Advertize on Diesel Engine Trader

Customer Testimonials

Newsletter

Subscribe to our mailing list to get all the latest DET news.as well as daily or weekly notifications of new engines, gensets and spare parts listings.

'Was looking for a Gardner 4LK to rebuild. None of my usual contacts could help me so I searched the Internet and found one on DieselEngineTrader. It was only 27 miles down the road!'

William Geldeard, North West Engine Services, Chester, UK

'We've sold 2 CAT engines and a Cummins in the last 4 months and even sold Crankshafts to Italy and Afganistan! DieselEngineTrader.com generates lots of inquiries - it definitely works for us!'

Joe Zalesky, Rebuild Incorporated, Ohio, USA

'Had an Deutz engine in our yard for 10 years then we thought - let's try listing on DieselEnginetrader.com and it sold within 2 weeks!'

Steve Spencer, Midwest Engine Inc., Michigan, USA

Copyright Diesel Engine Trader 2015