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 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...
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...
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...
I have tried to put on a dialog a static text (IDC_STATIC20), but the dialog background is blue, and the static text background remain white (I want it to be blue as the dialog background).
Then, on the dialog box on method CtlColor(...) I have control the static background color with the...
Hi!
I have made prooves with debug version and it reads correctly the values of the registers in the database.
But when I do it with Release version it doesn't work. It just read numbers and in that field there are no numbers they are names.
I have created a CFile object and I want to write in it, in fact I get it, but I cannot write on differente lines although I add "file.Write("\n",sizeof("\n"))" I just see
inside the file one very long line.
How can I get it?
Another question is that I give it code for an html file, I mean...
I get printing a form; but I would like it to be larger (A4 size). I have maximized the window but anyway on the paper fill half of it. The width is correct but not the height
I have defenided two classes like:
class Conversion{
Conversion(BOOL corregido);
};
class ConversionHTML:public Conversion{
...
};
then I use
ConversionHTML::ConversionHTML(BOOL corregido):Conversion(corregido){}
Inside the constructor of Conversion there are operations.
If I just compile...
Hi!
I'm trying to update a row with a recorset but I get the error -2147217864(80040e38) error on updating based on queries. The row to be updated couldn't be found.
However the row is there because I can read the values of the row.
rsmod.ActiveConnection = Inicio.conexion
rsmod.CursorLocation =...
I want to associate a ProgreesBar to several functions (but they don't work at the same time). The point is that I have read that I should create a worker thread. On that worker thread I must include the call to the progressbar functions(step) and from the application create the thread. My...
¡Hello!
My problem is that I'm writting queries in access, and when I try to write an Alias for a field it says "ODBC call failed", however I can run the query without the alias;
that alias, once defined on the select clause, it is used on the where clause.
I have found that writting (theAlias:"...
Hi! my problem is that I would like to save a report called by:
dim objinfacc as Object
set objinfacc = GetObject(path)
with objinfacc.application
.docmd.openreport nombre,acviewPreview,,condicion
.docmd.maximize
end with
through these actions I can print the report, but I also want...
Hi! My question is that I would like to open a CDialog using the ID associated to the window it shows; I mean, I've got several forms, each one belongs to a CDialog class, and I see for instance that one of then has the IDD_DATETOWN_DIALOG=105 and depending on the information I've got I decide...
Hello! My problem is that I have a LAN, and I want to add another computer, but I am forced to use windows 95 due to the PC system requirements; I've got other PC's with windows 95 and work correctly. The PC can see other PC's but when I get it into the Domain, I write the user, the password...
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.