So i would like to use the tSqlTemplate componente to delete all entries from a MySql database table. Should be simple enough:
因此,我想使用tSqlTemplate组件来删除MySQL数据库表中的所有条目。应该足够简单:
here is the what the template looks like:
以下是模板的外观:
however i can't do anything with it, since i am unable to select it:
但是,我无法对其执行任何操作,因为我无法选择它:
as you can see, the button "Hinzufügen" (meaning "add") is greyed out, meaning i cant add anything there. Then what is the use of the component?
正如你所看到的,按钮“Hinzufügen”(意思是“添加”)是灰色的,这意味着我不能在那里添加任何东西。那这个组件有什么用?
For unidentified reasons it just started to work. Additionally a ';' was missing.
由于不明原因,它才刚刚开始起作用。此外,还缺少一个‘;’。
更多回答
优秀答案推荐
Why do you want to use tSQLTemplate
?
为什么要使用tSQLTemplate?
It seems like you could just use tDBRow
and execute your deletion query there.
看起来您可以只使用tDBRow并在那里执行删除查询。
For unidentified reasons it just started to work. Additionally a ';' was missing.
由于不明原因,它才刚刚开始起作用。此外,还缺少一个‘;’。
更多回答
Yes, you are absolutly right, tbh I was not aware of this component. But it was for educational purposes.
是的,你是绝对正确的,我没有意识到这一点。但这是出于教育目的。
我是一名优秀的程序员,十分优秀!