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

Topic: Found Error in Button SQL ???

I add code in sql button 

DROP TABLE IF EXISTS "a";
CREATE TABLE "a" (
"id"  INTEGER NOT NULL,
PRIMARY KEY ("id"));
SELECT id FROM a ;

but when click show error

Error message:
Cursor not returned from Query

SQLITE ERROR
But Change Mysql Not Error

https://s10.postimg.org/avpwsci2d/2016_10_11_15_57_30.png

Post's attachments

Attachment icon 2016-10-11 15 57 30.png 29.55 kb, 350 downloads since 2016-10-11 

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

Re: Found Error in Button SQL ???

I checked this sql query, but don't get any error messages. Can you attach your project? And which version you use?


Also you can't use two or more SQL queries for one button.
You should use script:

SQLExecute('DROP TABLE IF EXISTS "a";');
SQLExecute('CREATE TABLE "a" ("id"  INTEGER NOT NULL, PRIMARY KEY ("id"));');
Dmitry.

3 Reply by prahousefamily (edited by prahousefamily 2016-10-11 14:09:30)

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

Re: Found Error in Button SQL ???

i try test by change database engine

  • SQLITE ERROR

  • MySQL Fine Not ERROR

How To Fix ??? Or Create Function ,Procedure  in SQLITE
Or Prepare Before Query ???


SQLExecute('DROP TABLE IF EXISTS "a";');
SQLExecute('CREATE TABLE "a" ("id"  INTEGER NOT NULL, PRIMARY KEY ("id"));');

It good way for fix
but if have script edit pascal+sql(Long Statement)
it hard and easy error..

i want to put sql Statement in MVD SQL BUTTON it easy and fast ... Thank You Dmitry.

Create By MVD Version 2.7

Post's attachments

Attachment icon morequery.zip 2.48 kb, 360 downloads since 2016-10-11 

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

Re: Found Error in Button SQL ???

prahousefamily
As I said, you can't use two or more SQL queries for one button. The button will execute just first SQL statement

DROP TABLE IF EXISTS "a";

But in the settings of button you have choose component TableGrid1 to display result, but the SQL statement (DROP TABLE IF EXISTS "a";) can't return any result to the TableGrid1. This is cause of the error.

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

Re: Found Error in Button SQL ???

Thank You Dmitry.
I Found answer  Error same you

Drop Table ....

i try change SQL statement by remove "drop" and "create"  and
edit new sql type select(sub select....)    it ok.. not error

Thank You Dmitry. Again

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