Search results for query: *

Is there a way i can create DTS package where i can get files from previous day. I am doing this process manually through IEW everyday. I want to schedule this package so that it can run on its on and i can get files from previous day. I am using sql 8

I am using VB 6 with SQL 8.I want to update 2 col on my table. I am doing something like this .. Gives me syntex error. I am not sure if i can use alias in update statment , Is it possible to update 2 col at same time ... update laborefficiency l set l.itemno = b.itemno from baandirecthrb19...

I am doing something like this in my select statment Query -1 SELECT Indirectlabcode.Labcode, emplhrdtltest.shiftnumber, emplhrdtltest.jobnumber, SUM(emplhrdtltest.totaltime) AS Expr1, emplhrdtltest.[date] FROM Indirectlabcode INNER JOIN emplhrdtltest ON...

Hello, I am using VB 6.0 with SQL 8.0. Everyday i need import file from different database. I want to write a query so that i dont have to go through this wizard everyday. I always get previous day file. I need to ignore some of the fields while i get data through IE - i dont know how...

I am using VB,SQL and CR 8.5. I want to export my reports to Excel sheet, i am able to do that but when i export data in excel sheet i get one extra raw in between 2 raws. HOw do i fix this problem. Thanks.

I am using VB 6.0 with SQL 8.0. I want to convert string to number one of my field in table. I am doing something like this. EMPNo is string in table, i want it to be numeric. "select jobnumber,substring(empno,3,8)as empno,shiftnumber,line,date " & _ "From empldtllab &quot...

Hello, I want to give some status or progress bar to user while they are searching the records.

I am getting syntex error 'Missing operator' in this query SELECT DISTINCT dbo.ttdilc101201.t_clot AS Lot, dbo.ttdilc101201.t_cwar AS Warehouse, dbo.ttdilc101201.t_cprj AS project, dbo.ttdilc101201.t_date AS ItemDate, dbo.ttdilc101201.t_item AS Item...

I have 3 tables A,B,C. I have item common col in each table. I need to display all the items form table A and B after where conditions. i am doing something like this. SELECT dbo.ttdilc101201.t_item, dbo.ttdilc101201.t_cwar, dbo.ttdilc101201.t_loca, dbo.ttdilc101201.t_clot...

I want to show users some kind of text or search bar while it search through the records from database. Any examples? Thanks

One of the col in my table is nvarchar datatype & data is something like this. PQ1234,PQ34566,PQ1111. I want to remove PQ's from data. How do i update this col. Thanks

I am joining 5 tables. I get the result but few have dulicate entries not sure why. Please look at my query and tell me whats wrong. select v.tc03_date,e.date,e.empno,v.total_hrs,sum(e.totaltime)scannerhrs,e.labcode,l.description,t.tc01_name,r.dept from varreport v,emplhrdtltest e, timeemp...

Can i join tables from different server. I am trying to do something like this. Gives me error. select e.jobnumber, baandb.dbo.ttisfc001201.t_pdno, baandb.dbo.ttisfc001201.t_mitm, baandb.dbo.ttiitm001201.t_dsca from dfb_erp.baandb.dbo.ttisfc001201 , dfb_erp.baandb.dbo.ttiitm001201 ...

I want to get in and out time for each emp for each day. My data is somthing like this. id seq Date Time tothrs 5058 1 6/30/2003 7:13:00 AM 713 null 5058 2 6/30/2003 0 0 null 5058 1 6/16/2003 7:02:00 AM 702 null 5058 2 6/16/2003 3:28:00 PM...

I am writting this query to update TC03_date col. update varreport set tc03_date = convert(datetime,mydate + ' '+ substring(right(('000' + mytime),4), 1,2)+ ':' + substring(right(('000' + mytime),4), 3,2)) tc03_date col is datetime, datatype and mydate and mytime is varchar. Getting this error...

need to write few error handling in my form. When user tries to enter jobcode if it does not exists in database should give me error. How do i write error handling in this form. My code is something like this. Thanks Ann Private Sub cmdexit_click() Unload Me End Sub Private Sub...

I have created application with VB6,SQl2000 & CR8.5. When i run this app within VB project it works fine and i have created Package through PDW. When i run through PDW package gives me error Run-Time error 372 Failed to load CRViewer from CRViewer.dll. YOur version of crviewer.dll may be...

I have distributed application through PDW . It's been working fine on client machine. I have made few changes and add new forms and reports to original application. I want to include those changes in application. Can i update this changes with out PDW again ?? Thanks Ann

How do i find out which version of MDAC I am using ?? Thanks

I get this error "Run-Time error -2147467259.The control is busy downloading data". When i try to run application.. I am using vb6,sql2000,cr8.5 Thanks