Search results for query: *

Maybe that's why it took so long to get a response. You can't use a DDM in SQL. RPG, no problem, but the EDI source has inline SQL. So, my question is, how do I go about doing it. It doesn't seem to be that far out there. Especially when you think that IBM is pushing LPAR so much. Thanks...

Is this possible? CONNECT TO <remotemachine> USER <user> USING <password>; INSERT INTO <localmachine>.localtable SELECT * FROM <remotemachine>.remotetable; If I issue SELECT * FROM <remotemachine>.remotetable; then all rows are corrently returned. My problem is specifying the local table...

Oh well, it was worth a try...lol

If I want to update a file in Free using the %Fields() BIF can the field be an array element? For Example... FMyfile UF E K DISK d Weeklyhrs ds d Monhrs d Tuehrs...

Would .WrapText = True help? Rob

PHV, if you're sugguesting a maximum of 1024 characters per cell if you merged two cells from 2 consequetive rows (merge C3, C4) would the new max be 2048? Would this provide a solution? Rob

Hi Greg, 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. Is this for the Notes field (exp5)? You mention that it crashes on the record containing "4/1 Tony was accepted by client and will start on 4/25/05". Is this the notes (exp5) field? Rob

I just noticed there is no WHERE clause. Was this omitted on purpose? Could this be causing too many records to be selected or q query timeout? Rob

More a comment then a solution... I was advised to use then & (ampersand) character when concatenating string as this is more of a standard. Looking at your SQL I see joins on tables CandidateSkill and CandidateRecruiter which have no used fields. These may be eliminated if no fields are to be...

Thanks Zathas, it did exactly as I wanted. One question though, I kinda thought the solution would use a Range object (and frankly I'd never seen Intersect). Is there a Range solution as well? Thanks again, Rob Don't sweat over an answer as I'll use the Intersect, I was just curious.

Actually I'm trying to use the ActiveCell.Offset(R, 0) where R is a variable incremented as I loop through a recordset. This is where my confusion lies. Thanks, Rob

I have the following snippet With ActiveCell.Offset(R, 0).EntireRow If .Interior.ColorIndex = 35 Then .Interior.ColorIndex = 36 Else .Interior.ColorIndex = 35 End If End With The problem is that the entire row is selected (ActiveCell.Offset(R, 0).EntireRow). What I would like to...

Could you not use a parm table to select the value of EIN? With ActiveSheet.QueryTables.Add(Connection:= _ "ODBC;DRIVER={Microsoft ODBC for Oracle};UID=mark;PWD=newpass;SERVER=test_mark;" _ , Destination:=Range("A1")) .CommandText = Array( _ "SELECT...

Interesting...I had the watch defined for another reason and noticed Stmt not being built correctly. Or so I thought. At your suggestion I let the code continue and even though the value in the watch did not show the full value of Stmt the string had been built correctly (the SQL statement...

I tried what you suggested but it did not make a difference. Next idea? lol Thanks, Rob

I am creating an SQL statement by concatenation as follows: Dim DataLib As String Dim Stmt As String DataLib = "Mylib" Stmt = "" Stmt = Stmt & "SELECT USRDPT, PRIOR, CONCAT(DESC1, DESC2) AS DESC, " Stmt = Stmt & " CONCAT(A.STATUS, CONCAT(' - '," Stmt = Stmt & " (SELECT...

Thanks Skip, it did work but I didn't give you accurate information. The original cell is actually A5. Row A4... has titles for the row returned from the query. When I originally created the query I the query I chose File-->Return Data To Excel and close call A5. When I move the query as you...

I thought this was going to be simple but I've not had any luck. I have an external query in cell A3 and I want to move it to Cell A1. I should think this is easily done but it's Monday morning... Thanks in advance, Rob

I am creating a new work sheet (sheet2) from a macro on sheet1. I later intend on emailing sheet2 (as an attachment through File->Send). The problem is that when the new worksheet (sheet2) is opened by the recipient he gets the macro that was used to create the sheet. I would like the new...

Worked lika a charm. Thanks... I even was able to make use of With/End With in Makeheaders Public Sub MakeHeaders() With ActiveSheet .Range("A1").Activate .Range("A1").Value = "Data refreshed..: " + Date$ .Range("A1").Font.Size = 10 .Range("A1").Font.Bold = True...