Click here to Skip to main content
15,879,535 members
Home / Discussions / Database
   

Database

 
GeneralRe: sharing sql server without client installation Pin
originSH27-Jun-07 1:06
originSH27-Jun-07 1:06 
AnswerRe: sharing sql server without client installation Pin
Mike Dimmick27-Jun-07 2:46
Mike Dimmick27-Jun-07 2:46 
QuestionSequence of events/methods execuion in SSIS Pin
I.explore.code26-Jun-07 19:57
I.explore.code26-Jun-07 19:57 
Questionpull subscriptions Pin
SVb.net26-Jun-07 12:58
SVb.net26-Jun-07 12:58 
QuestionDatabase design for exam system? Pin
HinJinShah26-Jun-07 8:08
HinJinShah26-Jun-07 8:08 
AnswerRe: Database design for exam system? Pin
Ashiq Shaikh26-Jun-07 22:56
professionalAshiq Shaikh26-Jun-07 22:56 
GeneralRe: Database design for exam system? Pin
HinJinShah27-Jun-07 6:31
HinJinShah27-Jun-07 6:31 
QuestionProblem configuring an OldDbDataAdaptor in VS03 Pin
Dan Neely26-Jun-07 4:54
Dan Neely26-Jun-07 4:54 
I'm not sure if I should be posting this here or in one of the .net forums.

I'm trying to get data from two access tables:

tblFoo
FooID  FooText
1      Text1
2      Text2
3      Text3
...

lnkFoo
FooID1 FooID2
1      2
1      3
2      7
...


I want to get the FooText for every row in lnkFoo eg:
Text1  Text2
Text1  Text3
Text2  Text7
...


Using the Configure Data Adaptor wizard I can get both FKs from lnkFoo and the FooText value for either FooID1 or FooID2 by putting both tables in the query builder and dragging to link either FooID1 or FooID2 in lnkFoo to FooID in tblFoo, but if I create links to both FK's in lnkFoo no records are returned.

The nonworking query that is generated looks like this:


SELECT        lnkFoo.FooID1, lnkFoo.FooID2, tblFoo.FooText, tblFoo.FooID
FROM            (lnkFoo INNER JOIN
                         tblFoo ON lnkFoo.FooID1 = tblFoo.FooID AND lnkFoo.FooID2 = tblFoo.FooID)


--
You have to explain to them [VB coders] what you mean by "typed". their first response is likely to be something like, "Of course my code is typed. Do you think i magically project it onto the screen with the power of my mind?" --- John Simmons / outlaw programmer

AnswerRe: Problem configuring an OldDbDataAdaptor in VS03 Pin
Dan Neely26-Jun-07 6:58
Dan Neely26-Jun-07 6:58 
AnswerRe: Problem configuring an OldDbDataAdaptor in VS03 Pin
hisi_200526-Jun-07 16:50
hisi_200526-Jun-07 16:50 
QuestionCalling all Irish devs!! Region-specific characters Pin
Mel Padden26-Jun-07 4:48
Mel Padden26-Jun-07 4:48 
AnswerRe: Calling all Irish devs!! Region-specific characters Pin
Mike Dimmick27-Jun-07 3:10
Mike Dimmick27-Jun-07 3:10 
QuestionMS Access functions to Oracle Pin
Mangilipelli26-Jun-07 2:20
Mangilipelli26-Jun-07 2:20 
AnswerRe: MS Access functions to Oracle Pin
leckey26-Jun-07 9:30
leckey26-Jun-07 9:30 
GeneralRe: MS Access functions to Oracle Pin
Mangilipelli26-Jun-07 22:54
Mangilipelli26-Jun-07 22:54 
GeneralRe: MS Access functions to Oracle Pin
Vasudevan Deepak Kumar27-Jun-07 2:52
Vasudevan Deepak Kumar27-Jun-07 2:52 
QuestionHow can i return the names of a stored procedures input parameters? Pin
Red_Wizard_Shot_The_Food25-Jun-07 23:52
Red_Wizard_Shot_The_Food25-Jun-07 23:52 
AnswerRe: How can i return the names of a stored procedures input parameters? Pin
Manas Bhardwaj26-Jun-07 0:10
professionalManas Bhardwaj26-Jun-07 0:10 
GeneralRe: How can i return the names of a stored procedures input parameters? Pin
originSH26-Jun-07 0:13
originSH26-Jun-07 0:13 
AnswerRe: How can i return the names of a stored procedures input parameters? [modified] Pin
originSH26-Jun-07 0:11
originSH26-Jun-07 0:11 
GeneralRe: How can i return the names of a stored procedures input parameters? Pin
Gamzun26-Jun-07 0:25
Gamzun26-Jun-07 0:25 
GeneralRe: How can i return the names of a stored procedures input parameters? Pin
originSH26-Jun-07 0:28
originSH26-Jun-07 0:28 
GeneralRe: How can i return the names of a stored procedures input parameters? Pin
Gamzun26-Jun-07 0:32
Gamzun26-Jun-07 0:32 
GeneralRe: How can i return the names of a stored procedures input parameters? [modified] Pin
originSH26-Jun-07 1:22
originSH26-Jun-07 1:22 
GeneralRe: How can i return the names of a stored procedures input parameters? Pin
Gamzun26-Jun-07 1:50
Gamzun26-Jun-07 1:50 

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.