About byron

Archive by Author
c-sharp-nullreferenceerror

C# – NullReferenceException with TableAdapter and Scalar Values

Ok, I’ve been hacking around this particular problem for a month now, but think I’ve got a bead on how to stop it. So, I hope this helps someone! The Situation I’ve got a TableAdapter in C# and I’m using a Query to return a scalar value that ultimately becomes a double data type. The [...]

Read full story Comments { 0 }
iOS 5 – Problem Setting an Image for UINavigationBar Background

iOS 5 – Problem Setting an Image for UINavigationBar Background

iOS 5 has made it much, MUCH easier to set an image as the background of your UINavigationBar. There are dozens of tutorials out there that will get you there, and I tried a half dozen of them, but still couldn’t get it to work. The code itself is very simple, and here it is: [...]

Read full story Comments { 1 }

C# / VSTO – Using Excel Ranges

Using Visual Studio Tools for Office (VSTO) with Excel lets you use C# (or your other favorite .NET language to leverage the power of Excel. But you will have to learn how the syntax for the Excel object model as opposed to just using VBA syntax. This post shows you how to use Excel ranges [...]

Read full story Comments { 0 }

C# – VSTO – Get Last Used Row or Cell in Excel Spreadsheet

I have had the opportunity to get my fingers dirty with Visual Studio Tools for Office, at long last.  My project brought me back to an old familiar problem in Excel, finding the last used row in a spreadsheet. This applies equally to C#, VB, and VBA.  You just have to get access to the [...]

Read full story Comments { 2 }
useful-auth-t-codes

SAP – AUTH – How to Find Users who have Access to a T-code

In the Business Analyst role in an SAP shop, it may be helpful to know what Roles or Users have access to a particular transaction code.  Here’s a little tip that lets you do all sorts of queries about the authorizations in your SAP system. Use T-code:  AUTH to Access “Infosystem Authorizations” Menu To get [...]

Read full story Comments { 5 }
sqlite

iOS – FMDB is THE End to Your SQLite Nightmares

When you’re writing apps for iPad or iPhone, you’ve got a couple of options for you database solutions.  By far the best options (if it fits your app’s data needs) is Apple’s own Core Data which can use SQLite as it’s database store.  Core Data is fast, efficient, an object store, and provides some great integration [...]

Read full story Comments { 4 }
Screen Shot 2011-07-21 at 12.31.38 PM

OS X 10.7 Lion – How to Fix Trackpad and Mouse Scrolling to Normal

I’m not sure if they are just messing with our minds or what, but Apple changed one of the most automatic navigation functions you do.  Scrolling is the computer equivalent of breathing.  You do it automatically, without thinking.  Except now in Mac OS X 10.7, aka Lion, you have to breathe out to breathe in. [...]

Read full story Comments { 3 }
ios

iOS – Get the NSIndexPath for a UITableViewCell by Row and Section

Here’s a newby tip for iPhone and iPad developers…I am noob too I was trying to build an indexPath based on a row # and section, but none of the constructors I tried seemed to work…stuff like indexPathWithIndex: or indexPathWithIndexes:length. Back to the class reference for more reading. I found the answer in the NSIndexPath [...]

Read full story Comments { 0 }
f110-problem

SAP: F110 Problem – Company Codes #/# do not Appear in Proposal

In SAP, T-code F110 allows to you process Payment Proposals and Payment Runs. Sometimes you might come across the error message “Company codes ####/#### do not appear in proposal [date] [proposal ID]; correct”. This basically means that the Proposal run isn’t finding any invoices that can be paid. In some cases, you may not get [...]

Read full story Comments { 2 }

WordPress – Tips on Creating and Updating Tables with dbDelta

One of the reasons I LOVE WordPress is that it makes some mundane programming chores very easy, particularly working with the database. WP uses a modified version of the ezSQL to interact with the database, and provides a number of data cleansing functions, both of which are huge time savers. One other thing that WP [...]

Read full story Comments { 0 }