By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,826 Members | 1,215 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,826 IT Pros & Developers. It's quick & easy.

Updating a table data via DDE connection

P: n/a
Can someone show me an easy code snippet to help update a table based
on DDE data. Here is the "jist" of what I am trying to do..

1. Get stocks/options symbols from portfolio management systems
(complete)
2. Add these to a table (complete)
3. open DDE channel - Telemet Quoting system (complete)
4. Get prices (I can get prices, but cannot update all 1100 stocks/
options in the table)
5. Update 2 fields (bid and ask) based on the stock/option symbol.
6. Close DDE channel.

I have tried about 10 combinations of code, I just can't seem to get
it right. I can manually enter an option/stock symbol (via textbox)
and get it to price, but cant seem to loop through all 1100 or so and
price them all.

Thanks,

Wayne

Jun 7 '07 #1
Share this Question
Share on Google+
1 Reply

P: n/a
On Jun 7, 12:03 pm, "wboy...@gmail.com" <wboy...@gmail.comwrote:
Can someone show me an easy code snippet to help update a table based
on DDE data. Here is the "jist" of what I am trying to do..

1. Get stocks/options symbols from portfolio management systems
(complete)
2. Add these to a table (complete)
3. open DDE channel - Telemet Quoting system (complete)
4. Get prices (I can get prices, but cannot update all 1100 stocks/
options in the table)
5. Update 2 fields (bid and ask) based on the stock/option symbol.
6. Close DDE channel.

I have tried about 10 combinations of code, I just can't seem to get
it right. I can manually enter an option/stock symbol (via textbox)
and get it to price, but cant seem to loop through all 1100 or so and
price them all.

Thanks,

Wayne
A couple questions:

1) Does the DDE data come in in a big chunk (file) or is it a constant
I/O stream?

2) If a stream, does the interface control have any _Events that you
could use to trigger a write?

Ron, King of Chi

Jun 7 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.