SQL Statement in Rev Wipes Out Table

[Adam]

Hi All:

This is driving me 'round the bend.
I'm executing a statement on a MySQL DB:

put revDataFromQuery(,,myDB,"SELECT COUNT(*) FROM myTable") into myCount

And I want to see the result by using:

answer myCount

Well I get zero (0).  The data in the table is gone after I execute that
statement or something like it with revQueryDatabase.  I checked in my Admin
tool, the data is really gone. Thank goodness for backups.

The table is populated with 60 million plus records so it's not empty to
start.  But after executing the statement, bam... gone.

Any ideas?

TVKIA,
Adam