I am new to Visual FoxPro and I am trying to write ASP pages that will be the interface to the database. I was wondering what kind of limitations FoxPro has (If any) because I can get information from the database to print out on a ASP page. I can't get forms to add information to the database to work. Every time I use a SQL statment to add something it throws an error. Below is my last attempt to do so>

Set rstDBEdit = Server.CreateObject("ADODB.Recordset")
rstDBEdit.Open strSQL, CONN_STRING, adOpenKeyset, adLockOptimistic, adCmdText

Any help or informtion would be helpful.