- Strength to Increase Rep
- +10
- Strength to Decrease Rep
- -2
- Upvotes Received
- 213
- Posts with Upvotes
- 171
- Upvoting Members
- 110
- Downvotes Received
- 6
- Posts with Downvotes
- 5
- Downvoting Members
- 5
Been in IT for years. It never gets old. If your problem is solved, be sure to mark your thread *Solved*.
- Interests
- Work, computers, music. GTK+ C programming. Dart and Flutter. Unusual operating systems.
- PC Specs
- Dell XPS 8920, 32Gb memory, 4Tb worth of PCIe and SATA NVMe drives, Intel Core i7, Linux Mint.
655 Posted Topics
 | "It is the responsibility of every citizen to question authority." -- Benjamin Franklin  |
 | I'm eating home-made beef stew. Definitely worth the effort. Two lbs stew meat, 1 head of celery topped and sliced, 5 carrots sliced, 5 good-sized potatoes cubed to 1 inch, 1/2 a yellow onion diced, 1 tbsp parsley, 1 tsp salt, 1 tsp black pepper, 7 bay leaves, 1/4 tsp …  |
 | "It Might Get Loud" "The Little Mermaid" "Star Wars (A New Hope)" "Spirited Away" I have a daughter and a son. Guess which movie I watched with which kid? :-) |
 | Re: Jokes Two Database Administrators walk into a NoSQL bar. They leave because they can't find a table.  |
 | Personally, I cut over to Linux Mint several years ago. When WinXP support sunsetted, I didn't have the cash to get a new machine to run Win7, and I thought my old Dell Dimension (maxed out at 2Gb of memory) still had some life. So I just took a deep …  |
