Visual FoxPro 7.0

Visual FoxPro 7.0

Post by Cindy Wine » Fri, 25 Jun 2004 06:51:19

Hi Cassie,

Run your app in the VFP IDE with the de *** open and set a breakpoint on
the offending line. Check the value of lchrg_dna_qiagen(nm,1) in the Locals
Window. You should be able to see the data type there.

Also, check the data type of your text boxes. You can initialize the box to
the Date data type by putting "{}" (without the quotes) in the Value
property via the Properties sheet.

I'd stay away from CTOD and also from 2-digit years. To write a Date value
in text, enclose it in curly braces: ... IF out_date > {01/01/1960}.... To
make a totally unambiguous date write it like ... {^1960/01/01} .

Finally, I know you've posted a code fragment, but you check for the
reasonalbleness of the date (Out is after In) but you don't do anything to
force the user to correct the problem.

Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP

Visual FoxPro 7.0

Post by Anders Alt » Fri, 25 Jun 2004 09:29:51

Why not input dates as date. Give the textbox an initial value of {} .
Regardless of you SET DATE setting, hardcoded dates should be in the form
{^1960/1/1} or DATE(1960,1,1) with SET
STRICTDATE=1 (or 2).

additional input field to this form, input5. Rebuilt the project and the
application. Am able to input data into this form and save it.
following error message:
exact same code, the only exception is this other form only has four input
fields. That is the only difference. Help would be greatly appreciated.