Chapter is Invalid

[Tankgirl]

Am getting this error on a client's machine (XP)

When the program does a second filter on a recordset it gives him the above error.

Form1.DataGrid1.Columns("TCode&quot.DataField = "TCode"
Form1.DataGrid1.Columns("TDescription&quot.DataField = "TDesc"
Set Form1.DataGrid1.DataSource = DRS.DataSource

'User enters value to search on i.e. "S"
'Returns 3 records...Smith, Simonds, Sampson
rsDRS.Filter = "TCode LIKE '" & Form1.txtSearch.Text & "%'"
Set Form1.DataGrid1.DataSource = rsDRS.DataSource

This works fine, but if he types in another value to search on i.e. "Si" - "Chapter is invalid" error occurs.

Using MDAC2.7 SP1
All datatypes are strings

On another client's machine who is also running XP all if working perfectly....PLS HELP

 

[lone84]

Hi,

Is the above program done in another client ?
If a particular program work in a client but not on another, the only possibility i could think of is the client that cannot run the program is using a lower version than the client that did the client.

For example comA maybe using SP1 and did this program.
However, client B try accessing this program without SP1.
Therefore, it gives an error

This is only my conjecture.
Good luck