Printing with Data Environment
-
I am trying to get the Data Environment to print to a Data Report When calling the Data Report the Data Report appears but I get this error message "Invalid SQL statement; expect 'Delete', 'Insert', 'Procedure'," etc My code to call the Data Report is: Clothing.Commands("Garment").CommandText = " & Text1.text & " GarPrint.Show My SQL Statement in the Data Environment is SELECT ID, CustomerCode, StyleNumber, GarmentDispcrip, ScreenPrint, SizeRange, Embrod, FabricColour, FabricType Can anyone offer any suggestions please :(:|:) bruceb
-
I am trying to get the Data Environment to print to a Data Report When calling the Data Report the Data Report appears but I get this error message "Invalid SQL statement; expect 'Delete', 'Insert', 'Procedure'," etc My code to call the Data Report is: Clothing.Commands("Garment").CommandText = " & Text1.text & " GarPrint.Show My SQL Statement in the Data Environment is SELECT ID, CustomerCode, StyleNumber, GarmentDispcrip, ScreenPrint, SizeRange, Embrod, FabricColour, FabricType Can anyone offer any suggestions please :(:|:) bruceb
SELECT ID, CustomerCode, StyleNumber, GarmentDispcrip, ScreenPrint, SizeRange, Embrod, FabricColour, FabricType you did not supply the FROM part of the query should be :
Select col1,col2,col3 from table_name -
SELECT ID, CustomerCode, StyleNumber, GarmentDispcrip, ScreenPrint, SizeRange, Embrod, FabricColour, FabricType you did not supply the FROM part of the query should be :
Select col1,col2,col3 from table_name