Error Code 3021:

[amitranjanmishra]

Hi Group, I need an Urgent Help. I have been connecting my application to a remote mysql database(For development it is in lan only). I fail to retrieve data from database I have used this: if rs.eof then rs.movefirst ' have also used rs.movelast else rs.movelast endif but it does not help....... Tell me how to rectify it.... Thanks Amit amit mishra

[Rob Graham]

you also need to check for rs.bof. If the recordset is empty (no rows returned) BOTH eof and bof will be true, and movefirst, movelast, movenext, moveprevious and move(bmk) will all return an error, sice there is no record to move to. Absolute faith corrupts as absolutely as absolute power Eric Hoffer All that is necessary for the triumph of evil is that good men do nothing. Edmund Burke