Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mjschroed

  1. mjschroed

    Getting "Syntax error in INSERT INTO Statement" error

    I figured it out. Turns out Month and Year have system values (?) so they have to be enclosed in []. This worked: INSERT INTO Occupancy ( UserProjName, DRSiRecordType, DRSiResultNumber, DRSsDescription, [Year], [Month], Amount ) values ('" & UserProjName & "'," &...
  2. mjschroed

    Getting "Syntax error in INSERT INTO Statement" error

    I just tried that but got the same error. Thanks for the suggestion though! "INSERT INTO Occupancy ( UserProjName, DRSiRecordType, DRSiResultNumber, DRSsDescription, Year, Month, Amount ) values ('135',10000,6,'Mall Shop GLA Occ. Area SqFt',2002,1,286316)" Melissa
  3. mjschroed

    Getting "Syntax error in INSERT INTO Statement" error

    I have created the following piece of code to update a database (I am kind of new at this) but it fails with the above error. If I put the insert statement into a SQL window with the right values - it works fine. Here is the statement: Dim UserProjName As String Dim DRSiRecordType As Long Dim...
  4. mjschroed

    Delete files by date

    Thanks! That worked great!!
  5. mjschroed

    Delete files by date

    Sorry - this may be a basic question but I am new to Solaris... I want to delete all the files in a folder that are older than a certain date. How do I do that? Thanks in advance. Melissa
  6. mjschroed

    New to Solaris - need a few basics

    Thanks for the help! I will check into those docs! Thanks! Melissa
  7. mjschroed

    New to Solaris - need a few basics

    Thanks Ken for your help! So far so good! On another note - can you recommend a good book to help me learn? I have some experience with HPUX but not solaris. Thanks! Melissa
  8. mjschroed

    New to Solaris - need a few basics

    I am fairly new to Solaris. I support an app that runs on it. I have two basic questions. First, in HP UNIX there is a command "top" that will show you what is processing and what kind of system resources it is utilizing. Is there something similar in Solaris? I have jobs that are...
See more

Part and Inventory Search

Back
Top