Database Discussion Boards

Re: Database Schema to represent directory structure

Mycroft Holmes20-Jan-10 18:36

20-Jan-10 18:36

Along with the filestream storage you can use the hierarchicyid you define your tree structure but you are going to have a coordination problem between the physical structure and the hierarchy in the table.

The filestream will not allow you to move the files via explorer so that would be one benefit.

Never underestimate the power of human stupidity
RAH

Oracle Boolean in a datatable with c#

camau20-Jan-10 5:54

camau

20-Jan-10 5:54

Hallo,

Did anyone solve the problem with a Boolean Column in a datatable for .net / c#?
I am new in Oracle development and want to convert my database to oracle. But there is no Boolean datatype with SQL and I want to display a gatagridview column as a checkbox. With Postgres or MSSQL there were no problems with that. But with Oracle I search a elegant solution.

Any ideas?

Thank you.

camau

Re: Oracle Boolean in a datatable with c#

Jörgen Andersson20-Jan-10 11:12

Jörgen Andersson

20-Jan-10 11:12

Boolean datatype is not defined by ANSI.
So either you'll have to use a number or a char, for example: flag char(1) check (flag in ( 'Y', 'N' ))

Oracle Installation Setting

svs_shyam_2720-Jan-10 4:15

svs_shyam_27

20-Jan-10 4:15

I have installed Oracle 9i I want to install now ( Oracle forms 6i ) ...On inserting the installation CD...the "Oracle installer" screen appears ..then "Oracle installation settings" form appears ..Here we have to specify

Company Name:xyz

Oracle home details

Name: OraHome92

Location: C:\oracle\ora92

Language: English

With theses entries when I click OK button, the following error message with the Title "General Information" appears:

The location specified "C:\oracle\ora92", is already used as an Oracle Home for 'Oracle 82 Beta'. It can not be used as an Oracle home for 'nt'.

The OS am using is Windows XP Professional with
Pentium 4 ...Please help me out...Thanking you in advance.

Re: Oracle Installation Setting

camau20-Jan-10 5:39

camau

20-Jan-10 5:39

Try to rename c:\oracle\ora92

Re: Oracle Installation Setting

Chris Meech20-Jan-10 5:48

Chris Meech

20-Jan-10 5:48

You probably need to check on some registry entries. Search for HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE. There may be an entry about an Oracle Home that is no longer valid and can be deleted.

Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

Re: Oracle Installation Setting

David Skelly20-Jan-10 6:28

David Skelly

20-Jan-10 6:28

If you search the Oracle forums you will find several threads discussing this issue. I haven't read them in detail but from what I can gather, the installer doesn't like installing Forms 6 and Oracle 9.2 to the same home location. There are a number of suggestions to work around it in this thread:

http://forums.oracle.com/forums/thread.jspa?threadID=340452[^]

Criteria for creating a new category table

JHizzle20-Jan-10 2:46

JHizzle

20-Jan-10 2:46

Here's my quandry: I am creating a new table that's holding records of message sent within the system. One of the fields is what type of message is being sent which currently falls into only 3 options.
Currently, it's likely that this is not going to change that much but I'm trying to work out if it's better to create a new table to hold these and thus enforce referential integrity or simply not bother and rely on the enumeration on the code end.
Queries against the data is likely to want grouping by message type but with only 3, it just seems a bit overkill.
Any suggestions?

Re: Criteria for creating a new category table

David Mujica20-Jan-10 3:11

David Mujica

20-Jan-10 3:11

From a purist standpoint, it would be better to create a parent table like:
MessageType
ID int,
Description Varchar

and create a constraint against your Message Table to ensure that only valid message types are created in your table. You won't pay much (if any) performance penalty because your parent table is so small.

That's my vote. Cool | :cool:

Update a column

Hum Dum19-Jan-10 22:11

Hum Dum

19-Jan-10 22:11

I want to update a column of one table A with column of another table B.

for one entry of A, B contains 2 or more entry. Say A is super table of B.

I wrote a query like this

UPDATE SendSet SET oDate = (Select oOrder.oDate from oOrder where oOrder.oID=SendSet.oID)
WHERE Exists (Select oOrder.oDate from oOrder where oOrder.oID=SendSet.oID);

DB is MS-Access.
But it gives error :
Operation must use an updatable query !!
You attempted to run a query that tried to update a field that cannot be updated. For example, you may have created the query in such a way that you tried to update a field on the one side of a one-to-many relationship.

any help ?

Re: Update a column

loyal ginger20-Jan-10 2:03

loyal ginger

20-Jan-10 2:03

You can use a join in your update query. Please check out how to do a join.

Re: Update a column

loyal ginger20-Jan-10 4:11

loyal ginger

20-Jan-10 4:11

Without knowing the relationship between table A and table B, I can only suggest that you use something like this:

update SendSet inner join oOrder on SendSet.oID=oOrder.oID set SendSet.oDate=oOrder.oDate;

You need to work out what exactly you need to do this update.

Happy programming!

Re: Update a column

Hum Dum22-Jan-10 17:47

Hum Dum

22-Jan-10 17:47

Thanks.

it works.

regards Smile | :)

Join query

