Click here to Skip to main content
15,437,442 members
Home / Discussions / Database
   

Database

 
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 
To add to the other comments, using 'select *' can also cause issues in columns are added or the order rearranged. If your application is expecting data in a particular column, then it may not be there; if your application is not expecting the columns that have been added, why bother spending the effort to retrieve the data and parse out the unwanted column?
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 
QuestionOLEDB for Old school DBASE or Foxpro databases, SUM with 2 decimal places Pin
jkirkerx12-Jun-14 18:30
professionaljkirkerx12-Jun-14 18:30 
AnswerRe: OLEDB for Old school DBASE or Foxpro databases, SUM with 2 decimal places Pin
Eddy Vluggen13-Jun-14 7:51
professionalEddy Vluggen13-Jun-14 7:51 
General[SOLVED] Pin
jkirkerx13-Jun-14 8:55
professionaljkirkerx13-Jun-14 8:55 
QuestionXQuery and Namespace Pin
kjfoley111-Jun-14 7:51
Memberkjfoley111-Jun-14 7:51 
AnswerRe: XQuery and Namespace Pin
Eddy Vluggen11-Jun-14 9:36
professionalEddy Vluggen11-Jun-14 9:36 
AnswerRe: XQuery and Namespace Pin
kjfoley111-Jun-14 10:12
Memberkjfoley111-Jun-14 10:12 
GeneralRe: XQuery and Namespace Pin
Mycroft Holmes11-Jun-14 13:03
professionalMycroft Holmes11-Jun-14 13:03 
QuestionIs there any one know what is the problem with my installing?I know nothing about PHP? Pin
basicshoes10-Jun-14 21:36
Memberbasicshoes10-Jun-14 21:36 

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.