Correct. Really, SQLPrepare is supposed to run a large queries and code. THere is no need to pre-compile such littel query as you shown in your message. This is because compiling time for such query on SQL Server is very short, so there are no big benefit from using SQLPrepare here. SQLPrepare is useful for really large queries.


>Hi Vlad!
>
>>Probably because you use a parameter in the query. Parametrised query could not be prepared at the server side, as far as I know. This is only for static queries.
>
>But... Can you show me one sample Static Query? and, what is the point of it?
>
>... Maybe... I can use in a static form: "List of members currently logged"
>
>In the Form.Init:
>SqlPrepare(x,"Select * From Users Where Login = 'OK'")
>
>and repeat SQLEXec() each 10 seconds... (Timer Object)
>
>[]'s!