Recent content by JohnKIT05

I need to declare a new variable called @DATES to have a date field called INV_DATE from the table to be moved to the new variable field for comparison. I need to do this because while having the INV_DATE in the CASE statement in the SELECT statement, I will need to include the INV_DATE field in...

I forgot to mention that in Dreamweaver I am using ASP.NET VB.

I am using Macromedia Dreamweaver MX 2004. I am able to connect to the web server which is MS Server 2003 using the SQL server conection. Somehow I was able to figure that out and now I am not sure how I did it. But I am getting the 'Http error code 500 internal server error' on a different...

Hey bassguy and Sheco, You both are right. I happens to find the answer while I was searching the index in the help of the SQL Analyzer when you both replied. That was the answer. Thanks, John Hey bassguy I play guitar too. Keep rockin!!!

Few of my databases has records of <Null> data in the fieldnames. I tried several ways of writing a code to delete those records but it will say '0 records affected'. Here is an example of my code to delete the records with the <NULL> data: USE PurchTransf DELETE FROM Whse2Data WHERE UnitsMTD...

Catadmin and JamesLean, I found there were a extra ')' shown. So I removed it and no errors. Still no data. I will have to do more investigating. Something is going on. John

Catadmin and Jameslean, Thanks for your help!!!. I apprecaite your time in helping me out. Catadmin ( Sorry) I ended up using JamesLean code becuase I did not come across any errors and I learned alot from you both. But ..the search is not finding any same data. After some investigating, I...

Catadmin, That makes sense but it does not like the receiving object name. I checked to be sure it is spelled right. Show below the lastest code and error: UPDATE PurchaseOrders SET PurchaseOrders.RecDate = (Select receiving.[appointment date]FROM receiving) FROM PurchaseOrders INNER JOIN...

I removed the dbo_ from the INNER JOIN and ON and still it dosplays an error on the INNER JOIN. I also tried removing the database name which are TrafficDaily and ReceivingLog and no luck. Should I include the USE statement. If yes, will it allow me to incluse two databases in a USE staement?

I know how to use the inner join command on linking tables within a database but how will be able to link data between two different databases? The code I have shown below is receiving an error which is "Server: Msg 208, Level 16, State 1, Line 2 Invalid object name...

Artie, I read the Mid statement in the new book I bought last night and it makes sense. This time no errors but the change is not working. The 5665 is still there. Here is the new code: Sub Openfile() Close #1 Dim fs, f, line, fread, Maxsize, Nextchar, Mychar Dim i As Single Open...

Artie, Last night, I decided to buy a book on VB 6 so I can understand the inout/write statements. The first line of the edi files looks like this: ^^BEGVN5665 I want the VB program to change the first line to this: ^^BEGVNAMPHIRE John

Artie, Sorry if I am driving you crazy haha. The file is a text file. What I am trying to accomplish on this VB program is to replace numeric characters starting on the 8th position to alpha. Any numbers starting on the 8th position to be replace with "AMPHIRE". John

I relaize I made a mistake in the loop but still the same runtime error. Latest update shown below: Sub Openfile() Close #1 Dim fs, f, r, fread, Maxsize, Nextchar, Mychar Dim i as Single i = 0 Open "c:\850whsetest.tmp" For Input As #1 Input #1, r Do While i < 14 Seek #1, i Mychar = Input(1...

Sorry to bother here but now I am getting a new runtime error. I am learning I must admit. The error is 'Runtime error 63 Bad record number'. Here is the new changes I amde shown below: Sub Openfile() Close #1 Dim fs, f, r, fread, Maxsize, Nextchar, Mychar Open "c:\850whsetest.tmp" For Input As...