473,320 Members | 2,117 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,320 software developers and data experts.

Input Parameters in an adp form

I am developing my first ADP client for a SQL db, after having used mdb's as
clients in numerous applications previously. I have found that
theoretically the Input Parameters property of a form in an adp and its
method of therefore enabling a form to be connected to a procedure that
requires parameters is really nifty. However in practice I am finding a
number of annoying issues with this, most particularly that the adp seems to
have intermittent issues adjusting the record source when the input
parameters are updated in code.

Am I wasting my time with this? Is this new feature full of bugs or is it
something I should be able to work thru?

Nov 13 '05 #1
2 3002
On Mon, 20 Dec 2004 23:21:12 GMT, "Andrew Chanter"
<he****@radsolutions.com.au> wrote:
I am developing my first ADP client for a SQL db, after having used mdb's as
clients in numerous applications previously. I have found that
theoretically the Input Parameters property of a form in an adp and its
method of therefore enabling a form to be connected to a procedure that
requires parameters is really nifty. However in practice I am finding a
number of annoying issues with this, most particularly that the adp seems to
have intermittent issues adjusting the record source when the input
parameters are updated in code.

Am I wasting my time with this? Is this new feature full of bugs or is it
something I should be able to work thru?


ADPs are plain buggy and quirky, and a huge drain of time and money to try to
fight with. Besides, Microsoft seems not to be actively fixing or enhancing
them at all. I recommend you give up with the ADP thing.
Nov 13 '05 #2
Hi,

I am able to make some headway in developing an ADP project by using an
unbound form for input parameters which I keep open and invisible to
the user.

I pass the required parameter values into the controls on this form and
the forms with record scources that need input parameters in turn refer
to the controls on the input parameters form.

I have seen improvements in performance when the default values of the
text boxes on the input parameters form is set to Null (the default
value of the parameter in the stored procedure is also null) and by
populating the control after conveting the parameter value into the
relevant data type.

Is this method of passing parameters inadvisable?

Isaac

Steve Jorgensen wrote:
On Mon, 20 Dec 2004 23:21:12 GMT, "Andrew Chanter"
<he****@radsolutions.com.au> wrote:
I am developing my first ADP client for a SQL db, after having used mdb's asclients in numerous applications previously. I have found that
theoretically the Input Parameters property of a form in an adp and itsmethod of therefore enabling a form to be connected to a procedure thatrequires parameters is really nifty. However in practice I am finding anumber of annoying issues with this, most particularly that the adp seems tohave intermittent issues adjusting the record source when the input
parameters are updated in code.

Am I wasting my time with this? Is this new feature full of bugs or is itsomething I should be able to work thru?
ADPs are plain buggy and quirky, and a huge drain of time and money

to try to fight with. Besides, Microsoft seems not to be actively fixing or enhancing them at all. I recommend you give up with the ADP thing.


Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: kie | last post by:
hello, when i create elements and want to assign events to them, i have realised that if the function assigned to that element has no parameters, then the parent node values can be attained. ...
0
by: ST | last post by:
Hello, I will be posting 2 errors that I just can't seem to figure out (I'll put them in different posts). I have looked all over the internet, and I still can't figure these out! This webapp was...
2
by: SophistiCat | last post by:
Hi, I am working on a computational program that has to read a number of parameters (~50) from an input file. The program contains a single class hierarchy with about a dozen member-classes or...
5
by: isaacrajan | last post by:
Hello, I have a form A in my ADP project. The record source of A has input parameters. I need to open form A from three different forms X, Y and Z. When I open A from form X, I want it to...
6
by: fumanchu | last post by:
I've got to let end users (really just one person) load billing batch files into a third party app table. They need to specify the billing cycle name, the batch name, and the input file name and...
0
by: lucas | last post by:
Hi, I have a simple input form that i use to add records to a sql server database. Bellow that is a datagrid that has one template column that I use to dispaly the 3 fields with some html...
4
by: joesin | last post by:
I recently found a vulnerability on my website that allowed sql injection. I have been trying to write some code that would clean user data but have been running into problems. The validation still...
0
by: yawnmoth | last post by:
I'm trying to get a list of all the input elements of a form tag and am having some difficulty doing so. First, here's my XHTML: <div> <form action=""> <input type="text" name="a" /> </div>...
5
by: yawnmoth | last post by:
I'm trying to get a list of all the input elements of a form tag and am having some difficulty doing so. First, here's my XHTML: <div> <form action=""> <input type="text" name="a" /> </div>...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.