Error msg: Select keyword not found

Error msg: Select keyword not found

Postby profixio » Tue 12 Dec 2017 09:05

This is a printscreen from an error which we cant get rid of:

The table certainly has "id" as a column.

Posts: 3
Joined: Wed 10 Dec 2014 10:04

Re: Error msg: Select keyword not found

Postby Shalex » Thu 14 Dec 2017 20:47

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;

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?
Devart Team
Posts: 7884
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for MySQL