I using vfp 7 on the front end and sql 2000 on the back. I have hit a snag now though. I setup a test server like I'm going to be installing a new client. But when my code runs and hits a query where there is no data, it seems to freeze. I end up having to ctrl+Alt+Del and kill the process. Here is one of the queries that it happens to (Actually it is a stored procedure).

CREATE PROCEDURE ct_lu_CardsBySurgeon
@tiSelectedPerID int

as

select carddesc,coSuperID from coSuper where coPerid=@tiSelectedPerID order by carddesc

I manually built a record in the coSuper table and then it works. Has anyone else had this problem and/or know a way to work around it?

Thanks
Kirk