Recent IT Questions

1 - 8 of 8
<<PREVIOUS 1 NEXT>>

sql update command to change text

I need to modify all characters within a text field. Some of the fields will contain 2-5 characters, others will contain 20-200 or more. The field is defined as Text 4000. I want to replace every letter with "K" We have a Select statement: select...

View Answer   |  Sep 24 2009  4:04 PM GMT
SQL, Oracle 9i, Update
asked by Mji

  50 pts.

sql update command to update a date-of-birth

I need to change the date-of-birth MONTH to May and DAYS to 15 without changing the YEAR

View Answer   |  Sep 24 2009  2:41 PM GMT
SQL Oracle 9i, Date format, Update
asked by Mji

  50 pts.

0 Row affected

Could you please assist with the following? UPDATE dbo.[Elution_Report_Template] SET [Elutriation_Set_SqM] = dbo.[Elution_Report].[Elutriation_Set_SqM], [Elutriation_Pump_SqM] = dbo.[Elution_Report].[Elutriation_Pump_SqM], = dbo.[Elution_Report]., = dbo.[Elution_Report]., =...

View Answer   |  Jun 29 2009  5:32 AM GMT
SQL, Update, Query
asked by GPNel2006

  75 pts.

OPNQRYF

I HAVE A CASE LIKE THIS IN CL/400 OPNQRYF FILE((MADE07/GLM0120)) QRYSLT('(GLFINP *NE + 99) *AND (GLPRDC *EQ "AR" *OR GLPRDC *EQ + "SW" *OR GLPRDC *EQ "WP" *OR GLPRDC *EQ + "LR" *OR GLPRDC *EQ "MD") *and (glbrnc + *eq ("' *CAT %substR(&bc...

Answer Question   |  Jan 1 2009  7:00 AM GMT
Update
asked by Zilan

  85 pts.

update a field from a file with a field from a selection from two files

Hi! When I try this: update fileD d set d.value = (select c.value from (select b.key, b.value from fileB b where b.key not in (select a.key from fileA a)) c where d.key = c.key) I get the message "Null values not allowed in column or variable VALUE." on the other hand, when I do this selection: ...

View Answer   |  Apr 29 2008  11:03 AM GMT
SQL, Update, SELECT statement
asked by Mr.

  70 pts.

Updating Dreamweaver Templates

Can anyone suggest a reason why my templates are not updating pages based on the template? I create a template in the usual way. Create a page based on the template. I go to the Assets Folder, click on edit. when I edit the template it asks me if I want to update pages based on the template. For...

Answer Question   |  Jan 2 2008  1:24 PM GMT
Dreamweaver, Web development, Update
asked by Ken10k

  5 pts.

update single row error

This query returns a single row error while attempting to update the mfr_name_id in the property table with the values in the eqp_mfr_names table where property.mfrcode = eqp_mfr_names.mfr_code why? UPDATE property p SET (mfr_name_id ) = ( SELECT (mfr_name_id) FROM eqp_mfr_names WHERE...

View Answer   |  Oct 20 2007  2:43 PM GMT
Update, multiple row query
asked by Mandrews81

  0 pts.

Problem with Microsoft Update

Working with an XP SP2 machine, I get notices that updates are ready to download. I choose them manually, but they never download. Next time I'm online, I get the same notices. Any suggestions greatly appreciated.

View Answer   |  Sep 26 2007  3:04 PM GMT
Windows XP, Microsoft Windows, Update
asked by NoHa11

  5 pts.

1 - 8 of 8
<<PREVIOUS 1 NEXT>>