Click here to Skip to main content
15,881,588 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Handling Exceptions In Threads Pin
Luc Pattyn15-Jul-09 3:32
sitebuilderLuc Pattyn15-Jul-09 3:32 
AnswerRe: Handling Exceptions In Threads Pin
Gideon Engelberth15-Jul-09 3:16
Gideon Engelberth15-Jul-09 3:16 
GeneralRe: Handling Exceptions In Threads Pin
sohaib_a15-Jul-09 4:04
sohaib_a15-Jul-09 4:04 
QuestionTrouble with COM-Class for Outlook Pin
Sonhospa14-Jul-09 8:16
Sonhospa14-Jul-09 8:16 
AnswerRe: Trouble with COM-Class for Outlook Pin
Sonhospa14-Jul-09 9:06
Sonhospa14-Jul-09 9:06 
QuestionHelp Creating Exe File[modified] Pin
Kaushal Arora14-Jul-09 6:52
Kaushal Arora14-Jul-09 6:52 
AnswerRe: Help Pin
Steven J Jowett14-Jul-09 7:47
Steven J Jowett14-Jul-09 7:47 
QuestionAdd tables to existing SQL database Pin
Nielvh14-Jul-09 1:38
Nielvh14-Jul-09 1:38 
I am writing an application that integrates with an accounting package(running on SQL). I need to add more tables to the existing database that only my application will use. I've created code to add the tables and it works fine. My question is where do I place this code in my program.
I currently run it when the application starts - it tries to create the table, if it doesn't exist it will create it, if it does exist I get an error and the code just continues without creating the table.
The problem with this approach is that every time the application runs it tries to create the table which I think is unnecessary, because after the first time the table would already be there.
I now want to add the code to create the table at the point where I need to use the table, i.e. when I try to read from the table and it is not there, I get an error and only then will the table be created.
Is this the right approach? And if so, how do I distinguish between different errors (if the problem is with the connection I do not want to create a table, but maybe display a message or something).
I hope this makes sense to someone.
AnswerRe: Add tables to existing SQL database Pin
helelark12314-Jul-09 1:47
helelark12314-Jul-09 1:47 
GeneralRe: Add tables to existing SQL database Pin
Nielvh14-Jul-09 1:55
Nielvh14-Jul-09 1:55 
GeneralRe: Add tables to existing SQL database Pin
helelark12314-Jul-09 2:09
helelark12314-Jul-09 2:09 
GeneralRe: Add tables to existing SQL database Pin
Nielvh14-Jul-09 2:17
Nielvh14-Jul-09 2:17 
Questionrun access query for crystal report Pin
KIDYA13-Jul-09 23:26
KIDYA13-Jul-09 23:26 
AnswerRe: run access query for crystal report Pin
helelark12313-Jul-09 23:37
helelark12313-Jul-09 23:37 
GeneralRe: run access query for crystal report Pin
KIDYA14-Jul-09 0:39
KIDYA14-Jul-09 0:39 
QuestionData Conversion Error at RecordSet.MoveNext VB6 Pin
she-Developer13-Jul-09 22:19
she-Developer13-Jul-09 22:19 
AnswerRe: Data Conversion Error at RecordSet.MoveNext VB6 Pin
helelark12313-Jul-09 22:27
helelark12313-Jul-09 22:27 
QuestionWindows Popup Watcher Pin
jeipiyaku13-Jul-09 22:09
jeipiyaku13-Jul-09 22:09 
AnswerRe: Windows Popup Watcher Pin
jeipiyaku13-Jul-09 22:16
jeipiyaku13-Jul-09 22:16 
GeneralRe: Windows Popup Watcher Pin
helelark12313-Jul-09 22:23
helelark12313-Jul-09 22:23 
GeneralRe: Windows Popup Watcher Pin
jeipiyaku13-Jul-09 22:37
jeipiyaku13-Jul-09 22:37 
GeneralRe: Windows Popup Watcher [modified] Pin
helelark12313-Jul-09 22:49
helelark12313-Jul-09 22:49 
GeneralRe: Windows Popup Watcher Pin
jeipiyaku13-Jul-09 23:26
jeipiyaku13-Jul-09 23:26 
QuestionDatabase deployment. using VB .net Pin
Cory Kimble13-Jul-09 8:25
Cory Kimble13-Jul-09 8:25 
AnswerRe: Database deployment. using VB .net Pin
David Mujica13-Jul-09 8:53
David Mujica13-Jul-09 8:53 

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.