XProfan

« this Posting watts as Solution marked. »

Michael
W.

then schreib' the Token "#TRANSACTION" time big.

Alle Sprachen
System: Windows 8/10, XProfan X4
Programmieren, das spannendste Detektivspiel der Welt.

Georg
Teles

under the point 11.9 or. 11.10 is n% = m (mode)

1 = Integer-type
2 = numerischer type with Nachkommastellen
3 = String-type
4 = BLOB

s. [...]

(the Link becomes httpS transformed, simply with http open)

Regards

XProfan X2
TC-Programming [...]

XProfan 8.0 - 10.0 - X2 - X3 - X4

12/18/20 ▲

RGH

The weight of n% is with db("fbExec", ...) still declared:

n% = mode:

0 : the Result becomes directly in the Mainwindow displayed (sooner for DebuggingZwecke)

1 : the Result becomes it in a Listboxliste written. The first entry is the Headline with the Feldnamen, the second a Trennlinie

2 : the Result becomes it in a File written, its Dateiname with set("SQLFile", name) set becomes. has the Dateiname The Endung".xml" becomes it in the XML-stature written, with the Endung ".json" in the JSON-stature, otherwise as normal Textdatei. with Set("SQLDel" and Set("SQLNull" can the Ausgabeformat tuned go.

-1: the Result becomes it in a Listboxliste written. The mode -1 is identical with the mode 1, supply but in the first Listbox-row not only The names the boxes, separate - separated through one ":" - too whom Feldtyp. Hierbei mean: 1 = Integer-type / 2 = numerischer type with Nachkommastellen / 3 = String-type / 4 = BLOB

>2: deals it itself at last Parameter around the lever of/ one GridBOX, becomes the Result in these written, where The Split and Überschriften the scheduler into GridBOX übernommen go.

Info: The Return the SQL-Befehls becomes properly the mode zurückgeschrieben. this is naturally particularly interestingly with SELECT-command, with others is it sooner irrelevant. The 0 ought to one then not use, there one "Ok" or "n Sätze bearbeitet" well seldom on-screen erwünscht is.

Greeting
Roland

Intel Duo E8400 3,0 GHz / 4 GB RAM / 1000 GB HDD - ATI Radeon HD 4770 512 MB - Windows 7 Home Premium 32Bit - XProfan X4

Martin
Kempf

ok, then skin what not there... I had it vermutet, that it the mode would, though I get a Error Message, if I it so angebe:
"Falscher Parametertyp: 1
row...
db("fbExec", "#transaction", 1)
same Error Message too with mode 0 and 2....

Michael
W.

db("fbExec", "#transaction", 1)

If I me whom commands in this shape anschaue, then question I:

"Für which Datenbankdatei because...." (means missing the lever)

db("fbExec", H, s, n)

H: Integer - lever the data base
s: String - SQL-Statement
n: Integer - mode

still once with the Helpfile abgleichen; happens too me still.
Z.B. is me the in Your first Posting none noticed...

I have incidentally only "fbexec" in that Suchfeld Help registered.
there becomes "db:fbSQLExec" found (one alternativer name for "fbexec").

as "<container>:<name>" registered finds The Search the most Containerfunktionen directly. here becomes the colon in the Search uses.

System: Windows 8/10, XProfan X4
Programmieren, das spannendste Detektivspiel der Welt.

Martin
Kempf

messerscharf determined.
db("fbExec", ep&, "#transaction", 0)
bring me unfortunately still not the erwünschte Result separate as error "Invalid Token"...

XProfan X4

Michael
W.

then schreib' the Token "#TRANSACTION" time big.

Alle Sprachen
System: Windows 8/10, XProfan X4
Programmieren, das spannendste Detektivspiel der Welt.