Francis Tracey's Q&A profile

• Visual C# How to create a new object of an unknown/changing type?

  For a couple of days now, i'm stuggeling with the next problem: Let's say i have an abstract class called "car". From this this class i have derrived the classes Audi, Austin, Bentley, BMW etc. abstract class car { /*...*/ } class Audi : car { /*...*/ } class Austin : car { /*...*/ } class Bentley : car { /*...*/ } class BMW : car { /*...*/ } //etc. Now i create an array: car [] cararray = new car [10]; In this array, there can be every derrived (car)class. Now i want to create a new object carfromarray, which has the same type as cararray[0], but i don't want a copy. One way to do this is: car carfromarray; if (cararray[0] is Audi) { carfromarray = new Audi() ...Show All

• SQL Server Considerations when delete records from table.

  Hello, I'm developing application which monitors network packets. The monitoring data are saved into table. Monitoring table maintains the data for fixed quantum time,for example during one 1 hour. So, every minute before or after insert new data, I delete the time-expired data. I doubt that the endless delete operation would results in some problems(increasing index,etc..). Is this mechanism safe to the dbms Aren't there round-robin( ) style table thats wat OLTP is for.... just keep the update statistics to auto (its default) , if ur using indexes.....also there may be fragmentation issues ...but thats a DBA activity/Db maintainance... ...Show All

• SQL Server Printing in MSRS - Riddle

  Is it possible to schedule a report to print to a specific printer, that would work on a schedule the way an email subscription does Thanks!! If you instaleld that within your setup, then there is a printer delivery example which shows you the way to enable your reports for printing delivery. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Gadgets Bug #25: Flyout will only show if Sidebar has focus.

  Bug #25: Flyout will only show if Sidebar has focus. If you show the Flyout via "System.Gadget.Flyout.show = true" and Sidebar doesn't have focus, the "System.Gadget.Flyout.onHide" event immediately fires. Added to the known bugs list with a Repro. I expect it's by design, but there's no mention of it in the MSDN documentation so I'm classing it as a bug. Firing the onHide event immediately could cause code issues, as any code relying on the Flyout body would fail. To catch onHide event misfires, check if the Flyout body is null: function onHideEvent() { //did the Flyout actually open if (System.Gadget.Flyout.document.parentWindow.body == null) return; //the Flyout was open. } ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Custom Content Processor - Usage

  Hi, I am looking from some advice on writing a custom content processor for XNA. I have been working on a tile engine and have my Windows based tile map editor up and running. This editor produces an XML file holding all the tile set bitmaps, a list of all the levels in the map and a list of layers on each level. I am thinking of using a custom content processor to load this XML file, parse it and serialise it to the xnb file. I then plan to write a custom importer which will create a top level map object which will hold the tile sets as Texure2D objects and a dictionary of levels in the map. Does this seem like the correct use for a content processor Andy This is absolutely a great way to emplo ...Show All

• Visual Studio Tools for Office PowerPoint 2007 ribbon addin

  I want to maintain some user data in the Tags collection of a slide. I have added a ribbon and can display a form for capture of required fields. How do I gain a reference to the current slide One would think so but I haven't been able to find it. Globals.ThisApplication.ActivePresentation gets you to the active presentation. There is a slides collection available from there but you need to know the index of the current slide to get it. ...Show All

• SQL Server How to display a table only in one page?

  Hi guys, I have one table which contains more than 200 rows of data. Our customer wants this report to be displayed only in one page with vertical scorll bar on the right of it. Could anybody tell me if it is possible Thanks. Danny I have the same requirement from my client. I have a report rendered on 3 pages, set the "fit table" and tried page size of 100in/100in and I still have the same 3 pages rendered. what do I do wrong ...Show All

• SQL Server SSRS Fixed Table Size

  Hello, I am trying to find a way to fix the size of a table in SSRS so that it would not push any items underneath it when it grows, due to multi-row data set. I have set the canGrow = false property of all the text boxes in the table, but this did not help. Does anyone know if it is possible to force a fixed size of the table and how it is done Thanks. TF I am begining to think that an invoice is not an application that SSRS 2005 can handle from the lack of responses. Maybe a future release will have this popular type of report. For now, I guess I need to find another solution to my problem - somewhere else. Does anyone know of a system that can handle that ty ...Show All

