Re: FN-FORUM: SQL ERROR - HELP REQUIRED PLEASE

date posted 8th January 2004 15:12

Hi,
Doesn't the 'Maximum' in the following statement create a tempory
column?

Pam

cmdFT.CommandText = "SELECT 'Maximum' = MAX(tblOrder.orderBasketID) FROM

----- Original Message -----
From: "Norman Beresford" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Thursday, January 08, 2004 3:41 PM
Subject: RE: FN-FORUM: SQL ERROR - HELP REQUIRED PLEASE


>
> Hi Pam
>
> I'd guess that there isn't a column called Maximum in the return
> datareader.
>
> Norman
>
> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of PAMELA
> WHITTAKER
> Sent: 08 January 2004 15:37
> To: FN-FORUM / [EMAIL REMOVED]
> Subject: FN-FORUM: SQL ERROR - HELP REQUIRED PLEASE
>
>
>
> Hi,
>
> I am getting the following error
>
>
>
> "Exception Details: System.IndexOutOfRangeException: Maximum"
>
> the line I am getting it on is Return drFT("Maximum")
>
> Could some one tell me what I have dobe wrong please
>
>
>
> Thanks
>
> Pam
>
>
>
>
> The .net function is
>
>
>
> Private Function _MaxBasketID() As Integer
>
> Dim connFT As New OleDbConnection(_ConnectionString)
>
> Dim cmdFT As New OleDbCommand
>
> cmdFT.Connection = connFT
>
> cmdFT.CommandType = CommandType.Text
>
> connFT.Open()
>
> cmdFT.CommandText = "SELECT 'Maximum' = MAX(tblOrder.orderBasketID) FROM
> tblOrder;"
>
> Dim drFT As OleDbDataReader
>
> drFT = cmdFT.ExecuteReader
>
> If drFT.Read Then
>
> Return drFT("Maximum")
>
> End If
>
> drFT.Close()
>
> connFT.Close()
>
> End Function
>
>
> --
> ** Get all the Freelance Work you Can Handle *
> The Web Design Business Kit will show you proven tactics
> and strategies for marketing your business, winning bids, managing
> projects and pricing your work. Free Shipping Worldwide. Read more & get
> free chapters at: http://www.sitepoint.com/launch/b7c91e/3/4
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>
> --
> ** Get all the Freelance Work you Can Handle *
> The Web Design Business Kit will show you proven tactics
> and strategies for marketing your business, winning bids,
> managing projects and pricing your work. Free Shipping Worldwide.
> Read more & get free chapters at:
http://www.sitepoint.com/launch/b7c91e/3/4
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>