11/22/2024 8:51:28 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.
|
|
|
|
help needed.prob in inserting recoed in SQL Database through SLX.
Posted: 16 Jan 08 9:56 AM
|
hello friends,
i have problem in inserting recoed in SQL Database through SLX. i want to know my syntax is correct. please help me.
here is my code...
Dim strlstrsql
set rsobjCMC = objSLXDB.GetNewRecordSet
strlstrsql = "Select * from Contact_Newletter where 1=2" 'DNL
rsobjCMC.Open strlstrsql, objSLXDB
with rsobjCMC
.addnew
.Fields("Contact_newletterid").Value=application.BasicFunctions.GetIDFor("Contact_Newletter")
.Fields("CreateUser").Value = Application.BasicFunctions.CurrentUserID
.Fields("CreateDate").Value = now
.Fields("ModifyUser").Value = Application.BasicFunctions.CurrentUserID
.Fields("ModifyDate").Value = now
.Fields("Subscribed").Value = "C"
.Update
End With
|
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|