Search results for query: *

I am trying to concatenate 2 values and place another on the next line: This is what is coming up: <SliceLabel textType="LD_TEXT_PERCENT"/> This is what I want to do: <SliceLabel textType="LD_TEXT" <New Line> "LD_VALUE" || "(" || "LD_PERCENT" || ")"/>

Hello, I am new to Oracle 8 and would like to know if anyone has ever come across this problem: Just before the sql is executed i want to pass it part of the SQL statement: function BeforeReport return boolean is begin :P_PrevYear := :P_CurrYear - 1; IF :P_Gender_Selection = 'Female'...

Microsoft ODBC Driver For Oracle Version 2.00.00.6325

I am using: rs_ROE.Open strSQL_ROE, curConnection, adOpenDynamic, adLockPessimistic Any other suggestions? Marcel.

I do not have an error. This works fine. The problem is that it does not update the database with my changes. I can see the record being changed but it does not update the database after the program ends. Marcel.

I am having such a problem with ADO that I need some help. I must be looking at this problem to close and can not see the obvious. Here is the code: Private Sub cmdUpdateEI_Click() Dim rs_CHH As Recordset Dim rs_ROE As Recordset Dim strSQL_CHH As String Dim strSQL_ROE As...

I get an error 1200: DB OPEN.&nbsp;&nbsp;This is a error from my application (User Programmed Error).<br>The following is the code I am using.&nbsp;&nbsp;We have an Oracle D/B on a Unix platform running NT 4.0 SP5.<br><br>Public Sub DBOpenConnection()<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim...

Hello,<br><br>I am running VB 6.0 and NT 4.0.&nbsp;&nbsp;I can get my VB application to work on Win 95 but not on NT 4.0.<br><br>Is there something special that I need to install or include when I package my application for NT 4.0?<br><br>Is there anyone out there working on such a...

Hello Everyone,<br><br>I am using listview to display data and am getting a <br><br>13: Type Mismatch error<br><br>I was wondering if anyone knows where there are any good examples for me to use as a guidline.<br><br>Here is the the code that is causing me the...

It works fine now.&nbsp;&nbsp;Thanks.<br><br>I tried the mdiform and it worked, then I copied that to my project and added the child forms and it worked fine.<br><br>I think it was copied form some other version.<br><br>Marcel.

I am experiencing problems when I call my child form.<br><br>I walked through the entire code line to line.<br><br>The child form does not show.&nbsp;&nbsp;I hide the active form then show the child form.<br><br>Can anyone help me?&nbsp;&nbsp;There must be something I am not setting.<br><br>Oh...

My name is Marcel Beals and I currently work at OCAS in Guelph (Ontario).<br><br>I would like to know what if any are the limitations of ADO in Oracle 8.x ?<br><br>Also can I still run simple D/B queries with Oracle 8.x and ADO?<br><br>Microsoft does not seem to have any idea on...

Set rsAudit = conODBC.OpenRecordset(strSQL, dbOpenSnapshot)<br><br>My application goes through this line of code once but when there is any type of D/B activity such as update or delete then the application goes into la la land on this statement.<br><br>Can anyone help?&nbsp;&nbsp;I am looking...

I can not use VB5's Grid because their are UNBOUND's being used and when I port the System to VB6 the grids are removed from the form.<br>Can you tell me how to get around the UNBOUND part?

I hope I am not stuck.<br><br>This is the problem:<br><br>I inherited a VB5 (E) system.&nbsp;&nbsp;I am trying to convert it to VB6 (P).&nbsp;&nbsp;There are 3 DBGrid's.&nbsp;&nbsp;I have tried to convert them without changing how the Oracle D/B is accessed.&nbsp;&nbsp;I may have hit a road...

Can anyone tell me how to transform a DBGrid to a DataGrid?<br><br>I have been trying and trying.<br><br>We went from VB5 (E) to VB6 (P).<br><br>If someone can send me some simple code that would be great.<br><br>I am trying to pre-load the DataGrid so when I do a SSTAB to that form the data is...

User Defined Type Not Defined<br><br>Can anyone help.&nbsp;&nbsp;I am trying to just open an Oracle D/B.<br><br>If you can shed some light on this error I would be grateful.<br><br>Marcel.

Can anyone tell me what to look out for?<br><br>Is there software already out there that will do the conversion?<br><br>The original program was written in VB5 Enterprise and I would like to convert it to VB6 Professional.<br><br>Help anyone.<br><br>Marcel.