>Hi,
>How to locate a record from the view,
>I use LOCATE command, but it seem not work.
>Why ?
>On the other hand, how can I create index for the view ?
>
>Please advise.
>
>Derek Yim
Easy:
SELECT YourView
lnOldBuffer = CURSORGETPROP("Buffering", "YourView")
CURSORSETPROP("Buffering", 3, "YourView")
INDEX ON .... TAG YourView
CURSORSETPROP("Buffering", lnOldBuffer, "YourView")But why the LOCAte didn't works? I suppose your condition is not rigth. Can you post the code for LOCATE?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
