| |
|
|
rquindt | Hello i want at Befüllen of/ one Firebird 3.0 data base ca. 40 Values transfer. try these as an array To transfer failure: SQLSTR$ = "INSERT INTO KUNDEN" + " (KdName,KdVorname,KdStrasse,KdPLZ,KdOrt) \ VALUES (:Transfer$[1], :Transfer$[2], :Transfer$[3], :Transfer$[4], :Transfer$[5])"
in the momentum help I me so: SQLSTR$ = "INSERT INTO KUNDEN" + " (KdName,KdVorname,KdStrasse,KdPLZ,KdOrt) \ VALUES (:Transfer2$, :Transfer3$, :Transfer4$, :Transfer5$, :Transfer6$)"
I had already attempts, The Values by Mid$(Transfer$,x,y) from the ursprünglichen String To transfer. has neither functions
gives it a alternative? |
|
|
| |
|
|
|
H.Brill | Nimm times the others Variante without Postfix :
but not the Postfix comes end one Semikolon.
otherwise would the one wish on Roland, The Arrays yet with moreover To take. too The aray-function
could it respect. |
|
|
| Benutze XPROFAN X3 + FREEPROFAN Wir sind die XProfaner. Sie werden von uns assimiliert. Widerstand ist zwecklos! Wir werden alle ihre Funktionen und Algorithmen den unseren hinzufügen.
Was die Borg können, können wir schon lange. | 12/22/16 ▲ |
|
|
|
|
Michael W. | it ought to really both functions, if one The Variable with a Semikolon abschließt, means H.Brill's Variant for both variables-types. thereafter the comma not forget, there the entire part :...; supplant becomes.
Yes and improve goes always. I need too a very large amount on Datenfeldern. presently write I the in a *.SQL-File and import. an interne Solution would but rather. |
|
|
| |
|
|
|
H.Brill | what I yet know wished : comes because a Error Message at testing with Arrays ?
comes Yes on it on, How Roland the implementiert has and at all Arrays vorgesehen has. might Yes his, that the Parser the Arrayelement :Transfer$[1] as simple Variable reads. there there nothing drinsteht, becomes it evtl. as Leerstring treats.
circa the thing on the reason to go, would I time testweise any undeklarierten variables take and look, what happens.
Übrigens begins one aray ex the place [0]. If you your aray ex [0] befüllt have (evtl. by a Move-function), writes the SQL-commands anyhow The incorrect values into boxes. Z.B. whom KdVorname in that area KdName.
one can it naturally too so leave, must but the size (if one fixes aray) 1 higher make and too at Befüllen desselben the first element [0] ignore. disadvantage is, that one The XProfanfunktionen, The one aray autom. befüllen not benefit can. |
|
|
| Benutze XPROFAN X3 + FREEPROFAN Wir sind die XProfaner. Sie werden von uns assimiliert. Widerstand ist zwecklos! Wir werden alle ihre Funktionen und Algorithmen den unseren hinzufügen.
Was die Borg können, können wir schon lange. | 12/23/16 ▲ |
|
|
|
|
RGH | cut a long story short: there are here only simple variables allows, means no Arrays!
standing too so in the Help SQLEXEC: "Arrays and expressions are not allows."
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 | 12/23/16 ▲ |
|
|
|
|
rquindt | Hello H.Brill
Vielen Thanks for hint with the Version without Postfix. so functions it with eindimensionalen Array´s correct. Mehrdimensionale have I do not tested.
with of my ursprünglichen Variante coming The Error Message: Variable not declariert : Transfer$ db("fbSQLExec",hdb&,SQLSTR$,1) |
|
|
| |
|
|
|
H.Brill | the wundert me now nevertheless, especially since loudly Rolands testimony only simple variables allows are.
Well, if it functions, so much the better.
PS: Müßtest You time in your others Posting over Bytevariablen + Firebird time try, whether there too Memoryvariablen in the SQL-Statement . Go |
|
|
| Benutze XPROFAN X3 + FREEPROFAN Wir sind die XProfaner. Sie werden von uns assimiliert. Widerstand ist zwecklos! Wir werden alle ihre Funktionen und Algorithmen den unseren hinzufügen.
Was die Borg können, können wir schon lange. | 12/23/16 ▲ |
|
|
|