View with criteria from form user in ADP!!! Help me!

  • Thread starter chich bong nguyen
  • Start date

C

chich bong nguyen

Hi everybody!
I converted DB from Access to SQl Server. I have problems about views with criteria from form user in ADP. I don't know how to pass parameters from form user to criteria of views in ADP? I know we must use @ nameparameters to pass but how can views understand these parameters's value from form user. I found in internet but i didn't see clearly answer. Help me please about this problem and can you introduce me about what book can explain about ADP, please? As soon as better. Thank you ^-^.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Sending SMTP email from within BizTalk Orchestration
http://www.eggheadcafe.com/tutorials/aspnet/9dd0f346-baf9-4674-a50f-1716445b26bc/sending-smtp-email-from-w.aspx
 
Ad

Advertisements

S

Sylvain Lafontaine

You cannot pass parameters to a view, you'll have to write a full Select
query; for example:

Select * from MyView where MyView.Id = 999 and MyView.FirstName = 'Sylvain'

and set it as the record source of your form. You don't have to make an
explicit requery as this will be done automatically by ADP each time you are
changing the record source.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)
 
C

chich bong nguyen

But in the case
MyView.Id = from form user and MyView.FirstName = from form user. How can i do?




Sylvain Lafontaine wrote:

You cannot pass parameters to a view, you will have to write a full
03-Mar-10

You cannot pass parameters to a view, you will have to write a full Selec
query; for example

Select * from MyView where MyView.Id = 999 and MyView.FirstName = 'Sylvain

and set it as the record source of your form. You do not have to make a
explicit requery as this will be done automatically by ADP each time you ar
changing the record source

-
Sylvain Lafontaine, ing
MVP - Windows Live Platfor
Blog/web site: http://coding-paparazzi.sylvainlafontaine.co
Independent consultant and remote programming for Access and SQL-Serve
(French

<chich bong nguyen> wrote in message

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Making Silverlight Emulate Synchronous Requests
http://www.eggheadcafe.com/tutorials/aspnet/91f69224-3da5-4959-9901-c5c717c9b184/making-silverlight-emulat.aspx
 
Ad

Advertisements

P

Paul Shapiro

Or you could use a stored procedure to get your form data. Stored procedures
accept parameters.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Viewing Forms in ADP 4
Open form with criteria in ADP 1
Cannot Update View in ADP Form! help! 3
ORDER BY in View and ADP Form 16
Editing Views from ADP 8
users and adp 7
ADP and Forms 1
ADP forms 7

Top