Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Wednesday, October 23, 2019 
 
View User Profile  

 User Profile - Samantha Knigge  
Samantha Knigge
All American Publishing, LLC

fiogf49gjkf0d


Log in to send this member a message!
 


 Samantha Knigge's Contributions
Samantha Knigge has contributed 4 comments and 0 articles.
 
Select to view:    
Comment: Re: How to Filter a SalesLogix Crystal Report by ID at Runtime
fiogf49gjkf0d
I'm having the same issue that JJE reported. It works one time when the report is actually printed, but then slx has to closed before the button will work again. Did anybody ever figure out a solution for this?

Author: Samantha Knigge - 9/28/2009

 
Comment: Re: How to Filter a SalesLogix Crystal Report by ID at Runtime
fiogf49gjkf0d
I'm having the same issue that JJE reported. It works one time when the report is actually printed, but then slx has to closed before the button will work again. Did anybody ever figure out a solution for this?

Author: Samantha Knigge - 9/28/2009

 
Comment: Re: Creating SalesLogix Table ID Values - The Definitive Guide
fiogf49gjkf0d
I'm trying to create a new row in the production table (one to many table off of the account table) for every account that has a specific value in userfield9 of the account table. I thought I'd need to use that select statement to get the accountid for each of the 950 accounts that I'd like to create the production table record for. My production table has ProductionID (PK), Accountid, etc. Is there a better way to do this?

Author: Samantha Knigge - 8/13/2009

 
Comment: Re: Creating SalesLogix Table ID Values - The Definitive Guide
fiogf49gjkf0d
This is a great article, but I am struggling with the same issue as John Gundram was . . . The auto increment box is checked, but it's not auto incrementing. I'm trying to insert into a custom table. Is this why?
I'm very new at this, so I'm sure it's something I'm doing, but any help here would be greatly appreciated!

Here's my script:

Dim objDB
Dim strSQL
Dim objRS
Dim AcctID

Set objDB = New SLX_DB

strSQL = "Insert Into PRODUCTION "&_
"(ACCOUNTID, CREATEDATE, CREATEUSER, MODIFYDATE, MODIFYUSER, PROJECT) " &_
"Select Accountid, " &_
"'" & NOW & "', " &_
"'" & Application.BasicFunctions.CurrentUserID & "', " &_
"'" & NOW & "', " &_
"'" & Application.BasicFunctions.CurrentUserID & "', " &_
"'" & pklProdSeason.Text & "' FROM ACCOUNT WHERE USERFIELD9 = 'NEWLINES'"
Set objRS = objDB.GetNewRecordset
objRS.Open strSQL, objDB.Connection

If objRS.State = adStateOpen Then
objRS.Close
End If
Set objRS = nothing
Set objDB = nothing

Author: Samantha Knigge - 8/13/2009

 


 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2019 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 10/23/2019 8:40:21 PM