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
Forum Index:
Programming Help |
C and C++ |
VB6 |
Java |
VB.NET |
C# |
ASP.NET |
PHP |
ColdFusion |
Perl and Python |
Ruby |
Databases |
Other Languages |
Game Programming |
Mobile Development |
Software Development |
Computer Science |
Industry News |
Programming Tutorials |
C++ Tutorials |
Visual Basic Tutorials |
Java Tutorials |
VB.NET Tutorials |
C# Tutorials |
Linux Tutorials |
PHP Tutorials |
ColdFusion Tutorials |
Windows Tutorials |
HTML/JavaScript Tutorials |
CSS Tutorials |
Flash Tutorials |
Web Promotion Tutorials |
Graphic Design & Photoshop Tutorials |
Software Development Tutorials |
Database Tutorials |
Other Language Tutorials |
ASP.NET Tutorials |
Game Programming Tutorials |
| 
