Search results for query: *

Thanks for the help, both of you! --Aaron

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...

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

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...

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

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...

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

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...

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...