I can't automatic re-built a view

[RedLion]

Hello,

In my program I let the user decide wich information he wants, and with that information I would like to re-built my view for printing raports.

CREATE SQL VIEW vRaport AS &cSql

the second time I run this foxpro asks if you would like to replace the view, but how can I automatic overwrite the previous view?

I can put

DROP VIEW vRaport

before the create statement, but how can I than check if there is already that view otherwise drop and than create or only create?

And sometimes I got the error file in use with create, which file could that be, the tables or the database and a solution for it?


thanx,

Charl [sig][/sig]

 

[jonscott8]

Hi Charl,

SET SAFETY OFF [sig]<p>Jon Hawkins<br><a href=mailto: jonscott8@yahoo.com> jonscott8@yahoo.com</a><br><a href= > </a><br>Focus on the solution....Not the problem.[/sig]

 

[RedLion]

Thanks Jon,

That was the thing I needed. Hours spend on searching for it, I knew it was a simple thing, I was searching for a thing like DBSETPROP.

And you are the amazing men helping me THANX!

Charl [sig][/sig]