Search results for query: *

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...

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...

How do you make a textbox entry only allow numbers....? Thanks

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...

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...

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 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()...

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...

I have to routines... btnData_Click - I get data from a database)DEPT / EMP tables... and load data into a dataset(ds) as two tables DEPT/EMP....EMP is a child table...many emps to one DEPT....I add the data to datagrids dgDEPT and dgEMP so can see that the data exists.... If I click on...

I have a dataset with two tables..."DEPT", "EMP" They have column "DEPTNO" in common... I have made a relation and tied the dataset to a datagrid "dgDEPT" and the relationship works. What I want to do is have a grid as the DEPT table and when I select on a record...I want a separate grid to...

I have listbox that I populate with data from a text file.. I select an item and populate a textbox(txtFileText) with the item I selected...I want to be able to modify the data and then update the list with the btnUpdLst_Click I was able to do this in VB .net...but unable to do so in C #...

I have an application that hits a database and pulls over two tables "Orders" and "Order Details" into one dataset link by OrderID. I have the data of the "Orders" table appearing in textboxes with navigation buttons using cmOrders.Position to navigate through the data. I have the "Order...

I have Form1 with a datagrid of Employees table.. I have a button on this form that will open a another form (frmEditDetail) where I can edit the data by passing the current position of the CurrencyManager. The data passes, but I do not know how to save changes to the dataset... Can anyone help...

I posted something similar previously but I did not have any responses...so I think I didn't explain it correctly. I pulled data from oracle through a web service to a windows app into dataset "ds". I bound the dataset to a datagrid. This works well. What I would like to do is select a row...

can anyone give me an axample of using currency manager in c# .. I have pulled my data through a web service....so I have the data in a dataset..(ds) I can place that data in grid, list, and text boxes.. what I am wating to do is select a row from lets say grid1... when I double_click I want to...

i am trying to covert a string to an integer.... I have tried v_counting = Convert.ToInt32(ENAME.Text); but I keep getting errors..not in correct format....