is there any thing wrong with this expression because its giving me an error. thanx for the help
SCAN FOR BETWEEN
(ldDate,from_date,to_date) !EOF()
anything wrong ?
Hot Topic
- Errors running FoxPro Stored procedures in .NET windows app
- Speeding up SQL Statements
- Forcing code into a Click Event
- VNC API?
- How to implement Mouse leave for a form.
- VBA to VFP code conversion
- Dynamically changing the mouse pointer in a grid.
- _MSYSMENU handle is changing after running a modal form
- ceiling to the nearest nickel
- Merge 2 text file
Visual FoxPro
- Cannot execute program outside VFP9 IDE.
- "When" firing after "Valid"
- HUGE problem with the Container Control (?)
- Memo field conversion
- SQL Server Express & Foxpro-populating SS from Foxpro
- What comand to clear content of General field?
- appending data into an existing DBF with an autoincrement field
- Passing multiple variables from forms w/ VFP7SP1
- Foxpro Power!
- How to change assigned class libraries.
anything wrong ?
learningdba
There is not any operator or scope clause between 2 functions.
scan for between(ldDate, from_date,to_date) && no need for eof() check scan does that for you
scan for between(ldDate, from_date,to_date) while !eof()
Mazzica
Actually, it's easier than that. SCAN FOR implies WHILE !EOF(), so leave that off. The statement can be:
SCAN FOR BETWEEN(ldDate, From_Date, To_Date)