• SQL Server Create new login non case sensitive

  I am trying to create a new login on a database, and I want that username and password NOT to be case sensitive. Do I have to set this at the server level or can I set this in the SQL script Here is the script I am currently using... IF EXISTS (SELECT * FROM dbo.sysusers WHERE [name] = 'UName') BEGIN EXEC sp_dropuser 'UserName' EXEC sp_droplogin 'UserName' END EXEC sp_addlogin 'UserName', 'Password', 'Database' GO EXEC sp_adduser 'UserName', 'Password', 'db_datareader' GO Any help would be appreciated... David SQL Server 2005 only uses case sensitive password, this is an intentional behavior change for SQL Server 2005. See http://msdn2.microsoft.co ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Can't use Microsoft Points to subscribe to XNA Creators Club?

  Hello, I want to become a member of the XNA Creators Club, and because I don't own a credit card I went out and bought 2 x 2100 Microsoft Points (because it also showed "redeem code" as a payment method). After entering both the 25-character codes, it didn't accept this as a payment method.. So now I'm stuck with 4200 Microsoft Points and an empty wallet. Is there a way to become a member using the Microsoft Points Or do I really need to use a credit card Because then I'm screwed.. Thanks. Well they didn't literally tell it, but they offered 'Redeem a prepaid card' as a payment option. And I thought I had to use a Microsoft Points prepaid card for it, because there aren't any 'Creators Club ...Show All

• .NET Development Control datatable and row events programatically

  I want to turn off events on several tables in a datset, which I know I can do using BeginLoadData. The problem is that I want to raise update events on specific rows after I call EndLoadData. Specific example: I have a datatable Data, and a datatable Summary. I update rows in the Data table but do not want events raised regarding the changes in Data until I've also updated Summary. Basically I need transactions, but applied to updates of a dataset. Any ideas I suppose I could lock the individual rows, but then I have to make sure to attempt a lock before accessing a row every time. May be, I would try to use triggers (on the database side) or a seperate view or UDF which calculates the column in the dat ...Show All

• Visual FoxPro How do i use the WHERE clause in remote database connection?

  After connecting to and oracle database i want to select specific records using the where clause as below gctype = 'A' gquery = '1' = SQLPREPARE(gnConnHandle, 'SELECT fssno,floc,fcurrent_address1,fcurrent_address2,; fhome_address,ferno,fquery_code,fdate_approved,fcap30,fbenefit_paid FROM cif_hist; WHERE ftran_type = gctype and fquery_code = gquery','MyCursor') = SQLEXEC(gnConnHandle) It gives me an error message "SQL statement parameter is required for non-prepared SQLEXEC() calls. Can someone help me Thanks for the response but i did as stated above and still does not work. Gives a an error message 'variable LCSQL not found'. All the SQLPREPARE syntax without the where clause works. I'm using VFP 6.0 ...Show All

• Visual Basic Data vanishing during run time

  When I enter data into a SQL database and save it, the data that I have just added vanishes, but when I close the applicaiton and re-open it, it's still there - is there any reason for this and any way to get it to stay Sorry my mistake again, i've solved he problem - I took out the Me.AlbumTableAdapter......., as i didn't need it in there, and tis has solved the problem Thanks for all your help ...Show All

• Connected Services Framework CSF tools/mmc

  hi, I have installed the dev lite version on my pc. The only mmc available is the CSF session. Any idea what happened to the IDM mmc Also only the message visualizer is available. Other tools for service catalog, IDM are not available. How can I get these thanks IDM lite is only installed ..as per the documentation. So the tool is not available. You don't need UDDI, because Service Catalog component is not installed with Devlite. ...Show All

• SQL Server ReportServer Database Where is ..?

  The To:, CC:, BCC: and ReplyTo: values stored for email subscriptions in the report server database The Subscriptions.Description column only stores 40 characters, and adds a "Send e-mail to" in front of the first 40 characters. Anyone know where to find the full values for these items Tai ...Show All