Click here to Skip to main content
15,612,452 members
Home / Discussions / Database
   

Database

 
GeneralRe: Selective queries? Pin
Member 448708313-Jun-14 10:27
Member 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
Tim Carmichael13-Jun-14 13:00 
AnswerRe: Selective queries? Pin
Member 448708316-Jun-14 7:08
Member 448708316-Jun-14 7:08 
AnswerRe: Selective queries? Pin
Member 448708324-Jun-14 7:25
Member 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 
jkirkerx wrote:
Any Suggestions would be cool.
It's an unformatted decimal/double (as should be), until you convert it to a string. Below gives a predictable result:
C#
Console.WriteLine(String.Format("{0:c}", 3.8));
Console.ReadLine();
There could be two things wrong here - either your formatting isn't applied, or it is formatting correctly. If your formatting is applied, then check out the regional settings in the configuration - if your end-user behaves like I do, then there'll be a non-default value.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

General[SOLVED] Pin
jkirkerx13-Jun-14 8:55
professionaljkirkerx13-Jun-14 8:55 
QuestionXQuery and Namespace Pin
kjfoley111-Jun-14 7:51
kjfoley111-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
kjfoley111-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
basicshoes10-Jun-14 21:36 
AnswerRe: Is there any one know what is the problem with my installing?I know nothing about PHP? Pin
Richard MacCutchan10-Jun-14 21:54
mveRichard MacCutchan10-Jun-14 21:54 
GeneralRe: Is there any one know what is the problem with my installing?I know nothing about PHP? Pin
basicshoes10-Jun-14 21:56
basicshoes10-Jun-14 21:56 
QuestionHow to get the Output based on Next Date if exists in the Table Pin
Robymon9-Jun-14 22:28
Robymon9-Jun-14 22:28 
SuggestionRe: How to get the Output based on Next Date if exists in the Table Pin
Richard MacCutchan9-Jun-14 22:47
mveRichard MacCutchan9-Jun-14 22:47 
AnswerRe: How to get the Output based on Next Date if exists in the Table Pin
Mycroft Holmes9-Jun-14 22:51
professionalMycroft Holmes9-Jun-14 22:51 
GeneralRe: How to get the Output based on Next Date if exists in the Table Pin
Robymon9-Jun-14 22:56
Robymon9-Jun-14 22:56 
GeneralRe: How to get the Output based on Next Date if exists in the Table Pin
Mycroft Holmes9-Jun-14 23:01
professionalMycroft Holmes9-Jun-14 23:01 
AnswerRe: How to get the Output based on Next Date if exists in the Table Pin
Tim Carmichael10-Jun-14 2:49
Tim Carmichael10-Jun-14 2:49 
AnswerRe: How to get the Output based on Next Date if exists in the Table Pin
Bernhard Hiller10-Jun-14 20:56
Bernhard Hiller10-Jun-14 20:56 
QuestionManually increment a column value in SQL Server database through query when date < currentdate Pin
hilbiazhar9-Jun-14 20:08
hilbiazhar9-Jun-14 20:08 
AnswerRe: Manually increment a column value in SQL Server database through query when date < currentdate Pin
Chris Quinn9-Jun-14 20:53
Chris Quinn9-Jun-14 20:53 

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.