I have deleted the rows in a table, I have inserted them again, I have made commit, and I was very happy to see that it worked, I could see the values.
So I decided to do it with other tables, but on the second table I tried it didn't work. I have even dropped this second table, I have inserted...
I test the connection through "oracle odbc driver connect" and it says "connection successful". The problem is from access. The user I use to connect it lets me open tables created in other schemas but not the last one I have created.
In fact in a few tables when I try to open them, I can see...
I have an oracle database and through access I connect to the database usign ODBC, but when I open a linked table from access, I can see no field values and, each field has #¿Name?
When I select the odbc connection to select the database and the table, I can see the tables, I can select it, but...
I have a field defined as NVARCHAR2(4). If I insert a row with a four length value in that field it's ok, however if I try to assign a value such as rs.fields("cp1")='R' when it executes rs.update the application hungs up without error.
I have noticed that this table has a foreign key with the...
I have found out the problem. I had the format for the field en visual basic and a trigger in oracle like this:
BEGIN
IF :NEW.FECHA_U IS NULL THEN
:NEW.FECHA_U := NULL;
ELSE
:NEW.FECHA_U := to_date(:NEW.FECHA_U,'DD/MM/YYYY HH24:MI');
END IF;
END;
if the trigger is active it doesn't...
The question is with informix it worked, and now with oracle it doesn't, that would mean that I should change all the application, to use a "select *..." there, where there is a source=<table-name> and I don't understand why because the recordset property it admits table names, so I think the...
Well, I got to put the datetime into the date field and it doesn't give an error.
From Visual basic I assigne:
rsoracle.fields("fecha_u")=Format(mydate, "DD-MM-YYYY HH:MM:SS")
mydate is "04-06-2009 10:15" (spanish format)
then, to check the value in the table, I make a select:
select...
I am using visual basic 6 and I want to add rows to a table in oracle.
If I use a recordset and assign to the source the name of a table it gives the ora-00900 error, however if I use the sql "select * from tabla1" it doesn't throw the error. The error appears just after rs.open
rs as new...
I am importing from a text file the records for a table and I have problems with the date field. The values are like '04-01-2009 10:28' and the field type on the table is date, although I have tried timestamp or interval day(0) to second(0) and it didn't work. It never works.
I am importing the...
I'm using a textbox to insert the age of a person.
Then I have assigned txt.Datafield=age, txt.DataSource=adolevel (adodc control) and the field "age" on the database table has numeric type. The problem exists when the field in the table has already a value and the user erase the value (txtbox...
Thank you for that answer, but the problem is the datagrid cell length. That cell shows the content of a field in a recordset. If the user wants to change it, I want to control that the length is not greater than the field size.
I don't know how to control the length of the text inside a column. I want to know the length of the text inserted/updated on the cell before updating. If the text is greater than 20 characters I want to warn the user. Right now instead of that, the application send an error (because sometimes...
Check that previous declarations of other variables exist. Por instance, if you have declared variables which belongs to a specific object (ADODB or another one) check that you can choose the type just typing adodb.recordset
.new
You can also see it trough...
'botón de actualización
Private Sub cmdUpdate_Click()
On Error GoTo UpdateErr
Me.MaskEdBox2_Validate (False)
Me.validartxt0
If PrimaryCLS.clv_repetida <> Trim(txtFields(0)) And _
Not (PrimaryCLS.exist_key(Trim(txtFields(0)))) Then
PrimaryCLS.clv_repeat = txtFields(0)...
Hi!
I am using classes to work with one database. When I cancel an updating operation, and I try to classrs.movenext it gives me an error "214721842 cancel operation", when I have already classrs.cancelupdate done and it looks like correct.
What should I do?
Thank you
I have made an app using MFC, and I use inside a class which heritates from OleDispatchDriver. This class calls to an external application (a parser). When I run the application it works perfectly (on my computer). Then I have created a installer and have include inside the libraries I need (at...
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.