pkj19-Jan-10 17:22

pkj

19-Jan-10 17:22

I have one table "Farmer" in which i store farmer name,village id,gut id
and when display this information in grid,i want display farmer name,village name (this name is retrieve from village table in which[village ID,Village name],but some farmer have no village id ,but i want show information in grid his name and after vilage name is blank,which query i use?

Re: Join query

dan!sh 19-Jan-10 18:51

dan!sh

19-Jan-10 18:51

What have you tried so far?

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Re: Join query

Pranay Rana19-Jan-10 19:41

Pranay Rana

19-Jan-10 19:41

i think for this try left outer join so that it get all the farmer even the village is not present for that

Installing a database using MSVS 2010

JaeBeam19-Jan-10 11:34

JaeBeam

19-Jan-10 11:34

I have downloaded the beta 2 of MS visual Studio 2010.

I'm not very familiar with database projects. I've walked thru the MSVS2008 example for deploying a database to a server. This method entails building directly to a server you have access too.

I'd like to know if there is a user friendly way to script out and install a database using MSVS2010 for a server you know nothing about at the time; ie you are developing a solution that needs to be installed at a client's network?

Re: Installing a database using MSVS 2010

Bassam Saoud20-Jan-10 8:37

Bassam Saoud

20-Jan-10 8:37

I am not sure if this changed with 2010, but this article[^] could be useful to you

SQL Query : Multiple joins [modified]

DotNetXenon19-Jan-10 11:11

DotNetXenon

19-Jan-10 11:11

I have 3 tables and need to update the TableC from TableA and TableB
TableA
OldId NewId

TableB
OldId OldName OldAddress

TableC
NewId NewName NewAddress

Please help me with the joins.

Thanks

------------------------------------------------------------
"The only true wisdom is in knowing you know nothing." --Socrates

modified on Tuesday, January 19, 2010 5:30 PM

Re: SQL Query : Multiple joins

SeMartens19-Jan-10 20:18

SeMartens

19-Jan-10 20:18

Hi

to get the values for TableC you can use this query:

SELECT TableA.NewId, TableB.OldName, TableB.OldAddress FROM TableA INNER JOIN TableB ON TableA.OldId = TableB.OldId;

If you want to insert the data from this query into tableC it must be something like this (not really sure):

INSERT INTO TableC VALUES (SELECT TableA.NewId, TableB.OldName, TableB.OldAddress FROM TableA INNER JOIN TableB ON TableA.OldId = TableB.OldId);

Hope this helps...

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

T-SQL: How to force rows insertion ignoring transactions?

Yuval Naveh19-Jan-10 8:36

Yuval Naveh

19-Jan-10 8:36

Hi,

I have a logger written in T-SQL (Stored Procs) writing to a log table.
When there are exceptions a log row is written, but then when the outer transaction rolls back it also rolls back the log entry.
I would like to have the log entry (i.e. row) to be inserted and persisted regardless of what the outer (nested) transactions are doing. The log entry should never roll back

Could someone point me to a solution using T-SQL?

Thanks
Yuval

"The true sign of intelligence is not knowledge but imagination." - Albert Einstein

Re: T-SQL: How to force rows insertion ignoring transactions? [modified]

Eddy Vluggen19-Jan-10 10:20

Eddy Vluggen

19-Jan-10 10:20

Yuval Naveh wrote:
I would like to have the log entry (i.e. row) to be inserted and persisted regardless of what the outer (nested) transactions are doing. The log entry should never roll back

Could someone point me to a solution using T-SQL?

You could use a raiserror[^] to write your message to the sys.messages view. You'd have to predefine the errormessages using sp_addmessage though.

Alternatively, if it's from a stored procedure then you might choose to add them to a variable, as opposed to logging them immediately. Next, RETURN that variable when exiting the sproc, and ~~write~~ insert it's contents to the ~~logfile~~ loggingtable.

If you have the option to drop the TSQL-requirement, then go for extended procedures, like xp_cmdshell (executing isql.exe to execute an SQL statement).

I hope someone else comes up with something better Smile | :)

I are Troll Suspicious | :suss:

modified on Tuesday, January 19, 2010 7:31 PM

Re: T-SQL: How to force rows insertion ignoring transactions?

Yuval Naveh20-Jan-10 2:58

Yuval Naveh

20-Jan-10 2:58

Hi Eddy,
Using the xp_cmdshell to come back and insert rows is a possibility - looks a bit cumbersome though.
If I can't figure it out a more elegant way this might be a (temporary) solution.
Thanks,
Yuval

"The true sign of intelligence is not knowledge but imagination." - Albert Einstein

Re: T-SQL: How to force rows insertion ignoring transactions?

debrah.h4819-Jan-10 19:00

debrah.h48

19-Jan-10 19:00

Check out quires here.
http://technet.microsoft.com/en-us/library/ms187373.aspx[^]

Re: T-SQL: How to force rows insertion ignoring transactions?

Yuval Naveh20-Jan-10 2:59

Yuval Naveh

20-Jan-10 2:59

Hi,
I could not find a specific hint that solves the problem.
Thanks
Yuval

"The true sign of intelligence is not knowledge but imagination." - Albert Einstein

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