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...
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...
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 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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.