>http://www.veryComputer.com/
by Obnoxio The Clo » Wed, 10 Apr 2002 02:42:13
by Mark D. Stoc » Wed, 10 Apr 2002 07:31:14
> http://www-3.ibm.com/software/data/informix/informixtoday/
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
| http://www.informix.com http://www.informixhandbook.com |///// / //|
| http://www.iiug.org +-----------------------------------+//// / ///|
| |This email will self-destruct in |/// / ////|
| |10 sec. If you received this email |// / /////|
| |in error, sorry about the mess. |/ ////////|
+----------------------+-----------------------------------+-----------+
by Andrew Ham » Wed, 10 Apr 2002 14:00:37
Will it have an article describing the newly trained IBM sales reps who'llQuote:>http://www-3.ibm.com/software/data/informix/informixtoday/
1. Please Sir, More help sir....(with set relation)....
select a
use employee order ssn
Ok, here's the snippet...
select b
use absence
set relation to ssn into a
set skip to employee
scan
replace vac_grant with a.vac_ent
endscan
close all
What I want this code to do is, scan thru the table in area b ssn by ssn;
when it finds a corresponding ssn in the table in area a, replace the field
called vac_grant in area b with the value in field vac_ent in area a.
This set relation stuff is real confusing, and I would GREATLY appreciate any
help with this one.
Thanx much, RH
2. sort order
3. Active script running SPAM ALERT - DELETE THIS ONE - SPAM ALERT
4. Lazywriter
5. IF statement
6. DON'T READ CodeSMART 3.0 - an addin for every VBer. it's Spam Spam Spam
9. xp_deletemail failing to delete from inbox
11. sqlmail stuck in inbox while sqlagentmail goes out
12. SQL Mail queues outgoing messages to Outlook Inbox