Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
dean.morrison
in reply to: j.romo

Hi,

 

 I havent done this with ilogic, but i use VBA to do similar..

 

This is the code i usually use to add new rows to the database..

 

rs.CursorType = adOpenDynamic
rs.LockType = adLockOptimistic
rs.Open "Tablename", cn, , , adCmdTable

rs.AddNew

rs!FieldName = DataString

rs.Update
rs.Close

 

I hope that helps you.

 

Dean.