I created a table 'B' that is the same structure as 'A'. I am wanting to copy the data from 'A' to be 'B'.
INSERT INTO B
SELECT * FROM A
I am unable to do so as col2 in both tables is a LONG datatype. I get an error ORA-00997 illegal use of LONG datatype. I have no idea what to do as I...
Hmmm,
Can I use a where clause with that?
If not my only other option is to find a way to put it into another table where I can insert with LONG datatype which causes errors.
I have a TABLE(i.e. LONGDESCRPTION) that has multi-million records WHERE one COLUMNS IS a LONG datatype.
Users have entered such data AS:
'The door should be removed.
Please contact USER.'
I am wanting TO ARCHIVE the data OR should I say place IN a text OR data FILE so that once it is exported...
If you have a table with let's say 30 columns and a million plus records:
Which is faster if I am performing a search?
Say on col1, col5, col23
Example 1
Separate indexes for each column
or
An index that includes all three columns?
Thanks,
vandy02
I have a datagrid bound to a dataset from a database...
The grid grows as the total count increases...that is fine as I don't have that many records. Yet when it grows it changes the size of the grid.
Is there a way where I can keep the column sizes and fonts the same size no matter how many...
I have a table with two columns
column1 BREAKSTART
column2 BREAKEND
These columns correspond to a break time...
i.e.
BREAKSTART = 1400
BREAKEND = 1430
I want to be able to pull records that an input time of 1435
would not fall within.....
basically where the input time is not between the...
thanks...
i also tried something else that seemed to work...
in the main form:
Public now as dataset
then I made the private sub that populated the dataset to public...and it carried over..
thanks again
I have a dataset called now that consists of three tables.
(now, "EMP")
(now, "DEPT")
(now, "SAL")
These are filled from remote db.
I am able to click within a datagrid (consisting of "DEPT") and then edit the values on a separte form with text boxes. This works very well through the use of...
=======================================================
First Question - Yes - exactly what you said..
more or less it would show in a list box or something the records modified due to the dataset changes
ie.
Updating records in table A....
WO984934..
WO839483...
WO849384...
etc...
I am updating a DB with local data from dataset now("EMP").
How can I show the rows affected as in the EMPNO's of which is a column(EMPNO) in both dataset now("EMP") and table EMP within db.
Also, is it possible to show the new or updated rows from a db when it is coming over to the local...
I am running a script the loads data from .dat files int informix...everything worked well a few days ago...but now I receive the error below
========SCRIPT===============
# -- load the tables in the order they were created, no
# --logging, commit not needed
dbload -d maximo -c craftcodes.ctl...
I got this to work so far....but not exactly what I am looking for....is there a way to update the table based on whether something has changed in the dataset...in this way I would only be updating db where i made changes...
Not sure how to do this with the UPDATE statement as I want the...
I have a dataset that I populate from a DB and then modify the local data. How do I take these changes back to the database?
refere to pull data sub() for data loading...
this the update I tried
=====================================================
Private Sub Update_DB()...
okay...i was able to setup a datatable through a dataset...
yet i am unable to take the changes back to the database..
this is what i added....I am going to open up a separate item as I now need to find out how to update the database through the dataset
btn_Data_click
...
I obtained data from a remote database.
Two tables DEPT and EMP
I created a DATATABLE DTEMP
I created a table within a dataset (now) as DTDEPT
I originally planned to use dataset with tow tables, but I was unable to
use a parent child relation as I was obtaining error after error so I went
to...
I pulled data from a remote database and filled a datatable with the results through a data adapter.
I then update the locale data using dataview with a datagrid...
How do I send these changes back to the remote db?
Note, when I pull the data from db it is in a table and not a dataset as I was...
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.