|
Considering ds as the dataset which contain all the three tables
ds.Tables["dataTable"].Constraints.Add("datpk", ds.Tables["dataTable"].Columns["id"], true);<br />
ds.Tables["authorTable"].Constraints.Add("authpk", ds.Tables["authorTable"].Columns["authorid"], true);<br />
<br />
<br />
ds.Tables["relationTable"].Constraints.Add("rtfk", ds.Tables["dataTable"].Columns["id"], ds.Tables["relationTable"].Columns["id"]);<br />
<br />
ds.Tables["relationTable"].Constraints.Add("rtfk2", ds.Tables["authorTable"].Columns["authorid"], ds.Tables["relationTable"].Columns["authorid"]);
Hope this helps!!!
Sathy
|
|
|
|
|
YES THIS helps !
Thanks!
Regards,
Pavas
|
|
|
|
|
its a pleasure
Sathy
|
|
|
|
|
Hi All,
Here's the Query from SQL 2000:
Select * from table1 <br />
Where Convert(DateTime,dtStTime,103) > = '17/01/2008'<br />
And Convert(DateTime,dtStTime,103) <= '19/01/2008'
????I want to have same kind of functionality query for Informix between ranges............
Please help as im new to Informix and im in midway of my project...
Bala
|
|
|
|
|
Hi,
Please try the following query:
SELECT * from Table1
WHERE DATE(dtstTime) > = '17/01/2008'
And DATE(dtstTime)<= '19/01/2008'
For more information on Informix SQL please visit the following web links:
http://www.dbcenter.cise.ufl.edu/triggerman/infoshelf/sqlt/02.toc.html#540217
http://www.dbcenter.cise.ufl.edu/triggerman/infoshelf/sqlt/02.fm2.html#104594
I hope this helps.
Regards,
John Adams
ComponentOne LLC
|
|
|
|
|
Hi Bala
I haven't used Informix for a long time, but you should be able to use:
Select * from table1 <br />
Where dtStTime between '17/01/2008' and '19/01/2008'
Informix uses environmental variables to determine the date format. From memory, DBDATE should be set to "DMY4/" for your example.
Regards
Andy
|
|
|
|
|
How to get the column name/Field name from a particular Table.
I want to list them in dropdownlist in C#
|
|
|
|
|
Ever heard of Google[^]?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
You need to provide more detail. What kind of database are you using?
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
I am using SQL Server 2000.
|
|
|
|
|
I think you can get table characteristics by looking in the system tables. Don't quite have the info right infront of me at the moment.
---modified
Never mind, imsathy got it
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
SELECT <br />
TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH<br />
FROM INFORMATION_SCHEMA.COLUMNS<br />
WHERE TABLE_NAME = 'your table name'
Sathy
|
|
|
|
|
|
Its a pleasure
Sathy
|
|
|
|
|
Hi All,
We have a PDF document about 2MB.It has many web links.
We are trying to get this document into a database format with search & reporting capabilities and we want to preserve all links and text formats in the document.
We have a couple of questions:
- What database technology could we use that could run on both a CD and a web site?
- What conversion tools (and processes) would be best to use to import the content into a database?
-Can SQL Server 2000 Reporting Services help us? If so,how?
Any help/suggestions will be appreciated.Thanks.
|
|
|
|
|
Good luck is all I can pretty much say right now
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
Makhangs32f wrote:
We have a PDF document about 2MB.It has many web links.
2MB isn't very big. I think it would be easier to migrate the content by hand rather that trying to do it programmatically.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi Paul,
Thanks for your reply.
To migrate the content,here is our initial plan:
-Convert PDF into a word or text file.
-Use SQL loader to transfer the content to the database.
We appreciate your comments on this plan.Also please feel free to suggest any other way to migrate the content to a database.
|
|
|
|
|
Makhangs32f wrote: Also please feel free to suggest any other way to migrate the content to a database.
Not knowing anything about the structure of your data, I can't really help.
The content of a PDF file is likely to be unstructured. This means it would be difficult to write scripts to load data into a structured repository like a database. Your best bet is to cut and paste the content into Excel or a text file and load the data from there.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi Paul,
Thanks for your suggestions regarding loading the PDF into a database.
We have one more thing where we need your suggestion.
We need to publish the database in some format (e.g., XML, MySQL, etc.) to a CD-ROM or DVD.Please let us know if you know some way to do it.Or if you can post a couple of URLs that we can look at to get some ideas on it,that will be helpful too.
Thanks.
|
|
|
|
|
If you are using SQL Server 2005, you should consider using SQL Server Integration Services (SSIS) to produce your exports. This site[^] has plenty of useful information. I suggest you search it for information on exporting data to specific formats. Deciding what format to export your data depends largely on the requirements of the people who will be consuming the data. Have you discussed this with your users, and what have they told you?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hello,
I have datatable and it is populated with some values.
Is it possible to add a column in an exiting datatable now with a auto increment values?
I am trying like this but it does'nt wotk
dslistItems1.Tables[0].Columns.Add("ID", Type.GetType("System.Int32"));
DataColumn[] pk = new DataColumn[1];
pk[0] = dslistItems1.Tables[0].Columns["ID"];
//dslistItems1.Tables[0].PrimaryKey = pk;
dslistItems1.Tables[0].Columns["ID"].AutoIncrement = true;
dslistItems1.Tables[0].Columns["ID"].AutoIncrementSeed = 1;
dslistItems1.Tables[0].Columns["ID"].ReadOnly = true;
This code doesn't populate the values in the column
Regards,
Pavas
|
|
|
|
|
mpavas wrote: Is it possible to add a column in an exiting datatable now with a auto increment values?
It is possible to add a column in an existing datatable with data's in it .. but u CAN'T set it to autoincrement
Sathy
|
|
|
|
|
|
Hii all,
I want to know how to insert multiple rows into a single column with one single statement. I want structure something like this.
JobNumber Supply Parts
J001 Tyres
Bonnets
Engine
J002 Mirrors
Seat Cover
Is it possible in Sql Server 2005 or My Sql. I want to insert values where column JobNumber will have only one value and Supply Parts for that particular job number say J001 will have different values like above in SupplyParts column.
Any help will be greatly appreciated
Thanks
Imran
|
|
|
|