Why do you need parameters in this case? Remove "?" and it'll work.
>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????
--sb--