Sql statement to ADO code

[franki]

Hi all,
I have created a DataEnvironment but when I copy the Sql statement in to an ADO code it wont work. The DataEnvironment works because I can drag it on to a form and it shows data. this is the sql statement:
SELECT [Screen Instruction Master 1].ORDER_NO, [Screen Instruction Master 1].DESIGN_REF, [Work In Progress].Stretch, [Work In Progress].[Glue 1], [Work In Progress].[Cut Out], [Work In Progress].[Glue Edges], [Work In Progress].Degrease, [Work In Progress].Dry1, [Work In Progress].[Coat 1], [Work In Progress].[Coat 2], [Work In Progress].[Frames Recieved], [Work In Progress].Engrave, [Work In Progress].Wash, [Work In Progress].Dry2, [Work In Progress].Harden, [Work In Progress].Pinhole, [Work In Progress].Paint, [Work In Progress].Silicone, [Work In Progress].Tape, [Work In Progress].Notes1, [Work In Progress].Notes2, [Work In Progress].Notes3, [Work In Progress].Notes4, [Work In Progress].Notes5, [Mesh tp].[Mesh tp], [Work In Progress].[Screen Making notes 1], [Mesh tp].[Mesh tp], [Work In Progress].[Mesh tp info], [Work In Progress].[Qty Frames Completed], [Work In Progress].[Qty Frames Req], [Work In Progress].[Frames Req Size Box Section], [Work In Progress].[Screenset req Priority], [Work In Progress].[Frame Notes from gaz], [Work In Progress].[Frames Completed], [Screen Instruction Master 1].FRAME_ID, [Screen Instruction Master 1].[Design Descript], [Work In Progress].[Screen Making notes 2], [Work In Progress].[Design Ref], [Work In Progress].[Job Id]
FROM [Screen Instruction Master 1] LEFT JOIN ([Work In Progress] LEFT JOIN [Mesh tp] ON [Work In Progress].[Mesh tp] = [Mesh tp].[Mesh tp id]) ON [Screen Instruction Master 1].DESIGN_REF = [Work In Progress].[Design Ref];

Basically I am pasting the above statement in to ADO code like - adoPrimaryRS.open "Sql statement here",db, adoOpentastic, adLockOpentastic

Is there any rules that change when you Paste an Sql statement in to ADO code?

Thanks

[Pradeep1210]

It might not be fitting in one line. Try to store it in a variable and then debug.print that variable to check whether the whole sql statement is there. Then open then ADO recordset.

[franki]

Sorry..... I did alter the statement to fit on multiple line by using the underscore_.