The results of your search are shown below. To refine your search, revise your keywords, and/or select the appropriate check boxes to the right.
Query Results Not Returned when Name Exceeds Field Length
Symptom
The system returns no results when querying for a value in the Name field that exceeds the field length
Product Line
Profile Report error "Error encountered when opening this report"
Symptom
Profile Report error "Error encountered when opening this report"
![](/sites/kb/files/picture9_1.jpg)
![](/sites/kb/files/picture9_1.jpg)
Product Line
Internal - Custom Fields Tables couldn’t be created successfully
Symptom
After user login “Upgrade error: Custom Fields Tables couldn’t be created successfully” appears.
![](/sites/kb/files/689813_1.png)
Product Line
How to Add or Move Content on a Check Without Forms Designer.
Question:
I do not own forms designer but want to put custom elements on my check or move the alignment of my check. Is this possible?
Solution:
Product Line
SCR-Unable to Transfer Payroll to Accounting – Account Code is Invalid
Symptom
Why am I getting a Payroll transfer error saying a new, valid code is invalid?
Product Line
DF-FR-23528-There are some reports that might not return no data if this Category is changed
Symptom
When attempting to add an Attribute to System Options, an error is returned
![](/sites/kb/files/error.jpg)
Product Line
DF-M17249-Error Code 264 inserting allocation after adding Source (giftsource) field to Allocation Insert screen template
Symptom
After adding the Source (giftsource) field to Allocation Insert screen template, you receive an Error Code 264 - The column name 'giftsource' is specified more than once in the SET clause.
Error Message -- Insert
INSERT INTO gifts_full (giftprocdt, gifteffdat, giftbatch, gifttender, giftsolic, giftcurr, giftanon, giftpotflg, gifthnrmkr, giftchckno, giftsecure, giftsource, gifttype, giftaba, giftdepost, giftrevoke, giftfrnamt, giftbnkact, giftbnkaty, giftacctgp, giftexrate, giftsumkey, giftsec1, giftsec2,giftrest, gift8020, giftamount, giftcamp, giftcampyr, giftclass1, giftclass2, giftcomm, giftsource, giftallkey, giftid) SELECT giftprocdt, gifteffdat, giftbatch, gifttender, giftsolic, giftcurr, giftanon, giftpotflg, gifthnrmkr, giftchckno, giftsecure, giftsource, gifttype, giftaba, giftdepost, giftrevoke, giftfrnamt, giftbnkact, giftbnkaty, giftacctgp, giftexrate, giftsumkey, giftsec1, giftsec2,'sm1', 'N', 60.00, 'c ', '2014', ' ', ' ', '', 'blast ', '2605438644', '0000000264' FROM gifts_full WHERE giftkey = 2605438644
SQL_ERROR
INSERT INTO gifts_full (giftprocdt, gifteffdat, giftbatch, gifttender, giftsolic, giftcurr, giftanon, giftpotflg, gifthnrmkr, giftchckno, giftsecure, giftsource, gifttype, giftaba, giftdepost, giftrevoke, giftfrnamt, giftbnkact, giftbnkaty, giftacctgp, giftexrate, giftsumkey, giftsec1, giftsec2,giftrest, gift8020, giftamount, giftcamp, giftcampyr, giftclass1, giftclass2, giftcomm, giftsource, giftallkey, giftid) SELECT giftprocdt, gifteffdat, giftbatch, gifttender, giftsolic, giftcurr, giftanon, giftpotflg, gifthnrmkr, giftchckno, giftsecure, giftsource, gifttype, giftaba, giftdepost, giftrevoke, giftfrnamt, giftbnkact, giftbnkaty, giftacctgp, giftexrate, giftsumkey, giftsec1, giftsec2,'sm1', 'N', 60.00, 'c ', '2014', ' ', ' ', '', 'blast ', '2605438644', '0000000264' FROM gifts_full WHERE giftkey = 2605438644
SQL_ERROR
[Microsoft][ODBC SQL Server Driver][SQL Server] The column name 'giftsource' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'giftsource' may appear twice in the view definition.
Error Code 264
Product Line
How to setup and use Dots
Dots are an eye-catching and convenient way to temporarily earmark constituent records that share common elements or characteristics. For example, the Red Dot on a Basic card could be used to specify Hot Prospects.
Product Line
Unable to Change Page Orientation Printing to a Local Printer
Symptom
Product Line
Print settings do not save for network printer
Symptom
Changes made to report orientation or other print options are not working on my network printer
Product Line
Custom Signature/Picture Missing
Symptom
Signature/Picture did not print on Custom Format
Error Message: "\\(Custom path) -access denied or file does not exist"
Product Line
Unable to connect to SQL Server
Symptom
Login error received:
“The system is unable to connect to SQL Server. Please contact your System Administration or Customer Support.”
Product Line