473,378 Members | 1,106 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

parameter query in datareport

i created a dataenvironment command with 2 query parameters which were received from the user through form.
one for numeric datatype and another for a string datatype.
when i call the report using the commnd it gives an error as....
parameter object is improperly defined.Inconsistent or incomplete information was provided with run time error no as
2147220992(80040200)

i have defined them as numeric and string datatype in the parameter properly.
kindly help me in solving the problem pls
Mar 2 '08 #1
3 2635
creative1
274 100+
i created a dataenvironment command with 2 query parameters which were received from the user through form.
one for numeric datatype and another for a string datatype.
when i call the report using the commnd it gives an error as....
parameter object is improperly defined.Inconsistent or incomplete information was provided with run time error no as
2147220992(80040200)

i have defined them as numeric and string datatype in the parameter properly.
kindly help me in solving the problem pls
How do you pass these parameters? query?
Mar 6 '08 #2
How do you pass these parameters? query?
hai ..
good morning...

here is the coding for passing the parametrer for the query
the following codes are called as click event of a commd button on a form

dim param1 as double
dim param2 as string
param1=inputbox("Enter the first number value")
param2=inputbox("Enter the string value")
dataenviroment1.command param1,param2
datareport1.show

pl reply

thanks in advance
Mar 8 '08 #3
QVeen72
1,445 Expert 1GB
Hi,

Check the Order of the parameters, may be you need to pass in the reverse order..?

param2 and Param1

Regards
Veena
Mar 8 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: DhavalPatel1983 | last post by:
Hi, I need help in VB Datareport, my problem describe as below.... I have one Bank application project with all the information like Deposite,Clearness,Check,Cash,Creadit,ATM...
6
by: klove1209 | last post by:
Good afternoon, Can someone please tell me how I can return records from a query. I have text fields that I need to obtain, and have those necessary records sent to MS Word. I need to return the...
5
by: anoopgopal007 | last post by:
Hi, I am using vb6 and datareport. I am updating the tables whle the program running. But the datareport doesnot show the updated information. Its always shows the previous value. But...
3
by: suresh_punniyakkodi | last post by:
Hello to all, How to pass SQL Query to DataReport at Runtime... Please, Any body help for this Question... Regards, Suresh...
6
by: pramodrepaka | last post by:
hi this is pramod i am facing a small problem Private Sub Command_Click() Dim a As String a = InputBox("enter empno") If rs.State = 1 Then rs.Close rs.Open "select * from microbiology...
4
by: ashutoshvyas | last post by:
I am designing a data report in VB6. In data environment it is possible to selet tables and 'select quries'. But I want to generate a report based on parameters passed by user, so i had created a...
0
by: nishjee | last post by:
Hello friends, i need visual basic 6.0 code to export a datareport to html other than the defult option coming with datareport. I need this very urgently because when i am exporting the datareport...
1
by: ragavan | last post by:
hi, i have some problem in my project.i have membername and member detail.nw i want to sortlist member details instead from city.how can i derive from datareport when select a city name from...
9
smartchap
by: smartchap | last post by:
I have a table having 3 fields viz. SNo, FName and LName. The table has 10 records having SNo from 1 to 10. In DataReport I have 3 labels and 3 textboxes. I want to display all records from 1 to 10...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.