Type: Posts; User: T2T2
Search took 0.01 seconds.
December 6th, 2006, 12:13 AM
For anyone who is interested, I have worked this problem and come up with the following solution.
Within my select statement I use Case statements to set up the 3 address lines.
December 4th, 2006, 11:18 PM
I was unsuccesful finding a thread on this topic to my surprise so I am sorry if I am doubling up.
I am using sql server 2000 to extract data from a software package.
This package contains 2...
August 16th, 2006, 09:38 PM
thanks for your posts.
The system I am working on is a customer relations management package (Goldmine).
The particular srectype code identifies sales rep activities
c - call
August 13th, 2006, 12:21 PM
I don't understand, what do you mean by -
"I would reccomend to do it function of the app logic"
August 13th, 2006, 12:07 PM
sorry I am not answering your question.
I am using 2000 at the moment, and I am having all sorts of problems.
You mentioned in your post that it is buggy, I am starting to loose...
August 2nd, 2006, 02:15 AM
Within the VS editor I used the Server Explorer to create a SQL Server 2000 connection.
I then incorporated the connection into the web form by dragging a table. This created a SqlConnection...
July 30th, 2006, 10:34 PM
I like your user id name.
I am only starting to appreciate (understand) datasets.
Your examples actually illustrated to me how sql can be employed with adaptors, which I will now...
July 26th, 2006, 12:20 AM
I should have added the approach I am taking to learn and develop a project. It is web form based.
In the early days of my VB6 learnings, I worked with bound controls off the editor.
July 25th, 2006, 01:43 AM
I will read through those links you suggest.
I am still thinking VB6 and RecordSet processing.
One process I will be programming will involve the user entering parameters which will...
July 14th, 2006, 12:09 AM
Ali thanks for the advice on the express version.
I had a look at the quick tour and got the impression it may not be able to connect to SQL Server Databases across network servers. It...
July 12th, 2006, 01:43 AM
:lol: Looks like I have a lot more to learn than I thought.
I purchased VB.net which has the framework 1.1
When I try to connect to my local sql server databases, I get an error saying this...
Thanks for the quick replies.
I guess the .net environment is more complex because of the integration of various facilities.
Installing VB.net on my laptop was very involved.
With my vb6...
I was looking for some guidance in this area.
I have been productive with VB6 on recent projects but have only experimented with ASP.Net and briefly with Asp Classic.
I am hoping to jump into...
June 10th, 2006, 08:42 AM
Hi, I was hoping to get some advice on Hex Editors.
I noticed there is a lot of commercial and free choices.
This thread caught my attention, as I am a VB6 programmer.
Do either of you use a...
March 21st, 2006, 05:05 AM
I downloaded the INIReader.zip file from the other thread.
I believe I do have windows authentication set, but have not updated my connectionstring? I'll check it out at work...
March 19th, 2006, 08:21 PM
if I understand your approach, you are suggesting that the user enters the server and sql server log in details to build the connectionstring statement at run time.
March 16th, 2006, 05:57 PM
our dba talks of "memory leaks" with respect to SQL Server applications.
I don't know what this means myself, but I assume that he has statistical diagnostics which indicate that...
March 15th, 2006, 08:04 PM
We run VB6 applications connected to SQL Server 2000.
The issue I have is that we need to move the databases to a different server from time to time.
Mainly for maintenance reasons, the DBA has...
March 14th, 2006, 07:46 PM
I am using VB6 to build custom processes for a software product going by the name of Goldmine.
The Goldmine documentation recommends access via Goldmine's Com Server.
It instructs you to add a...
February 28th, 2006, 06:53 PM
Thanks for the advice.
I have just been asked to consider Publications Subscriptions (PS).
So now i have to compare DTS with PS. ?
Great more documentation to read through.
I believe with PS...
February 27th, 2006, 11:19 PM
I have never used DTS, but I believe it is the tool for my current project.
We have regional databases supporting sales reps across the country. For the purposes of management reporting we want to...
February 18th, 2006, 08:44 PM
Yes, this code was written by a collegue and forwarded to myself.
I tested the code on his server (sydney australia) and it worked perfectly.
Unfortunately, here in Melbourne the server and my...
February 16th, 2006, 11:35 PM
Sorry and thanks for the help.
I guess that exposes me as a newbee web programmer.
February 15th, 2006, 05:39 PM
Peejavery thanks for your interest.
The code is based on 5 files (2 being .gif files to show left/right arrows for calendar month scrolling).
I will eventually embed this into a host...
February 15th, 2006, 05:33 AM
I have some asp code that pops up a calendar and allows the user to scroll months, and to choose a date.
The web form shows a start date and an end date.
There is a submit button, that calls up a...
Click Here to Expand Forum to Full Width