Click here to Skip to main content
15,936,119 members
Home / Discussions / Database
   

Database

 
AnswerRe: Selective queries? Pin
jschell13-Jun-14 8:32
jschell13-Jun-14 8:32 
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 
I'm back to the old foxpro databases using OLEDB.

I'm suppose to pull all the items in a Sales Orders, and go back into the history database file, and get the total QYT and AMOUNT purchased in the past as well.

I can do the math, but wow it's slow!, and I have an issue at the end with formatting the number with 2 decimal places for the cents. So I'm not sure if I need to fix it in the database call, or try and fix it when presenting the number in the PDF.

So $85.30 appears as $85.3

In the past I have had trouble, but not for years since.
The other one i.FPRICE works fine, so I'm scratching my head on this one.

Here's what I have
SELECT  
  i.FCUSTNO 
, i.FORDQTY 
, i.FITEMNO 
, i.FDESCRIPT 
, i.FPRICE 
, (SELECT SUM(s.FSHIPQTY) FROM ARTRS01H.dbf s WHERE s.FCUSTNO = i.FCUSTNO AND s.FITEMNO = i.FITEMNO) AS FSHIPQTY 
, (SELECT SUM(s.FAMOUNT) FROM ARTRS01H.dbf s WHERE s.FCUSTNO = i.FCUSTNO AND s.FITEMNO = i.FITEMNO) AS FAMOUNT
 FROM SOTRS01.dbf i
 WHERE i.FSONO=@FSONO

The reader
If Not (reader.IsDBNull(5)) Then sIRi(rC).FATD_SHIPQTY = reader.GetValue(5)
If Not (reader.IsDBNull(6)) Then sIRi(rC).FATD_TOTAL = reader.GetValue(6)

And in ASP.Net to create a PDF of the Order Confirmation
Dim lbl_item_FATD_TOTAL As Label
lbl_item_FATD_TOTAL = New Label("", 373, currentY, 45, 12, Font.Courier, 9, TextAlign.Right)
lbl_item_FATD_TOTAL.Text = String.Format("{0:c}", sSOI(idx).FATD_TOTAL)
currentPage.Elements.Add(lbl_item_FATD_TOTAL)


Any Suggestions would be cool.
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
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 

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.