Search results for query: *

Dear all I have a vb connection string in my program which has been connecting to oracle 8.0 successfuly for months. Oracle has now been upgraded to oracale 9.0 and the connection string won't work. The DSN works successfully but when run through the program I get the following message:-...

thank you r937 it works....... Sandra

Golom What we want to see is the client number which is the key field on the record and the actual fields with the non-alphanumeric characters in. We did think of doing this in a while loop checking each character of the string but as we've got thousands of records we're not sure how long it...

Dear all We have data in a field within a table that has non alphanumeric characters in it. We want to be able to find these fields that contain such characters. How do we do this? We've looked up ANSI but to no avail as there are no examples on how to use this. Plus we can't find a table...

Dear all Our application needs to send an email. Originally we were getting a security warning telling the user that someone was trying to access their address book. We overcome this by downloading a dll called Redemption (thanks to technet). However, redemption seems to only work if outlook...

Angel you are an angel thanks alot Sandra

Hi In ingres sql you can type the command:- create table tt2 as select * from tt1 table tt2 will then be created with exactly the same properties etc as tt1. Is there an equivalent in SQL version 7.0. also in ingres you can do the following command :- insert into tt2 select *...

Thanks for that but I've never written a funtion before so I went into the help and it says that SQL 7.0 doesn't support user-defined functions. how do I create one?

I am trying to call a procedure in an insert statement. The procedure takes in two dates and outputs how many working days are between those dates. I then want to use the output in my insert. Sounds simple enough but I'm going round in cirles with it. here is my code declare @numbofdays int...

Angel Fantastic!! that did the trick. I also managed to do it using CURSORs so now I have two ways... which one shall I choose :) thanks for all your help much appreciated

Angel, Thanks for that, nearly there. This works if it was the same site but the sites could differ and their site_pay_no's differ. I will fiddle with it and see what I can do, thanks for getting me on the right track cheers Sandra

Dear all I am trying to insert into a table (0 to whatever number of records). One of the fields is incremented by one for each record. (It looks at another table and just takes the number and adds one to it). because my insert does them all in one go all records have the same number on them...

Hi all, Just a question regarding connections to a SQL database. I've always been told to open a connection, do what you have to do and then close the connection. However, a colleague of mine recently went on a course for VB and when she explained that we will be having a large number of...

thanks both, i'll take a look sandra

Dear all I am trying to send an email via a VB 6.0 program. The email is being sent but there are two boxes appearing for user intervention which I don't want. Apparently it is something to do with a security measure for viruses. Do you know what I need to do to stop these boxes from...

My collegue has written a VB application and I am testing it. I keep getting the above and it throws me out of the application. Not that bothered as I have now put the application on Terminal server and will test that way but I was wondering if any of you are experiencing the above and knows...

Two things - 1. Trying to format a money amount showing 2 decimal places eg if I put in £36 it is showing as that where I want it to display as £36.00 2. I want to show negative amounts in a cell in red. Does anyone know how to do this. It seems as you can do an entire row or column but not...

I have a file and the columns are of fixed length (cobol format). There are no delimiters in the file and I need to take it into SQL. I've looked at bulk insert but this needs you to specify the delimiter. I could copy it somewhere and edit it to insert delimiters but I don't really want to...

In access you can create a continuation form which will list all the rows of a record set and allow you to amend the records. Is there an equivalent control in VB. We've looked at MSHflexi grid and data grids but can't seems to amend the contents. Not sure if we're barking up the wrong tree...

I have a data combo box which consists of a record set. I want the user to be able to just choose what's in that list. At the moment it's letting the user put anything in that box. There must be a simple way of doing this, in access it is limittolist property on the object but I can't seem to...