TSQLScript (sqlDB)
lazarus / 63-Database

----------------------------------------------------------------------
Mlaue · 2020-08-02 23:06

Wie kann ich programmseitig der Eigenschaft script ein sql-Statement
zuweisen und dies ausführen (TSQL.execute oder ähnlich)

----------------------------------------------------------------------
TRon · 2020-08-02 23:20

https://wiki.freepascal.org/TSQLScript

But... your question seem to suggest you are referring to a sql query,
instead of a sql script ?

Because German is not my native tongue and I do not trust translators
in such matters you are the only one who is able to tell that for
certain

----------------------------------------------------------------------
Mlaue · 2020-08-03 00:52

Ich beziehe mich auf das SQL-Script. Ich möchte das SQL-Script im
Programm generieren.

----------------------------------------------------------------------
TRon · 2020-08-03 01:22

Ok thank you for clarifying Mlaue.

Just an administrative note:

in case you are not able to write in English then it is preferred that
you use a translation service to translate your native language to
English and post both messages.

It is frowned upon to not use English, unless you are writing in one
of the language specific subforums. Unfortunately there isn't a German
subforum here.

Also unfortunate is the fact that the wiki page I referred to is not
available in German.

The actual TSQLScript script seems nothing more than TStrings. And for
that there is a German page: https://wiki.freepascal.org/TStringList-
TStrings_Tutorial/de

so for example (assuming that you placed the sqlscript component on
your form and named it FBScript):
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i   .. 
FBScript.Script.Clear;  FBScript.Script.Add('sql statement 1'); 
FBScript.Script.Add('sql statement 2');  FBScript.Execute;  ... 
Similar as was showed in the wikipage from my first reply that I
linked to (except in the wiki example the statements were loaded into
a stringlist first then copied to the SQLScript strings and the
component was created at runtime).