|
karinb wrote: I am actually copying/pasting text from a document and it includes some html tags. would that cause a problem?
Yes. Some of the characters in the html are probably causing the problem. Try using the query analyzer, or some other tool, to get/set the data. The enterprise manager isn't a very good tool for data manipulation.
Gotta go for the day. Bye.
----------
There go my people. I must find out where they are going so I can lead them.
- Alexander Ledru-Rollin
|
|
|
|
|
I disabled the 'text in row'. I reset my field to 'text', and the length changed to '16'. Now, in the field when i open the table, this <long text=""> is in the box, and i am unable to enter my data into the field.
i am confused, why wouldn't it allow me to declare text and then put all my data in the row? i thought text held over 2bill chars?
karinb
-- modified at 17:45 Monday 17th April, 2006
|
|
|
|
|
In a database management project ,we have used Oracle at back-end and VB.Net at front-end.
In Oracle ,we used object-oriented features and created nested tables.Now we want to accesss those nested tables using ADO.Net .We are in search of answers of following questions:
1.Does Dataset class of ADO.Net support nested tables ?
2.If yes,can XML be used to specify schema of nested dataset ?
3.If not,how to manipulate nested tables of Oracle in ADO.Net?
As a temporary solution , we are retrieving main table and child table in two different tables;but this mechanism of database handling is affecting preformance of project badly.So we are in need of some other efficient solution.We will be thankful for your response if you will be able to help us to get out of the problem .Please reply as early as possible.
kam_ps
|
|
|
|
|
Not having used Oracle for a very long time this concept of nested tables sounds very much like a standard one-to-many relationship with the nested table being at the many end of the join. 1 parent row to many (nested) child rows.
kam_ps wrote: 1.Does Dataset class of ADO.Net support nested tables ?
It depends on what a nested table is. If it can be described as I have done above then yes it can support it.
kam_ps wrote: 3.If not,how to manipulate nested tables of Oracle in ADO.Net?
So long as you can access these "nested" tables through an SQL statement then you can pretty much do anything you like. All ADO.NET does is pass SQL Statements around and receive result sets. The Oracle data provider will handle that for you.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
There is nothing like nested table in ado.net. But, the solution is there where the relational features of dataset comes in picture.
fetch both the tables separately and add a foreign key relation between them. Then using methods like getchildrows, etc, you can get ur prob solved.
Best Regards,
Darpan Gogia
|
|
|
|
|
Darpan Gogia wrote: There is nothing like nested table in ado.net. But, the solution is there where the relational features of dataset comes in picture.
Isn't that what I suggested?
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
I thought to clear his basics that dataset doesnt support nested tables 
So that he is not another babbage.
Best Regards,
Darpan Gogia
|
|
|
|
|
I have a little problem:
I use ado to connect to a mysql database (version 4.0.12) and mysql odbc driver(3.51).
The system works fine but recently i ran into this problem:
I've installed it on a LAN consisting of 5 win98SE stations making one of them the database server.
The program works on two of them quite ok but fails on the other 3. The thing is that the other 3 computers still connect to the db but some of the querys fail.
Actually is not the querys that fail but rather the call to _RecordsetPtr->GetCollect("field")
To be more precise a query like "SELECT id, name, address FROM clients" works.
A query like "SELECT clients.id AS id, clients.name AS name, ocupations.kind AS kind FROM clients AS clients, ocupations AS ocupations WHERE clients.ocupationid = ocupations.id" fails when i do a call to pRecordSet->GetCollect(L"kind") with invalid pointer.
Another thing to remember is that the database server is installed on one of the computers that do not work. The stations on which the program works connect to this computer via LAN
So, what do i do? Where should i search for the bug? I really have no ideea.
I never had this problem on winxp and this program works on several win88se networks
|
|
|
|
|
Nevermind. It worked after installing MDAC 2.8 sp1.
It didn't work with MDAC 2.8 though..wierd since this is a win98se computer and on winxp i didn't upgrade anything
|
|
|
|
|
Hello,
In SQL Server 7.0, I can easily create tables and import data from other sources such as access. Is it possible to do the same with SQL Express Edition?
Thanks in advance,
Rashar
|
|
|
|
|
If you can export to MSAccess you should then be able import the MSAccess tables to SSE
Pictures of the menu available at the drive-thru
|
|
|
|
|
I think I *may* have found a better way. Go to SSMSE and use the wizard to create a new database and make it sql7.0 compatable. You'll find that choice under the select a page window (click the option page).
HTH.
Pictures of the menu available at the drive-thru
|
|
|
|
|
Hey, Thanks for your replies...
So I take it that I will need to install SSMSE? I don't recall seeing that anywhere after I installed studio 2005? If so, I will download it and run the wizard.
Thanks again,
Rashar
|
|
|
|
|
|
Hi
I have a data in sql table as
EventTypeID Content EventID
1 abc 1
2 gdfg 2
3 fdg 4
4 fgh 54
1 er 54
2 dfg 34
3 fgfdg 34
1 eert 45
2 dfg 4
The result i want is, when i fire a select query , the result should be IN THIS FORMAT like this
EventTypeID Content EventID
1 abc 1
2 gdfg 2
3 fdg 4
4 fgh 54
1 er 54
2 dfg 34
3 fgfdg 34
4 NULL NULL
1 eert 45
2 dfg 4
3 NULL NULL
4 NULL NULL
So which query will do this ?
|
|
|
|
|
Looks like you are missing a column. If you are trying to match sets of EventTypeIDs (1,2,3,4) you need to identify the sets some how. I can't see anything in your data that would indicate a relationship between the sets except order (which is unreliable and not guarenteed).
Go back to take a closer look at your design.
|
|
|
|
|
Select EventTypeID ,Content ,EventID from Tablename
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshers
http://himabinduvejella.blogspot.com
|
|
|
|
|
Hi Sandeep,
Your reply is:
Select x.EventTypeId, z.Content, z.EventId from (Select distinct EventTypeId from tbl) x left join tbl z on x.EventTypeId=z.EventTypeId
This way you can get the expected result.
Best Regards,
Darpan Gogia
|
|
|
|
|
We're on the process of shifting from Single to Distributed Database.
We have a program (say Mainprogram) that updates the central database, specifically Table1.
Also, we have many existing little programs (say Subprogram1, Subprogram2, ..etc) that also updates the central database, also the Table1, just like the MainProgram. We need to resolve this in such a way that only one program will update the central database.
It is certain that the Mainprogram will only the one who will update the central database. How will our little programs handle this. These little programs need also to update the Table1 in central database.
Or is this OK? Please help. I dont know anything about DB. Im using Oracle 9+ and VC++ 6.0
|
|
|
|
|
Hi,
I have table like this
Name Age RolNo. Qty
A 1 2 3
B 1 2 3
C 2 4 5
D 2 9 2
E 2 4 1
F 3 3 4
G 4 5 5
H 4 4 4
NOW, I WANT THE FETCH RESULT AS (i,e First row of each group , GroupBy Age)
Name Age RolNo. Qty
A 1 2 3
C 2 4 5
F 3 3 4
G 4 5 5
What query i should write for this. which meets my requirement.
Thanx
sandeep
|
|
|
|
|
SELECT a.Name, a.Age, a.RolNo, a.Qty FROM Table1 AS a, (SELECT MIN(Name) AS MinName FROM Table1 GROUP BY Age) AS b WHERE a.Name=b.MinName
Is that right?
|
|
|
|
|
i face a problem converting varchar to datetime,the date is stored as char(10) and i need to compare it with a time. i use this stored procedure
CREATE PROCEDURE cst
@v datetime AS
select * from col
where CAST ( col AS DATETIME ) < @v
GO
and get this error when run this (exec cst '01/02/2006')
Server: Msg 242, Level 16, State 3, Procedure cst, Line 5
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
|
|
|
|
|
Do you have a table named col in your database that also has a column named col?
What is the datatype of the col column?
----------
There go my people. I must find out where they are going so I can lead them.
- Alexander Ledru-Rollin
|
|
|
|
|
EricDV wrote: Do you have a table named col in your database that also has a column named col?
yes i have.
the datatype of the col is char(10).and all its data like '01/02/2006'
what i want is to select recoreds less than eg. '01/01/2006'
|
|
|
|
|
Check your data in the col column.
You will get that error if there is a record that cannot be converted:
ie.
00/00/0000
01/01/0001
00/01/2000
01/00/2000
The error will not happen if all the data is valid.
----------
There go my people. I must find out where they are going so I can lead them.
- Alexander Ledru-Rollin
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
