MYISAM, MYSQL and (may be) cache problems

[Roberto Amucano]

Hi everybody, I wrote an interface to MYISAM to substitute FAIRCOM CTREE and, in the future, to use MYSQL in my procedures.
The problem is: when I insert using mi_insert() a record in a table and I try to get the new record from the CLI mysql, the select fails to obtain the new inserted record. If I perform a "flush tables;" command, the record magically appears.

If I query the table from another connection (using the same procedures that wrote the record), the record is there;
If I try to insert from SQL a new record, it doesn't feel the previously inserted new record at all and it creates a new one with the same primary key.

It seems a cache problem: may be I should tell MYSQL that something has changed and to refresh its buffers or something like that.

Please, does anybody have a suggestion?

thank you in advance
roberto