Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
xcllentplus
Starting Member
1 Post |
 Posted - 2006-01-16 : 01:56:28
|
| HiI am using visual basic 6 and sql server 2000I want to pass an argument (date for displaying sales of that particular date) through vb6 to sql server 2000 viewPlease advise me how can i do thisthanks |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-16 : 02:29:56
|
| In your VB code, writeCon.execute("Select columns from yourView where col='" & someval & "'")MadhivananFailing to plan is Planning to fail |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-01-16 : 21:52:42
|
| create the stored procedure to access the view...avoid dynamic sql as much as possible especially from apps to server unless it's dba tasksHTH--------------------keeping it simple... |
|
|
|
|
|
|
SQL Server Views and VB 6