General information
Category:
Coding, syntax & commands
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only