|
I have an ms sql database that has foreign key relationships and until today I hadn't mapped those out via sql server, they were just on paper.
So for example, I have a Company with many People.
Before, when I deleted a Company, it's many people were orphaned. Now, since I've mapped the relationship for the sql server, when I try to delete a Company, I get an error. I think in mysql talk this is called a cascading delete.
How do I do this with ms sql?
/\ |_ E X E GG
|
|
|
|
|
Which database product are you using? With most databases you just need to add ON DELETE CASCADE to your foreign-key definition.
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".
|
|
|
|
|
I'm using sql server 2000, but I just found the property for cascading deletes under the relationships menu on my table.
/\ |_ E X E GG
|
|
|
|
|
when i run my application i got error "SQL Error # 55030 Optimistic Conncurrency Error". please provide solution for it
|
|
|
|
|
If your database is SQL-Server then this is probably a user-defined error message that is produced by one of the following:- A stored procedure within your database (look for instances of
RAISERROR). - A trigger within your database (look for
RAISERRROR). - The front-end application that is accessing your database (this depends on which programming language has been used on the front-end - for VB/VbScript look for
Err.Raise).
You will need to investigate your system more deeply to identify where the error comes from.
Regards
Andy
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".
|
|
|
|
|
I've a table with one of columns having an image datatype.
The data in the image column is table data.
Currently, the image data is read/inserted/updated through an application for which there is no source code available and we intend to rewrite this in C#/VB.
I know the structure of the table in image column.
The structure of main table is tb_MyTable(Col1 int, Col2 Varchar(100), col3 image).
The inner table in image column has an int column and 2 varchar columns.
I tried "select * from tb_MyTable" from front end(C#) and i see that the data type of image column is a byte array.
How can i read the table data residing in this image column into a datatable in C#/VB?
OR can it be done in SQL itself?
|
|
|
|
|
The following link[^] demonstrates how to read and write image data from SQL Server in C#.
Paul
|
|
|
|
|
Vadlamudi VenuGopal wrote: The inner table in image column has an int column and 2 varchar columns.
Vadlamudi VenuGopal wrote: How can i read the table data residing in this image column into a datatable in C#/VB?
OR can it be done in SQL itself?
You have to find out what format it is in and decode it. SQL Server does not store "inner tables" in image columns. What ever is in the image column is likely nothing to do with SQL Server. The original application must have put data there in a format it understood.
|
|
|
|
|
Hi friends,
I have a table like this
Id City
-- ----
1 Chennai
2 Vilupuram
3 Trichy
4 Madurai
But i want Output like this
Chennai Vilupuram Trichy Madurai
Simply i want to display a column horizandally in a row. Is it possible? Help me.
Thanks
--Jegastar
|
|
|
|
|
jegastar wrote: Simply i want to display a column horizandally in a row. Is it possible? Help me.
Use cursor and iterate through each row. Assign value to a variable and select the variable at the end.
|
|
|
|
|
Hi,
Try this
DECLARE @str varchar(50)
When using space as the delimiter
---------------------------------
select @str = coalesce(@str+' ','')+Msg
from Table1
SELECT @str
Result:
Chennai Vilupuram Trichy Madurai
When using comma as the delimiter
---------------------------------
Result:
Chennai,Vilupuram,Trichy,Madurai
Senthil
|
|
|
|
|
hi;
i new in MFC and i have a problem with adding and deleting but basically i can attribute my problem to lack of proper tutorials on the same. ANy site i try to get tutorials i end up with getting complex stuff posted by Gurus tryiong to implement not the usual basic works that am in need of so i have been tring to understand the whole concept by following one simple code example i have and so in that connection if you know a site i can get real introduction tutorials to ADO in MFC i will appreciate but in the mean time
help me get thru this problem at hand(my name is king'ori from kenya);
I want to add supplierid (not null primary key) and suppliername(not null) to the SUPPLIERS table (which i have alreaady created);
so i have included the adofields.h in my project..,done the ::initialization, the opening() plus i have these functions
void MyView:: RefreshSupplier()
{
if(p_rsSupplier->BOFILE || p_rsSupplierEOFILE)
return;
m_strSupplierName =(const char*)_bstr_t(FieldValue(p_rsSupplier,"suppliername");
m_lSupplierID = long(FieldValue(p_rsSupplier,"supplierID"));
UpdateData(FALSE);
}
vooid MyView:: UpdateSupplier()
{
if(p_rsSupplier->BOFILE || p_rsSupplier->EOFILE)
retirn;
CString strSupplier;
long lsupplier;
UpgateData();
if(lSupplier != m_lSupplierID)
FieldValue(p_rsSupplier,"supplierid",m_lSupplierID);
if(strSupplier != m_strSupplierName)
FieldValue(p_rsSupplier,"suppliername",m_strSuppliername);
}
void MyView::BlankSupplier()
{
m_lSupplierID = 0;
m_strSupplierName = _T(" ");
}
problem comes i dont understand the adding flow,- for instance why do you have to blank the recordset? what comes first p_rsSupplier->Addnew() or is it UpdateSupplier() and why;
this is not working
void MyView::AddSupplier()
{
BlankSupplier(); //why this and my fields are not null?
p_rsSupplier->AddNew();
UpdateData();
p_rsSupplier->PutCollect(_variant_t("Suppliername",_variant((LPCTSTR)m_strName);
p_rsSupplier->PutCollect....suppierID);
p_rsSupplier->MoveNext();
RefreshSupplier();
}
void MyView::DeleteSupplier()
{
if(p_rsSupplier->BOFILE || p_rsSupplier->EOFILE)
{
if(Warning MSgBx ==YES)
{
p_rsSupplier->Delete(adAffectCurrent);
p_rsSupplier->MovePrevious();
RefreshSupplier();
}
|
|
|
|
|
hi;
i new in MFC and i have a problem with adding and deleting but basically i can attribute my problem to lack of proper tutorials on the same. ANy site i try to get tutorials i end up with getting complex stuff posted by Gurus tryiong to implement not the usual basic works that am in need of so i have been tring to understand the whole concept by following one simple code example i have and so in that connection if you know a site i can get real introduction tutorials to ADO in MFC i will appreciate but in the mean time
help me get thru this problem at hand(my name is king'ori from kenya);
I want to add supplierid (not null primary key) and suppliername(not null) to the SUPPLIERS table (which i have alreaady created);
so i have included the adofields.h in my project..,done the ::initialization, the opening() plus i have these functions
void MyView:: RefreshSupplier()
{
if(p_rsSupplier->BOFILE || p_rsSupplierEOFILE)
return;
m_strSupplierName =(const char*)_bstr_t(FieldValue(p_rsSupplier,"suppliername");
m_lSupplierID = long(FieldValue(p_rsSupplier,"supplierID"));
UpdateData(FALSE);
}
vooid MyView:: UpdateSupplier()
{
if(p_rsSupplier->BOFILE || p_rsSupplier->EOFILE)
retirn;
CString strSupplier;
long lsupplier;
UpgateData();
if(lSupplier != m_lSupplierID)
FieldValue(p_rsSupplier,"supplierid",m_lSupplierID);
if(strSupplier != m_strSupplierName)
FieldValue(p_rsSupplier,"suppliername",m_strSuppliername);
}
void MyView::BlankSupplier()
{
m_lSupplierID = 0;
m_strSupplierName = _T(" ");
}
problem comes i dont understand the adding flow,- for instance why do you have to blank the recordset? what comes first p_rsSupplier->Addnew() or is it UpdateSupplier() and why;
this is not working
void MyView::AddSupplier()
{
BlankSupplier(); //why this and my fields are not null?
p_rsSupplier->AddNew();
UpdateData();
p_rsSupplier->PutCollect(_variant_t("Suppliername",_variant((LPCTSTR)m_strName);
p_rsSupplier->PutCollect....suppierID);
p_rsSupplier->MoveNext();
RefreshSupplier();
}
void MyView::DeleteSupplier()
{
if(p_rsSupplier->BOFILE || p_rsSupplier->EOFILE)
{
if(Warning MSgBx ==YES)
{
p_rsSupplier->Delete(adAffectCurrent);
p_rsSupplier->MovePrevious();
RefreshSupplier();
}
|
|
|
|
|
in my project, i use toolbar toolbar in my buttons...i used case structure for the functions of each buttons in the toolbar but theres an error in it...
my codes goes like this:
Select Case
Case 0
Dim subjects As New subjects
subjects.Show()
Me.Hide()
Case 1
Dim file_maintenance As New file_maintenance
file_maintenance.Show()
Me.Hide()
Case 2
Dim grade_entry As New grade_entry
grade_entry.Show()
Me.Hide()
End Select
is this code correct???
or this:
dim keyin as integer
Select Case keyIn
Case 0
Dim subjects As New subjects
subjects.Show()
Me.Hide()
Case 1
Dim file_maintenance As New file_maintenance
file_maintenance.Show()
Me.Hide()
Case 2
Dim grade_entry As New grade_entry
grade_entry.Show()
Me.Hide()
End Select
in the first code, there is an error so i can't run my program...
in the other code, the 1st button is only functioning...
what is the really correct code for this???
|
|
|
|
|
Rharzkie wrote: what is the really correct code for this???
What is the correct forum for this question because I really don't see anything to do with SQL or databases in here!?
|
|
|
|
|
You would be better-off with the VB.Net forum. However, it looks like you haven't assigned any value to the keyIn variable.
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".
|
|
|
|
|
Breaking forum rules will result in you getting no help.
_____________________________________________
Flea Market! It's just like...it's just like...A MINI-MALL!
|
|
|
|
|
Hi Rharzkie,
In your first part of your code you didn't pass parameter for the case.
It should be
Select Case <parameter>
Case 0
Dim subjects As New subjects
subjects.Show()
Me.Hide()
Case 1
Dim file_maintenance As New file_maintenance
file_maintenance.Show()
Me.Hide()
Case 2
Dim grade_entry As New grade_entry
grade_entry.Show()
Me.Hide()
End Select
Senthil
|
|
|
|
|
I was successful in creating my Stored Procedure. But if tomorrow I want to access and see the code that I have written for the Stored Procedure how should I access that?
|
|
|
|
|
What in? SQL Server 2005? SQL Server 2000? How you view it depends on the database.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
What database are you using? It depends on what database platform you are using...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
It depends which database you are using, If you are using SQL Server, Goto Enterprise Manager and choose Database - > Stored Procedure's. Alternatively you can use Sp_helptext ProcedureName also.
|
|
|
|
|
how to get sql server 2005 last execution time? is there any system store procedure? plz help...
|
|
|
|
|
You could always find some way to look in the log file. Not sure if this is how you want to do it...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi all,
I have an application which uses MS Access, SQL Server and MYSQL as back ends
Only one connection is opened at a time
My problem is,
when i tried to open the my sql connection after closing an MS Access connection it shows the following error message, but no problem with the SQL Server
Cannot start your application. The workgroup information file is missing or opened exclusively by another user
I am using Connection15::Open to open the connection
I used same connection object to open all connection
Thanks
Sivan
www.ktsinfotech.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
