OK, hair pulling here ...
I'm just trying to insert a record into a database and when I do it, I get so many different errors. The main one was the problem with the locking. Here's the code I have.
Set adoCon = Server.CreateObject("ADODB.Connection"
adoCon.ConnectionString = "Driver=Microsoft Visual FoxPro Driver;"_
&"SourceType=DBF;SourceDB=C:\Inetpub\& "NULL=No;BackgroundFetch=No;"
adoCon.Open
SQLQuery="Select * from C:\Inetpub\Set RS=Server.CreateObject("ADODB.Recordset"
RS.Open SQLQuery, , adOpenKeySet, adLockOptimistic
RS.AddNew
RS.Fields("cnumber" = request.form("txtrepnum"
RS.Fields("sname" = request.form("txtlast"
RS.Fields("sfname" = request.form("txtfirst"
RS.Fields("webpass" = pv
RS.Update
I'm sure this is all mixed up because I've changed bits and pieces, so I've confused myself even more. There's also some other things I don't understand like what is adOpenKeySet and adLockOptimistic.
Anyway, hopefully this makes sense, any insight would be great.
Thanks in advance.
I'm just trying to insert a record into a database and when I do it, I get so many different errors. The main one was the problem with the locking. Here's the code I have.
Set adoCon = Server.CreateObject("ADODB.Connection"
adoCon.ConnectionString = "Driver=Microsoft Visual FoxPro Driver;"_
&"SourceType=DBF;SourceDB=C:\Inetpub\& "NULL=No;BackgroundFetch=No;"
adoCon.Open
SQLQuery="Select * from C:\Inetpub\Set RS=Server.CreateObject("ADODB.Recordset"
RS.Open SQLQuery, , adOpenKeySet, adLockOptimistic
RS.AddNew
RS.Fields("cnumber" = request.form("txtrepnum"
RS.Fields("sname" = request.form("txtlast"
RS.Fields("sfname" = request.form("txtfirst"
RS.Fields("webpass" = pv
RS.Update
I'm sure this is all mixed up because I've changed bits and pieces, so I've confused myself even more. There's also some other things I don't understand like what is adOpenKeySet and adLockOptimistic.
Anyway, hopefully this makes sense, any insight would be great.
Thanks in advance.