4/27/2024 10:34:24 AM
|
| |
| 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 general external development topic (related or not to SalesLogix development). View the code of conduct for posting guidelines.
|
|
|
|
Using COM to interact with client
Posted: 09 Jan 07 4:55 PM
|
fiogf49gjkf0d I'm using a VB6 application to interact with COM. Until now, I've never had to write any value.
I'm populating a flexgrid with items that are older that 10 days old. I would like to close all the items returned. I'm going to add a "Close" checkbox next to each row. I can step through the checkbox arrays, but I'm unsure of the command/function to write a value.
If modifydate < currentDate - 10 then populate grid. Here's the sql string.
rs.Open SELECT DISTINCT A1.TICKETID, A1.MODIFYDATE, A1.TICKETNUMBER, A1.ASSIGNEDTOID FROM TICKET A1 LEFT OUTER JOIN PICKLIST A2 ON (A1.STATUSCODE=A2.ITEMID) WHERE (UPPER(A1.ASSIGNEDTOID)='TEST0012134') AND (UPPER(A2.TEXT)<>'CLOSED') AND (A1.MODIFYDATE< (CurrentDate - 10) & ")", m_cn, adOpenForwardOnly, adLockReadOnly, adCmdText
Any ideas?
Thanks.
CH |
|
|
| |
|
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!
|
|
|
|
|
|
|
|