CANNOT GET ID - SQL NEED HELP

lucas555 said:

Hello all,
I'am having a problem of getting an ID from the data base.
This is my Code

Dim PickingSlipNo

Query = "SELECT MAX([PickingNo]) As PickingNo" & CRLF & _
"Table1" & CRLF & _
"WHERE [dbo].[OE_PICKINGSLIP_Header].[OrderNo] = " & OrderNo

openconn
Conn.ExecuteQuery(Query)
PickingSlipNo = conn.ReadField("PickingNo")

The openconn Is a method that opens the connection to the DB. The connection is function I have tested it out.

In the PickingSlipNo variable it always return #ERROR# for some reason, all I want him to do is to get the ID of a precise OrderNo.

Need Help with it please help.

Click to expand...

Query = "SELECT MAX([PickingNo]) As PickingNo" & CRLF & _
"Table1" & CRLF & _
"WHERE [dbo].[OE_PICKINGSLIP_Header].[OrderNo] = " & OrderNo
openconn
Conn.ExecuteQuery(Query)
Conn.Advance    'Here the lack of a code
PickingSlipNo = conn.ReadField("PickingNo")