11/24/2024 11:21:21 AM
slxdeveloper.com
Now Live!
|
|
| |
|
User Profile -
Samantha Knigge
|
|
|
Samantha Knigge
All American Publishing, LLC
name of abortion pill in u abortion pill kit fjrigjwwe9r1SiteUser:UserBio fiogf49gjkf0d
|
|
| Log in to send this member a
message! |
|
|
| Samantha Knigge's
Contributions |
|
Samantha Knigge
has contributed
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
|
|
|
|
|
|
|
|