Database Discussion Boards

ChandraRam30-Oct-08 1:23

30-Oct-08 1:23

Just a thought...

If you can afford to let this run as a batch update, maybe you can implement a Levenshtein distance algorithm and decide which records are dupes based on the distance.

SSIS - Multiple packages using the same sharepoint path

notes4we29-Oct-08 3:03

notes4we

29-Oct-08 3:03

I have created some packages which are using the same sharepoint file. So, when I try to run the jobs (having those packages independently) in parallel, I am not able to execute those. It shows an error stating that failed to acquire connection manager.

What I feel is that as the packages are sharing the same file, those are not able to share the files properly and so the packages are not able to connect to the file.

I just want to know if anyone of you know any changes that I need to make in the sharepoint file properties, in the package properties or in the job properties.

Thank you.

how to get in report watermark text

imranafsari28-Oct-08 23:56

imranafsari

28-Oct-08 23:56

Dear all,
i am using sql server 2005 , ssrs2005.
i have to generate a report(delivery challan ) where if articles is issued against sample request then one should display as back ground "sample request not for sale" behind the article details

Please help

imran khan

Embedded Fire Bird - Programmatically creating a new database [solved]

Harvey Saayman28-Oct-08 23:54

Harvey Saayman

28-Oct-08 23:54

Hey guys

i need to create a new database using embedded fire bird, at the moment ive got this...

private void btnCreateDatabase_Click(object sender, EventArgs e)
{
    // if valid data has been entered
    if (FieldsValidated())
    {
        try
        {
            // build connection string
            string fbConnectionString = string.Format("ServerType=1; Dialect=3; User={0}; Password={1}; Database={2};",
                                                      txtUserName.Text, txtPassword.Text, txtDbName.Text);

            //create db file
            FbConnection.CreateDatabase(fbConnectionString);

            // fire event that db has been created
            DatabaseCreated(this, new CreateFirebirdDbEventArgs(fbConnectionString));
        }
        catch (FbException ex)
        {
            MessageBox.Show("btnCreateDatabase_Click - FbException" + Environment.NewLine + ex.ToString());
        }
        catch (Exception ex)
        {
            MessageBox.Show("btnCreateDatabase_Click - Exception" + Environment.NewLine + ex.ToString());
        }
        finally
        {
            this.Dispose();
        }
    }
}

... this creates the file just fine, but how do i create the tables in that db?

Thanks

<edit>
I came across a FbBatchExecution object which seems to do the trick
</edit>

Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111

modified on Wednesday, October 29, 2008 6:31 AM

increment number

susanhalim28-Oct-08 21:35

susanhalim

28-Oct-08 21:35

how to generate field number by increment (+1) in table mysql using PHP after inserting and deleting data?
ex:
Number
1A (next)
2A
3A

Re: increment number

notes4we29-Oct-08 3:09

notes4we

29-Oct-08 3:09

In SQL Server Management Studio (SSMS), in the Object Explorer, connect to your Database Engine, Databases, Expand your Database Name, Expand Tables, Right - click the Table Name in which you wish to have the increment number and select Modify from the context menu.

You will see the column names in that particular table.

Just select the column where you want the increment number and in the bottom in the Column Properties window, Expand Identity Specification. In the (Is Identity) from the drop down list select Yes and you will see the Identity Increment as 1 by default. That is what you need. If you wish you can change it also to 2 or some other number as you wish.

Hope this helps.
I was to descriptive to answer this simple question, but I am not sure how much do you know about it, so I thought of starting from the scratch.

Good Luck.

Re: increment number

PIEBALDconsult29-Oct-08 5:05

PIEBALDconsult

29-Oct-08 5:05

Are those "A"s part of the "number"? Confused | :confused:

If so, I don't think the system can do it automatically, you'd have to roll your own.

Re: increment number

mahsa shahi1-Mar-14 7:09

mahsa shahi

1-Mar-14 7:09

why you dont declare the column in the design of table auto increamnet ?

category tree like structure in sql

S.Dhanasekaran28-Oct-08 21:13

S.Dhanasekaran

28-Oct-08 21:13

Hi all, i am building a category tree like structure for my FAQ app. i need to show all active categories. The hitch is that

if a parent category is checked as inactive, then the sub or child categories under it should not be displayed even if they

are marked as active. I need a query which will return me such a resultset which i can display in a table. the columns in my

