Search results for query: *

Hi All, I am running AIX and I am trying to get all mail forwarded to an SMTP server on Windows. I have added the SMTP server's ip address as the relay host: # "Smart" relay host (may be null) # Relay host to forward outgoing mail not in the local domain to. # To forward ALL mail to...

Hi, I'm fairly new to progress, can use your help. I've setup a decimal variable with extent 14 called Sales_qty. I would like sales information to be separated by item by day for 14 days. The data is in a table called ih_hist with detail in idh_hist. I have a break by idh_part by...

I am currently cim loading sales orders into progress, but it seems really slow. I am getting about 1 second per detail line, but I am loading between 7000-10000 detail lines per day. Anyone have any suggestions on how to speed up this process? Thanks,

Does anyone know how to setup unix mail to automatically relay all messages to an exchange server? Thanks,

I have a ftp script named ftpscript.txt that looks like this: open 142.218.71.30 username password ascii hash send "xxtest.p" quit In windows, the command line ftp can run the script like this: c:\>ftp -s:ftpscript.txt But in AIX, it says that -s is an invalid parameter. My UNIX book...

I have tried using ADO connection, but with no success. Does anyone have any suggestions?

I am running SQL Server 7.0. I am looking for a way to output a query to a file. The filename needs to be dynamic. The logic should work like follows. Stored procedure is passed a date stored in @inDate. SELECT * INTO FILE "c:\" + @inDate + ".txt" FROM tblHistory WHERE...

Is there a way to remove duplicate records quickly? Possibly a query? Thanks,

Is there a built-in date function that does the following? Basically, I want something that can return all dates that are not in a table. Example. SELECT AllDates() FROM tbl_Work WHERE AllDates() <> WorkDate AND AllDates() BETWEEN '01-01-2002' AND '12-31-2002'

More specifically, does anyone know how I would go about coding this. Here is the pseudo code. For Each 'Wednesday' IN 2002 ' Do Something Next Thanks,

My console app does some stuff, and if certain conditions are in place, I want it to run a batch file. How do I do this? Thanks

I have integer with the value 5. I need to store the value in a string. If I use this, strValue = intValue strValue becomes the club symbol, which is #5 in the ascii chart. I want the number 5. I also need it to work in the thousand range.

I have a W32 console app, and I need to get the Created and Modified datestamps of a file (C:\Temp\Test.txt). I have no idea how to get it, and any help is greatly appreciated.

Let's say this is my query. SELECT InvoiceNumber, InvoiceDate, Product, (QtyReturned / QtyOrdered) AS '% Returned' FROM Invoices ... Occasionally the QtyOrdered may be 0 causing a Divide By Zero error. How can I catch it, and instead of QtyReturned / 0, make it QtyReturned...

Let's say there are 4 tables. Customer, Product, Invoice, and Returns. Here is my SQL query so far. It works fine. SELECT Customers.CustomerID, Customers.Long_desc AS 'Description', Products.ProductID, Products.p_Desc AS 'Description', SUM (Invoice.qty_ordered - Returns.qty_returned) AS...

I am wondering what the equivalent of the Access tabledefs collection is in SQL Server. Ideally, I would like to do a 'SELECT * FROM tabledefs' that returns all the tables in a database.

What is a good rule of thumb for how often to run the UPDATE STATISTICS command on a table? Thanks, 8-)

There is a table with approx 19 million records in it. Is there a way to find out how much space it takes up on disk?

I am creating an order table that will hold an average of 60 million records for each year, and expected to contain 5 years worth of data. So I'm looking at approximately 300 million records for the table. What is the best datatype to use for creating a Unique OrderID? Should it be numeric...

By default, F12 opens some quicksave window in access. I would like to program the F12 to open my custom search form. Does anyone have any idea how to do this? Do I have to hook the keyboard?