| Author |
Find Works in Design Time - Bombs in a Executable File!
|
|
| Manish Sawjiani 2005-04-20, 4:01 am |
| Hello Experts
I am using VB 6.0 - SQL Server 7.0 - and the following command
rs.MoveFirst
rs.Find "Code like 'E*'
if rs.eof or rs.bof then
msgbox "Sorry Not Found
Else
fillfields
End if
THIS WORKS FINE in design time but from an executable i get a runtime error
'Eof or Bof' if it is not found
PLEASE HELP
Manish Sawjiani
--
Three Cheers to technet for the Help!
| |
| argusy 2005-04-20, 4:01 pm |
| Try
if rs.eof and rs.bof then ' at both ends of query - no data
Argusy
Manish Sawjiani wrote:
> Hello Experts
> I am using VB 6.0 - SQL Server 7.0 - and the following command
> rs.MoveFirst
> rs.Find "Code like 'E*'
> if rs.eof or rs.bof then
> msgbox "Sorry Not Found
> Else
> fillfields
> End if
> THIS WORKS FINE in design time but from an executable i get a runtime error
> 'Eof or Bof' if it is not found
> PLEASE HELP
> Manish Sawjiani
| |
| Manish Sawjiani 2005-04-21, 4:01 pm |
|
"Manish Sawjiani" wrote:
> Hello Experts
> I am using VB 6.0 - SQL Server 7.0 - and the following command
> rs.MoveFirst
> rs.Find "Code like 'E*'
> if rs.eof or rs.bof then
> msgbox "Sorry Not Found
> Else
> fillfields
> End if
> THIS WORKS FINE in design time but from an executable i get a runtime error
> 'Eof or Bof' if it is not found
> PLEASE HELP
> Manish Sawjiani
> --
> Three Cheers to technet for the Help!
| |
| Manish Sawjiani 2005-04-21, 4:01 pm |
| It Bombs at rs.find itself!!!
"argusy" wrote:
> Try
> if rs.eof and rs.bof then ' at both ends of query - no data
> Argusy
>
>
>
> Manish Sawjiani wrote:
>
>
|
|
|
|