English
Forum

SQL Firebird Values by aray transfer

 

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?
 
12/21/16  
 




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
aray(String "a", "b")

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.
 
Alle Sprachen
System: Windows 8/10, XProfan X4
Programmieren, das spannendste Detektivspiel der Welt.
12/23/16  
 




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)
 
12/23/16  
 




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  
 



Answer


Topictitle, max. 100 characters.
 

Systemprofile:

no Systemprofil laid out. [anlegen]

XProfan:

 Posting  Font  Smilies  ▼ 

Please register circa a Posting To verfassen.
 

Topic-Options

8.766 Views

Untitledvor 0 min.
rquindt01/04/21
iF10/31/20
p.specht01/31/19
maroro08/09/18
More...

Themeninformationen



Admins  |  AGB  |  Applications  |  Authors  |  Chat  |  Privacy Policy  |  Download  |  Entrance  |  Help  |  Merchantportal  |  Imprint  |  Mart  |  Interfaces  |  SDK  |  Services  |  Games  |  Search  |  Support

One proposition all XProfan, The there's!


My XProfan
Private Messages
Own Storage Forum
Topics-Remember-List
Own Posts
Own Topics
Clipboard
Log off
 Deutsch English Français Español Italia
Translations

Privacy Policy


we use Cookies only as Session-Cookies because of the technical necessity and with us there no Cookies of Drittanbietern.

If you here on our Website click or navigate, stimmst You ours registration of Information in our Cookies on XProfan.Net To.

further Information To our Cookies and moreover, How You The control above keep, find You in ours nachfolgenden Datenschutzerklärung.


all rightDatenschutzerklärung
i want none Cookie