1 Replies - 7019 Views - Last Post: 10 September 2008 - 06:35 PM Rate Topic: -----

#1 bjones  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 10-September 08

Passing Parameters using a Data Environment

Posted 10 September 2008 - 01:43 PM

Hi I'm working on an applicaiton for work (but I'm a sales guy :) ) and I'm stuck on the Data Environment when it comes to passing paramenters at runtime. I've purchased a few books on VB6 but most of then brush over DE at best. I have setup my connection, commands and built a few forms using the DE but I'm confused when setting up SQL statements within the DE that need parameter passed, say through a text box.
Ideally I would like a user to enter in a year through a textbox, then click a command button that in turn refreshs a datagrid filtered by year...but first things first - what is the proper way to setup a SQL driven Command? Do I simply enter SELECT * FROM tblquotafile WHERE year = ? - then what method to I use to push a variable in "?" at runtime?

Any help here is much appreciated - if anyone knows a good book that covers DE in more detail it is appreciated

Regards, Brock

Is This A Good Question/Topic? 0
  • +

Replies To: Passing Parameters using a Data Environment

#2 thava  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 180
  • View blog
  • Posts: 1,606
  • Joined: 17-April 07

Re: Passing Parameters using a Data Environment

Posted 10 September 2008 - 06:35 PM

i think the following link will help you

http://www.dreaminco...snippet2492.htm
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1