Error msg: Select keyword not found

Error msg: Select keyword not found

Postby profixio » Tue 12 Dec 2017 09:05

Hi!
This is a printscreen from an error which we cant get rid of:
http://sharing.profixio.com/uploads/devenv_2017-12-12_09-59-50.png

The table certainly has "id" as a column.

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


Return to dotConnect for MySQL