Search results for query: *

I have Oracle 9i Database and 9iAS working ok now. Several computers running different applications connect ok to the db. I installed the Oracle client on a windows 2000 using the local administrator user, and when I try to connect with sql plus, says: "user credentials do not correspond...

Hi. I've just installed Oracle 9i client on a W2000 Professional and when I try to connect to the database I receive this message: TNS-12638 Credential retrieval failed. The error messages book says: Enable tracing to determine exact error. I don't know how to turn tracing on. My database is...

I am writing a program in VB and Oracle using OO4O. My program tries to add records in a database. I made a couple of programs using the syntax mydyn.executesql(sentSQL) and it works ok, but now I'm trying to use the methods of the dynaset. OraSession.BeginTrans mydyn.addnew...

Hi. I've just installed Oracle 9i client on a W2000 Professional and when I try to connect to the database I receive this message: TNS-12638 Credential retrieval failed. The error messages book says: Enable tracing to determine exact error. I don't know how to turn tracing on. My database is...

How do you "destroy" a Dynaset after creating it? I want to reuse the dynaset variable, and I don't want to have garbage in this variable at the time of re-creating it. Thanks in advance

I'm using dynasets in VB with OO4O. I have no problems using them, but I don't know how to 'destroy' a dynaset and create it again. This is the situation: .... do artNumber = NextArtToProcess() ' some function --- SQLsent = "select art, qty from stock " & _...

(posted earlier - 1 unsuccesful response) Hi!!!. I have a form and a subform in it. The form is to type in orders, and the subform the items of the order, it has unlimited number of lines. I generated these forms using the wizard a long time ago, and it has a lot of code in it, so I can't...

Hi!!! I have a form and a subform in it. The form is to type in orders, and the subform the items of the order, it has unlimited number of lines. I generated these forms using the wizard a long time ago, and it has a lot of code in it, so I can't start it again. I would like to add another...

Hi!!! I have a very simple table of products, identified by a reference number: Reference Text Description Text I need to retrieve the description of one product, but I don't know how to use the INTO clause in a SELECT statement. In many other programming languages the use would be...

Hi, everyone!!. I have a form with a subform. With this form the users type in orders, and in the subform they type the articles they buy, identified by a reference. I have 3 tables related: orders, order items and articles. I didn't put the field "description" from the table...

I have a form to capture product orders, which has a subform in it. Each line has: product number, quantity, price per unit, and the total of the line. It is like this: Order Number: _________ Date: ________ Client : _________ Line Prod.Number Quantity Price Total...

I have an order form with a subform in it. Each line in the order represents an article sold. I have to decrement the stock of each article in each line of the order. I did that using a button at the footer, in the click event; I used a SQL sentence. If I select more than one record and press...

I am developing a very simple application, that manages products and orders. When entering one line of the order for a client, I have to update the stock like this: Private Sub Form_AfterInsert() strsql = "update stock set art_quant = art_quant - " & _...