Overwriting Entry In Table
Task:
To insert entries into a table. The table has a primary key based on a field 'ID'. When inserting into the destination table, I want to make sure that the new entry will overwrite the old entry.
What's the quickest/cleaniest way to do this ?
thanks,
Clayton
View Complete Forum Thread with Replies
Related Forum Messages:
Copying All Rows From One Table Into Another Existing Table And Overwriting Data
i have 2 tables (both containing the same column names/datatypes), say table1 and table2.. table1 is the most recent, but some rows were deleted on accident.. table2 was a backup that has all the data we need, but some of it is old, so what i want to do is overwrrite the rows in table 2 that also exist in table 1 with the table 1 rows, but the rows in table 2 that do not exist in table one, leave those as is.. both tables have a primary key, user_id. any ideas on how i could do this easily? thanks
View Replies !
Repeating Table Headers Overwriting Data
I'm using RS2000 SP2 and am getting an issue when exporting to PDF. If I have a table that spans more than one page and I set the RepeatHeaderOnNewPage to True, then on occasion the table header will be displayed on top of the first few rows of data. It does not happen on all the pages or all the time and I can not find any information on this issue. Has anyone come across this before and solved it?
View Replies !
How Do I Enter NULL In A Table Cell In The Enterprise Manager UI For Table Data Entry?
I have a column defined as smalldatetime. Default length (4), and "allow NULLS" is checked.In the Enterprise Manager UI, when i enter data into that table row, if i just tab past that column, all is well, and the value is represented in the UI as <NULL>.The problem comes once i ever enter a date into that column. Say i have entered a date (all is well), and now i want to remove that entry and go back to NULL (after the date value has been committed, different entry session, say).How is that done?It seems to me, once a date has ever been entered into that column, now, if i try to remove it, i get the error "The value you entered is not consistant with the data type or length of the column, or over grid buffer limit". I have tried deleting the value, entering spaces, entering the string NULL or the string <NULL>; maybe some other tries as well, but none works, i always get that error message and am not allowed to proceed past that cell until i restore a date value to it. I want to get back to <NULL>.Anybody know?Thank you.Tom
View Replies !
Determining Last Entry ID In Table
Not sure if this is the right place to post this but hopefully someone can help me. I would like to determine what the last automatically incremented ID is in a table I need to return it as a variable to a VB.NET program but I'm not sure what the SELECT statement would look like for this. Any help would be greatly appreciated.
View Replies !
Table Entry Problem
While i execute the below query ,Entry is put in status_report table.But the same if i put in scheduling (Sql Agent) no entry is made in the table and the message success is shown in "Agent Job Activity". Purpose of the sp is to transfer data from One Server to Another Server. But if see in the Destination Tables No entry is made. CREATE procedure RBI_Control_sp as begin set nocount on begin try BEGIN TRANSACTION insert into fin_wh..Status_report ( [object_name], row, st_date ) select 'Data Tranfer', 'Inprogress--', getdate() --Data Transfer From the Live Server [RamcoFin02(scmdb)] to Dw-Server[Ramcovm392(fin_ods)] exec fin_ods..RBI_Data_Transfer_sp --temp table Table population,Fetching data from the fin_ods[erp Table] exec FIN_wh..RBI_SPExecution_sp Update fin_wh..Status_report set row= 'Success', [error_message] = 'No Error', end_date= getdate() where row= 'Inprogress--' COMMIT TRANSACTION end try begin catch ROLLBACK TRANSACTION Update fin_wh..Status_report set row= 'Failure', end_date= getdate(), [error_message]= cast(error_number() as varchar) + '***' + error_message() where row= 'Inprogress--' end catch set nocount off end Txs in advance
View Replies !
How To Prevent Doublicate Entry To A Table
hi, If I have a table which contains customer names. I want to have some kind of process to validate any new insert record into the customer table. so if the inserted new customer already exist in the table I will get a message that say " Sorry , this customer name is already in the system " .... how can I do that, I am using sql server 2000. thanks Ali
View Replies !
Preventing Duplicate Entry For A Given Foreign Key In Db Table
Hi,i am using SQL server 2005 and have a table with 4 columns.Column1 is primary key,col2 is foreign key and col3 and col4 are regular data column.When the user enters the data i want to make sure that for a given foreign key(col2),entries in col3 are not duplicated.Is there a way,i can make sure this at db level,using some kind of constraints or something?Thanks a bunch..
View Replies !
Table With Duplicate Entry With Primary Keys
We have a SQL Server 6.5 table, with composite Primary Key, having the Duplicate Entry for the Key. I wonder how it got entered there? Now when we are trying to import this table to SQL2K, it's failing with Duplicate row error. Any Help?
View Replies !
Overwriting Current Db
I'm new to Sql Server. I am bringing down a db in Enterprise Manger through the DTS-Export Data feature. I bring it down into Access because I know how to work in Access. I make some changes to the db. Then export it back in to Sql Server then up to the the hosted database through DTS. Well instead of overwriting the information it just added to it..So now my database has two of every field. How do I upload a new db and have it overwrite the one that's up there. I thought there was an option to "Drop before creating.." or something like that. I'm in touch with the sysadmin to have him restore...which he has already done. Any help would be appreciated.
View Replies !
Inserts Overwriting
Hi, I have a small web application managing complaints. During multiuser testing we noticed that when complaints where added at "exactly" the same time one complaint text seemed to be over writing the other, and returning the current max value for table id as current complaint number. I tested in my development environment and was able to recreate reasonably easily ( 1 go out of 3 recreated the issue ). The Id column itself is an auto increment ( primary key ), so I can't think of a concievable reason why one record should overwrite another. I should say that I am assuming the record is overwritten, perhaps there is a clash and one complaint is ignored by the database. Have anyone encountered this in the past? Thanks
View Replies !
Overwriting Database
I am very new to SQL, but I am now receiving a updates on a database from an online HD. My idea was that I could download the updated database and paste over the existing database in my SQL folder. For some reason that is not working. How should this database be updated. I would prefer not to have to drop and add everyday. Possibly I could make a database that is not in any folder and then make an update to it from the newly recieved database, but I am not sure how that would be done.
View Replies !
Restoring Database Without Overwriting The Old One.
Hello, I'm trying to create installer that installs database from empty backed up database. The SQL script executed by installer: RESTORE DATABASE [DU] FROM DISK = N'$TARGETDIR$DuTempDU.bak' WITH FILE = 1, MOVE N'DU' TO N'$DATABASE_DIR$DU.mdf', MOVE N'DU_log' TO N'$DATABASE_DIR$DU_log.ldf', NOUNLOAD, STATS = 10 GO There $TARGETDIR$ and $DATABASE_DIR$ are MSI variables set on runtime. The REPLACE flag is not set, but DU database (non empty )still gets overwritten with empty database. Do I need to check manually if database exists before trying to restore it?
View Replies !
Db Backups Appending / Overwriting
When I create a db backup on our network using BACKUP DATABASE... BACKUP DATABASE [TKKCommonData] TO DISK = N'G:SQL_BACKUPSTKKCommonDataTKKCommonData_DATA.bak' WITH NOFORMAT, NOINIT, NAME = N'TKKCommonData_DATA-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 I've specified the NOINIT so that it appends rather than overwrites the database, however the database is still overwritten. Any idea how to get the database to backup and append to the set rather than overwrite the backup ? Programmers HowTo's -- http://jhermiz.googlepages.com
View Replies !
DTS - Source Row File Overwriting When Need Append
The source row file is being overwritten rather than appended to in my data driven query tasks when a data error occurs. I have not changed the default which is supposed to be append. Is this a "feature"? I am using SQL Server 2000 with service pack 1 applied.
View Replies !
Overwriting An Excel File Using SSIS
Hi All, I created a package which runs everydays and dumps the data into an excel file. The problem iam facing is that -today the package runs and fills in the excel file,tomorrow it again runs and fills in the data without deleting the previous records....... But i want it to delete the records already present and fill in the excel only with the new records... Any help is greatly appreciated. Thanks in Advance, SVGP
View Replies !
Overwriting An Existing Database With One That Is Populated With Data
I am tring to figure out how to simplify the process of populating a database created by an application with the same database, only with data already in it. So far i have created a backup of the database and used that backup file with SQL server management express to overwrite the existing database with that backup file on a new computer so the program will have data when initally installed for Demonstration purposes. I was hoping there was an executable script that i could use, so that when someone wants a demonstration of our product, they can see its options and functionallity with data available. Maby i am going about this the wrong way, i need to know if there is a way that when our program is installed an executable can simply be run to populate our database with a backup of our sample database. Any imput would be helpful. Thanks. Isaias
View Replies !
The Index Entry For Row ID Was Not Found In Index ID 3, Of Table 357576312
Hi, I'm running a merge replication on a sql2k machine to 6 sql2k subscribers. Since a few day's only one of the merge agents fail's with the following error: The merge process could not retrieve generation information at the 'Subscriber'. The index entry for row ID was not found in index ID 3, of table 357576312, in database 'PBB006'. All DBCC CHECKDB command's return 0 errors :confused: I'm not sure if the table that's referred to in the message is on the distribution side or the subscribers side? A select * from sysobjects where id=357576312 gives different results on both sides . . Any ideas as to what is causing this error?
View Replies !
Restore Backup To Second System Without Overwriting Local Custom Views?
Is this possible? here is the situation. I have a DB on one system. I back it up and then restore it to a second system. This second system I run reports off of and I want to create custom views that do not exist on the original system. Can I restore the backup DB from the remote system without wiping out the custom views on the local system? I have to do this this way as they won't let us create the views we want on the remote system so the only way we have access to run the reports is by restoring the backup locally. TIA!
View Replies !
Last Entry In A Log
(I don't post here often, so in case I'm violating long-standing taboosof this newsgroup, I apologize in advance for calling a relation atable, using nulls, and other ignorant, destructive, and comtemptibleterminology.)I have a table that's keeping a sort of running log of different typesof changes to pieces of data. The table has a foreign key of the databeing changed, the foreign key for the type of change occuring, someinformation about the change in a couple more columns, and a timestampfor each entry. So it's:dataIDeventIDeventInfotimestampWhat I'd like to do, if at all possible, is a single SQL query that,given a dataID, returns the most recent eventInfo and timestamp foreach eventID. Is this possible?Many thanks.-Eric
View Replies !
Could Not Add The Entry...
Can someone please help me solve the following error? I am not sure of the version my hosting company is using and where to get the manual. Could not add the entry because: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-id, title, entry, date_entered) VALUES ('testing', 'testing', . The query was INSERT INTO blog_entries (blog-id, title, entry, date_entered) VALUES ('testing', 'testing', 'testing'. PHP Code: if ($dbh = mysql_connect ('localhost', 'blu6592_money', 'rich')) { print '<p>Successfully connected to MySQL.</p>'; if (mysql_select_db ('blu6592_myblog')) { print '<p>The database has been selected.</p>'; } else { die ('<p>Could not select the database because: <b>' . mysql_error() . '</b></p>'); } $query = "INSERT INTO blog_entries (blog-id, title, entry, date_entered) VALUES (0, '{$_POST['title']}', '{$_POST['title']}', '{$_POST['entry']}', NOW())"; if (mysql_query ($query)) { print '<p>The blog entry has been added.</p>'; } else { print "<p>Could not add the entry because: <b>" . mysql_error() . "</b>. The query was $query.</p>"; } } else { die ('<p>Could not connect to MySQL because: <b>' . mysql_error() . '</b></p>'); } mysql_close(); Thanks in advance.
View Replies !
Data Entry
We are into BPO and Software development business for past six and half years. We are looking for the following any kind of business from your end. Back Office Process Data Entry, Large Volume Data Processing, Data Conversion, Forms Processing, Process flow & Quality Data Entry Text, Numeric or Alphanumeric entry, Printed or Handwritten matter, Hardcopies or Scanned Images, Some typical examples include, Mortgage Documents, Abstract records, Index cards, Market Research Tabulations, Various different forms, Guest/Customer comment cards, Property tax records, Accounting and Book keeping, Extracting data from Catalog, Payroll Services, Dictionaries, Manuals, Encyclopedia etc,Surveys,Questionnaires,Company reports, Material Safety Data Sheets (MSDS) forms, Airway Bill entries Large Volume Data Processing Formatting of Data like mailing list, Database creation and updation,Data Conversion,OCR Clean up, ICR, OMR,Scanning from hardcopies, microfilms, microfiche,Indexing,Archiving,PDF conversion: PDF to text, HTML etc,HTML conversion, XML tagging, Document conversion Forms Processing Credit Card Processing, Insurance Claims Processing, Market Research forms entry, Survey Forms Processing, Order Processing Financial Services Accounts Payable Management, Accounts Receivable Management, Account Setup, Account Reconciliation, Bank Reconciliation, Bookkeeping, Financial Statements Financial/Operational Budget, Payroll Services, Prepare and File Tax Returns, US GAAP Reporting Drafts Contact COMPUTER CONSULTANCY SERVICES INC, URL: www.ccsgroupindia.com Email: jobs@ccsgroupindia.com, (24 x 7 online support) Chat MSN : rajamanickam73@hotmail.com Chat Yahoo: rajamanickam73@yahoomail.com Tel: +91 44 42037794, 42037795
View Replies !
Error Log Entry
I keep getting this message in my error logs. I can't find any references to it in Books online. Does anybody know what this error is? "dbswritecheck: Read of first trailer failed"
View Replies !
Duplicate Entry
Hi All, I have a table with name C1_Subscribers with three fields (1)-MobileNumber [varchar] (2)-ReceivedTime [datetime] (3)-Status [char]. Now here how to remove duplicate entry of same mobile number to MobileNumber field? Regards Shaji
View Replies !
Anyone Know What Causes This Error Log Entry?
"High priority system task thread: Operating system error Exception 0xAE encountered." we are seeing this on one of our development servers, running SQL 2005 Enterprise SP1. The symptom is that after the sql service has been running a while (order of days), this error starts getting written to the sql server log file over and over, and eventually the logfile fills the drive. Apparently it's fixed by this hotfix, but our ops team doesn't want to install this - they'd rather just cycle the service and delete the log when it happens. I was wondering if anyone else has seen it might know the root cause so we might be able to workaround it without cycling the service. I know, lame question. The correct answer is "install the hotfix" or "install sp2" but our ops team won't do that for now... www.elsasoft.org
View Replies !
Automatic Field Entry
Hi,I'm creating a database using SQL Server 2005 Express Edition (Comes with Visual Web Developer). The table which I am creating has the following Fields - all don't allow nulls:IDUserIdDateDescription(UserId is a foreign key to asp_net_Users as I am supporting user accounts)Basically what I need to do is create a page where I as an Administrator can log onto and enter just the text for the field Description. Then once I upload this I wish all users to visit the site and view this Description on a page however with it also listing the Administrator who wrote it along with the Date. I wish both of these fields to be added automatically (UserId to display the User Name and the Date to display the date and time with which the Description was added - However these need to be editable by the Administrator if he/she wishes to change them).Can anyone point me in the right direction on the steps needed to create this scenario?Thanks for any helpDaniel
View Replies !
DateTime From Database Entry
Hi, I know this is probably very simple but I am pretty new to this and have tried looking but cant seem to get the search criteria right. I have a database with a storeDate field which is of shortdatetime type. I am connecting to the database (MSSQL) via a stored procedure and returning all the records. I then use the code foreach (DataRow dr in ds.Tables[0].Rows) { DateTime dtTo = DateTime.Now; DateTime dtFrom = DateTime.Parse(dr["storeDate"].ToString()); TimeSpan diff = dtTo.Subtract(dtFrom); } I am basically trying to find out the age of the database entry by subtracting it from the current DateTime so i can delete records over a certain age. The problem (at least one of them!) is retrieving the "storeDate" object from the database and storing it in the dtFrom object. I have tried just assigning it directly as dtFrom = dr["storeDate"] and various other methods but I just don't know enough to assign it! Can anyone help me with this or spot any other mistakes in this process of removing old files automatically. Greatly Appreciated,Sean.
View Replies !
Verifying Entry Is Not In DB B4 Inserting
How do i do that... in sch lab, the lecturer said: Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Try SqlDataSource2.SelectParameters("Title").DefaultValue = txtProductTitle.Text GridView1.DataBind() If GridView1.Rows.Count > 0 Then //if no repeated Label1.Text = "Existing Record Found. Please enter another Software." Else 'SqlDataSource1.Insert() 'Label1.Text = txtProductTitle.Text & " successfully added to the database." End If Catch ex As Exception Label1.ForeColor = Drawing.Color.Red Label1.Text = "An error occured!" & ControlChars.NewLine & ControlChars.NewLine & _ ex.Message.ToString() End Try End Sub but its not working for me... the GridView1.Rows.Count is always 0, if there is a repeat, it should be > 0
View Replies !
Selecting First Entry In Results By Name
Hello, I have a table of names/dates as such: Class 1 1/1/2007Class 1 1/3/2007Class 1 1/5/2007Class 2 2/1/2007Class 2 2/3/2007Class 3 3/1/2007 What I want to do is select only the nearest entry from the list for each distinct class, so the results are like this: Class 1 1/1/2007Class 2 2/1/2007Class 3 3/1/2007 So basically, I want the first upcoming class in the list for each distinct class name. How do I do this? I'm using SQL 2005 Express. Thanks.
View Replies !
Identical Database Entry Already?
Here's some code that says it should identify if a user already exists in my database. I have changed the code to match my database, but it seems to have somewhat the opposite affect, rejecting all names (even new ones) or accepting all names (including existing ones). The switch in situations occurs in the "if" statement towardsd the end, when I change the sign of objDR.RecordsAffected. Do you have any idea what could be wrong? Thanks. Function DoesUserExist(ByVal userName As String) As Boolean Dim connectionString As String = "server='(local)Netsdk'; trusted_connection=true; Database='AuthorizedUsers'" Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionString) Dim queryString As String = "SELECT [Users].[UserName] FROM [Users] WHERE ([Users].[UserName] = @UserName)" Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection) Dim Cmd as New SQLCommand(queryString, sqlConnection) With Cmd.Parameters .Add(New SQLParameter("@username", username)) End With sqlConnection.Open Dim blHasRows As Boolean Dim objDR As System.Data.SqlClient.SqlDataReader = Cmd.ExecuteReader(system.data.CommandBehavior.CloseConnection) if objDR.RecordsAffected > 0 then blHasRows="True" else blHasRows="False" End If Return blHasRows End Function
View Replies !
Could Not Find The Index Entry For RID...
Greetings. Today I was testing the sql backup/restore functions on ourprimary server. I was able to backup my database without any problemsbut when I tried to restore it, I received an error "Could not find theindex entry for RID '3610200101a03cc4b49d8bbc84bac50cbe042cecf76' inindex page (1:40), index ID 0, database 'walkthrough'." Thinking thatdata had been corrupted somehow I tried another database and received asimilar error for that database. In the past, our service provider hasattempted to restore data to this server and the restore failed do toanother data corruption. The problem is, I can't find out where thecorruption is located or how to fix it.When I open the restored database in enterprise manager, it returns theabove error and is unable to get a listing of my tables. In queryanalyzer I am able to view my data but receive the index error when Iattempt to look at the information_schema data. When I try to run a DBCCCHECKDB on the corrupted database it reports 0 errors and 0inconsistencies.So my diagnosis of the problem is that something is corrupting my systemtables and that problem shows up whenever I try to restore data from abackup. There could be a hardware failure but I believe the failurewould affect more then just the sql system tables. Can anyone offer anyadvice on how to find the corruption?Thank you in advanceRichard Bailey*** Sent via Developersdex http://www.developersdex.com ***
View Replies !
Query Every Entry Not In Each Hour
Hello,I have been having a tough time writing the follow requirement for aquery.On a table that the primary key is a tagId and an hourly timestamp, Iwould like to find out for every hour which tags did not get enteredinto the database. Essentially I am looking for patterns of entriesthat are not making it into tableB.Examples of the tables:TableA TableBTagID and TagName TagId TimestampPK PK1 PK2approx 6000 rows approx 6000 rows per hourI am thinking that I will need to do something like:Select tableB1.time, count(*) from tableB1 group by tableB1.timehaving tableB1.time >= XXXX and tableB1.time <= XXXX and tableB1.tagIdnot in (select tagId from tableA where not exists (selecttableA.tagId, distinct.tableB2.time from tableB2)I have been trying to create an effecient query handle this but havenot had any luck. Any assistance would be more then appreciated.Thanks,Andy
View Replies !
Number Of Entry Query.
MSSQL2K SP4 Howdy all. Im trying to write a query that will track a data modification grouped by employer ID and transaction date. I don't know if Im asking it right so here is what I have, plus my current and desired outputs. --drop table #foo create table #foo (empID int, transDate datetime, transType varchar(10)) insert into #foo values(1, '01/01/06 01:01:01','Insert') insert into #foo values(1, '01/01/06 01:01:02','Update') insert into #foo values(1, '01/01/06 01:01:03','Delete') insert into #foo values(2, '01/01/06 01:01:01','Insert') insert into #foo values(2, '01/01/06 01:01:02','Update') select f.empID, Change = (select count(transDate) from #foo f2 where f2.empID = f.empID group by empID), f.transDate, f.transType from #foo f Current results: 132006-01-01 01:01:01.000Insert 132006-01-01 01:01:02.000Update 132006-01-01 01:01:03.000Delete 222006-01-01 01:01:01.000Insert 222006-01-01 01:01:02.000Update Desired results: 112006-01-01 01:01:01.000Insert 122006-01-01 01:01:02.000Update 132006-01-01 01:01:03.000Delete 212006-01-01 01:01:01.000Insert 222006-01-01 01:01:02.000Update TIA, CFR
View Replies !
System DSN Entry Does Not Show Up
I am installing a product that sets up a System DSN entry for an added database. The problem is that it does not show up in the ODBC - System DSN group as it should. If I try to add it manually, the system tells me that it already exists. I try to overwrite it, which seems to work, but the entry still does not show up. Is there a place I can "clear" out the entry from beside that panel in the odbc administrator? If I try to user the application to access the data, it does not find it under the local system. If I plug in the server ID from the server manager, I do see the data source and can log onto the system. So, the connection is there, but ODBC Data Source Admin does not see it and the application does not see the server as Local. Any suggestions?
View Replies !
&<Long Text&> Entry
Hi all, Newbie here, just wanted to get that out of the way first and foremost. Im trying to set up a DB in SQL 2000 that allows me to enter lots of text into a column. I read one site where it said to use the NTText datatype with a length of 16. I did that, but everytime I enter alot of text into that column I get <Long Text> and I dont know how to output that or even read it. Do any of you guys know how to either: 1. get the text out of the <long text> or 2. a better way to store that much data. Thank you in advance!!! REZ
View Replies !
Could Not Locate Entry In Sysdatabases
Hey there, could someone please help me!! I had created a database in sql server but since then installed windows xp pro and now when i go through the microsoft sql server dsn configuration the database is not valid and therefore i cannot change the default database as it says it doesn't exist. So then when i type in command prompt use 'db' it says it doesn't exist but when i try to create 'db' it says that the database already exists. I get the error message, could not locate entry in sysdatabases for 'cti' (database name). When i look in mysql - data - along with master etc there is my cti.mdf and log files?? I'm stuck??? Is it that the files just aren't registering through sql server??? Please help!
View Replies !
MULTIPLE ENTRY FORMS
I WOULD LIKE TO MAKE A MULTIPLE ENTRY FORM IN ACCESS, I HAVE BEEN TOLD THIS IS NOT POSSIBLE. I NEED TO BE BE ABLE TO ENTER A SSN AND EDIT A FIELD IN A TABLE, BUT I NEED TO HAVE IT PROMPT EVERYTIME FOR THE SSN. KELLY HOBBS
View Replies !
Select Last Entry Per Category?
Hello, I am trying to select the last entry (by date) for each category in a table. For example, if my table had the following fields; id, category, product, datePosted,.... ...how would I select the last product for each category posted by date? Any guidance is appreciated. Thanks, AC Probably a simple solution, but can't find it my brain right now!
View Replies !
NULL Entry In Lookup
Hi, In my Integration Scenario I have a source field 'CompanyTypeCode' which is nullable in 'tblCompany' and There is a specific lookup Table 'tblCompanyType' to map the codes with descriptions for this field. When I want to transform this table, The NULL Entries fail in Lookup and I ran into problem. Please suggest a clean solution for bypassing the lookup when the entry in source is NULL. (If I bypass the lookup, the flow changes since there is not an extra column from the lookup component any more, therefore I must have another OLEDB Destination if the code is NULL). Regards, Sassan
View Replies !
Null Entry In The Database
I am using a script component to retrieve some values from a server. This script component using Script task which uses VB.NET code. I have tested the VB.NET code and it returns a non null value for a string field 'sentence'. The 'sentence' feild is then passed on to an OLE DB Command transformation to be stored into the database along with a couple of other feilds. The OLE DB Command transformation uses a stored procedure to store these feilds into the database. But when I check my table in the database, all other feilds are stored properly other than the 'sentence' feild which is null. I am wondering what could be causingthis problem. Thanks
View Replies !
Parameter Entry On A Report
I'm trying to graduate from Access to SQL and am finding that Access is still meeting my needs better than SQL. So, I figure I'm doing something wrong. In Access, I have queries that contain parameters. So far, I've gotten SQL to accept parameters, using =@prompt. But, this seems to be a limited parameter capability. Number one, I can't use a phrase for a prompt. Number 2, I can't do something like Access' Between [upper] And [lower]; I've not found away to use parameters as bounds in SQL. Any help?
View Replies !
Deleting An Entry During Run-time
I am trying to delet a row duing run-time but everytime i go to save the program I get an error message saying: "Update Requires a valid DeleteCommand when passed DataRow collection with deleted row. Anyone any ideas?
View Replies !
|
TRACKER
