Click here to Skip to main content
15,903,033 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
AnswerRe: text file spliting Pin
PIEBALDconsult1-Oct-09 15:08
mvePIEBALDconsult1-Oct-09 15:08 
GeneralRe: text file spliting Pin
digitaldxb1-Oct-09 21:14
digitaldxb1-Oct-09 21:14 
GeneralRe: text file spliting Pin
PIEBALDconsult2-Oct-09 3:49
mvePIEBALDconsult2-Oct-09 3:49 
GeneralRe: text file spliting Pin
digitaldxb2-Oct-09 6:48
digitaldxb2-Oct-09 6:48 
GeneralRe: text file spliting Pin
shree08813-Oct-09 18:14
shree08813-Oct-09 18:14 
GeneralRe: text file spliting Pin
shree08813-Oct-09 18:14
shree08813-Oct-09 18:14 
QuestionHow to write and read HttpWebRequestStream asynchronously Pin
vsaratkar1-Oct-09 9:28
vsaratkar1-Oct-09 9:28 
QuestionHow to Edit crystal report SQL Query shown in 'Show SQL Query' Pin
she-Developer30-Sep-09 23:34
she-Developer30-Sep-09 23:34 
Hi there, I just need to edit the query below, i'm aware that the best place to edit the where clause is on the Select Expert, however that wont work for me.
I just need to remove the * on the where clause below

SELECT
    InvoicesCreditsOrders.TypeOfReport, InvoicesCreditsOrders.Isbn,  InvoicesCreditsOrders.CustNo, InvoicesCreditsOrders.CustRef, InvoicesCreditsOrders.OrderDate, InvoicesCreditsOrders.InvDate,
CustMaster.Custno, CustMaster.Custname, InvDelAddr.DelivCustname
FROM
    CATAPULT.dbo.InvoicesCreditsOrders InvoicesCreditsOrders,
    CATAPULT.dbo.ItemMaster ItemMaster,
    CATAPULT.dbo.CustMaster CustMaster,
    CATAPULT.dbo.InvDelAddr InvDelAddr
WHERE
    InvoicesCreditsOrders.Isbn *= ItemMaster.Isbn AND
    InvoicesCreditsOrders.CustNo *= CustMaster.Custno AND
    InvoicesCreditsOrders.ProcessNo *= InvDelAddr.ProcessNo AND
    InvoicesCreditsOrders.DeliveryNo *= InvDelAddr.DeliveryNo AND
    ItemMaster.Filename = 'SA' AND
    InvoicesCreditsOrders.TypeOfReport = 'INVORD' AND
    (ItemMaster.StockReport = 'RSL' OR
    ItemMaster.StockReport = 'PST' OR
    ItemMaster.StockReport = 'O/P' OR
    ItemMaster.StockReport = 'NRR') AND
    CustMaster.Company = '03'
ORDER BY
    CustMaster.Custno ASC,
    InvoicesCreditsOrders.CustRef ASC,
    InvoicesCreditsOrders.Isbn ASC


Please assist.
QuestionIndex was outside the bounds of the array while performing Stack.Pop operation Pin
Furqan Safdar30-Sep-09 1:21
Furqan Safdar30-Sep-09 1:21 
AnswerRe: Index was outside the bounds of the array while performing Stack.Pop operation Pin
Henry Minute30-Sep-09 2:23
Henry Minute30-Sep-09 2:23 
GeneralRe: Index was outside the bounds of the array while performing Stack.Pop operation Pin
burito12330-Sep-09 5:48
burito12330-Sep-09 5:48 
GeneralRe: Index was outside the bounds of the array while performing Stack.Pop operation Pin
Dave Kreskowiak30-Sep-09 7:26
mveDave Kreskowiak30-Sep-09 7:26 
Generalfail. Pin
leckey30-Sep-09 16:17
leckey30-Sep-09 16:17 
QuestionTwo people working on one project at the same time Pin
113st4life29-Sep-09 20:14
113st4life29-Sep-09 20:14 
AnswerRe: Two people working on one project at the same time Pin
freakyit29-Sep-09 21:22
freakyit29-Sep-09 21:22 
AnswerRe: Two people working on one project at the same time Pin
Richard MacCutchan30-Sep-09 1:42
mveRichard MacCutchan30-Sep-09 1:42 
AnswerRe: Two people working on one project at the same time Pin
PIEBALDconsult1-Oct-09 15:10
mvePIEBALDconsult1-Oct-09 15:10 
GeneralRe: Two people working on one project at the same time Pin
nowrocktheworld1-Oct-09 18:40
nowrocktheworld1-Oct-09 18:40 
GeneralRe: Two people working on one project at the same time Pin
Richard MacCutchan1-Oct-09 22:59
mveRichard MacCutchan1-Oct-09 22:59 
GeneralRe: Two people working on one project at the same time Pin
PIEBALDconsult2-Oct-09 4:01
mvePIEBALDconsult2-Oct-09 4:01 
QuestionThree dimensional form designing and use it in windows application.How it can be? Pin
nowrocktheworld29-Sep-09 4:42
nowrocktheworld29-Sep-09 4:42 
AnswerRe: Three dimensional form designing and use it in windows application.How it can be? Pin
Richard MacCutchan29-Sep-09 5:40
mveRichard MacCutchan29-Sep-09 5:40 
AnswerRe: Three dimensional form designing and use it in windows application.How it can be? Pin
Dave Kreskowiak29-Sep-09 5:49
mveDave Kreskowiak29-Sep-09 5:49 
GeneralRe: Three dimensional form designing and use it in windows application.How it can be? Pin
Luc Pattyn29-Sep-09 6:17
sitebuilderLuc Pattyn29-Sep-09 6:17 
GeneralRe: Three dimensional form designing and use it in windows application.How it can be? Pin
Dave Kreskowiak29-Sep-09 6:31
mveDave Kreskowiak29-Sep-09 6:31 

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.