Member Avatar for pmark019

How can I use SQL Statements in VB 6 with DataEnvironment.

I have a DataEnvironment called Table(DataEnvironment2.Dsr) and a report named rptStudMastOne(rptStudMastOne.Dsr). I am planning to use the SQL Statement " SELECT * FROM Student WHERE StdSSN = txtStdSSN " and it will show in the report the record that has a StdSSN that is equal to the number inputed in the txtStdSSN but I don't know where to put it.

  • 3 Contributors
  • 3 Replies
  • 103 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by abu taher
Member Avatar for abelingaw

Is your SQL is on a command button (ex: cmdPrin Selected).?

Member Avatar for pmark019

Is your SQL is on a command button (ex: cmdPrin Selected).?

My SQL is not on a command button. It is on a DataEnvironment - Comand. The only code inside my cmdPrint button is rptStudMastOne.Show.

Edited by pmark019 because: n/a
Member Avatar for abu taher

you have to set parameter in DataEnvironment for txtStdSSN.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.