Click here to Skip to main content
15,911,896 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Unable to Upgrade Vb6 to Vb.net Pin
sarfarazaliqureshi13-Jan-09 9:11
sarfarazaliqureshi13-Jan-09 9:11 
GeneralRe: Unable to Upgrade Vb6 to Vb.net Pin
Henry Minute13-Jan-09 9:25
Henry Minute13-Jan-09 9:25 
GeneralRe: Unable to Upgrade Vb6 to Vb.net Pin
sarfarazaliqureshi13-Jan-09 9:32
sarfarazaliqureshi13-Jan-09 9:32 
QuestionSQL Query Syntax Issue Pin
tcd6713-Jan-09 5:59
tcd6713-Jan-09 5:59 
AnswerRe: SQL Query Syntax Issue Pin
Wendelius13-Jan-09 6:28
mentorWendelius13-Jan-09 6:28 
GeneralRe: SQL Query Syntax Issue Pin
tcd6713-Jan-09 6:46
tcd6713-Jan-09 6:46 
GeneralRe: SQL Query Syntax Issue Pin
Wendelius13-Jan-09 7:24
mentorWendelius13-Jan-09 7:24 
Questionwindows service structure/custom actions Pin
captainmogo13-Jan-09 4:42
captainmogo13-Jan-09 4:42 
I was given a service application that manages (creating/deleting) the partitions on database tables. Currently at the top of every hour, the progam adds a new partition & deletes any partitions that are older than 36 hours. I am being asked to modify this so that on startup the application creates 36 paritions for each of the tables. Then at the top of every hour, it will create a new parition for time + 36hrs and again delete anything older than time-36hrs. A timer is used (with a 30 second interval) to check if it is the top of the hour.

I have 2 questions.....
1. I created a flag and set it to true on startup. Timer tick sub routine checks the flag, if it is True, the app loops through each table and creates 36 paritions, then sets the flag to False. Every time there after, the timer tick routine checks the minute property of the current time and if it is 0, runs the routine to create the new partition and delete the old. Is this the most efficient way to do it. I was reading about custom actions for setup projects and was thinking that maybe the first 36 could be created using this.

2. The timer tick every 30 seconds to check the minute property but I was wondering if there was a better way to check for the top of the hour.

Thanks in advance
AnswerRe: windows service structure/custom actions Pin
Wendelius13-Jan-09 6:40
mentorWendelius13-Jan-09 6:40 
GeneralRe: windows service structure/custom actions Pin
captainmogo13-Jan-09 8:12
captainmogo13-Jan-09 8:12 
GeneralRe: windows service structure/custom actions Pin
Wendelius13-Jan-09 8:57
mentorWendelius13-Jan-09 8:57 
QuestionVBA - Changing a name of a Worksheet Pin
Dalek Dave13-Jan-09 4:16
professionalDalek Dave13-Jan-09 4:16 
AnswerRe: VBA - Changing a name of a Worksheet Pin
Dalek Dave13-Jan-09 4:20
professionalDalek Dave13-Jan-09 4:20 
QuestionMaximise already created process Pin
hrishiS12-Jan-09 23:56
hrishiS12-Jan-09 23:56 
AnswerRe: Maximise already created process Pin
EliottA13-Jan-09 2:48
EliottA13-Jan-09 2:48 
AnswerRe: Maximise already created process Pin
Henry Minute13-Jan-09 6:13
Henry Minute13-Jan-09 6:13 
AnswerRe: Maximise already created process Pin
Dave Kreskowiak13-Jan-09 8:24
mveDave Kreskowiak13-Jan-09 8:24 
GeneralRe: Maximise already created process Pin
hrishiS14-Jan-09 17:23
hrishiS14-Jan-09 17:23 
GeneralRe: Maximise already created process Pin
hrishiS3-Feb-09 23:45
hrishiS3-Feb-09 23:45 
GeneralRe: Maximise already created process Pin
Dave Kreskowiak4-Feb-09 2:21
mveDave Kreskowiak4-Feb-09 2:21 
QuestionBack up ms access database using vb.net2005 Pin
hrishiS12-Jan-09 23:36
hrishiS12-Jan-09 23:36 
AnswerRe: Back up ms access database using vb.net2005 Pin
Tom Deketelaere13-Jan-09 1:42
professionalTom Deketelaere13-Jan-09 1:42 
AnswerRe: Back up ms access database using vb.net2005 Pin
Wendelius13-Jan-09 6:52
mentorWendelius13-Jan-09 6:52 
QuestionImage Processing Pin
nishkarsh_k12-Jan-09 19:24
nishkarsh_k12-Jan-09 19:24 
AnswerRe: Image Processing Pin
Guffa13-Jan-09 1:03
Guffa13-Jan-09 1:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.