Recent content by magnus2

In an applet I got this error-message in a Java-s system window. What could be the problem? Grateful for comments. java.lang.StringIndexOutOfBoundsException: String index out of range: -13 at java.lang.String.substring(Unknown Source) at...

I needed to use ' signs also around a double variable to make SQL accept a double with more than one decimal. Strange! Should I always use ' around my variables? Maybe parameters then, but I think my code will work on my local database. Thanks! /Magnus

Hm, it works when I do it like this and put 'signs around the double variable: StrSQL = "INSERT INTO Table1 (A, B)" & _ " VALUES (" & integerA & ", '" & doubleB & "')" The 'signs seems to be a somewhat magical solution. Should I always have ' around my variables? Maybe this is a VB question...

That is I can enter a number with more decimals directly in the table, but it doesn't seem tom be possible to send it from Visual Basic. Hmm...strange...

Hi! There's only room for one decimal though it says 'data type double' in the SQL table. I don't use a server, only a database on my computer. I will try your suggestions. Thank you!

Hi! I send a double variable from VB.NET code to a SQL database on my own computer. There seems to be a problem when the double contains a lots of decimals. This prevents the variable from being sent. Is it possible to change the allocated memory space for the double in the database or do I have...

Thanks again! This also seems to work: StrSQL = "INSERT INTO FyllTid (A, B, C, D, Time1)" & " VALUES (" & a & ", " & b & ", " & c & ", " & d & ", '" & time1 & "')" The ' signs around time1 does the trick!! Thanks!

Hi again! The variable name is not the problem. Sorry for troubling you with that. No debugging error messages. I will look up SQL injection. Thanks for your time so far! Thank you very much!

Hi! SET DATEFORMAT mdy is not allowed by the build error manager in VB.NET. The database is local on my machine. Could the localization still be a problem? I'm still struggling :)

Hi! I have trouble sending a DateTime variable from VB code to a SQL database DateTime field. I use this: StrSQL = "INSERT INTO FyllTid (A, B, C, D, Time)" & " VALUES (" & a & ", " & b & ", " & c & ", " & d & ", " & time & ")" Time is DATETIME in SQL and time is DateTime in VB.NET. What could...

Hi! I want to write data to a database using SQL frases from Visual Basic .Net code. How do I do it? Kind regards /Magnus

I have put some activex components on a form and made an application. Now I want an executable file that will run on another computer. The activex components are installed on the other computer. If I do 'build solution' (I use VB.net) I get a .exe file but that don't run on the other computer...

Thank you DrJavaJoe for your answer! I just - maybe - have found a way to work around this problem, but I ask you anyway - how do I hook a window? Thanks again for your time. Thank you very much!

I'm not sure that this is what I need but maybe. Thanks! What is the exact workings of this code?: <meta http-equiv="refresh" content="5; url=http://www.example.com/noscript.asp"/> For me it is important that the redirecting web page will be omitted from the browser history folder - as is the...

Thank you shaddow! I use som scripting statements in my HTML. But if the user has scripting turned off I want him to be redirected instead with no trace in history. Since this won't work: <noscript>location.replace(...)</noscript> I hope I can use ASP and <% Respons.redirect %> instead. I...