Home » Developer & Programmer » Forms » How to Display Last 15 Days Record in Execute Query
How to Display Last 15 Days Record in Execute Query [message #87698] Wed, 02 February 2005 00:09 Go to next message
M Kumar
Messages: 38
Registered: August 2004
Member
Hi All,

I am having a form with three modes (ADD,MODIFY,QUERY).

In Add Mode Records are added.

In Modify Mode a date field CDATE is entered then executed and against that date datas are modified.

In Query Mode all the records in the table get displayed and user cannot Add or Modify in Query Mode.

My problem is i want to Display only last 15 days data in Query Mode.
How to do it and needed and what code is to be written .

Thanks in Advance.
M Kumar

Report message to a moderator

Re: How to Display Last 15 Days Record in Execute Query [message #87699 is a reply to message #87698] Wed, 02 February 2005 00:56 Go to previous messageGo to next message
sanjiban
Messages: 10
Registered: January 2005
Junior Member
u can set the same condition in the Where clause property of ur data block.

Report message to a moderator

Re: How to Display Last 15 Days Record in Execute Query [message #87700 is a reply to message #87699] Wed, 02 February 2005 01:11 Go to previous messageGo to next message
M Kumar
Messages: 38
Registered: August 2004
Member
But I want in Modify Mode to Execute Query for any Date.

I am having a MODE Button which when pressed changes Mode from Add to Mofify to Query.

Think u now understand my problem.

M Kumar

Report message to a moderator

Re: How to Display Last 15 Days Record in Execute Query [message #87708 is a reply to message #87698] Wed, 02 February 2005 20:56 Go to previous message
Ritesh
Messages: 38
Registered: November 2001
Member
u can use default_where clause or
write code in pre-query according to ur conditions.

Report message to a moderator

Previous Topic: process queries parallel
Next Topic: Ungent-Opening another Form on the Same Window
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 13:41:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.