table are categoryid, category, ParentcategoryID,companyID and active. The ParentcategoryID contains id of another category

or 'No parentcategory' which denotes its the main category. It is easy to get the immediate parentcategory and find out if

its active or not. But to find out if that parent category's parent and so on is active or not is tough. please help.

Re: category tree like structure in sql

Wendelius29-Oct-08 8:00

Wendelius

29-Oct-08 8:00

Have a look ate CTE. Here's one link for example: Recursive Queries Using Common Table Expressions[^]

The need to optimize rises from a bad design.

My articles[^]

[Message Deleted]

kyi kyi28-Oct-08 17:22

kyi kyi

28-Oct-08 17:22

[Message Deleted]

Re: Function problem

balaji.t28-Oct-08 22:17

balaji.t

28-Oct-08 22:17

hi,

1.first replace ? with @ symbol for all the variables declared with?
2.give ur query like this

select ExtractDigit ('<stringname>')
stringname--> your string name

T.Balaji

managing database queries

DSPCottage28-Oct-08 10:36

DSPCottage

28-Oct-08 10:36

Dear All
in a multi threaded system, I want to access the sql server 2000 data base in 15 separate threads.

But now, when the connection of data base is lost , threads find it separately and they can not make other threads aware of this situation, also it is not possible to organize and manage the data base systematically.

now I want to manage my data base with better mechanisems.

I'd like to use design patterns for this purpose.
But I didn't find any useful information in this regard yet.

May you please let me know any information in this regard.

Thanks in advance
Mahdi

Saving changes to a database via Windows forms

danielhasdibs28-Oct-08 7:01

danielhasdibs

28-Oct-08 7:01

I'm no stranger to programming, but I am brand new to programming with databases. I use MS Visual C# 2005. I have tried making forms with datasets and table adapters and it looks just fine... that is, until I try to make a change.

I have a simple form with a single datagridview. I edit the records, click the Save button on the binding navigator, the tableadapter.Update() method returns the correct number of updated rows, but when I close the program and re-open it, the changes aren't there.

Am I leaving out something? Is there extra code needed? etc.?

Thanks.

Problem with query pulling from AS400

missyd28-Oct-08 6:52

missyd

28-Oct-08 6:52

I am able to pull the correct data in SQLDS1 for the dropdownlist. And, it seems as though SQLDS2 is pulling the correct data in the gridview. However, when selecting from the gridview to populate the detailsview, it only uses the rdb1aa field and i need it to be able to match the selected row data from rdb1aa and rdb2aa with two fields I am selecting from the JOIN in SQLDS3.
If anyone can help, I sure would appreciate it. My code is as follows:

Choose an Area of Study:

<asp:dropdownlist id="ddlPrefix" runat="server" datasourceid="SQLDS1" autopostback="true" datatextfield="rdb1aa" xmlns:asp="#unknown">

<asp:gridview runat="server" id="gvCourse" cellpadding="0" datasourceid="SQLDS2" datakeynames="rdb1aa" autogeneratecolumns="False" font-names="Arial" width="371px" allowpaging="True" pagesize="16" xmlns:asp="#unknown">
<footerstyle backcolor="#D59F0F" font-bold="True" forecolor="White">
<rowstyle backcolor="#FFFBD6" forecolor="#333333">
<pagerstyle backcolor="#D59F0F" forecolor="#333333" horizontalalign="Center">
<selectedrowstyle backcolor="#D59F0F" font-bold="True" forecolor="Navy">
<headerstyle backcolor="#820024" font-bold="True" forecolor="White">
<alternatingrowstyle backcolor="White">
<headerstyle backcolor="#820024" font-bold="True" forecolor="White">
<columns> <asp:commandfield showselectbutton="true">
<asp:boundfield datafield="rdb1aa" headertext="Prefix" readonly="true">
<asp:boundfield datafield="rdb2aa" headertext="Number" readonly="true">
<asp:boundfield datafield="rdi8aa" headertext="Title" readonly="true">

<asp:detailsview datasourceid="SQLDS3" cellpadding="2" headerstyle-backcolor="#BDCFE7" headertext="Course Description" autogeneraterows="False" id="dvDesc" runat="server" height="186px" width="164px" forecolor="#333333" gridlines="None" horizontalalign="Center" xmlns:asp="#unknown">

