Information générale
Catégorie:
Codage, syntaxe et commandes
Is it possible to create dynamic SQL on the fly and then execute. I suppose it wouldn't need to be SQL but could be any fox code. The true requirement here is that the statement(s) are created and executed dynamically.
What i have is a 2D array which contains some or all field names of a particular table in the first column and the value of that field i want to insert.
laMyArray[1,1] = 'fieldA'
laMyArray[1,2] = 'apples'
laMyArray[1,1] = 'fieldB'
laMyArray[1,1] = 'bananas'
some code ...
would dynamically
INSERT INTO MyTable (fieldA, fieldB) VALUES ('apples', 'bananas')
tia, kim
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement