<No Subject Supplied>

TO: mark@cdin-1.compu.com Quoted from Mark Heringslake to All mh> I am running 4.10U2 version of Informix SE... mh> 1) I have a table that has a SERIAL field. Forconversion purposes mh> I force inserted (via SQL) a row w/ a value of -1 (which I use for mh> any record that doesn't convert right). It took it and I can view mh> the data via SQL, but none of the other programs seem to "see" mh> this record. NOTE: This is NOT a problem, just curious as to why mh> it seems to be invisible. I'm not "Expert" with Informix. I've only been programming in it for about 1 year, but boy have I learned alot in that year! I have noticed that a few times if I alter a table and then runn a program, it sometimes just goes crazy! but if I recompile (R4GL or I4GL) the program works grerat... I'm not saying thats your problem, just a suggestion. mh> c) Somewhat unrelated..... mh> How do I get the "serial" value to start over - do I have to mh> alter the table to remove the "serial" field and then alter it mh> again back to "serial"? If memory serves me correct, you have to drop the table and recreate it or maybe just the serial field. * Origin: Hard Disc Cafe | Houston Texas | (713) 589-2690 | (1:106/30)