Click here to Skip to main content
       

Visual Basic

 
AnswerRe: messagebeep PinmvpDave Kreskowiak14-Nov-12 8:31 
QuestionRijndael encryption not working Pinmembermaskrtnik0114-Nov-12 2:20 
AnswerRe: Rijndael encryption not working PinmentorKeith Barrow14-Nov-12 2:52 
GeneralRe: Rijndael encryption not working Pinmembermaskrtnik0114-Nov-12 3:08 
GeneralRe: Rijndael encryption not working PinmentorKeith Barrow14-Nov-12 3:26 
GeneralRe: Rijndael encryption not working PinmentorKeith Barrow14-Nov-12 3:35 
GeneralRe: Rijndael encryption not working Pinmembermaskrtnik0114-Nov-12 3:48 
GeneralRe: Rijndael encryption not working PinmentorKeith Barrow14-Nov-12 4:05 
QuestionRe: Rijndael encryption not working [modified] Pinmembermaskrtnik0115-Nov-12 19:40 
GeneralRe: Rijndael encryption not working PinmemberDisIsHoody14-Nov-12 9:34 
GeneralRe: Rijndael encryption not working Pinmembermaskrtnik0114-Nov-12 18:21 
AnswerRe: Rijndael encryption not working PinmemberDisIsHoody15-Nov-12 17:37 
GeneralRe: Rijndael encryption not working Pinmembermaskrtnik0115-Nov-12 19:37 
QuestionRetrive date from sql server in system date format in VB6 application by a one time setting PinmemberJohnson Antony13-Nov-12 13:34 
Hi,
 
My VB6 application has been developed long back using Access as back end. Now I am planning to migrate data from Access to sQL server 2008 .
 
1)Previously vb6 application was retrieving date from Access file in dd/MM/yyyy format which is the system format without any format function.(Uses RecordSet object) . After migrating to sQL server 2008 date retrieved in yyyy-MM-dd format which I have to format each time to my required format.
 
So it's creating issues at many places like inserting records to server, date comparison with date controls of vb6 etc. So I may have to apply format() function at many places. Can we use any once only setup to retrieve date in required format , so the application changes will be minimal. (at SQL Server side or at my application). ie the RecordSet.Open will always provide date data in dd/MM/yyyy format without any explicit formatting.
 
2)I am not able to use seek function with RecordSet object
 
Thanks in Advance
Johnson
AnswerRe: Retrive date from sql server in system date format in VB6 application by a one time setting PinmvpDave Kreskowiak13-Nov-12 14:00 
QuestionHow to find out if a file is in use before reading the data in that file PinmemberKreativeKai13-Nov-12 7:47 
AnswerRe: How to find out if a file is in use before reading the data in that file PinmvpDave Kreskowiak13-Nov-12 8:09 
GeneralRe: How to find out if a file is in use before reading the data in that file PinmemberKreativeKai13-Nov-12 8:22 
GeneralRe: How to find out if a file is in use before reading the data in that file PinmemberKreativeKai13-Nov-12 8:46 
AnswerRe: How to find out if a file is in use before reading the data in that file PinmemberKreativeKai13-Nov-12 8:13 
GeneralRe: How to find out if a file is in use before reading the data in that file [modified] PinmvpDave Kreskowiak13-Nov-12 9:57 
AnswerRe: How to find out if a file is in use before reading the data in that file PinmemberEddy Vluggen13-Nov-12 11:41 
GeneralRe: How to find out if a file is in use before reading the data in that file PinmemberKreativeKai14-Nov-12 1:37 
GeneralRe: How to find out if a file is in use before reading the data in that file [modified] PinmemberVitorHugoGarcia19-Nov-12 1:12 
QuestionVB Script for automatically turning off the monitor PinmemberPrasan Cumar13-Nov-12 4:14 
AnswerRe: VB Script for automatically turning off the monitor PinmvpDave Kreskowiak13-Nov-12 4:59 
AnswerRe: VB Script for automatically turning off the monitor PinmemberBernhard Hiller13-Nov-12 21:20 
QuestionSQL Configuration PinmemberDinoRondelly13-Nov-12 3:46 
AnswerRe: SQL Configuration PinmemberDavid Mujica13-Nov-12 4:07 
GeneralRe: SQL Configuration PinmemberDinoRondelly13-Nov-12 5:56 
GeneralRe: SQL Configuration PinmemberDavid Mujica13-Nov-12 9:44 
GeneralRe: SQL Configuration PinmemberDinoRondelly13-Nov-12 18:17 
QuestionSource Code PinmemberMember 939009712-Nov-12 15:59 
AnswerRe: Source Code PinmvpDave Kreskowiak13-Nov-12 2:20 
QuestionMonitoring Network Usage For Remote Users [modified] PinmemberDinoRondelly12-Nov-12 10:54 
AnswerRe: Monitoring Network Usage For Remote Users PinmemberEddy Vluggen13-Nov-12 11:44 
QuestionScan Multipage Tiff Image For A Barcode Pinmemberdaveofgv12-Nov-12 4:07 
AnswerRe: Scan Multipage Tiff Image For A Barcode PinmemberEddy Vluggen12-Nov-12 10:54 
QuestionGetting All Logged On Users and IP VB.net PinmemberDinoRondelly12-Nov-12 3:39 
AnswerRe: Getting All Logged On Users and IP VB.net PinmvpDave Kreskowiak12-Nov-12 4:37 
GeneralRe: Getting All Logged On Users and IP VB.net PinmemberDinoRondelly12-Nov-12 4:44 
GeneralRe: Getting All Logged On Users and IP VB.net PinmvpDave Kreskowiak12-Nov-12 4:52 
GeneralRe: Getting All Logged On Users and IP VB.net PinmemberDinoRondelly12-Nov-12 4:55 
GeneralRe: Getting All Logged On Users and IP VB.net PinmvpDave Kreskowiak12-Nov-12 5:55 
GeneralRe: Getting All Logged On Users and IP VB.net PinmemberDinoRondelly12-Nov-12 6:11 
GeneralRe: Getting All Logged On Users and IP VB.net PinmvpDave Kreskowiak12-Nov-12 6:46 
AnswerRe: Getting All Logged On Users and IP VB.net [modified] PinmemberDinoRondelly12-Nov-12 8:05 
GeneralRe: Getting All Logged On Users and IP VB.net PinmvpDave Kreskowiak12-Nov-12 10:02 
QuestionModule error> PLEASE HELP! Pinmemberleashim11-Nov-12 13:57 
AnswerRe: Module error> PLEASE HELP! PinmvpDave Kreskowiak11-Nov-12 17:08 

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

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


Advertise | Privacy | Mobile
Web03 | 2.8.140916.1 | Last Updated 18 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid