Comments by cigwork (Top 26 by date)

That is never going to work.

Please go back and re-read what I wrote; especially the sentence, "Create a class Transaction (or any other name that you choose) that has properties that match the names of the fields in your JSON string." then go back and look at what you have written.

Depends how "clever" you want to be and what want to do with the address.

You could use System.Net.IPaddress if you're working with .Net

Or if there isn't already an IPAddress class in the libraries you have access to you could create your own IPAddress class with all sorts of "useful" features like construction from string, validation of entered string, splitting the string into octets, various formatted string representation (hex or octal or ...) or whatever else you think might be fun.

Or you could just use a string as previously suggested and trust the user to enter a sane address. It all depends how robust you want your solution to be.

GIGO.
1. You have a table that is holding date/time information as varchar rather than datetime. This is generally considered to be a less than sensible decision.
2. You (probably) have a UI that doesn't validate input dates adequately.

This has allowed someone to enter a "date" value that isn't a date, a date outside the min/max range for a SQL date or a valid date in a format for some locale other than that of the DB server.

The only solution at this point is to identify the offending row(s) and attempt to convert the "bad" data to "good". You then need to go back and see if whether or not it is possible to update the application to prevent the problem happening again.

It's probably going belly-up on the EXPENSE_REQUISITION_DETAIL.From_Date or To_Date column(s).

,CASE(D.Expense_Head_Id) WHEN 12 THEN (CONVERT(VARCHAR(11),D.From_Date,103)+' '+COALESCE(Start_Time,'') +' - ' + COALESCE(End_Time,''))
ELSE (CONVERT(VARCHAR(11),D.From_Date,103)+' '+COALESCE(Start_Time,''))
END AS 'FromDate'

,(CONVERT(VARCHAR(11),D.To_Date,103)+' '+COALESCE(End_Time,'')) AS 'ToDate'
,TM.MODE_DETAIL AS 'ModeOfTravel',TC.CLASS_DETAIL AS'ClassOfTravel'

Have a butcher's at these and all should be a bit clearer.

http://www.theregister.co.uk/2014/12/09/a_first_look_at_googles_android_studio_10_should_you_use_it

http://developer.android.com/sdk/installing/migrate.html

BTW. A colleague _seems_ to have found a problem on Windows machines with AMD processors not running the new emulator at all; even with hardware acceleration off. I'm increasingly tempted to hold off and wait for SP1/V2.

Thanks for that. The problem (as I understand it) is that it is no longer going to be a case of preference because The Chocolate Factory is dropping Eclipse as the IDE so it will be A.S. or nothing (chiz chiz). What I'd also like to know, hence the supplementary q., is whether or not A.S. is stable enough for me to make the cut-over now or to hang on a bit. Quite happy to hang on for SP1/V2 of A.S 'cos Android is hobby stuff only for me and I'm not interested in being at the bleeding edge for "fun" stuff; bad enough dealing with it in the day job.

Check that the account the IIS/ASP process runs under has access to the F:\ drive. "File / Dir not found" exception is quite common (IME) when a process doesn't have sufficient rights.

I know I can solve this problem in code, I've already done so. Artificial problem? Yes. Where does it say questions on this forum have to be for, "real world problems"? This is an experiment/tutorial exercise to see whether or not XAML lives up to the hype and because it looked like a fun thing to try.

What about colour analysis? In the UK and those European countries using the Euro the currency notes are of different colours. So one possible solution might be to take the bitmap containing the image of the note and work out its average colour (most non white pixels of a specific colour of all colours found perhaps?) and compare the value with previously determined reference values. If you want to cope with multiple currencies then if reference colour values are grouped by locale it should be possible to offer the most likely identification of a note based on current locale in the case where notes from different countries have the same reference colour.

Something as crude as this should work reasonably quickly without needing a round-trip to the server. You could fall back to a server to request an update of reference colour values should you encounter an average colour value not held locally.

Alternatively you could provide the application with a training mode. Present it with a series of notes and let it work out the reference values for each note for itself. This would take account of vagaries in the image quality of individual device cameras and allow a user (with help from a sighted friend) to set up the app. for any currencies that he or she commonly uses. The application then becomes self supporting.

Of course none of this will work for coins nor for currencies like the U.S. dollar which have notes of a uniform colour.

Indeed you could, but the problem is in Access so the query needs to be something that stands a chance of being converted to Access

Assuming you are using Eclipse and the Android plug-ins:

Have you tried running this in the emulator rather than directly on the target machine? If you do then the logcat window will (very probably) tell you where you've gone wrong.

If there's nothing showing in logcat wrap the failing code in a try/catch block and in the catch call android.util.Log.e method with the exception info.

catch (Exception e) {
Log.e("MyActivity::MyMethod", e.getMessage());
}

It's probably a null pointer or other uninitialised variable. It nearly always is for me. :)

If you need to do something like that then all I can suggest is that you use a Cursor. It will let you process the table a row at a time. Cursors are normally regarded as a last resort solution because they are slow. If your employee table isn't too big then that probably won't be a problem.

Cursors help page.
http://technet.microsoft.com/en-us/library/ms180169.aspx

OK I'm stumped too. A quick search on teh interwebs shows you are not alone. This problem has been turning up for a couple of years now.

The link below although for C++/MFC is interesting because its 1st suggestion is to uninstall the acrobat PDF reader. What happens if you try to select files that aren't PDFs? There's also a link to a hotfix that may be of interest.

Another suggestion that seems to be made on a regular basis in the various articles is to get rid of any Windows Explorer shell extensions you may have loaded. It seems that bugs in these can cause this sort of behaviour.

http://mfctips.com/tag/access-violation/

The following links have a work-around which the authors freely admit are a bit smelly.

http://social.msdn.microsoft.com/Forums/vstudio/en-US/c29e6bcc-9dbb-49b5-a09a-e1716326cedb/access-violation-using-open-file-dialog?forum=vbgeneral

http://social.msdn.microsoft.com/Forums/en-US/d08161ec-0484-45b0-b940-3cad58a33d33/mdi-application-error-with-openfiledialog?forum=csharplanguage#0b2377cb-2864-4c80-9085-d876a36bd5b4

Unsafe code.
You can mark code as "unsafe" to allow the use of Windows APIs that don't/won't/can't play nicely in .Net's memory managed and garbage collected (or safe) world. AFAIK you can't use the "unsafe" keyword in VB, but if your project references a library DLL written in (say) C# that has unsafe methods then that could be a source of your woes.

Does this happen on the very first attempt or only after some random number of attempts? If the latter have you tried calling ofd.Dispose() before exiting the click event handler?

Have tou tried specifying a local path that you know the process will have access to? If that works, check that the process has access to the server path. Perhaps the dlg is trying to do something clever if there's no access and failing?


' Can we see the server directory?
Dim dI As IO.DirectoryInfo = New IO.DirectoryInfo(ofd.InitialDirectory)
Try
Dim fA As io.FileAttributes = dI.Attributes
Catch ex As Exception
' Might get caught. Might not if a security exception is thrown.
MessageBox.Show(ex.Message)
End Try

If you can't you use two (or more if necessary) sort columns can you concatenate values?
Something like ...

select
name,
case when name like 'PackageTotal' then '00' else '01' + name end as CombinedSort
from sortTest
order by CombinedSort

myDataView.Sort = "CombinedSort ASC"

If you can't add columns to the result set then perhaps return a single InvoiceItemLevel with a prefix as shown for the CombinedSort above and then (oh this is horrible) use a template column rather than a "plain text" column in your datagrid to display the invoiceitemlevel without the sort prefix

Have you tried:
0 - Checking that the target machine has a version of the .Net framework that matches or supersedes the one on your dev. machine?

1 - Building a single "hello world" window/page WPF app and seeing if that will run on a test machine? If it doesn't then you can _probably_ rule out problems in the main app.

If "hello world" runs then have you considered:

2 - Replacing the initial start view/page with a simple "It Lives" with no/minimal property bindings and no additional namespace references?

3 - Checking that any DLLs required/used in the failing start page/window are actually built/installed on the test machine?

4 - Tracing the startup sequence in the Windows Application event log?

You can't validate filesize server side this way.

If I remember correctly the HTTP max request is intended to be used as a first line of defence against DOS attacks mounted using large requests. For this reason any request exceeding the server's configured limit will throw an exception before any application code is executed.

If the server holding the files can be configured as an FTP server then you can use
WevRequestMethods.Ftp.DownloadFile see:

http://msdn.microsoft.com/en-us/library/system.net.webrequestmethods.ftp.downloadfile.aspx

Have a look at this Code Project article based on framework 2
http://www.codeproject.com/Articles/17202/Simple-FTP-demo-application-using-C-Net-2-0

Yes, but the multi-byte character encoding schemes used to handle many non-Latin alphabets mean that there isn't necessarily a 1:1 match between a byte (char) and what's painted on the monitor.

What is the purpose of the "sOutlet" columns in the stock table? I expect I have misunderstood something, but they don't seem to add anything to the structure you've outlined. If they are just cruft then I'd expect to be able to use something like this...

select
stockdetail.PID
, branch.[name]
, stockdetail.S15
, stockdetail.S30
from [stockdetail]
inner join [branch]
on [branch].[name] = [stockdetail].[storeID]
inner join [stock]
on [stock].[PID] = [stockdetail].[PID]
and [stock].[disable] = 0

To share an image I think you will first have to load it to an image sharing site like flickr and then put the URL of the image in your reply or comment.

It would also help if you posted a code fragment showing how you are changing the form's backcolor.