andrew johnston - Page 14

What is an easy way to list the foreign key contraints in an MDB?

- by Craig Johnston

What is an easy way to list the foreign key contraints in an MDB? Is there a system table that can be queried in order to list this information? Specifically, I need to know whether any foreign key contraints exist in the MDB.

Read the article

Why would a error get thrown inside my try-catch?

- by George Johnston

I'm pushing a copy of our application over to a new dev server (IIS7) and the application is blowing up on a line inside of a try-catch block. It doesn't happen locally, it actually obey's the rules of a try-catch block, go figure. Any idea why this would be happening? Shouldn't it just be failing silently? Is there something environmental I need to enable/disable? Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Line 229: Try Line 230: Here >> : _MemoryStream.Seek(6 * StartOffset, 0) Line 232: _MemoryStream.Read(_Buffer, 0, 6) Line 233: Catch ex As IOException End Try Although it doesn't matter for answering this question, I thought I would mention that it's third party code for the Geo IP lookup.

Read the article

How can I tell whether two .NET DLLs are the same?

- by Craig Johnston

I have the source for a DLL and I have a compiled version of it lying around somewhere. If I compile the source it will have a different date to the already-compiled version. How can I tell whether they are in fact the same and have merely been compiled at different times?

Read the article

VB6: Question about version numbers of dependent OCXs

- by Craig Johnston

Is it important for a VB6 app to refer to certain OCX versions? I have noticed that if I put my VB6 app code through the IDE on one machine then the form files will refer to different version of some OCXs than if I use another machine. What is the rule of thumb with this? Is it safe to assume that most of these old OCX versions will be compatible with each other and so I shouldn't worry? Some of the OCXs in question are: RICHTX32.OCX v1.1 and v1.2 COMCTL32.OCX v1.2 and v1.3

Read the article

How to quickly analyse large MDB file

- by Craig Johnston

I need to know how to quickly analyse a large MDB file (about 1GB) to see which tables are causing it to be so big. Is there something will easily allow me to show a breakdown of which tables are responsible for how much data. I need to know whether it is just this one customer who is using the application differently, or whether there is genuinely a lot of data in the MDB. This MDB is currently causing the VB app to crash, and I need to know why it is so big so that I can maybe think about how to put some of the data into another 'archival' MDB. Migrating to SQL Server is not an option, unless the use of linked tables from an MDB is a realistic option.

Read the article

Providing an application data update from a website

- by Craig Johnston

I need to provide an update to application data as a download from a website. The update would actually just be the replacing of some data files with some updated ones. The update, which I assume would be some sort of setup package type program, would need to be able to do the following: access the file system and registry to determine where files should be copied to supply the files to be copied provide strong security so the data files cannot be downloaded or used by the wrong people What would be best way to achieve all of the above?

Read the article

Requirement to deploy the .NET framework

- by Craig Johnston

Has the requirement to deploy the .NET framework with a .NET application caused programmers to go back to languages such as C++ where more standalone applications can be created?

Read the article

How to refactor VB6 code to prevent run-time errors

- by Craig Johnston

A VB6 app is experiencing a run-time errors at a variety of places. I know this is the result of poor error handling, but is it possible to analyse the code to see where it is susceptible to run-time errors?

Read the article

C#: proprietary DLLs requiring access to my assemblies

- by Craig Johnston

My solution uses a proprietary assembly, which when debugging the solution throws an Exception saying it can't find an assembly that is meant to be one of the projects in my solution. I cannot add a reference to the proprietary assembly because all I have is the DLL. When I compile everything into a single application directory and run the app it works fine, but I want to debug. Where should assemblies be placed if you want a proprietary assembly in the solution to see them? I assume the issue is that there is no path specified and it is just looking in a default directory of some kind.

Read the article

3 Dimensional Array

- by George Johnston

I don't know why I'm experiencing so much trouble with this, but I would like to have an array that basically represents a layer number and x,y coordinates so I could essentially say, int i = array[layer,x,y] and get the corrisponding value per layer. I create the array.. int[,,] myarray ...initialize it myarray = new int[0,width, height]; ...and it blows up when try and grab a value. int n = myarray[0,1,1] What am I missing?

Read the article

C#: are ranges possible with enums?

- by Craig Johnston

In C#, can you use number ranges in enum types, for example public enum BookType { Novel = 1, Journal = 2, Reference = 3, TextBook = 4 .. 10 }

Read the article

Help with django filters

- by Cato Johnston

