Re: AW: SQL record exists

[Antonio Fernandez-Vicenti <afvaiv@xxxxxxxxxxxxxx>]

Birgitta Hauser escribió:
> To avoid this problem enhance the statement as follows:
>
> Clear IsFound;
> Exec SQL  Select 1 Into :iSFound
>              From MyFile
>              Where .... 
>           Fetch first row only;
Sorry if I'm asking a stupid question, but... are the variables:
- "IsFound" being cleared by "Clear"
- and  "*:*iSFound" (prefixed with "colon :"...) in the Select
referring to the same variable?
Sorry if I'm short in SQL knowledge...