General information
Category:
Coding, syntax & commands
Title:
INSERT INTO cannot be parameterized?
This works (in VFP):
lnID = 5
SELECT * FROM mytable WHERE TableID=?lnID
But this doesn't work:
lnID = 5
lcName = "Name"
INSERT INTO MyTable ( TableID, Name ) VALUES ( ?lnID, ?lcName )
Is this true?
Why is this? Should INSERT and DELETE be able to be parameterized just like SELECT????
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