In a django template, I want to get an value from the first object in a list's field. I have the following code {{ list.object|first.field }} But it results in an error. Is there a way to achieve this without writing a loop or doing it in the view?

Read the article

How to suppress jqgrid from initially loading data?

- by Steve Johnston

I have a page that has a couple of jqGrids on it, along with a few other fields. I want to make one AJAX call myself that pulls back a JSON object that has the data that should be used to fill the entire page. So, I would like to make the call myself, populate the "other fields" and then pull a couple of collections off of the main JSON object that was returned and populate each of the jqGrids with those collections "manually". I have this much working, but I can't get jqGrid to stop attempting to make an AJAX request itself. Shouldn't there be a way to tell jqGrid to NOT attempt an AJAX call when it is initialized? I found a similar question asked here: http://stackoverflow.com/questions/1850159/how-to-suppress-jqgrid-from-initially-loading-data But I don't have the option that solved it for the poster. It seems pretty logical to me that some people may want to use this plugin without having the table attempt to get its own data upon initialization. Am I missing an option somewhere in the documentation (wiki - options)? Thanks.

Read the article

What's the best Mac custom disk image creation app?

- by Lawrence Johnston

I'm looking for a custom disk image creation app that I can integrate into the build process for my app (which means I need to be able to run it from the command line if possible). My desired features are that it will size the image for me, let me set the location of my icons when the image is opened, set a custom background/icon, etc. Free would be nice but if there's something that does exactly what I need I'll pay for it.

Read the article

How do I disable zoom on control-scroll in Visual Studio 2010?

- by Lawrence Johnston

Visual Studio 2010 adds a zoom setting on the bottom left of the text editor (to the left of the horizontal scroll bar) and also adopts the control + mouse scroll idiom for zooming in and out. The former is fine, but I dislike the latter as I am occasionally still holding control when I start scrolling my source code (which results in the text size radically changing and completely throwing me off whatever I was doing). How do I disable it?

Read the article

Access: strange results with queries against MDB file

- by Craig Johnston

I am running the following SQL against an MDB file, a copy of which is located here: http://hotfile.com/dl/40641614/2353dfc/test.mdb.html (perfectly clean file, no macros or viruses) SELECT datediff("d", MAX(invoice.date), Now) As Date_Diff , MAX(invoice.date) AS max_invoice_date , customer.number AS customer_number FROM invoice INNER JOIN customer ON invoice.customer_number = customer.number GROUP BY customer.number If the the following was added: HAVING datediff("d", MAX(invoice.date), Now) > 365 would this simply exclude rows with Date_Diff <= 365? What should be the effect of the HAVING clause here?

Read the article

VB.NET: how to require CheckedListBox to have at least one item selected

- by Craig Johnston

With the CheckListBox in VB.NET in VS2005, how would you make it compulsory that at least one item is selected? Can you select one of the items at design time to make it the default?

Read the article

VB.NET: what does the 'friend' modifier do?

- by Craig Johnston

What does the 'friend' modifier do in VB.NET? Why is it the default modifier for GUI components in Visual Studio?

Read the article

C#: do you need to dispose of objects and set them to null?

- by Craig Johnston

C#: do you need to dispose of objects and set them to null, or will the garbage collector clean them up when they go out of scope?

Read the article

Can't check more than one RadioButton across multiple items in a Treeview

- by Mike Johnston

I’m using a TreeView control to present a list of Questions. Using the Prism.DataTemplateSelector, I'm loading a View (.xaml file) that represents a single Question into each node in the TreeView. In the View for that question is a ListBox containing RadioButtons (one for each item in a Picklist object that the ListBox is bound to). The radio buttons work as expected for the question, but when I check a RadioButton on another node/question in the TreeView, the check for the button in the Question I was editing before disappears. In other words, I'm only able to check one RadioButton in the whole list of Questions/Items bound to the containing TreeView. How do I group the RadioButtons in the ListBox to the scope of the single question instead of all the questions in the TreeView.

Read the article

What is the best and simplest http user agent in .NET?

- by Craig Johnston

What is the best and simplest http user agent in .NET? I simply want to put in the url have it return the page as a string.

Read the article

How can you speed up the display of WinForms in C#?

- by Craig Johnston

How can you speed up the display of WinForms in C#? I am finding that forms are being painted quite slowly, even if the window is being 'reactivated' (ie. switched to) after having been already loaded. Other languages seem to be render forms a lot quicker. Is there a way to speed things up? Using C# in VS2005.