What is the code to INSERT a record (SQL) with LotusScript??

[eds27]

I already know how to select records since calls like:
*****
conDBF.Connectto ("dBase IV")
Set qryLogin.Connection = conDBF
qryLogin.SQL = |Select *
FROM "| & strTN1 & |" | & strSN1 & |
WHERE(| & strSN1 & |.Login = '| & Login1 & |')|
With rsLogin
Set .Query = qryLogin
.Execute
If .NumRows > 0 Then
.FirstRow
Profile1 = .GetValue("Profile")
End If
End With
*****
work just fine when the SQL statement is a SELECT.

But when I use an INSERT call it says "could not open table" o something like that...right on the Execute.
what am I doing wrong?
Is there another way to make that call??
do you guys have any example code.??

Thanks in advance.

 

[suesloan]

INSERT is not supported in SQL in Approach.

Sue Sloan
XpertSS.com