Search results for query: *

I have code in VB6 that sends a web request to my server to pass and get data. Once upon a time it was working, but now it's not. To be clear, this is used in a VB6 app that is distributed to my customers. It passes a webrequest to a web server that I fully control. I mention this because I...

I am trying to convert my VB6 application to spanish. It's still in development, so it's not installed on many computers. When I install it on one computer in my office, it won't display accented characters. On several other computers, it displays fine. I've checked everything I could think...

My application allows users to send emails. Before anyone thinks it's a spamming application, it's not. This email functionality allows transportation directors to notify students about delays with their school bus routes. Because of this, there are times when many emails get sent...

I have approximately 800 icons I use in my app. I am trying to consolidate them in to a single dll so that I do not have slightly different versions of the icon all over the place. I tried several things, none of which are working out well for me. Originally, I had several forms (for...

I'm trying to print to a Zebra printer (p430i) from within VB6. I also need to encode mifare cards with this printer. All of the documentation and sample code for the mifare functionality is written in C++. I am trying to convert this code to VB6. typedef struct S_CARD_AND_TIMEOUT {...

Please forgive me, I'm an accidental network admin. My primarily role is DBA and occasional programmer. Unfortunately, we don't have a network admin, so I am stuck in very unfamiliar territory. Small company with 2 internet connections (separate providers). Each internet connection has a...

I'm working on a blog article, and I am curious to know how prevalent a particular "problem" is. Can you kind folks run the following query and tell me how many rows are returned? SELECT name FROM sys.foreign_keys Where is_disabled = 1 or is_not_trusted = 1 I don't need to see the...

Try this: select epn.EntityID ID, Max(BPh.AreaCode+' '+ BPh.Number) as BusPhone, Max(BFx.areacode+' '+ BFx.Number) as BusFax from EntityPhoneNumbers epn left join PhoneNumbers BPh on BPh.PhoneNumberID = epn.PhoneNumberID and BPh.TypeID = 71...

The parameter is varchar(20). Is it possible you are calling this with a userid longer than 20 characters? -George Microsoft SQL Server MVP My Blogs SQLCop "The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

You need to use a GROUP BY anytime you use an aggregate function. The HAVING clause allows you to put a filter condition on the aggregate. The simplest thing to try is to reproduce the entire select clause in the group by with the exception of the aggregate function. SELECT Distinct...

At the SQL Server PASS summit today, Microsoft announced it's next version of SQL Server (code name Denali). This version is available for download now. Details can be found here...

I am trying to determine the amount of memory used by an array. Specifically if it's an array of user defined types containing strings. Using this code as an example... Option Explicit Private Type Person Id As Long EyeColor As String ShoeSize As Single Name As String End...

I've created a user control that is causing me some problems. If you start a new VB project and put a standard picture box, image box, text box, etc.... on the form, and then put debug.print statements in the click and DblClick event handlers, it appears as though the click event always fires...

I am trying to automate an ftp process and I am having a problem. I want to download 3 files from another companies ftp server. They have given me a username and password that I use to access their ftp server. Since I want to automate this process, many (if not all) of the 3rd party ftp...

I have a customer that is trying to send me some map files. She is using ESRI tools (arc something or other) version 9 (I think). She has data in one of the State Plane projections, and I need the data in WGS84 projection. Since I am not familiar with any of the ESRI tools, I don't know how...

I "modified" the API call slightly, and it seems to work. Basically, I am trying to use this API with a map (latitude/longitude). I got tired of getting confused about the top/bottom, min/max weirdness, so I created an alias for the API call and a 'different' rect structure to suit my needs a...

I recently bought a new computer. My old one had 2 dual video cards, and I had 3 monitors connected to it. (spoiled, I know). My new computer has 1 dual monitor video card, so it was super easy to connect 2 of my monitors to it. The 3rd is giving me problems. I removed one of the video...

I've been having a problem loading my VB6 project lately. I'm hoping someone recognizes the problem and can help me out. When I attempt to load one of my projects, I get an error. It says, "Errors during load. Refer to 'C:\folder\frmWhatever.log' for details. When I look at the log file, it...

Without running these queries, predict the output. If 1/0 = 10 And 1/1 = 0 Select 'True' As Query1 Else Select 'False' As Query1 If 1/0 = 10 And sqrt(1)=0 Select 'True' As Query2 Else Select 'False' As Query2 -George "The great things about standards is that there are so many to...

I was just experimenting with the ParseName function and discovered something a bit unexpected. I thought I would share (but in the form of a teaser). Without running the code, what do you expect the output to be? Create Table #Temp(Data VarChar(50)) Insert Into #Temp Values('Easy Answer')...