Search results for query: *

Do you have access to the Digimaster "Interface Developer's Guide? This document will probably get you started in the right direction. You can download the correct version for your system software here...

I think I found a solution, but I would appreciate any feedback on ways that it might fail. I ended up moving my subqueries into the from clause, like this: select d.debtor_id, d.name1, emp.name, sum(t.cur_bal) as total from dm.dbtr d left outer join (select debtor_id, max(pmt_date)...

I am getting so close, but I have run up against another odd behavior, and can't figure a way around it. Here is my query as it currently stands: Select d.debtor_id, d.name1, sum(t.cur_bal) as total, max(e.name), max(p.pmt_date) from dm.dbtr d left outer join dm.dbtremp e on...

This is great! and I appreciate your help. Sadly, it turns out that I was trying to fix the wrong problem - and in an effort to simplify the question, I left out information (which I thought wasn't important) which is related to the problem. This query actually involves a join of 7 tables. I...

Thanks, Does it make a difference that the debtor id and name are coming from a different table than the debts? Would I just need to add a join? select [debtor ID], [debtor name], sum([debt balance]) from [dbtr] join [debt] on [dbtr.debtor ID] = [debt.primary debtor ID] where...

Thanks for any help, I think I am thinking myself into a corner... In my database I have (among others) 2 tables. One is a list of people who owe money (debtors) and the other is a list of individual debts. A debtor can have one or more debts. Debts are assigned a 3 digit status code. What I...

Thanks for the explanation. Luckily, nulls aren't a factor in this data. Each record will have *something* in each field, so all I have to worry about is calculating a "total if this" and a "total if that". It's working now, using two queries, and has been for a month or so - but something in...

Thanks for the explanation. Since I have one of those jobs where I don't get to do any one thing regularly, and have to jump from skillset to skillset (and language to language when I DO get to code), I tend to gravitate toward syntax that will be easy for me to understand when I next look at...

Ok, cool. And then in the second example, "NonLetterCount", we are using "then 0 else TotalCount" rather than "<> "Letter"? It looks like 2 ways to achieve the same result?

Thanks for this. I have never used Case in SQL, so I would like to make sure that I am clear on what this is doing: Select Sum(Case when PaperSize = 'Letter' Then TotalCount Else 0 End) As LetterCount, Sum(Case When PaperSize = 'Letter' Then 0 Else TotalCount End) As NonLetterCount...

I have 2 queries which perform aggregates (sum) on the same column, depending on the value of a different column in the same table - similar to this: SELECT SUM(TotalCount) WHERE PaperSize = "Letter" SELECT SUM(TotalCount) WHERE PaperSize <> "Letter" The actual queries are slightly more...

Can you tell me which settings you changed? I have run into this exact problem, and it's driving me batty! Thanks! JAFrank

Mark, my experience has been that setting logon time restrictions will prevent a user from logging in, but has no effect on a user who remains logged in after their time has expired. In other words, If I allow users to login between 7am and 6pm, a user who goes home at 5pm and leaves his...

Did you ever get this fixed? What version of System Software are you running on your iR110? If you are running one of the 5.x versions, there is a patch available for the machine that addresses this exact problem. At one of my customers, installing this patch reduced the spool time of a...

I am in the planning stages of writing an application that will make a small modification to a Postscript file & then send it to a printer. I can't find any information on LPR in any of the VB help or in the MS KB. It's easy from the command line: lpr -S <server> -P <port/printer> <filename>...

Also, can vncserver be run by a user with less privileges than root?

I am trying to come up with a script that can be run periodically (via cron?) that would grep ps -A for Xvnc, and if it is not found, start vncserver. Any help would be appreciated. jafrank

Thanks for the reply. I am trying to figure out what would happen if the file were still being written when my program checked the folder? Would it generate an error, or would it try to process the incomplete file? The file I am processing is created by a &quot;Print to File&quot; process...

I am doing some work on an old DOS app which runs acceptably well in a Win2k console window. Unfortunately, it is hard coded to print it's reports to a dot matrix printer on LPT1. The ouput from this app has to be entered into another program, and currently someone has to retype the data from...

I am writing a VB app that opens a text file, manipulates the contents a little, and writes out to a new text file. I can make it work perfectly using manual controls, but what I would like to do is have it 'watch' a folder and have it do the conversion on any file that appears in the folder...