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.
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
Calendar dates display invalid year
Symptom
Calendar dates are displaying an invalid year when a date is chosen from the calendar.
Product Line
Calendar dates display invalid year
Symptom
Calendar dates are displaying an invalid year when a date is chosen from the calendar.
Product Line
Cursor focus remains in Name/Id field in Search using Chrome but not using Internet Explorer
Symptom
Using Internet Explorer 10, when you enter a name in the Name/id field in Search Database, and there is no match on criteria, the cursor focus does not remain in the name/id field. You must mouse back into the field to type in another name.
Using Chrome however, the cursor focus remains in the name/id field for the user to continue typing in another name, without having to mouse in the field.
Using Chrome however, the cursor focus remains in the name/id field for the user to continue typing in another name, without having to mouse in the field.
Product Line
Entry Defaults-How do I change my entry defaults for transaction line entries to be a specific value
DF-M17165-Guests are assigned to seats or tables, but randomly you cannot see the seating assignment or table assignment
Symptom
You can assign guests to seats, but randomly when you Edit Table you do not see anyone assigned to the seat. As well you can assign a guest to a table, but sometimes the table is not found so you can Edit Table, even if you scroll to the right and left to find the table.
Product Line
DF-M17079-Lookup maintenance-Error inserting/updating relation pair with limited Access
Symptom
If you try to limit Millennium User Group Access on a relation pair record, an error occurs on insert or update.
Error Message -- Update
UPDATE relation_pairs SET relp_mgp2 = '67108863.0 ', relp_whose = 'la ', relp_amt2 = 0.00, relp_agp1 = '1'000000, relp_amt1 = 0.00, relp_isa = 'am ', relp_agp2 = '1'000000, relp_comm = '', relp_mgp1 = '67108863.0 ', relp_actv = 'Y' WHERE relp_key = 5046
SQL_ERROR
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '000000'.
Error Code 102
UPDATE relation_pairs SET relp_mgp2 = '67108863.0 ', relp_whose = 'la ', relp_amt2 = 0.00, relp_agp1 = '1'000000, relp_amt1 = 0.00, relp_isa = 'am ', relp_agp2 = '1'000000, relp_comm = '', relp_mgp1 = '67108863.0 ', relp_actv = 'Y' WHERE relp_key = 5046
SQL_ERROR
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '000000'.
Error Code 102
Product Line
DF-M17027-After inserting attribute on a constituent with multiple pages of attributes, the link to options are grayed out.
Symptom
After inserting an attribute on a constituent with multiple pages of attributes, the "link to" options are grayed out.
Product Line
DF-M17099-Change to a constituent checkbox missing in relations for non-constituent records
Symptom
The “change to a constituent” checkbox is missing in non-constituent relationship screen.
Product Line
DF-M16694-ADE responds slowly when selecting an existing mapping plan
Symptom
ADE responds slowly when selecting an existing mapping plan to Edit or Import
Product Line
DF-M16594-Relations: reltype field is not being populated when a relationship is updated
Symptom
Relations: reltype field is not being populated when a relationship is updated
Product Line
DF-M16470-View Generator Error message:"String or binary data would be truncated.--22001"
Symptom
When creating a custom view using view generator customer receives an error message when using a custom where statement:
*GF02==csArg1: insert into viewlist(vlist_code, vlist_name, vlist_tnum) values('gif1001','giftsa0850','05')nMode: 4csArg1: insert into viewlist(vlist_code, vlist_name,
vlist_tnum) values('gif1001','giftsa0850','05') nMode:4[Microsoft][ODBC SQL Server Driver][SQL Server]
vlist_tnum) values('gif1001','giftsa0850','05') nMode:4[Microsoft][ODBC SQL Server Driver][SQL Server]
String or binary data would be truncated.--22001.
Product Line