Welcome to the { mindfrost82.com } forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

Go Back   { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Programming > Visual Basic

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-14-2008, 09:56 PM
JP
 
Posts: n/a
ADO, SQL & Parameters Question

Problem with Parameters with an ADO control

Hello:

I am trying to fill a Microsoft DataGrid with specific data. Based on a
selection by the operator.

I have an option box at the top, a command button just below that to have
the program get the desired info.

A datagrid with an ADODC as the datasource.

The operator selects an option
If option(0) is selected then SelType = " "
Elseif Option(1) is selected then SelType = " "
Elseif Option(2) is selected then SelType = " "

Then there is a command button below that which tells the program to get the
requested data.

This takes you to an SQL that says:

MyGridData = "SELECT [ABN Table].ABNId, [ABN Table].PatientName, "
MyGridData = MyGridData & "[ABN Table].AbnItem, [ABN Table].Reason, "
MyGridData = MyGridData & "[ABN Table].Amount, [ABN Table].PrintYN, "
MyGridData = MyGridData & "[ABN Table].EntryDate, [ABN Table].CareCaidPers "
MyGridData = MyGridData & "From [ABN Table] "
MyGridData = MyGridData & "Where ((([ABN Table].CareCaidPers) = '" & SelType
& "')) "
MyGridData = MyGridData & "ORDER BY [ABN Table].EntryDate DESC;"

Then I set up my Adodc and try to load it with data:
Me.datABN.ConnectionString = Connectstr
Me.datABN.RecordSource = MyGridData
Me.datABN.Refresh

However, when the program tries to refresh, I get an error that says:
Run-time Error '3061':
Too few parameters. Expected 4

The problem is that I built the SQL in Access and it works there (i.e., I
replace "SelType" with "Personal"...one of the selections) but here I keep
getting this error.

Any suggestions or assistance would be appreciated.

Thanks

JP




Reply With Quote
Reply

  { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Programming > Visual Basic


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 04:04 PM.


Powered by vBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0 ©2007, Crawlability, Inc.
© 1999-2008 mindfrost82.com v11.0


Sponsors:
Grand Theft Auto Mp3 | Loans | Loans | Buy Anything On eBay | Rokr E2



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114