602 Posted Topics
 | Hi, You have not supplied a WHERE clause in your SQL and it looks like you have mixed up the syntax between an INSERT statement and the DELETE Statement. With Insert Statements, you are creating new records so you pass in the table columns and the values. With DELETE, SELECT …  |
| | Yes this is because you are posting from one page into another page. Therefore, the page has not posted back on to itself. |
| | Hi, Your form Action is set to handler.asp this means the form submits to the page handler.asp for processing. In the Handler page you do something like this: <% 'as your using classic ASP your radio button can all be called the same thing: dim myURL as string ="" Select … |
 | I like my code slightly fried over a charcoal pit :-) Seriously, I summarise at the begining of a function / routine, I comment gong through it, I indent and I use Polish or Prefix notation - Why? because I've lost days after being handed a project that someone else …  |
 | Re: Six Nations Hi, I don't think Scotland will win it unless there are some fairly big upsets BUT I think for the first time in ages I'm seeing signs of improvement, maybe it's the new coaches. I'm happy to see improvement this year and mount a challenge next year. France are certainly … |
 | Hi your databinding is wrong, the dataset will contain a table with the data retrieved from the query run in your data adapter. (The idea is that you can store several different query results in a single dataset and even link them with relationships - think of it as a … |
| | Hi All, I have a problem with a treeview class in my windows form. Specifically I'm try to detect when a user has expanded or contracted a node verses if they have clicked/selected the actual node. When the user clicks on the node, I want to expand / contract the … |
 | Hi, For retrieving Data from your database: [SQLDataAdaptor](http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.aspx) [SQLDataReader](http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.aspx) For running commands on the database such as Inserts and Updates: [SQLCommand](http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx) For Connecting to a database: [Connectionstrings.com](http://www.connectionstrings.com) |
| | Sorry, but a web based application and a desktop application are two different things. Do you mean you want the clients to be able to install the application from a web site? or do you mean create a web enabled / web based version of your application? |
| | Hi, I haven't a clue where to start on that one, maybe you should post under the Hardware & Software forum - it sound like the issue you have is hardware related i.e. how do you read which pin is live |
 | Show us what code you have so far and where it is falling over/ you are stuck...  |
| | Re: Graphs in ASP Hmmm... I once did a fairly good bar chart using html tables and coloured table cells. I made a borderless table containing rows of twenty cells (each cell = 5%) (I didn't have to be too accurate) Then for each thing I was displaying I calculated the percentage of the …  |
 | First are you sure there is definately a table named **Personal_Details** in your database? If so try using **[Personal_Details]** instead of just **Personal_Details** access may not like the table name not being bracketed off. Also, (because I know others will point this out,) it is a bit of a security … |
 | Hi, Have you tried running in debug and doing watches on newpass and passwordchange? Maybe newpassword1.text is empty? Also how are you running the passwordchange query through a sql command? could you show us the code where yu execute the query?  |
| | Hi, You should just in case also convert your search string to lower to ensure both the search string and the string being searched are in the same case. Why not use Instr? IF Instr(StringToSearch, lcase(trim(Textbox1.Text))) <> 0 Then |
 | Do a search for the following (both Google and here): Dataadaptor Datareader SQL |
| | Hi, For people using a Microsoft SQL Server database: 1. Don't build queries on the fly - use only stored procedures, it forces you to use parameters and leads on to point two: 2. Use a dedicated SQL account for your application that has only has execute rights on the … |
 | Hi, I think you are applying the cascade delete to the wrong table. You are altering the table Sample Customer to include a Foreign Key (Sample_Note_No) linked to Sample.Sample_Note_No but you are then saying if the record in Sample Customer is deleted, delete the corresponding record in Sample. Therefore SQL … |
 | Hi, Instead of `cmd.Parameters.AddWithValue("@Empid", TxtEmpID.Text.Trim.ToString)` I think you meant ` cmd.Parameters.AddWithValue("@Empid", Trim(TxtEmpID.Text))` You may also want to check that there is actually a value in the textbox first. |
 | Hi, I'm seeing lots of text values being passed in but no string delimiters e.g. 'Like you have sql ="INSERT INTO MYtable(MyField, MyField2) VALUES(" &MyValue &", " &MyValue2 &")" 'Example where MyField is a text (string type Field) and MyField2 isnumeric -spot the difference sql ="INSERT INTO MyTable(MyField, MyField2) VALUES('" … |
| | Hi, Run the code in debug mode and find the exact line that gives the error.. That's alot of code to go through! I'd say it is likely to be somewhere you are running a SELECT statement based on a WHERE clause and an empty or null value is being … |
| | Hi, Could you post what you have so far? What you want to do is to select the last record entered into the text box for that person hint: sort your query by person and date or record id in descending order. |
| | Hi This site will give you the connection strings to required to connect to most databases, [ConnectionStrings.com](http://www.connectionstrings.com). You need to connect to the database via ADO (in this case using SQL native connections) - I'm assuming as you have posted on a VB.net forum you are using VB.net as your …  |
 | Hi Why use PHP? Why not VB.NET > MySQL? |
| | Hi, Try doing something like this: Dim ConFunnelLocation As String If trim(Form_Funnel_Report.Combo_Funnel_EBU.Text) <> "" then ConFunnelLocation = "C:\Database\Funnel\" & trim(Form_Funnel_Report.Combo_Funnel_EBU.Text) & ".xls" else msgbox("Please select the excel sheet") exit sub end if |
| | Hi I suspect it could be this line: `If Me.TbmembersTableAdapter.ScalarQueryCardID(cardid) Then` You say the `.ScalarQueryCardID` is just returning the CardID as a string? Then I think you should be using: ` If Me.TbmembersTableAdapter.ScalarQueryCardID(cardid) <> "" Then` Without knowing more about `.ScalarQueryCardID` I can't really comment. |
| | Re: LIST BOX `object.Remove({Index | Key})` In this case `object` is your listbox, `Remove` is of course what you are doing to the listbox, now you can either specify the `Index` i.e. the position of the item in the listbox that you wish to remove or, the `Key` of the item which really … |
| | Hi, Have you tried this? Do you have any code? lots of examples here and on MSDN website about using datagridviews.. |
| | English, Some Scots dialectics (not Gaelic), some French and currently learning Irish (Irish Gaelic,) from my wife and child (I'm from Scotland but I live in Ireland and my kid goes to Gaelscoil) also my dog only responds to Irish commands (We got her as a rescue and noticed one …  |
| | Hi, Do you have access to the source code of the class? Is the function `ReturnNewStockodes` public in the class? What should the `ReturnNewStockodes` return i.e. a single clsStockcode or a list of them? Stockcodes = mag.ReturnNewStockodes("admin", "password") Would imply a list of clsStockcodes where if you only expected a … |
 | |
| | Re: UPDATE SQL PROB Hi, Looking at your code, I can only see two possible reasons for a syntax error: 1. You are passing strings in for every field you are updating, are all the fields in the database definately string types? 2. txtUser.text is either blank or has a value that doesn't match … |
| | Would you walk into a bakers and ask for a free loaf of bread? Would you expect a builder to put up a wall for nothing? Would you ask an accountant to do your tax audit for free? Then why ask someone here to do their job for you for … |
| | After six pages I'd like to point out that I now understand the need for automatic doors! If you ask me who I am: 1. I'm George 2. I'm Scottish 3. I'm British 4. I'm a European 5. I'm a Human I'm not now or will never be English. Quick … |
 | Hi raajsj, I think what JorgeM is sugesting is that you have a go at coding it and let us know where you hit problems... start by writing breaking down what you want to happen into a flow chart then for each stage of the flow chart try to write … |
 | Re: Databases Have a look at this thread... http://www.daniweb.com/software-development/vbnet/threads/446697/network-applications-in-vb |
| | Re: update table Hi, You need to apply an UPDATE statement. You can either define one for your adapter via the UpdateCommand property ([OLEDB DataAdapter.UpdateCommand](http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbdataadapter.updatecommand.aspx)) Or run an Update statement via a OleDbCommand |
| | I think you want this: IF not(EVENT_NUMBER.Text ="" Or person.Text ="") And Event_ASSOC2.Text <> "Stolen" then 'Call your create excel file ElseIf Event_ASSOC.Text ="Stolen" And ORIGINAL_VALUE.Text ="" then messagebox.show("Property listed as stolen requires a value", "Warning", Messageboxbuttons.ok, MessageBoxIcon.Error) ElseIF EVENT_NUMBER.Text ="" Or person.Text ="" then messagebox.show ("Person and Event Number … |
| | Use settings... |
| | Hi, I can't see any loop in your code... What I see is the following: 1. You only do anything with the `recips` array when `intReply` = 250 2. When you go into that bit of the code, `recipCount` = 0 (unless changed somewhere else) 3. You build your command … |
| | Re: Birds in Space Hmmm Interesting - from years of watching the **Muppets Show** I can inform you that **Pigs in Space** seem to bumble from one funny adventure to the next... While Swedish Chefs are obsessed by chickens |
 | Hi, I always install SQL first. I do this because in the past I got caught out by installing VS first then trying to install SQL server and Management Studio and I couldn't... I think it may have been on VS 2005 but it could have been 2008. Anyway it …  |
| | I think he is running the UPDATE to test if he has opened Access in Read Only mode. As Ancient Dragon says, the data will only be altered if you run an UPDATE, INSERT or DELETE query so don't!  |
| | Hi, First of all I would not use firstname to identify the record. Say you have 3 people in your database John Brown, John Green and John Smith and you want to update the John Green record you will end up with 3 identical John Green records. Give your employee … |
| | Hi, You just need to modify your code slightly... in your SQL string, LIKE expects a value after it, you wish to use the parameter @Input to supply this value but because you are placing the parameter inside a string '%@Input%' the SQL literaly thinks find a record where lenscode … |
 | Hi You may want to use a dataadapter instead of a datareader. Datareader is a forward only connected recordset. Datadapter will give you access to a dataset which alows you to go back and forth and is disconnected. |
| | Hi Unfortunately there is no try catch block in VB6... You have to go back to the good old fashioned **On Error** Do you want to handle the error in your code? or are you trying to figure out where it occurred? If you're handling in the code you have … |
 | Hi This wouldn't call an error but I was wondering why you did this: If File.Exists(path) = True Then Exit Sub ElseIf File.Exists(path) = False Then .... End if Surely if File.Exists is not true then it is false... i.e. why not just "Else" I'm just wondering would the way … |
 | Hi, Row 11 could be different in some way did you manually populate the table? Is there a chance there is a leading or trailing space for example ("United" vs "United ")? Are the team names in the same case ("United" vs "united") If you remove the clause about the … |
| | Re: Recording Data @IsaacMessi10 What happened did you get an error? What did it say? Show us your code... |
The End.