Question

Asked on 2009-10-12 at 14:40:00ID: 25040663

Take a user input and use it for the SQLEXEC()

by: jaymz69500

Rating9.2Excellent

If I select the run x.prg on my menu I want it to prompt for a Startdate and EndDate so I can pass it through in the sqlExec()

SQLEXEC(lnHandle,"select * from shlshpinfo where slssdat between ?ldStartDate and ?ldEndDate and slsco=1", "cSlshpinfo")
                              
1:

Select allOpen in new window

Related Solutions

Solution

Access this solution immediately by signing up as a member of FoxproAnswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.

About this Solution
Sign up Now to View This Solution
Zone
general
Tags
Participating Experts
1
Solution Grade
A

Replies

 by: JF0

Posted on 2009-10-12 at 15:04:55ID: 26270643

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: jaymz69

Posted on 2009-10-12 at 15:23:42ID: 26270644

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: JF0

Posted on 2009-10-12 at 15:30:52ID: 26270645

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: jaymz69

Posted on 2009-10-12 at 15:32:43ID: 26270646

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: JF0

Posted on 2009-10-12 at 15:40:18ID: 26270647

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: jaymz69

Posted on 2009-10-12 at 15:41:37ID: 26270648

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Log In

Forgot your password?Sign up

Top Experts

  1. pcelba

    4,240

    0 points yesterday

    Profile
  2. mozner

    2,000

    0 points yesterday

    Profile
  3. mbarbir

    1,912

    0 points yesterday

    Profile
  4. jrbbldr

    1,500

    0 points yesterday

    Profile

BrowseAre you an Expert?