I am using Vb6.0 with SQL Server 7.0.
The code is below
If rSetQuery.EOF Then
If rSetQuery.State <> adStateClosed Then rSetQuery.Close
mySql = "Select Top 50 * from FDHS WHERE CustomerName >'" & Trim(tdbtName) & "' Order By Customername,Trxdate"
rSetQuery.Open mySql, Con
When run this query in SQL Server Enterprise manager I can get the top 50 results.
When I run in the vb6.0 I am getting the error
Run-time error '-2147467259 (80004005)':
The fieldname CustomerName is varchar 75. tdbtname is the textbox control in the VB.
Can anyone help me to solve this problem asap.
Thanks & Regards,