| | I'm assuming that you have this code in the Form_Load event? If so, you can't use SetFocus until the form itself is visible (Reference: [Microsoft VB6 Documentation](https://msdn.microsoft.com/en-us/library/aa244175(v=vs.60).aspx)). One method to work around this is use a "sub Main" to show your form, then set all the relevant stuff afterward. So, … |
 | Please note that the asterisk wildcard character should be used for MSAccess SQL. The percent sign, as in @JxMan's example, is the wildcard character for MS SQL Server. There are other wildcard characters that are used for different purposes. You can find a full list of them in the MSAccess … |
| | You are very close. The last dynamic query returns SQL statements, not results, like so: Line 1: SELECT ISNULL(SUM(amount),0) AS a FROM table1 Line 2: SELECT ISNULL(SUM(amount),0) AS a FROM table2 Even if you execute them, it doesn't quite give you what you need. You need to also UNION them … |
| | This error usually occurs when you are referencing an identifier that has no context within your query. So, for instance, if you say select myTable.myCol1, MissingTable.myCol2 from myTable it will give you the same error..."MissingTable" has no context...it doesn't appear in the "FROM" clause. If you want to update one … |
| | Your best bet is to store each of the sets in a single string, then use the "SPLIT" function in VB6 to parse the sets into a series of one-dimensional arrays, then iterate through the arrays. Here's a crude example to get you started. You might have to play with … |
| | Re: Love Poems I have to say I'm not much of a poetry afficionado, but I do know a good source that might help you with the chasing...go to www.gutenberg.org. Lots of books (literature, poetry, a whole bunch of great stuff!) and it's searchable. And no, I'm not the owner of the site...but … |
 | |
| | If you know what the filename is for the old file, you can just use a FileSystemObject like so: Dim fs set fs = CreateObject("Scripting.FileSystemObject") ' ' do whatever you need to here using the FileSystemObject methods ' set fs = Nothing and rename the file, then save the new … |
 | Granted. Everyone is dead. Very peaceful. (ewww...even I think that's icky) I wish I had an independent income of $100,000 US per year. |
 | I actually wasn't able to get your second function to compile, but I tweaked it a tiny bit. Final result looked like this: (renamed the function so it wouldn't stomp on anyone's original) create FUNCTION [dbo].[StockNumbers2] () RETURNS @SequenceNumbersOfShares TABLE (StockNumber BIGINT) AS BEGIN DECLARE @MIN BIGINT DECLARE @MAX BIGINT …  |
 | |
| | Look at the "Substring" function in the documentation. Use a "where" clause that specifies to return all rows where the first 6 positions of user = 'ZZZQQQ' and then update user = substring(user from 7). |
| | Re: Joining 8 Fields At the risk of reviving a stale thread... It looks like you aren't including a "FROM" clause. You have a bunch of joins but never include the anchor table. I reformatted your code and included a comment that might make it clearer: SELECT TOP (1) CONVERT(varchar, tmpRptAssetEvent.EventTimeStamp, 120) AS 'DateTime', … |
| | At the risk of reviving a stale thread... Since we can't see your data division, it's kind of tough to tell what's wrong. However, your logic says that if the value in EMPL_GNDR = 'M' then do something...otherwise tally the record as 'FEMALE'. So that means if there's garbage in … |
| | Does "lbl1" refer to a Label control on a form? If so, you should be setting "lbl1.Caption" instead of "lbl1.Text" equal to your value. If this is not the case, we need more information about your application before we can provide guidance. |
 | First a little background...when the SQL Server services get installed, they have to have a security context that has sufficient permissions on the local server to do what it needs to do. Usually the person doing the installation has local administrator permissions on the server, but it is usually NOT … |
| | Where is the object "conn" set? Are you supposed to be using Module1 as your ADODB connection? If so, then you need to specify that in your recordset open statement.  |
 |  |
| | You can do highlighting by setting the CellBackColor property for each cell in the row. Here's a little code snippet that will steer you in the right direction: Me.MSHFlexGrid1.Row = 10 For j = 0 To Me.MSHFlexGrid1.Cols - 1 Me.MSHFlexGrid1.Col = j Me.MSHFlexGrid1.CellBackColor = vbGreen Next j Hope that helps! … |
| | This might work. I didn't get a chance to test it on mySQL but it uses ANSI standard SQL and it works in MSSQL just fine...you might have to tweak it because of the square brackets in the name since "user" is a reserved word in MSSQL. update a set … |
| | For me, not so simple to explain. First some background: I used to do some Win32 graphics programming. One of the methods used in animating is heavily using a technique called a Bit Block Transfer. Basically, you reserve an area in memory, do some manipulations like setting pixel properties, then … |
 | Interesting little problem. I was able to get a result set that I think is what you're looking for, but it shows all the detail lines. It does, however demonstrate the technique, so I hope you can use it as a starting point for further refinement depending on your needs. … |
 | Re: Expiration vb6 When you create your expirationdate string from the values from combo2, combo3 and combo4, it comes out with no formatting. The default value returned by the datepicker is a formatted date. Here's a little code snippet that you can use to demonstrate this: Debug.Print "Datepicker: " & datepicker Debug.Print "expirationdate: … |
 | Guitar (electric, acoustic, classical), baroque recorder, harmonica |
| | |
| | Let's first explain why it DIDN'T work then suggest a possible solution. The SELECT statement is just that. It stands alone inside your stored procedure. It's job is to return a result set. The UPDATE statement is not related in any way to your SELECT statement. So, if you look …  |
| | Track and Field (I was primarily a pole vaulter, but I was also a decathlete), basketball, long-distance running.  |
| | Um...round is a shape, right? :-) Just kidding. I usually just take a daily walk in the hills near my home. I have some nice little loop trails I follow that are between 2 and 4 miles. I've found that if I have my dinner, then have a post-prandial stroll, … |
| | Not much to go on here. Which statement times out? Are there indexes on your tables to help with the selection? What is the timeout value set to on the connection? What is your server memory? Are there governor policies set? Does the insert cause an autogrow condition on the … |
| | Yes it does. There is a Camera API that you can force to take pictures using the "takePicture" event. Of course, you'll have to create your own stream objects to handle the input and (probably) to save it to the SD card. Here's a link to a great tutorial that …  |
 | You're probably better off using FileSystemObjects to read your file. The problem with the approach you're using is that the program tries to reserve string space equal to the size of the entire file. If there are other programs or services running on your machine there might not be enough …  |
| | If I may ask a silly question, does the routine fail on the first time through the loop, or on a subsequent time through? I ask this, because your logic appears to do this: 1. Start the loop 2. Set the "selected" property to "True" in every case 3. Check … |
| | I would say that you are checking the rowcount returned from the select statement, rather than the actual value of count(*) that is returned. If you get a hit on that username, you'll get one row returned, and the value of count(*) will be 1. If you DON'T get a … |
| | Hello, fellow DaniWebians...it is I, BitBlockTransfer, returned from project death-march land and ready to contribute again. I'm happy to be back! |
| | Here's an ugly script that will illustrate the technique. Is it the best way? Who knows. But it works and should do what you want it to do. declare @myString varchar(1000) select @myString = 'Here is some text that contains more than 160 characters so I can test the line … |
| | Re: SQL Question You may want to re-think the order that the tables appear in the join chain. You ALWAYS want to start with the table that will have the interesting values. In this case, tblOutlet has all the retailers, right? So, put that first, then LEFT JOIN tblVoucherIssues LEFT JOIN tblVoucherHeader. Then, … |
| | I went from knowing nothing at all about Android development to completing and rolling out a fully operational IT-on-call-service-rotation app to our company...complete with phone, calendar and e-mail integration. Still doesn't do geo-location, but I'm working on that. Now my boss (bless his innocent executive heart) wants me to do …  |
| | This response is a little late in the game, I guess. All the advice above is good, but sometimes translating that into practical knowledge can be...challenging. Many entry-level programmers I've worked with have a problem with humility. I know I had the same thing when I was first starting out … |
| | The problem is that you have to use Integer.toString() to convert your int "extra" to a String type before you can use TextView.setText(). Line 9 of Result.java should read: tv.setText(Integer.toString(getIntent().getExtras().getInt("Result"))); Hope that helps! Happy coding!  |
| | You are so close! The problem is that on lines 9 and 10, you don't have a value calculated for variables "product" and "weight". Move those two lines down below lines 11 and 12 and it should work fine. Hope this helps! Happy coding! |
| | Just out of curiosity, are you getting your strings on line 181 from strings.xml? If so, you have to use something like this to actually get the strings in question: tvLocation.setText(getResources().getString(R.string.streetAddress) + " " + address + "\n" + getResources().getString(R.string.city) + " " + city + "\n" + getResources().getString(R.string.country) + … |
 | I can only advise in the context of Android (sorry...I'm still learning Objective-C and iOS) but I do know that you use a MapController object and use the methods "animateTo" to position the center of the map and the "zoomToSpan" to show how much you should zoom in. Not sure … |
| | It's tough to advise you when you haven't posted your code. The simple answer is that when you receive your onItemClick event, you just look at the position (argument 3) that is passed back. That tells you the position inside the GridView (argument 1) that was clicked. You can examine … |
 | Re: sql formula You could always create a temp table to hold the results of your pivot, then join that back to your original table...if I understand what you're asking for, that is. |
 | Network administrators make sure the network is available and secure so the machines and users can communicate with each other appropriately. Database administrators make sure that structured application data is available, secure, uncorrupted, backed up, etc. so the users, applications and machines can see it. In both cases you'll work … |
The End.