Click here to Skip to main content
15,920,828 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: MDI form... Pin
mr_lasseter10-Oct-07 5:20
mr_lasseter10-Oct-07 5:20 
GeneralRe: MDI form... Pin
manni_n10-Oct-07 10:39
manni_n10-Oct-07 10:39 
GeneralRe: MDI form... Pin
mr_lasseter10-Oct-07 15:20
mr_lasseter10-Oct-07 15:20 
QuestionHow can I create a tab dynamically? Pin
Big Ralph9-Oct-07 8:55
Big Ralph9-Oct-07 8:55 
AnswerRe: How can I create a tab dynamically? Pin
Patrick Etc.9-Oct-07 10:47
Patrick Etc.9-Oct-07 10:47 
GeneralRe: How can I create a tab dynamically? Pin
Big Ralph9-Oct-07 18:03
Big Ralph9-Oct-07 18:03 
GeneralRe: How can I create a tab dynamically? Pin
Tom Deketelaere9-Oct-07 22:41
professionalTom Deketelaere9-Oct-07 22:41 
QuestionDateformat! Pin
jensenx9-Oct-07 7:25
jensenx9-Oct-07 7:25 
Hello all!

I'm having a complicated problem here, here goes;

At my development workspace, im running on Vista, VB .net 2005 and the DB on SQL Express 2005. Now i would normally insert a date value as such;

INSERT INTO Table(DateColumn) VALUES ('" & "yyyymmdd" & '")

The date that is in yyyymmdd format without slashes in between, and its in a string format.
As far as it is, it works well.

But now my problem is, when I tried my program on another system (Windows XP), I couldnt be able to insert a date in such a way, an error states that 'unable to convert to smalldatetime ..etc'

ive' tried changing my method to as such,

INSERT INTO Table(DateColumn) VALUES (" & dateValue.Date & ")

it works, to most extent, but the weird part is, some areas in my program dint turn out to work as well as it's expected. The values are inserted into the DB but its showing "1/1/1900" ! As mentioned, using the same identical method on other areas dint have a problem.

What should I do? Why couldnt I in the first place, replicate the success I had over with my Vista workspace onto the other PC. (2 in fact, both running on XP).

Should I define how the database should accept date values? or? Cry | :((


Thanks in advance! Do need some advices here.. Dead | X|

Regards,
Jensen


AnswerRe: Dateformat! Pin
Dave Kreskowiak9-Oct-07 7:34
mveDave Kreskowiak9-Oct-07 7:34 
GeneralRe: Dateformat! Pin
jensenx9-Oct-07 15:16
jensenx9-Oct-07 15:16 
AnswerRe: Dateformat! Pin
GuyThiebaut9-Oct-07 8:23
professionalGuyThiebaut9-Oct-07 8:23 
GeneralRe: Dateformat! Pin
jensenx9-Oct-07 15:19
jensenx9-Oct-07 15:19 
AnswerRe: Dateformat! [modified] Pin
Thomas Krojer10-Oct-07 0:07
Thomas Krojer10-Oct-07 0:07 
Questionvisio org chart shapes are not well formated on its position by using VS.Net Pin
memoboy9-Oct-07 6:22
memoboy9-Oct-07 6:22 
Questiondatabase sql server2000 suspect? [modified] Pin
Phan Van Thao9-Oct-07 5:31
Phan Van Thao9-Oct-07 5:31 
AnswerRe: database sql server2000 suspect? Pin
Dave Kreskowiak9-Oct-07 6:24
mveDave Kreskowiak9-Oct-07 6:24 
AnswerRe: database sql server2000 suspect? Pin
GuyThiebaut9-Oct-07 8:29
professionalGuyThiebaut9-Oct-07 8:29 
Questionchange color of ProgressBar Pin
Sur4u9-Oct-07 5:23
Sur4u9-Oct-07 5:23 
AnswerRe: change color of ProgressBar Pin
Dave Kreskowiak9-Oct-07 6:23
mveDave Kreskowiak9-Oct-07 6:23 
QuestionSockets receive and send Pin
Nasbcn9-Oct-07 5:09
Nasbcn9-Oct-07 5:09 
AnswerRe: Sockets receive and send Pin
Dave Kreskowiak9-Oct-07 6:22
mveDave Kreskowiak9-Oct-07 6:22 
QuestionHow to Accept Parameters in this Situation Pin
Vimalsoft(Pty) Ltd9-Oct-07 4:10
professionalVimalsoft(Pty) Ltd9-Oct-07 4:10 
AnswerRe: How to Accept Parameters in this Situation Pin
SHatchard9-Oct-07 6:08
SHatchard9-Oct-07 6:08 
AnswerRe: How to Accept Parameters in this Situation Pin
Dave Kreskowiak9-Oct-07 6:16
mveDave Kreskowiak9-Oct-07 6:16 
QuestionCheck if changes exist? Pin
Mr Oizo9-Oct-07 3:38
Mr Oizo9-Oct-07 3:38 

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.