[solved] USE and SEEK / SEEK () as the target

[zehnernet]

Hi there!

It's very confusing and Lianja is not doing what I expect and understand from the documentation.
The goal is simple: Open the table and search for a data record with LOCATE, SEEK / SEEK().

So roughly:

OPEN DATABASE
USE tabel
LOCATE / SEEK / SEEK()
BROW

As an example here is the Lianja Southwind database.

OPEN DATABASE SOUTHWIND // for all further lines

USE table in 0 ALIAS MyTable -> table is open

LOCATE FOR customerid = "EASTC" -> No error message
BROW -> Shows the first record, not the 19th!

SET ORDER TO customerid -> No error message
SEEK("EASTC", MyTable) -> Error message: "')' was expected"
SEEK("EASTC") -> No error message
BROW -> Shows the first record, not the 19th!

SET ORDER TO customerid -> No error message
seek "EASTC" -> no error message
BROW -> Shows the first record, not the 19th!

I have already tried all types of play with '"' and parameters, etc. NOTHING leads to the goal. I have not written down all attempts here.

BTW: Why does Lianja no longer know my table when I switch to DATA WORKSPACE in between and look at the table there? Must that be possible? Sometimes, when the table is open in the console, Lianja also shows me in Data WORKSPACE: "File 'customers.dbf' does not exist".
What ??? Can I only go back to the table when I close all databases in DATA WORKSPACE ("X" in the toolbar) and open them again?

Sorry, but sometimes I start to wonder if anyone on the data side is working with VFP-script here ... :-(

In any case, I would be grateful for a few hints that go beyond the 3 lines in the documentation and reveal connections between the various commands / functions.
It's no fun like that ...

Thanks a lot in forehand!