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!

  • 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!

Search results for query: *

  • Users: AaronA
  • Content: Threads
  • Order by date
  1. AaronA

    Does Oracle have an IIF Function?

    The subject should explain my question, to reiterate I have a field say FieldA that is 1's and 0's (True or False) AN Example Select IIf(FieldA = 0,'Yes','No') From TableName; I have tried using double quotes too. I always get this error: ORA-00907: missing right parenthesis, and it points to...
  2. AaronA

    How do I send an SP a parameter?

    This may be a dumb question, but I have a book that tells me how to pass a parameter programmaticaly. (I have CR v8 and I am using VB 6.0). Anyway, the Book Says to use this: [Form.]Report.StoredProcParam(ParameterArrayIndex%) [= newParamter$] I have looked in the Object Library, but dont see...
  3. AaronA

    RE: Excel Automation how do I resize a column?

    I am trying to do some Excel Automation. I need to be able to change the width of a column in the Excel Workbook. Any Ideas on how to do that? I have tried this: Workbook.Range("A1").Width = 12 do you see what I am trying to do? It tells me something about an object is required, but...
  4. AaronA

    RE: Excel Automation Column Widths

    I am trying to do some Excel Automation. I need to be able to change the width of a column in the Excel Workbook. Any Ideas on how to do that? I have tried this: Workbook.Range("A1").Width = 12 do you see what I am trying to do? It tells me something about an object is required, but...
  5. AaronA

    AIM Icon replaces Shortcut Arrow

    Someone I work with has AOL Instant Messager on her computer. For some reason Yesterday, the Icon of the Little Man is on top of all he shortcuts on her Desktop, the arrow is missing, and we believe that somehow the Arrow has been replaced with the AOL Icon. She tried restarting her computer...
  6. AaronA

    Dockable Windows

    I would like to add some Dockable Windows to my MDI Form. I could I go about doing this?
  7. AaronA

    Reports with Stored Procedures

    I have asked this question before, but I dont think I got a straight answer. All I want to know is if it is possible to generate a report with a stored porcedure. I have tried to set a report's datasource to a recordset created by a stored porcedure and it doesn't work. It gives me an error that...
  8. AaronA

    I cannot report with my stored procedure

    Hello, I am new to Crystal Reports and so I've been learning as much as I can about all the methods and procedures that come along with Crystal Reports. However, I am trying to move from embeded SQL to Stored Procedures and this is how I go about doing that. I have a recordset that I set Equal...

Part and Inventory Search

Back
Top