Re: Please help :MERGE Statement conflict with the foreign key constraint - Database Discussion Boards

Re: ADO 2.8 working Asynchronously in C++

rana ray14-Feb-12 19:14

14-Feb-12 19:14

Did you try below link as well:

http://social.msdn.microsoft.com/Forums/eu/sqldataaccess/thread/a262abdf-4516-45c6-8065-8203ca29977f[^]

regards,
vatsa
www.objectiveprogramming.com

xBase question

David Crow7-Feb-12 7:29

David Crow

7-Feb-12 7:29

I've been asked to rewrite a 16-bit xBase application (it was last copyrighted in 2003) such that it will run on (at least) Windows 7 32-bit. As I understand it, xBase is more than just a repository for the data; it's also a language of sorts. Is there some sort of silver bullet available that would convert the whole thing to something current, thus requiring no real rewrite?

"One man's wage rise is another man's price increase." - Harold Wilson

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

"Show me a community that obeys the Ten Commandments and I'll show you a less crowded prison system." - Anonymous

Re: xBase question

Peter_in_27807-Feb-12 11:50

Peter_in_2780

7-Feb-12 11:50

I suspect you're up the creek for any UI stuff - it was a quirky 80x25 text-based "forms" front end. If you're only concerned with the backend database, check out Codebase[^]. I've used it to drag an old dBase4 app (kicking and screaming) into Win32 land. No database migration required. Compile their library source with your 32bit weapon of choice and slip it in behind your business/UI layers.

HTH
Peter

Software rusts. Simon Stephenson, ca 1994.

Re: xBase question

David Crow8-Feb-12 3:09

David Crow

8-Feb-12 3:09

Peter_in_2780 wrote:
...it was a quirky 80x25 text-based "forms" front end.

Actually, the screen shots I have show it to have a Windows GUI. Maybe it's not xBase after all.

Re: xBase question

Peter_in_27808-Feb-12 10:05

Peter_in_2780

8-Feb-12 10:05

It probably still is xBase. The dinosaur I slayed was written in dbIII+ in about 1988 and ran on DOS. Some of the later ones probably had a real GUI.

Cheers,
Peter

Software rusts. Simon Stephenson, ca 1994.

Re: xBase question

Mycroft Holmes7-Feb-12 13:24

Mycroft Holmes

7-Feb-12 13:24

AFAIK Peter is right, your UI is up for a rewrite and rightly so. Your database should be converted to something current and I am betting only the table structure will be transportable. You may need to fiddle with the drivers to get a valid connection, we had to use the FoxPro drivers on the last xbase app we moved.

Never underestimate the power of human stupidity
RAH

Please help :MERGE Statement conflict with the foreign key constraint

anushh6-Feb-12 23:46

anushh

6-Feb-12 23:46

The above error occurs, while trying to merge table1 data(from db1 to table1 data of db2. Confused | :confused:

Thanks in Advance.

Re: Please help :MERGE Statement conflict with the foreign key constraint

Wes Aday7-Feb-12 3:26

Wes Aday

7-Feb-12 3:26

Perhaps this discussion will help you, http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/711614c8-e67d-4137-8f46-3187ac0ce363[^]

Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Individuality is fine, as long as we do it together - F. Burns

DataBase - protection / encryption

Alberto Neves6-Feb-12 4:39

Alberto Neves

6-Feb-12 4:39

I have a problem, i need to protect a database(Sql or access), TDE is a good choice but only(Enterprise and Developer Edition), and i use Sql 2008 Express, any suggestions ?

Re: DataBase - protection / encryption

Eddy Vluggen6-Feb-12 5:26

Eddy Vluggen

6-Feb-12 5:26

You could put the database on a virtual drive[^] and crypt that. When moving the database, move the virtual drive.

Bastard Programmer from Hell Suspicious | :suss:

Please help with an UPDATE statement conflicted with the FOREIGN KEY constraint problem

AlexanderBlade5-Feb-12 14:39

AlexanderBlade

5-Feb-12 14:39

Hi can someone help me to solve a foreign key constraint problem? I’m using using Web Developer 2010 Express with mvc3. When my view loads I can create an object by clicking on the Create button but on the edit page, I click on save button and get an error message: That says my UPDATE statement conflicted with the FOREIGN KEY constraint giving the tables relationship and the column.

Here’s what I’ve tried so far: I researched and found that this error is a bug in SQL Server 7.0. but I'm using Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1

I found another tip that suggested that the id field in the main table is perhaps being called before the id fields of the associated table(s) was created. I tried changing the order by seeding all the other tables with data before my main table in my DBInitializer class. I also changed the order in my DBContext class… same error. Finally I decided to change the relationship directly in the database. I removed the relationship and created a new one (had to add fields in the main table to match the number of columns in the associated table). Nothing worked. I then removed the SetInitializer line from my Global.asax and created all tables from scratch directly in the database and as I created them, I found that I had to add data to the associated tables before adding stuff to my main table which seems to support an earlier suggestion but I still got the error message.

I then changed my SetInitializer back to seed the tables still got the same error. I have no problems when I click the “Create” button, only “Save” on the Edit page.

Any help would be greatly appreciated.

Re: Please help with an UPDATE statement conflicted with the FOREIGN KEY constraint problem

Shameel5-Feb-12 19:42

Shameel

5-Feb-12 19:42

To really understand how to solve this problem, you must know what commands are executed against your database. One way to solve this issue is to turn on CASCADE UPDATE in your foreign key definition.

SSMS question

SQL Ed4-Feb-12 6:24

SQL Ed

4-Feb-12 6:24

SQL

I am running a report in SQL SERVER 2008 that I inherited from a past co-worker in another state. The code is accessing two different servers, but SQl Server management studio seems to be only recongzing only one server/database/table at a time. Is it possible to access two servers while running one report in SSMS/ Below is the server names and databases:

ELMO.[HBS Patient Information].dbo.ECS_Plan_Information E (NoLock)
(Getting invalid oblect name when I hover over this)

[167.211.200.214].Billing03990.dbo.pclaim P

Ed English

Re: SSMS question

Eddy Vluggen4-Feb-12 22:52

Eddy Vluggen

4-Feb-12 22:52

You can link[^] servers within SSMS. Once set up, you can query both servers in a single statement, by prefixing the server-name before the database-name.

Bastard Programmer from Hell Suspicious | :suss:

Need help for Customize the except query

ptr_Electron3-Feb-12 1:30

ptr_Electron

3-Feb-12 1:30

I need one column from the table1 which need not be used comparassion but I need the colume (ID colum in this case)to get lised in the query result.

Ex :

SQL

<pre lang="SQL">select ID a,b,c from table1 except select a,b,c from

table2
in the above example ID color of Table1 need not be compared with table to but just required in the query result for each rows.

Thanks in advance

modified 3-Feb-12 7:37am.

Re: Need help for Customize the except query

jschell3-Feb-12 11:02

jschell

3-Feb-12 11:02

I think some of your post was truncated.

As a guess if you are suggesting that you want to return rows from two tables where there is no common columns between them then the answer is simple - use two queries.

Re: Need help for Customize the except query

Mycroft Holmes3-Feb-12 12:00

Mycroft Holmes

3-Feb-12 12:00

If you are looking for records in table 1 where A,B,C records are not in table 2 then the following should help

SQL

Select * from table1 T
where not exists(Select * from Table2 TT where T.A = TT.A and T.B = TT.B and T.C = TT.C)

Never underestimate the power of human stupidity
RAH

Re: Need help for Customize the except query

ptr_Electron3-Feb-12 22:53

ptr_Electron

3-Feb-12 22:53

Gr8 sir .. it worked .. you made my weekend Smile | :)

