On Mon, Apr 27, 2009 at 8:44 PM, Ben Dewey <ben.de...@26ny.com> wrote:
> Vineet, > > > -Does data get stored by running the "setup" procedure?? > > Yes, The data is inserted when you run the SetupActions. In particularly, > The SetupActions creates storeprocedures to insert the data from the XML > documents stored in setup_utilities\DataLoad\StockTraderDB > > > > -How can i find the data of individual accounts?? > > The data for an individual account is stored in the ORDERS and HOLDINGS > tables > In SQL Management Studio you can: > 1. expand the StockTraderDB Database > 2. expand the Tables category > 3. Right-Click the Table named Orders and click Edit Top 200 > > Or > > 1. Right Click the StockTraderDB and choose New Query > 2. Copy the following in there and change SET @accountId to the number > your looking for > 3. Click Execute > > -- Begin SQL Query > > DECLARE @accountID int > SET @accountID = 1 > > SELECT * > FROM ORDERS > WHERE ACCOUNT_ACCOUNTID = @accountId > > SELECT * > FROM HOLDING > WHERE ACCOUNT_ACCOUNTID = @accountId > > -- End SQL Query > > Hi Ben, > Thanks for that I worked them Its working just fine. With Regards, Vineet Ghatge H > > > > -----Original Message----- > From: Vineet ghatge [mailto:vgh4us...@gmail.com] > Sent: Monday, April 27, 2009 11:00 AM > To: stonehenge-dev@incubator.apache.org > Subject: Re: DATABASE HELP > > On Sun, Apr 26, 2009 at 7:01 PM, Ben Dewey <ben.de...@26ny.com> wrote: > > > Vineet, > > > > It sounds like you should be okay. There was also a patch to the > > SetupActions/Program.cs file that displays a message saying "Press any > key > > to continue.". > > > > When it says you are unable to open the files, are you trying to double > > click? If so that's not going to work. The MDF file is the actual > database > > and when the SetupAction scripts runs it attaches the database to > SQLServer, > > thus using it by another process. In order to view that newly created > > database, Open SQL Management Studio, connect to .\MSSQLServer, and > expand > > Databases, you should see a StockTraderDB on that list. > > > > -Ben > > > > Hi Ben, > > > Thanks for those instructions .I followed your instructions and found > StockTraderDB on the list of"database".Can please tell me:- > -Does data get stored by running the "setup" procedure?? > -How can i find the data of individual accounts?? > > With Regards, > Vineet ghatge H > > > > > > ________________________________________ > > From: Vineet ghatge [vgh4us...@gmail.com] > > Sent: Saturday, April 25, 2009 11:37 PM > > To: stonehenge-dev@incubator.apache.org > > Subject: DATABASE HELP > > > > Hello all, > > > > I have managed to create "SetupActions.exe" according to steps described > by > > Scott Golightly on Apr 6(Subject:How to create and populate DB) > > After running the "SetupAction.exe" in the command prompt(as an > > administrator) i got the following as the output:- > > > > -Setting up database > > -Config.Appsettings: > > -dbserver is .\MSSQLExpress > > -installPath is C:\StockTraderDemo\ > > dbadmin is sa > > authType is SQL > > .......................................(cursor stops here) > > Does this mean it that it finished populating database? How do I knw that > I > > finished populating the database???. > > > > While the command prompt runs at following path C:\Program > Files\Microsoft > > SQL Server\MSSQL.1\MSSQL\Data,it creates two files:- > > 1)StockTraderDB.mdf----SQL Server Database Primary Data File > > 2)StockTraderDB_log.LDF---SQL Server Database Transaction Log File > > > > But I am unable to open the file instead throws an error saying "its > being > > used by another process". I did not understand why?? . > > > > I am running the whole process on Windows XP OS > > > > With Regards, > > Vineet Ghatge H > > >