• Registered: 2014-02-17
  • Posts: 365

Topic: Dataset Error Help Me Please

Error message :
no Such Table: testdataset

But Use SQL normal no Error
Help me Please !

Post's attachments

Attachment icon dataset.zip 3.46 kb, 443 downloads since 2016-01-09 

My Visual Database : I Love You
Easy For Beginner Student For Me
  • Registered: 2014-02-14
  • Posts: 10,294

Re: Dataset Error Help Me Please

You use MySQL server, so I don't have access to your database for testing.


Try to connect to database from My Visual Database, thus your database structure will be automatically analyzed and you will get error message if your database structure is broken.
http://myvisualdatabase.com/forum/misc.php?action=pun_attachment&item=1622&download=0

Post's attachments

Attachment icon MySQL.png 86.85 kb, 300 downloads since 2016-01-09 

Dmitry.

3 Reply by prahousefamily (edited by prahousefamily 2016-01-09 12:05:55)

  • Registered: 2014-02-17
  • Posts: 365

Re: Dataset Error Help Me Please

connect to database  : Ok and data display in Tablegrid
But Error


Um...
IF USE SQLITE : OK
But IF USE MySQL : Not OK

Post's attachments

Attachment icon 2016-01-09 001.png 67.32 kb, 283 downloads since 2016-01-09 

My Visual Database : I Love You
Easy For Beginner Student For Me
  • Registered: 2014-02-14
  • Posts: 10,294

Re: Dataset Error Help Me Please

Unfortunately I can't test your project without remote connection to you database.

Dmitry.
  • Registered: 2014-02-17
  • Posts: 365

Re: Dataset Error Help Me Please

Thank You Very Much Dmitry. For Help .

Um...  i m try change script  from    SQLQuery(,) to SQLExecute()
It Ok  Not Error but  very slow  use  time  and long command script more than  SQLQuery(,)

because
SQLQuery(,) use one short time for answer
but SQLExecute() use time equal to  answer * column to display

Thank You Very Much Dmitry.  Again

My Visual Database : I Love You
Easy For Beginner Student For Me