Select * from MARKET_PRICE where PART_ID = @PartID and MARKET_ID =(Select Market_ID from CUSTOMER where ID = @CustID) ????

There are unicode types in Oracle, nchar and nvarchar2 are there. You should create database with a unicode - characterset (i.e. AL32UTF8) for better performance and sorting. see also http://www.oracle.com/technology/tech/globalization/index.html

if both tables are identical, you can use 'Select * from tab1 UNION Select * from tab2' in fact you can use the UNION statement whenever querys return a identical resultset. dirk

Yup, at least that is Standard-SQL, should work with most Databases, for shure with SQL Server and Oracle. You could try it out from Enterprise Manager or Query Analyser by raising a INSERT statement from there.

insert into values ('''') will insert a single "'" "fathers'''s" or "isn'''t" will do.... dirk

Hi, you need to owner-draw the complete headercontrol to do so, which means: - subclass the header control that is a child of the listcontrol in its PreSubclassWIndow handler - for every button in the headercontrol set the HDF-OWNERDRAW flag - draw the button in the DrawItem handler takes only some 100 lines of code... dirk

dbms_utility.get_time will only give you resolutions of 1/100 second. try to use TIMESTAMP instead. dirk

Corinna John wrote: DB.Railroad.TrackException occurred in 'ICE 3' at ICE3Controller.EnterSaarland() You got it. I really never had a chance to use an ICE, every time I tried my connection trains came late. Why do yopu think Mainz sucks? There is, ah, uh, oh, .... well, maybe you can go to bed early. Your chance to sleep out.:zzz: And for 'Oberdoppelriesenmist': www.berndi-das-brot.de :-D dirk

'ICE 3' has executed an illegal instruction and will shut down. Stack trace: JMP Blieskastel <-- don't know how to jump HLT Oberdoppelriesenmist (engl. Sh**f**k)

Hmmmm... Try to power up your laptop while sitting in the train. 'Device manager found a new device 'ICE 3'. Press any key to finish installation. After reboot, you may use the device... Then come anlong. I'm living in an old train station only 200km away. Sure you will get a birthday cake and coffee here. ;-) dirk

Grab the Seagate Tools (or those from another manufacturer) from their website and read out the SMART-Errorreport, just to make sure your drive is not going down the drain. If there are a lot of new errors consider replacing the drive. And always follow the 3 golden rules: 1. Backup 2. Backup again 3. Backup once more ;) dirk

Have a look at Toshiba Tecra or IBM machines, but those with a Pentium M processor. The only laptops I know which still perform when a compiler (and maybe a database) is loaded. A 1.8 GHz Pentium M feels like a 3Ghz P4, but gives you much longer uptime and less heat and noise. IMO 512M are enough, give it a try, you can always add more (make sure you got a free memory slot left) dirk

Trollslayer wrote: Shuttle do a nice small form factor Athlon64 beastie Yes, they got nice things, not only for Atlon but also for Intel flavors. Easy to set up, just add CPU, mem, FP and optical drives, done. It all depends on what you want to spend and where you want to compromise. Imo those big brands seem to build 'fire and forget' machines, they never want to hear from them again. The reason I build my machines myself is stability. You can choose only the most reliable parts. 24/7 uptime with boxes from HP, IBM etc. will cost you a fortune. So, if you can't say a hammer from a screwdriver, get one of those Shuttles and fill it up. Otherwise choose a nice BIG case (Tower, easier to cool, more silent, ie. Lian Li), Intel or Tyan MB (rock solid) and other parts at your liking. I personaly go for Matrox cards (P650, fanless, top picture-quality) and SCSI-components (Seagate 15K, expensive, but can cut the build-time by more than half). Plus, after the whole things is buzzing smoothly, you can start to add dampers and other stuff to make it quiet, or modd the case into a V8 or Saturn V rocket :-D. dirk

Prost! And off I am... dirk

IDE = Insane dev env Solution: Whenever you need to edit resources use VC6. Next, use Anna's wonderful resource ID organiser to get things in shape. Switch over to VS.Net 2003 and let the wizards do their - ah - magic(?). Press the function key that will invoke the real magic of a macro to get rid of the stupid '#include ' etc and especialy the VERY useful comments. Compile with a fine compiler, link to a less buggy MFC and debug with a superb debugger... you're done! Smile returns to your face and you can see the weekend comming ;-) At least thats my solution.... dirk

German newsticker c't is reporting that german police arrested the 'Phatbot' programmer yesterday too. (for those who read german http://www.heise.de/newsticker/meldung/47209) Too bad a german judge can't those sickos make to stay away from computers for the rest of their lives... dirk

I don't know what to be more afraid of: the early windows 3.0 or the Longhorn look... both give me a shiver... dirk

UPDATE table SET PK =PK+1 WHERE PK>=X INSERT INTO table(PK) VALUES(x) But your DB may not allow a direct access to the PK field, depending on the implementation. In that case, simply forget it. dirk

Just silently enjoying the victory. And maybe in the evening: :beer: :beer: :beer: Live can be such a dry thing :-D dirk

ExecuteSQL lets you send SQL-Commands to the Database directly, but it doesn't change the recordset (you can prove by examining the m_strSQL member) to use aggregate functions and the like (sum, count, distinct, ...) you have to modify the DopFieldExchange-function: void CDPDCount::DoFieldExchange(CFieldExchange* pFX) { pFX->SetFieldType(CFieldExchange::outputColumn); RFX_Long(pFX, _T("COUNT(*)"), m_lCount); } hope it helps :) dirk