Page 1 of 1

Error msg: Select keyword not found

Posted: Tue 12 Dec 2017 09:05
by profixio
Hi!
This is a printscreen from an error which we cant get rid of:
http://sharing.profixio.com/uploads/dev ... -59-50.png

The table certainly has "id" as a column.

/Ole

Re: Error msg: Select keyword not found

Posted: Thu 14 Dec 2017 20:47
by Shalex
We cannot reproduce the issue with the following code:

Code: Select all

    using (var conn = new MySqlConnection()) {
        conn.ConnectionString = "server=db;port=3311;uid=root;pwd=root;database=test;";

        var table = new MySqlDataTable("select deptno from dept", conn);
        table.FetchAll = false;
        table.NonBlocking = true;
        table.StartRecord = 0;
        table.MaxRecords = 10000000;
        table.Open();
    }
1. Make sure that your SelectCommand.CommandText includes SELECT without any non-English letters (retype SELECT).
2. How should we modify this sample to reproduce the issue in our environment?