Snip...
>>-Called the same routine with same values (matching to current record keys)
>>-Indexseek would return .f. causing an insert
>>Cetin
>
>Hi Cetin,
>Thanks, I didn't realize that INDEXSEEK() would return .f. if the table was buffered and the current record was the one you were looking for and it hadn't been TABLEUPDATE()d yet. I did discover that once you move off the record, then INDEXSEEK() finds it, even without TABLEUPDATE(). I liked the idea of not moving the pointer if it was already on the correct record, but now I'll have to rethink it.
>
>BTW, since you appear to be so good at buffers, is there any way I can get a SELECT .... to query buffered data? That's one of my achilles heels to remember that SELECT ... ignores the buffer.
>
>Thanks again.
Bill,
AFAIK no way directly on buffered data. You might either use nonSQL commands or copy to a temp table and SQL from there.
Cetin