>Hi there,
>
>in myprogram I build this query:
>
>
>select kartei.* , RECNO() as satznr, kunden.vorname, kunden.name1, kunden.name2,
> kunden.name3, kunden.strasse, kunden.plz, kunden.ort from kartei inner join kunden
>on kartei.kundennr == kunden.kundennr where kartei.vormerker = .T.
>and (kartei.nummer == this.cIsbn) and not DELETED() into cursor myvormerker
>READWRITE order by best_dat DESC
>
>
>by assigning it to a var like
>
>cSelect = "Select...."
>
>And run it
>
>&cSelect
>
>Unfortunately this works only if I have more than one record fulfilling the conditions.
> If there is only one record matching it, _tally returns 0
>If I run the query in the command window, it works.
>Hay anybody some help für me?
In the past I've run into weird issues using DELETED() in SQL queries.
Instead, can you try removing that function from your query, and issuing SET DELETED ON before you run it?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up