Data Report in Vb6 with Sql Command.please reply urgently.

[Jaseem Ahmed]

i have a project connected with sql server 2000...
i want to generate the some reports, for that user should itself enter the dates or codes for reports..
i have created a data environment, called the tables.
now in general tab, i have selected SQL Statement to filter my data from database.
now where i am comparing the field with parameter SELECT * from customer where customercode=text1.text when i am clicking on apply button it errors...

"to retrieve field information for this command, the command must be executed.you may need to specify input parameters values in input parameter tab before the command is executed.execution may add to or modify data in database.

execute command?"

if i am clickin "yes", nothing happens, and pressing No, tit cancels it.
where as the parameter tab is disable, where from i should input the parameter values.

[jlego]

how about some code

select * from whatever where whatever = '" & textbox1.text & "'

[Jaseem Ahmed]

i think u did not read above post correctly!!!! i said this is not working,.,..
and i m writting this code in Data Envirnomnet>>Sql Command.

[jlego]

what is not working where is the error what does your code look like ?

[aktharshaik]

Hi!!!

Use the following syntax for the SQL Query

SELECT * from customer where customercode = ?

? will display the parameter in the parameter tab

[aktharshaik]

Hi!!!

For more information, read this KB Article

http://support.microsoft.com/kb/193866

[kaippilly]

I am Using Access 2007 and adodc in Vb6.Please help me how to execute sql by writng code under command button click(). adodc1.recordsource="select * from table1 where[Date]=#7/1/11# does not work. what is the way?
please help me.It is very urgent

[aktharshaik]

Hi,
It is better to start a new thread.
Anyhow here is some solution i can get for u.

Open VB IDE.

1. Insert your ADODC Control in your form.
2. Insert the Command Button.
3. Open the Code Window for Command_Click() and Use this code to set the ADODC Control Properties

Adodc.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & App.Path & "\test.accdb;Persist Security Info=False"
    Adodc.CommandType = adCmdText
    Adodc.RecordSource = "SELECT * FROM USERS"

Rest you make out and get back if any problem.

Regards
Shaik Akthar

[aktharshaik]

Also refresh the ADODC Control

Adodc.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & App.Path & "\test.accdb;Persist Security Info=False"
    Adodc.CommandType = adCmdText
    Adodc.RecordSource = "SELECT * FROM USERS"
    [U]Adodc.Refresh[/U]