Database

no problem ;) TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L %^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2 W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN% R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i’TV.C\y<pŠjxsg-b$f4ia> ----------------------------------------------- 128 bit encrypted signature, crack if you can

I have a cunning plan! Use two (or possibly more) tables, I haven't completely thought this out. :) First table for Generic data. Second table: OrganizationID NameForAdditionalField TypeForAdditionalField Length... etc I hope that you get the idea. One table contains the 'required' fields and the other table(s) allow you to organise the requirements for each client. Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

What do you mean by access client from the SQL Server 2005.... Please put in some addl. details... usually, from client, the database server is connected...

Hi Abhijit/CodeManiac, Expert exchange displays the answers at the bottom when your referrer is Google. Try searching for the question title "Linking, Connecting MS SQL 2000 to AS400 Database" using Google, go to the first result, and scroll down to the bottom of page to view the replies. Hope that helps. Regards, Syed Mehroz Alam My Blog | My Articles Computers are incredibly fast, accurate, and stupid; humans are incredibly slow, inaccurate and brilliant; together they are powerful beyond imagination. - Albert Einstein

hi there, please try to do below query. It is working perfect with the '-' value. declare @sql nvarchar(1024) set @sql='' set @sql=@sql+'update tbl_swbom_checklist_items set ' + @COLUMN + '=' + '''' +@VALUE + ''' where @PACKAGE='''+ @PACKAGE +'''' exec (@sql) Regards :)

Art Frank wrote: There appear to be a few different ways This my friend is an understatement, I usually use 2 data sources, a datatable/view or a List either bound to a bindingsource and the bindingsource as the datasource to the table. I then hide any columns in the DGV I don't like, I have a base rule that the recordID is ALWAYS in column0 and this is almost always hidden. On the dblclick, grab the selected row.cell[0].value and pass it to the dialogs constructor. If you are using a List you can pass the instance of MyClass. I have a Utils class that does all the binding and formatting for me so I dont even think about it. It has some requirements like controls are named and prefixed correctly but I have been doing that for so long it is automatic. Never underestimate the power of human stupidity RAH

VBA is what Access 2007 uses as default, as far as I know. I am forced to use a lot of different tools and languages in my projects. I am more comfortable with other languages as well. I will try to more it to the VBx forum. I guess that is a cut and paste unless you are a moderator. Thanks for the Hints. PS: If you need help with Perl, maybe I can reciprocate. "Coding for fun and profit ... mostly fun"

Use distinct or try to group. 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. www.aktualiteti.com

Hi, Thanks for ur reply. i dont know much sql server but my higher official want like that. could you please explain me, what exactly your trying to say. is that method is wrong or i dont want to this thing in sql server. sorry for late response. Regards, P.Prakash.

try this select convert(varchar(10),cast(datevalue as datetime) ,120) from dateformats where convert(varchar(10),cast(datevalue as datetime) ,120) ='2007-10-01' Date Thu Sep 20 06:32:10 GMT-0400 (EDT) 2007 will not work for this query because it will cause convertion error exception. 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. www.aktualiteti.com

You need to look at the Red-Gate products. While you can create the scripts yourself it is tedious and time consuming. I have been using SQL Compare for years and would not be without it. Seriously it will totally eliminate this headache. Never underestimate the power of human stupidity RAH

You can wrte triggers for the same. However it is not a good approach. Better check in your stored procedure with the condition...

Hey, I guess you repeated your question.

If you are migrating the database from SQL Server 2000 to 2005, there should ot be any issue as such as SQL Server 2005 is backward compatible and all the statements, functions and other database objects and syntax of SQL Server 2000 works fine in SQL Server 2005. In case of conflict, during migration it will show the alerts. However for double checking, you can run through the test cases that are meant for sections, that have database transactions.

There are few options here for you: Using Windows authentication to access the database. Using SQL authentication to access the database. For Windows Authentication, you need to use Active Directory User to map to your database. For SQL Authentication, you need to create a SQL User and map the appropriate Roles and map with your database. In your C# application, encrypt your connection string and use the same. Many a times in shared deployment environment, they allow on SQL Authentication only, in such a case you will have to use SQL Authentication.

I appreciate it. Yes, ideally I'd be using a different server. Unfortunately, with this client that's not do-able. It's something I hope to be able to convince them of the necessity of in the future but for now..... As far as SQL Server being backed up... I doubt it. If they have to do something different from a regular Windows backup then I don't believe it's happening. Just something else I need to talk to them about. Figuring that the hosting provider (a small company) is not doing a separate SQL Server backup, is it possible to point me to some quick literature of just a couple pages that I could send him to say "do this"? Denise "Hypermommy" Duggan

use this, cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "Your_SP"; cmd.CommandType = CommandType.StoredProcedure; if (con.State != ConnectionState.Open) con.Open(); cmd.Transaction = con.BeginTransaction(); try { parentmainid=Subroutine\_For\_Parent\_Insert(userid); for (items = 0; items <= \_alldata.Count - 1; items++) { Subroutine\_For\_Child\_Insert(parentmainid,childdata); } cmd.Transaction.Commit(); \_status = true; } catch (Exception e) { cmd.Transaction.Rollback(); \_status = false; } Some important points : 1>Remember to declare cmd as global or pass it as byreference. 2> Do not reinitialze the connection in any of the functions. 3> Use cmd.Parameters.clear() on every function call or else you would get a "Too many parameters error". 4> Do not reinitialize the cmd object during the transaction or else the transaction will lose the data and won`t be rolled back. When you fail to plan, you are planning to fail.

we can use sub reports in the body, but it will not show every page. If body is larger then it will continue in the second page and I have to show the header in every page. I do not want to design of header of every reports that's why I have created a sub report and want to put that sub report (header) in each and every report. Pankaj

I needed to reset identities as well so, deletion was not enough for me... But at the end I found a good sp that makes all I need.