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 Rhinorhino 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: *

  1. AaronA

    Does Oracle have an IIF Function?

    Thanks for the help, both of you! --Aaron
  2. 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...
  3. AaronA

    How do I send an SP a parameter?

    Folks, I guess I got confused as to what I was using. I am using the RDC Active-X control, which has different methods to do what I needed. Please Disregaurd this Thread
  4. 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...
  5. AaronA

    vertical scroll bars on a form

    You can in VC++. I would Suggest using an MDI form that contains the form you want to have scrolbars on. Hope this helps
  6. AaronA

    VB login to SQL Server

    Try this if nothing else works Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=SomeDB;Data Source=SomeServer The Integrated Security part is what you need I think. I created this by slapping an ado control onto a blank form and then generating a...
  7. 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...
  8. 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...
  9. 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...
  10. AaronA

    Dockable Windows

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

    Cannot Find Installable ISAM?

    Hey grh, I have had this problem before. It was while ago, so i am not sure exactly how I got it. My hunch is that you are trying to work with a controls data binding properties. I would try binding the controls programmaticaly. It might also have to do with some property that is an enum...
  12. AaronA

    Reports with Stored Procedures

    Thanks for the Input, I figured out what was going on. I wrote up a FAQ, for it called "Generating Reports With Stored Procdures" That should Explain it to anyone else who may have the same question. What happend was I have a connection object that the App uses and everything uses it...
  13. AaronA

    Generating Reports using Stored Procedures for Visual Basic Front Ends

    I have been working on this problem for a while now. I have finally found out how to make it work. The problem with Crystal Reports is that it cannot generate a report with a recordcount of -1. How is it possible to have a recordcount of -1 you might ask? When using a recordset, you can...
  14. AaronA

    Reports with Stored Procedures

    I just got off the phone with Seagate, the reason why it DOESN'T work is the fact that Stored Procedures return -1 as a record count, but any recordset that uses a forward only cursortype will return -1 as a recordcount. I've never heard of a Stored Procedure that wasn't forward only. The guys...
  15. 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...
  16. AaronA

    I cannot report with my stored procedure

    Ken, Yeah Acctually the '3' seems to be a optioanl variable, I've seen it used in a book before, but since I didn't know what it meant, I never Used it. So I am using RDC, that's good to know becuase Seagate Always asks me what I am using when I use their tech support. I am guessing that the...
  17. AaronA

    I cannot report with my stored procedure

    They are always recordsets, the first is an embedded SQL statement and the new one will be a stored procedure. So I think I am using the active data driver. But I when I create the report, I am using a *.ttx file (DDL file) to create the columns in the report. Also in the function call...
  18. AaronA

    I cannot report with my stored procedure

    Ken, Acctually that was what I was trying to do, using ADO I give a recordset to the Report.Database.SetDataSource method and it does a report. However, When I try to do it with a recordset derived from a stored procedure, it gives me that error. Thanks for your time. Aaron
  19. AaronA

    I cannot report with my stored procedure

    Ken, Thanks for helping me on this problem. I dont think I have that method available to me. I did a search in the objectviewer for "SetTablePrivateData" and couldn't find it. I am using v8 active-x control, that might be why. Also I am not familiar with Active Data Driver Is this for...
  20. AaronA

    I cannot report with my stored procedure

    Yes it is populated, I would run my function that returns the recordset, and I have used SQL Server Analyzer to check the results, they are the same. I am using the CRViewer Active-X Control. Also now that you mention if it was populated... I would check to see if the recordset was BOF or EOF...

Part and Inventory Search

Back
Top