Click here to Skip to main content
15,846,826 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Questionhi any one plzzz help urgent Pin
harieshkumar.n31-May-09 21:32
harieshkumar.n31-May-09 21:32 
AnswerRe: hi any one plzzz help urgent Pin
Christian Graus31-May-09 22:51
protectorChristian Graus31-May-09 22:51 
AnswerRe: hi any one plzzz help urgent Pin
0x3c01-Jun-09 1:29
0x3c01-Jun-09 1:29 
AnswerRe: hi any one plzzz help urgent Pin
Dave Kreskowiak1-Jun-09 3:06
mveDave Kreskowiak1-Jun-09 3:06 
QuestionImage not loading in Crystal Report Pin
Ovais Memon31-May-09 20:52
Ovais Memon31-May-09 20:52 
AnswerRe: Image not loading in Crystal Report Pin
Kschuler1-Jun-09 9:12
Kschuler1-Jun-09 9:12 
QuestionHow do I track in which line the error exactly occurs ? Pin
tiagu31-May-09 5:55
tiagu31-May-09 5:55 
AnswerRe: How do I track in which line the error exactly occurs ? Pin
Dave Kreskowiak31-May-09 6:45
mveDave Kreskowiak31-May-09 6:45 
If your running thing under the debugger, it'll stop on the exact line the problem occurs.

Also, if you're using string concatenation to "build" the SQL statement, it's very easy to get an error like your describing:
sql = "SELECT something FROM table WHERE field1 = #" & datevalue & "#"

Use parameterized queries instead to have the code automatically convert the date to the appropriate format for the database engine.


A guide to posting questions on CodeProject[^]



Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
     2006, 2007, 2008




GeneralRe: How do I track in which line the error exactly occurs ? Pin
tiagu31-May-09 22:28
tiagu31-May-09 22:28 
GeneralRe: How do I track in which line the error exactly occurs ? Pin
Dave Kreskowiak1-Jun-09 2:47
mveDave Kreskowiak1-Jun-09 2:47 
AnswerRe: How do I track in which line the error exactly occurs ? Pin
dan!sh 31-May-09 6:49
professional dan!sh 31-May-09 6:49 
AnswerRe: How do I track in which line the error exactly occurs ? Pin
Christian Graus31-May-09 13:27
protectorChristian Graus31-May-09 13:27 
QuestionHow do you populate an array with dataset values Pin
directred31-May-09 2:12
directred31-May-09 2:12 
AnswerRe: How do you populate an array with dataset values Pin
0x3c031-May-09 2:23
0x3c031-May-09 2:23 
AnswerRe: How do you populate an array with dataset values Pin
Johan Hakkesteegt31-May-09 20:56
Johan Hakkesteegt31-May-09 20:56 
QuestionHow to save and retrieve an image in Access using vb.net Pin
mirzamujib31-May-09 1:39
mirzamujib31-May-09 1:39 
AnswerRe: How to save and retrieve an image in Access using vb.net Pin
0x3c031-May-09 2:30
0x3c031-May-09 2:30 
AnswerRe: How to save and retrieve an image in Access using vb.net Pin
Dave Kreskowiak31-May-09 4:28
mveDave Kreskowiak31-May-09 4:28 
QuestionAbout Auto detecting immage face Pin
ashika198631-May-09 0:29
ashika198631-May-09 0:29 
AnswerRe: About Auto detecting immage face Pin
Dalek Dave31-May-09 2:52
professionalDalek Dave31-May-09 2:52 
GeneralRe: About Auto detecting immage face Pin
Dave Kreskowiak31-May-09 4:21
mveDave Kreskowiak31-May-09 4:21 
AnswerRe: About Auto detecting immage face Pin
Dave Kreskowiak31-May-09 4:25
mveDave Kreskowiak31-May-09 4:25 
GeneralRe: About Auto detecting immage face Pin
Dalek Dave31-May-09 5:09
professionalDalek Dave31-May-09 5:09 
GeneralRe: About Auto detecting immage face Pin
TheMrProgrammer31-May-09 21:56
TheMrProgrammer31-May-09 21:56 
GeneralRe: About Auto detecting immage face Pin
Dalek Dave31-May-09 22:31
professionalDalek Dave31-May-09 22:31 

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.