... I wish you a wonderfull weekend. Smile | :)

Oracle - odd behavior with nested select/join

Paladin20002-Feb-12 9:19

Paladin2000

2-Feb-12 9:19

Here is a strange result that I am getting with Oracle. Unless I wrap the select from TABLE1 as shown (specifying "rownum > 0"), the query never seems to complete. However, when it is included, it only takes a second or two.

It doesn't make any sense to me, because all that it seems to do is force Oracle to evaluate the nested select with the alias "a" before performing the join. I had thought that placing it in parenthesis would do that automatically. Perhaps the Oracle optimizer does something wonky that this compensates for..? Scratching my head here, because all that the "where" condition adds is basically saying "give me any rows that you find".

SQL

select COUNTRY_NAME, count(*) TALLY from
  (
    select * from (
    select IP_SOURCE_NUM from TABLE1 
    where log_date between '01-JAN-2012' and date '01-FEB-2012'
      and IP_SOURCE_NUM > 0
    ) where rownum > 0 
  ) a
  JOIN ip_geo b on b.ip_from = 
  (
    select max(ip_from) as ip_from_match from ip_geo
    where ip_from <= a.IP_SOURCE_NUM
  )
group by COUNTRY_NAME
order by count(*) desc

Re: Oracle - odd behavior with nested select/join

Mycroft Holmes2-Feb-12 13:16

Mycroft Holmes

2-Feb-12 13:16

While passing up the opportunity to make sarcasic remarks about a 'wonky' Oracle you might be better served by asking Tom[^] as it sounds like a rather deep and very specific Oracle issue.

Never underestimate the power of human stupidity
RAH

Re: Oracle - odd behavior with nested select/join

Jörgen Andersson2-Feb-12 21:32

Jörgen Andersson

2-Feb-12 21:32

I think your link is broken.

Light moves faster than sound. That is why some people appear bright, until you hear them speak.
List of common misconceptions

Re: Oracle - odd behavior with nested select/join

Jörgen Andersson2-Feb-12 21:31

Jörgen Andersson

2-Feb-12 21:31

As you already realized yourself, the paranthesis doesn't define in which order the query is executed, only what data the result is built from.
But by specifying Rownum > 0 you're forcing the optimizer to change the order of execution.

But I would use an optimizer hint instead. Like Select /* +materialize */ * from...

Light moves faster than sound. That is why some people appear bright, until you hear them speak.
List of common misconceptions

Re: Oracle - odd behavior with nested select/join

Paladin20003-Feb-12 4:14

Paladin2000

3-Feb-12 4:14

I suspected something like that was happening. I've never used optimizer hints before; I will look into that.

Thanks for the tip. Thumbs Up | :thumbsup:

Insert Statment

Seema Bawa2-Feb-12 9:05

Seema Bawa

2-Feb-12 9:05

What is the wrong in this query

insert into tbTasks_New( AssignedToId)
values('Employee')
where
Owner = 'Seema'

Re: Insert Statment

jschell2-Feb-12 9:13

jschell

2-Feb-12 9:13

1. It isn't a query
2. An insert is an insert - 'where' doesn't apply (not for the form given.)

It is also possible that 'Employee' is not a valid value for 'AssignedToId'

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.