Recent content by JoBlink

HI! I have a laptop running Ubuntu 8.04 server - command line. This laptop has 2 network interfaces: USB and RJ45 I'm trying to share internet connection and have it work as router It pings internet sites through USB, but unable to ping anything on LAN through RJ-45, i.e 192.168.0.1 -...

Hi! I read for 4 days various articles on it, but being a networking and Linux Noob, could not make it work. I am out of ideas with no hope of making it on my own, so please, HELP! I am trying to set up a laptop with linux server as a gteway/router. Laptop needs Public IP because some app...

Out of 10 million rows, 1,2 million should be deleted. Can you please suggest a way to loop this code until subquery result is ZERO - no duplicate exceeds count 100. Each DELETE removes about 6000 records - that's 200 loops! DELETE FROM [1] WHERE (Name IN...

OK, I got it working, but there was a price to pay! I removed all indexes except for the Name index. Modified code suggestions by GMMASTROS: instead of "TOP 100", which FAILS, I tried "TOP 10" - FAILS, then "TOP 5" - WORKS! So I am moving along at a snails pace. My boss promised to fire me...

MARKROS, I don't have primary key, but I will look into the article you suggested, thanks! ------------------------------------------------------------- GMMASTROS, I have no triggers, so the first command returned blank. Here is second: index_name index_description index_keys State...

OK, this is really frustrating! GMMASTROS, I like your suggestion to limit queries to a few TOP results. I verified your suggestion with SELECT statement, and it returns just the records that need to be erased . HOWEVER!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! when I am ready to...

Let me clarify. This Sub-query works, and I want to delete all of those records returned by it: (SELECT Name FROM [1] GROUP BY Name HAVING (COUNT(Name) > 100))) Is there a better way to delete those ...

SUMMARY Query works on a 1 Mil row table but gives above error on 10 mil. row table. QUERY ___________________________________________________________ DELETE FROM [1] WHERE (Name = ANY (SELECT Name FROM [1]...

Still looking for help on calling procedure using SetLinkOnData and passing a variable to it. Help will be greatly appreciated. I found 2 references: on passing a parameter between subroutines and on caling procedures. NONE OF THEM WORKS WITH SetLinkOnData method. EIther I get "Type...

HI! I declared all variables outside of subs. I changed Dim Links as Variant to Global Links as Variant I still get error due to the problem with the Links and "i" variables: either "type mismatch" or "subscript out of range" It means I failed to pass the value. Here is the catch...

Dear PHV, Your solution works, but implementing it will be very inefficient in my case. Links(i) are DDE query strings, containgin subject of a query and parameter to be returned. There are 100 subjects, with 7 parameters each. If I did as you suggested, I'd need to write 700 subs. What I...

Hi! I have 2 subs in excel VBA module. OBJECTIVE: combine code into one Sub / Function First sub DOES: CONTINUOUSLY monitor DDE updates with LinkOnData method, DOES NOT: pass link strings to another sub Second sub DOES: Pass link strings to anoter sub DOES NOT: monitor links contuinuously...

hi! I have a workbook with several links to DDE server. The link source is an external file on a server to which I have no direct access, and updates come automatically at random intervals. I would like to know if there is a way to write the code that will show me a message box every time a...

thank you, you're bringing the points which I have overlooked. I do not have access to the link source file. I did not make updates manually, they come automatically at random intervals. because of all that, all I have is my destination file and DDE formulas, like...

hi! I have Excel file with several DDE links from external sources, updated @ random intervals. For the example sake let's say there are three links. I would like to know which of the three links was updated last.. How can I do that? The links are the part of the array.. Can I identify the...