Recent content by Vandy02

Well - That worked great! Thanks!

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

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

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

would you be able to provide me short example of how to do that? this sounds like the better situation for sure

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