<footerstyle backcolor="#5D7B9D" font-bold="True" forecolor="White">
<commandrowstyle backcolor="#E2DED6" font-bold="True">
<rowstyle backcolor="#F7F6F3" forecolor="#333333">
<fieldheaderstyle backcolor="#820024" font-bold="True">
<pagerstyle backcolor="#284775" forecolor="White" horizontalalign="Center">
<fields>
<asp:boundfield datafield="r3raak" nulldisplaytext="No Description Found">
<headerstyle height="1px" horizontalalign="Left" verticalalign="Top">
<itemstyle font-bold="True" font-size="XX-Small" height="15px" horizontalalign="Left" verticalalign="Top">

<headerstyle backcolor="#D59F0F" font-bold="True" forecolor="White">
Font-Size="Small" Height="1px" HorizontalAlign="Center">
<editrowstyle backcolor="#999999">
<alternatingrowstyle backcolor="White" forecolor="#284775">

<asp:sqldatasource id="SQLDS1" connectionstring="<%$ ConnectionStrings:ConnectionString %>" xmlns:asp="#unknown">
SelectCommand="SELECT distinct RDB1AA from (select rdb1aa,rdb2aa from OPENQUERY (as400 , 'select rdb1aa, rdb2aa from shwcmfil.catmsp WHERE RDJHAA = ''A'' AND RDB8AA = ''AC''')) AS derivedtbl_1 ORDER BY RDB1AA" Runat="Server">

<asp:sqldatasource id="SQLDS2" runat="server" connectionstring="<%$ ConnectionStrings:ConnectionString %>" xmlns:asp="#unknown">
SelectCommand="SELECT RDB1AA, RDB2AA, RDI8AA FROM OPENQUERY (as400 , 'select * from shwcmfil.catmsp WHERE RDJHAA = ''A''') AS derivedtbl_1 WHERE (RDB1AA = @rdb1aa) ORDER BY RDB2AA">
<selectparameters>
<asp:controlparameter controlid="ddlPrefix" name="rdb1aa" propertyname="SelectedValue">

