Click here to Skip to main content
15,444,523 members
Home / Discussions / Database
   

Database

 
GeneralRe: ORM Rant Pin
Mycroft Holmes16-Jun-14 12:43
professionalMycroft Holmes16-Jun-14 12:43 
GeneralRe: ORM Rant Pin
Richard MacCutchan16-Jun-14 21:20
mveRichard MacCutchan16-Jun-14 21:20 
AnswerRe: ORM Rant Pin
Bernhard Hiller16-Jun-14 21:06
MemberBernhard Hiller16-Jun-14 21:06 
QuestionDistinct records on old school foxpro database file Pin
jkirkerx15-Jun-14 12:22
professionaljkirkerx15-Jun-14 12:22 
AnswerRe: Distinct records on old school foxpro database file Pin
GuyThiebaut15-Jun-14 22:03
professionalGuyThiebaut15-Jun-14 22:03 
GeneralRe: Distinct records on old school foxpro database file Pin
jkirkerx16-Jun-14 6:08
professionaljkirkerx16-Jun-14 6:08 
AnswerRe: Distinct records on old school foxpro database file Pin
Jörgen Andersson15-Jun-14 22:27
professionalJörgen Andersson15-Jun-14 22:27 
GeneralRe: Distinct records on old school foxpro database file Pin
jkirkerx16-Jun-14 6:11
professionaljkirkerx16-Jun-14 6:11 
I ended up doing something similar. I wrote one function to get the distinct items, and went back and got the sums with the distinct item list. I don't know what I was thinking, was trying to do it all in one shot.

" SELECT " & _
"  SUM(FSHIPQTY) " & _
", SUM(FAMOUNT) " & _
" FROM ARTRS01H.dbf " & _
" WHERE FCUSTNO=@FCUSTNO " & _
" AND FITEMNO=@FITEMNO "

AnswerRe: Distinct records on old school foxpro database file Pin
NitinDhapte16-Jun-14 23:30
MemberNitinDhapte16-Jun-14 23:30 
Answer[SOLVED], I finally go it Pin
jkirkerx19-Jun-14 18:42
professionaljkirkerx19-Jun-14 18:42 
QuestionUnable to establish a connection to sql database 2005 Pin
Otekpo Emmanuel14-Jun-14 11:57
MemberOtekpo Emmanuel14-Jun-14 11:57 
AnswerRe: Unable to establish a connection to sql database 2005 Pin
Kornfeld Eliyahu Peter14-Jun-14 19:22
professionalKornfeld Eliyahu Peter14-Jun-14 19:22 
QuestionSelective queries? Pin
Member 448708313-Jun-14 7:00
MemberMember 448708313-Jun-14 7:00 
GeneralRe: Selective queries? Pin
Richard MacCutchan13-Jun-14 7:16
mveRichard MacCutchan13-Jun-14 7:16 
AnswerRe: Selective queries? Pin
PIEBALDconsult13-Jun-14 7:19
professionalPIEBALDconsult13-Jun-14 7:19 
AnswerRe: Selective queries? Pin
Tim Carmichael13-Jun-14 7:35
MemberTim Carmichael13-Jun-14 7:35 
AnswerRe: Selective queries? Pin
Eddy Vluggen13-Jun-14 7:47
professionalEddy Vluggen13-Jun-14 7:47 
GeneralRe: Selective queries? Pin
Member 448708313-Jun-14 10:26
MemberMember 448708313-Jun-14 10:26 
AnswerRe: Selective queries? Pin
jschell13-Jun-14 8:32
Memberjschell13-Jun-14 8:32 
GeneralRe: Selective queries? Pin
Member 448708313-Jun-14 10:27
MemberMember 448708313-Jun-14 10:27 
GeneralRe: Selective queries? Pin
Mycroft Holmes13-Jun-14 13:10
professionalMycroft Holmes13-Jun-14 13:10 
AnswerRe: Selective queries? Pin
Jörgen Andersson13-Jun-14 9:21
professionalJörgen Andersson13-Jun-14 9:21 
AnswerRe: Selective queries? Pin
Tim Carmichael13-Jun-14 13:00
MemberTim Carmichael13-Jun-14 13:00 
AnswerRe: Selective queries? Pin
Member 448708316-Jun-14 7:08
MemberMember 448708316-Jun-14 7:08 
AnswerRe: Selective queries? Pin
Member 448708324-Jun-14 7:25
MemberMember 448708324-Jun-14 7:25 

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.