No announcements
Found 2429178 threads
-
2 VotesHelp with record source statement
record sets and doesn't work for others. If I remove it, it still seems to work fine. Will do more testing This project has to do with ...Answered | 5 Replies | 126 Views | Created by tkosel - Wednesday, January 3, 2018 5:37 PM | Last reply by .theDBguy - Wednesday, January 3, 2018 7:09 PM
-
0 Votes
binding source primary key
hi i have two binding sources on a form i have navigated one binding source with other with this statement ...Answered | 1 Replies | 3650 Views | Created by fazee - Wednesday, October 10, 2007 11:03 AM | Last reply by Vilsad - MCTS - Thursday, October 11, 2007 7:34 AM -
0 Votes
Informix to SQL Server - EIX000: (-107) ISAM error: record is locked.
, using OLE DB drivers. Quite often, the load fails with "An OLE DB record is available. Source: "Ifxoledbc" Hresult: 0x80004005 Description: ...Answered | 3 Replies | 6698 Views | Created by madion - Wednesday, December 7, 2011 7:34 PM | Last reply by ArthurZ - Thursday, December 8, 2011 7:21 PM -
0 Votes
Foreign Key issue
; Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E2F Description: "The INSERT statement conflicted with the FOREIGN ...Answered | 2 Replies | 2490 Views | Created by bgeregach - Wednesday, April 10, 2013 7:05 PM | Last reply by bgeregach - Wednesday, April 10, 2013 7:49 PM -
0 Votes
How do I move a selected record to the top of a form in Datasheet view after returning from another form?
selected Job Number to the top of the datasheet, followed by jobs that are listed after. The Datasheet form Record Source property is a sql ...Answered | 1 Replies | 726 Views | Created by smsemail - Wednesday, March 20, 2013 7:18 PM | Last reply by QA Guy CommElec - Wednesday, March 20, 2013 8:40 PM -
0 Votes
Modify query in Mail Merge in a Word document
, you can include the SELECT statement when you hook up to the data source. For any more detailed support, I recommend the newsgroup, as it's been quite a while ...Answered | 1 Replies | 2753 Views | Created by Brad SDS - Thursday, August 6, 2009 8:41 PM | Last reply by Cindy Meister MVP - Friday, August 7, 2009 4:28 PM -
0 Votes
UPDATE Statement with a JOIN Condition
the first record of the temp table and does not update the quantity of the second record from tne source table. I woould appreciate any help on ...Answered | 3 Replies | 21163 Views | Created by Jothivel - Friday, June 30, 2006 8:29 PM | Last reply by Umachandar Jayachandran - MS - Friday, June 30, 2006 8:57 PM -
0 Votes
Populating OLEDB connectionstring with variable value
: 0x80040E14 Description: "Statement(s) could not be prepared.". An OLE DB record is available. Source: "Microsoft OLE DB ...Answered | 1 Replies | 2306 Views | Created by youranonymous2727 - Friday, August 3, 2012 2:24 PM | Last reply by youranonymous2727 - Friday, August 3, 2012 3:30 PM -
0 Votes
Custom Conflict Resolver Handling of Upload Insert/Update Failures
caused by a subscriber record being inserted/updated with a foreign key reference to a record that has been deleted at the publisher. For example, my database includes a ...Answered | 1 Replies | 5880 Views | Created by chrishilton - Thursday, October 9, 2008 2:47 PM | Last reply by chrishilton - Wednesday, December 10, 2008 3:33 PM -
0 Votes
Cannot Avoid Duplicate records
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "The statement ...Answered | 2 Replies | 5830 Views | Created by priyapinky - Monday, June 14, 2010 6:26 PM | Last reply by Uri Dimant - Tuesday, June 15, 2010 5:49 AM -
0 Votes
Problem with record source
Instead of setting the record source of the form, you could leave the record source alone, and filter the form. Pseudo code for a command button ...Answered | 1 Replies | 1732 Views | Created by DylanBaxter - Tuesday, November 1, 2011 10:22 PM | Last reply by Hans Vogelaar MVP - Tuesday, November 1, 2011 10:50 PM -
0 Votes
Inconsistent result using Data Reader source to get data from DB2
an infinite loop mode. though my query is not a procedure, it is just a sql statement. But this ssis pkg with the query runs absolutly fine on the other server. I aslo tried ...Answered | 4 Replies | 4285 Views | Created by Jinita Jain - Tuesday, April 22, 2008 3:04 AM | Last reply by Jinita Jain - Thursday, May 1, 2008 1:14 AM -
0 Votes
problem in inserting a record
table with same User ID . i am getting following error The data in row 1 was not committed. Error Source: .Net SqlClient ...Answered | 6 Replies | 3892 Views | Created by onjus - Saturday, July 30, 2011 8:28 AM | Last reply by Erland Sommarskog - Saturday, July 30, 2011 10:07 PM -
1 Votes
Help with Update statement
The final result should be: Need help with the Update statement CREATE ...Answered | 1 Replies | 2043 Views | Created by Meir1 - Thursday, November 3, 2011 9:18 AM | Last reply by Rishabh K - Thursday, November 3, 2011 9:24 AM -
0 Votes
Help with Delete statement
I need to delete some rows from my table for s specific condition. I get the required data for deletion with the following SQL statement. Without writing a cursor, is there a way to ...Answered | 3 Replies | 298 Views | Created by dper77 - Thursday, June 29, 2017 7:24 PM | Last reply by Hilary Cotter - Thursday, June 29, 2017 7:35 PM -
1 Votes
Help with case statement
sure what am I missing . can you please help WITH MEMBER [Measures].test AS CASE ([TIME].[Total ...Answered | 5 Replies | 442 Views | Created by JJ_18 - Monday, July 9, 2018 8:49 PM | Last reply by willson yuan - Tuesday, July 10, 2018 2:44 AM -
0 Votes
Help with Case Statement
My case statement is as follows: CASE WHEN vBillingStatement.dscr = ‘Citizen's High Risk Account Recoupment Fee’ THEN CAST([billed] as money) ELSE 0 ...Answered | 3 Replies | 3437 Views | Created by Chanjo - Tuesday, August 25, 2009 3:26 PM | Last reply by Chanjo - Tuesday, August 25, 2009 3:43 PM -
0 Votes
Help With Switch Statement
Hi I need help with these statement. I get a syntax error (near my case) when trying to execute this SELECT JobID,JobName ...Answered | 5 Replies | 651 Views | Created by Hefff - Monday, January 26, 2015 3:04 PM | Last reply by Jingyang Li - Monday, January 26, 2015 3:29 PM -
1 Votes
Help with Case Statement
instead. Is your IF statement returning multiple values, or just one value? If it is just returning one value (and with a count(*) you normally only return one valuer, unless using ...Answered | 9 Replies | 6979 Views | Created by NoEgo - Thursday, February 2, 2006 9:00 PM | Last reply by NoEgo - Saturday, February 4, 2006 7:20 PM -
0 Votes
Help with record navigation...
. I am able tor retrieve the data fine, but I'm having trouble with the record navigation. I'm tring to use the movefirst/last/previous/next methods of a bindingsource to ...Answered | 1 Replies | 3084 Views | Created by ray.n - Saturday, October 3, 2009 10:06 PM | Last reply by Arjun Paudel - Sunday, October 4, 2009 8:11 AM - Items 1 to 20 of 2429178 Next ›
No announcements