<asp:sqldatasource id="SQLDS3" connectionstring="<%$ ConnectionStrings:ConnectionString %>" runat="server" xmlns:asp="#unknown">
SelectCommand="SELECT RDB1AA, RDB2AA, RDI8AA, R3RAAK, R3IXAA FROM OPENQUERY (as400 , 'select * from shwcmfil.catmsp
JOIN shwcmfil.catxtp on (shwcmfil.catmsp.rdb1aa = shwcmfil.catxtp.r3b1aa and shwcmfil.catxtp.r3b2aa = shwcmfil.catmsp.rdb2aa)WHERE RDJHAA = ''A''') AS derivedtbl_1 WHERE (RDB1AA = @rdb1aa)">
<selectparameters>
<asp:controlparameter controlid="gvCourse" name="rdb1aa" propertyname="SelectedValue" type="String">
<asp:controlparameter controlid="gvCourse" name="rdb2aa" propertyname="SelectedValue" type="String">

explain entity storingduef

Member 564239427-Oct-08 21:03

Member 5642394

27-Oct-08 21:03

hello, I WANT DESIGN ERD STORINGDUEF if must MY ENTITY(customer,yoodf,store,storekeeper)is it store receipt and store order entity or relation,please explain

Embedding

AnieMVC27-Oct-08 18:59

AnieMVC

27-Oct-08 18:59

How is database embedding Done?

MYSQL Help is needed

Rameez Raja27-Oct-08 18:44

Rameez Raja

27-Oct-08 18:44

Hi all,

I have to use MYSQL Database server as beckend for asp.net 2.0 web application. i have downlaoded and installed the MYSQL on my development machine(windows XP) and also downlaoded MYSQL Administrator for ease.

what are the remaining things which are essentail for connection asp.net 2.0 with MYSQL Database .

Best Regards
Rameez

Re: MYSQL Help is needed

Blue_Boy28-Oct-08 0:22

Blue_Boy

28-Oct-08 0:22

http://connectionstrings.com/[^]

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

How to Check Existing Record first then Insert otherwise update statement

zjaffary27-Oct-08 16:57

zjaffary

27-Oct-08 16:57

I have a Table.It is containing 4 column RegionID, MapFillColor, MapLineColor, MapCoordinates.

I want to run insert statement if the record is new when button press. But if the record already exist it should update the record REGIONID is primary Key in my Table. I donot know where i should put my function which check first the record exist if so then run update else insert statement.

Here is my Code

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

SqlConnection con = new SqlConnection("Data Source=ZAFAR-PC\\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True");

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

SqlCommand cmd = new SqlCommand("Insert into Region(RegionID,MapFillColor, MapLineColor, MapCoordinates) values( '" + RegionID_txt + "','" + MapFillColor_txt + "','" + MapLineColor_txt + "','" + MapCoordinates_txt + "')", con);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

}

}

Re: How to Check Existing Record first then Insert otherwise update statement

Blue_Boy28-Oct-08 0:20

Blue_Boy

28-Oct-08 0:20

The T-SQL statement looks like this:

if(select count(*) from tablename where columnname='value') = 0<br />
begin<br />
insert into tablename values('value1','value2','value3','value4'.....)<br />
else<br />
Update tablename set columnvalue='newvalue' where regionID='value'<br />
end

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: How to Check Existing Record first then Insert otherwise update statement

Tim Carmichael28-Oct-08 2:02

Tim Carmichael

28-Oct-08 2:02

Since the T-SQL has already been given, I'll only add this:
don't put the SQL statement directly in the code; use a stored procedure instead. If the need arises to alter the SQL statement, it can be done at the stored procedure level without altering the code itself.

Tim

Copying data in one table to specific fields in another table

Member 365120927-Oct-08 1:22

Member 3651209

27-Oct-08 1:22

Typically,am new in stored procedures and have been trying to do the following.

To copy/move data in Payments Table to CustomerAccounts.The id in payment is CashId and want to Copy just the data when i pass a specific CashID.Here are my sample stored Procedures.
the Source of Data is "PaYments"
Destinatin is "CustomerAccounts".Any assistance is greatly appreciated.

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 1

CREATE procedure Payments_CustomerAccounts

DECLARE @CatInsert varchar(2000),@CashID int,@Pay_Date date,@Amount money,@DrCr varchar(20), @PaymentModeId int,@BranchID int,@DeptID int

SET @CatInsert = 'INSERT INTO CUSTOMERACCOUNTS (ClientID,[Date],AmountPaid,[Cr/Dr],PaymentModeID,BranchID,DeptID) SELECT ' + CONVERT(varchar,@CashID) + ', Pay_Date,AmountPaid,PaymentModeID,BranchID,DeptID From PAYMENTS Where ClientID IN(' + @CashID + ')'

insert Into CUSTOMERACCOUNTS

([ClientID],[Date],[AmountPaid],[Cr/Dr],[PaymentModeID],[BarnchID],[DeptId]) VALUES(@CashId,@Pay_Date,@Amount,@[Cr/Dr],[@PaymentModeID],[BranchID],[DeptID])

-----------------2

Create Procedure INSERT_INTO_CUSTOMERACCOUNTS

Declare @CashID int

SELECT (cashID,Pay_Date,Amount,PaymentModeID,BranchID,DeptID)
From ACCOUNTS.PAYMENTS
Where CAshID=@CashID

INSERT INTO CUSTOMERACCOUNTS([ClientID],[Date],[AmountPaid],[PaymentModeID],[BranchID],[DeptId])VALUES(@CashID,@Pay_Date,Amount,PaymentModeId,BranchID,DeptID)

Re: Copying data in one table to specific fields in another table

Wendelius27-Oct-08 10:00

Wendelius

27-Oct-08 10:00

If I understood the problem correctly, in the first proc, instead of declaring @CashID as a variable, pass it as a parameter to procedure. After that a single INSERT INTO ... SELECT ... FROM ... WHERE ... will be sufficient.

Refer to INSERT (Transact-SQL)[^] and CREATE PROCEDURE (Transact-SQL)[^]

The need to optimize rises from a bad design.

My articles[^]

Error:The cursor does not include the table being modified or the table is not updatable through the cursor

V K 226-Oct-08 19:19

V K 2

26-Oct-08 19:19

Hi,
CRecordSet::Update( ) is throwing the following exception.

Error:The cursor does not include the table being modified or the table is not updatable through the cursor

I donot know what could be the solution.

I am currently using SQL-Server 2005 ,VC++6.0 . Any help would be appreciated.

Thanks

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