Click here to Skip to main content
15,845,212 members
Home / Discussions / Database
   

Database

 
Generaldbo Pin
Hugo Hallman5-Nov-03 13:19
Hugo Hallman5-Nov-03 13:19 
GeneralSQL! Pin
Silly Boy5-Nov-03 7:18
Silly Boy5-Nov-03 7:18 
GeneralRe: SQL! Pin
Jeff Varszegi5-Nov-03 8:34
professionalJeff Varszegi5-Nov-03 8:34 
GeneralRe: SQL! Pin
andyharman5-Nov-03 12:49
professionalandyharman5-Nov-03 12:49 
GeneralEncoding problem using ADO Stream Pin
Firas Rashid4-Nov-03 3:59
Firas Rashid4-Nov-03 3:59 
GeneralAlternative SQL Queries based on Table Data Pin
Jo Fredrickson3-Nov-03 22:58
Jo Fredrickson3-Nov-03 22:58 
Hi,

I am using ADO to query my Access database and need to run one sql query that conditionally issues one of two complex select statements depending upon the value of a particular field in a table. The two select statements query different tables. I'm trying to use something like:

SELECT IIF((SELECT PropertyValue FROM PropertyTable WHERE PropertyCode=10)=0,
(SELECT ...), (SELECT ...))

But this only lets me return one column, whereas my select statements need to return many columns. The CASE statement seems to have the same limitation.

Any advice would really help!Smile | :)
Joanne


GeneralRe: Alternative SQL Queries based on Table Data Pin
andyharman5-Nov-03 12:35
professionalandyharman5-Nov-03 12:35 
GeneralRe: Alternative SQL Queries based on Table Data Pin
Jo Fredrickson5-Nov-03 15:59
Jo Fredrickson5-Nov-03 15:59 
GeneralMSADO 2.5 Pin
Kant3-Nov-03 16:46
Kant3-Nov-03 16:46 
GeneralRe: MSADO 2.5 Pin
Mike Dimmick5-Nov-03 2:51
Mike Dimmick5-Nov-03 2:51 
GeneralRe: MSADO 2.5 Pin
Kant5-Nov-03 6:01
Kant5-Nov-03 6:01 
GeneralFULL LEFT/RIGHT JOIN Pin
devvvy3-Nov-03 13:53
devvvy3-Nov-03 13:53 
GeneralRe: FULL LEFT/RIGHT JOIN Pin
Jeff Varszegi3-Nov-03 15:28
professionalJeff Varszegi3-Nov-03 15:28 
GeneralRe: FULL LEFT/RIGHT JOIN Pin
devvvy3-Nov-03 15:30
devvvy3-Nov-03 15:30 
GeneralTrouble Running Sql Script from Code Pin
perlmunger3-Nov-03 12:42
perlmunger3-Nov-03 12:42 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi3-Nov-03 15:54
professionalJeff Varszegi3-Nov-03 15:54 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 4:58
perlmunger4-Nov-03 4:58 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi4-Nov-03 5:03
professionalJeff Varszegi4-Nov-03 5:03 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 5:54
perlmunger4-Nov-03 5:54 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi4-Nov-03 6:38
professionalJeff Varszegi4-Nov-03 6:38 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 7:55
perlmunger4-Nov-03 7:55 
GeneralIdentity Seeds Pin
Colin Angus Mackay3-Nov-03 7:56
Colin Angus Mackay3-Nov-03 7:56 
GeneralHandling Disconnected Data In ADO.NET Pin
L Thomas3-Nov-03 6:10
L Thomas3-Nov-03 6:10 
Generalsql tables Pin
ranjjj31-Oct-03 4:14
ranjjj31-Oct-03 4:14 
GeneralRe: sql tables Pin
ranjjj31-Oct-03 4:18
ranjjj31-Oct-03 4:18 

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.