Click here to Skip to main content
16,005,080 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: regarding vbscript Pin
tirucapricorn14-Oct-05 18:55
tirucapricorn14-Oct-05 18:55 
GeneralRe: regarding vbscript Pin
Dave Kreskowiak15-Oct-05 6:04
mveDave Kreskowiak15-Oct-05 6:04 
QuestionUNSETCOMMA Pin
Greeky14-Oct-05 0:14
Greeky14-Oct-05 0:14 
AnswerRe: UNSETCOMMA Pin
Briga14-Oct-05 1:19
Briga14-Oct-05 1:19 
GeneralRe: UNSETCOMMA Pin
Greeky14-Oct-05 1:23
Greeky14-Oct-05 1:23 
GeneralRe: UNSETCOMMA Pin
Briga14-Oct-05 2:29
Briga14-Oct-05 2:29 
GeneralRe: UNSETCOMMA Pin
jo0ls15-Oct-05 16:36
jo0ls15-Oct-05 16:36 
QuestionJoin Tables Pin
Greeky13-Oct-05 23:55
Greeky13-Oct-05 23:55 
Imagine two table
One Table (ForeignCurrency)

FC_ID FC_TYPE
1 USD
2 EUR
3 YTL


Other table (Rates)

FCV_ID FCV_RateIN FCV_RateOUT FCV_DATE
1 1 1 10/13/2005
2 1.345 1.346 10/13/2005
3 1.651 1.654 10/13/2005


I need to join two table in a one query. I do this so
Select FC.FC_TYPE,ISNULL(FCV_RateIN,1) FCV_RateIN,ISNULL(FCV_RateOut,1) FCV_RateOut from ForeignCurrency FC LEFT OUTER JOIN Rates R ON FC.FC_ID=R.FCV_ID WHERE FCV_Date='10/13/2005'

This give me result as i want. But when i need 10/14/2005 rates it give me empty result set , but i expect
FCV_TYPE FCV_RateIn FCV_RateOUT
YTL 1 1
USD 1 1
EUR 1 1

How can i re-write code ?
AnswerRe: Join Tables Pin
Qhalis14-Oct-05 6:37
Qhalis14-Oct-05 6:37 
QuestionREAD ONLY COMBO CONVERT C++ CODE TO VB.NET Pin
Greeky13-Oct-05 23:26
Greeky13-Oct-05 23:26 
AnswerRe: READ ONLY COMBO CONVERT C++ CODE TO VB.NET Pin
Briga14-Oct-05 1:53
Briga14-Oct-05 1:53 
AnswerRe: READ ONLY COMBO CONVERT C++ CODE TO VB.NET Pin
jo0ls15-Oct-05 12:14
jo0ls15-Oct-05 12:14 
AnswerRe: READ ONLY COMBO CONVERT C++ CODE TO VB.NET Pin
jo0ls15-Oct-05 12:16
jo0ls15-Oct-05 12:16 
QuestionHow to generate an operating system token of other valid network user Pin
farazzzzzz13-Oct-05 21:38
farazzzzzz13-Oct-05 21:38 
QuestionRAW DATA PRINTING ON WINDOWS ME Pin
Greeky13-Oct-05 21:09
Greeky13-Oct-05 21:09 
AnswerRe: RAW DATA PRINTING ON WINDOWS ME Pin
Dave Kreskowiak14-Oct-05 1:29
mveDave Kreskowiak14-Oct-05 1:29 
GeneralRe: RAW DATA PRINTING ON WINDOWS ME Pin
Greeky14-Oct-05 1:51
Greeky14-Oct-05 1:51 
GeneralRe: RAW DATA PRINTING ON WINDOWS ME Pin
Dave Kreskowiak14-Oct-05 4:04
mveDave Kreskowiak14-Oct-05 4:04 
QuestionVB.net or C# Pin
Guerven13-Oct-05 20:24
Guerven13-Oct-05 20:24 
AnswerRe: VB.net or C# Pin
Dave Kreskowiak14-Oct-05 1:23
mveDave Kreskowiak14-Oct-05 1:23 
QuestionChess programming Pin
Byamatsogt13-Oct-05 17:52
Byamatsogt13-Oct-05 17:52 
AnswerRe: Chess programming Pin
munkh-erdene13-Oct-05 17:54
munkh-erdene13-Oct-05 17:54 
AnswerRe: Chess programming Pin
Dave Kreskowiak14-Oct-05 1:21
mveDave Kreskowiak14-Oct-05 1:21 
QuestionThe Beep sound question again... Pin
13-Oct-05 11:32
suss13-Oct-05 11:32 
AnswerRe: The Beep sound question again... Pin
jo0ls15-Oct-05 16:57
jo0ls15-Oct-05 16:57 

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.