Search results for query: *

UPDATE: So Ive been running this code for a month ad a half and it's working perfectly. Every Monday at 12:00 AM the capture stops then restarts as I want it too. Next I'll work to have it email up a status message when it restarts. Donald M

Thanks for the suggestions kodr. I'll look into how that would work. This is my first "big" (not three lines of code) script in ASPECT language. The code worked perfectly last night. One single capture at midnight was restarted. Thanks again to knob, and I appreciate kodr for the alternate...

Yes they were happenning at the same time. Basically within milliseconds. Pausing for 60 seconds made it worse. It actually captured 5 or six and then kept doing it every minute after. I made a change to pause 1 second and then I changed the time evaluation in the if statements at the...

Hi Knob, I have got the code almost where I need it but there is a problem. At the minute change over from 59 seconds to the new minute two captures are created not one. Basically it captures then closes then captures again. I only have ONE capture off in the code. What do you think might...

Thanks Knob, Should I wrap them together like this? if $CAPTURE == 0 capture on if DayWeek == 1 waituntil "23:59:30" capture off clear endif endif I also wrapped the code in while 1 yield (capture code here) endwhile To save from accidental user closure of...

SO I did more searching and have code to start and stop the capture at the day change. Sunday AM just before the midnight day change. proc main integer LeapYear ; Stores state of leap year. integer DayYear, DayWeek ; Day of year and day of week. string WeekDay, Leap ...

Sorry, We're using Procomm 4.8 Donald M

Hello all, I have a PC serial conencted to capture data on our paging system. Only the standard Startup script is running. Each Monday morning we have a user manually stop the capture that is taking place and restart the capture. Unfortunately due to human error I find that periodically...

Dhookom: Gave it a try and this is what I was looking for changed line 6 to read: strSQL = qd.sql & vbcrlf & "union all select...." & varMonth & ";"This might just do the job. MichaelRed: I haven't written off your sugesstion. I'll give it a try also and see which flavor works best in my...

Is there a way to modify a query, adding permenantly to it (periodically) through code (function, etc)? We receive our Nextel billing as an Access db and normally the info is only needed monthly and not as a union of the multiple months. Though lately I have had to compile multiple month data...

PHV, This returns the info in a completely different way than I thought it should (much more lines and sequences returned) but I am definitely able to get the info I need with this. Thanks again. Donald M

Remou, I noticed that this function is skipping the first couple of numbers in each sequence. example 7421 7591 7592 7593 7594 7595 7596 7597 7598 7599 7600 7601 7602.../... When I run sequential(5,false) it returns 7593 7594 7595 7596 7597 Shouldn't I be getting: 7591-7595 for seq1...

I took another look and yes that helps identify the numbers greatly. I went on to add some code in the loop to deposit the numbers into a table for use. I will add some to display them on a form to choose the values the user or I need and then mark them as used. here is the application I have...

Remou: Thanks, your function does return the number of sequences. I also (though not stated in my post need to know what those numbers in the sequence are..) I think my wording should have been more like I would like to retrieve and display the actual numbers that satisfy 4 , 6, 10 or (what...

(I've dual posted this in Access Queries also...) My problem is this.. I now manage phone numbers for an institution and need to identify sequential numbers in a table. tblNumbers:(fldPhoneNumber...and other fields) The issue is sometimes I need to identify 3 sequential #s sometimes 4...

My problem is this.. I now manage phone numbers for an institution and need to identify sequential numbers in a table. tblNumbers:(fldPhoneNumber...and other fields) The issue is sometimes I need to identify 3 sequential #s sometimes 4 sometimes 10. So the ability to have the...

I have a table of details (tblPDS) holding the status (statusID) of a device. When one of the records in this table for the associated device detail(PagerDetailID) is the status "Active" I would like to not allow another status record to be chosen with the same Value. This one value "Active" is...

PHV, Thanks this a perfect example to work with. Much appreciated. dm Donald M

Hello all, I hope I got all the detail necessary in this... I am tracking cellular devices in our Org. There are multiple records in some cases for an individual, because of upgrades, lost devices, service changes, etc. I need to see only the most recent record (either by choosing the highest...

Thanks HOA much appreciated. Donald M