hondaboy24
Apr 9th, 2008, 10:36 PM
hi i have a data report in vb6 that is attached to a data environment, but i have a problem with my query.. my query will consist of a where clause for example: WHERE date = '" & form1.label1.caption & "'"
but currently i put my query at the properties window of the data environment, is there a way to be able to write the code of the query on the form itself? i tried using dataenvironemnt1.command.commandtext but there isnt any
but currently i put my query at the properties window of the data environment, is there a way to be able to write the code of the query on the form itself? i tried using dataenvironemnt1.command.commandtext but there isnt any