Problem with SQL in VB6

[mclueless]

i m using vb6 n access. i am not able to use summary function that i have used in SQL query in VB6.

Call Connection
Set rs = New ADODB.Recordset
rs.Open "SELECT max(Inv_No) FROM Invoice_Master", con, 3, 3
txtInvNo.Text = rs!Inv_No

I m getting error 3265.

[mafaisal]

Hello
Try this
Set rs = New ADODB.Recordset
rs.Open "SELECT max(Inv_No) as Inv_No FROM Invoice_Master", con, 3, 3
txtInvNo.Text = rs!Inv_No

set alias name for fields max(Inv_No) default it have no column name

i m using vb6 n access. i am not able to use summary function that i have used in SQL query in VB6.

Call Connection
Set rs = New ADODB.Recordset
rs.Open "SELECT max(Inv_No) FROM Invoice_Master", con, 3, 3
txtInvNo.Text = rs!Inv_No

I m getting error 3265.

[werks]

Where does the error located?


Better Than Yesterday ^^

[mafaisal]

Here
Also
txtInvNo.Text = rs.Fields(0) u get

Faisal

Hello
Try this
Set rs = New ADODB.Recordset
rs.Open "SELECT max(Inv_No) as Inv_No FROM Invoice_Master", con, 3, 3
txtInvNo.Text = rs!Inv_No

set alias name for fields max(Inv_No) default it have no column name

[mclueless]

Thanks a lot....Using alias it worked...