[DUG] Validate data entry

I'm entering quite a lot of data from different forms into a single database. I need to validate the data on each entry point on each form. If I use a OnKeyPress, I can write a routine to get what I want, but I would like to use the routine directly off the field in the DataModule and not on

Re: [DUG] Validate data entry

Hi Wallace Write a procedure for the validation routine in the DataModule. Then call it from the OnKeyPress event in each form. Todd. I'm entering quite a lot of data from different forms into a single database. I need to validate the data on each entry point on each form. If I use a

Re: [DUG] Validate data entry

I have a related question - I have been wondering how to display data in a dataset that is not either simple integer, string or date-time. Examples are: dates stored as an 8 digit integer (MMDD) (want to display as dd-mmm- and I already have the code to format it how I want) IRD

Re: [DUG] Validate data entry

Hi John, Don't have the details in front of me but have a look at TField.OnGetText event. Wherever the field gets displayed it will call on its OnGetText event if it has been defined. In that event you can reformat you field into what ever string format you like. Hope this helps, Colin On 1

Re: [DUG] Validate data entry

Hello John A first step could be to capture the data in a control that ensures the data is correctly formatted. In the three examples below the format is fixed and ideal for a TMaskEdit control. In my document production package I accept data for arbitrary used defined fields and allow users to

[DUG] Sorting by date

Hi, I'm using Delphi 2007 and dBase files. I am creating a .csv file. I need to sort my file by RailType and OrderDate. The resultant .csv shows RailType is in alpha order and OrderDate is in string order; namely, the sort is on the month part of the date ( 12/2/2010) that is the 12. So I'm

Re: [DUG] Validate data entry

Thanks for the reply. Write a procedure for the validation routine in the DataModule. Then call it from the OnKeyPress event in each form. I have about 20 forms and 10 -20 entry points on each form, so the OnKeyEvent looks like the long way round. The database is only 20 fields long but each

Re: [DUG] Validate data entry

. What I would like is to attach the validation to the data field in the DM. That way I can also specify a range for the entry which will be common to all forms. Thanks Wallace. __ Information from ESET NOD32 Antivirus, version of virus signature database 6172 (20110601

Re: [DUG] Sorting by date

Yes, the numeral order would be correct. Or format the date as -MM-DD Rohit On 2/06/2011 10:08 a.m., Charlie wrote: Hi, I'm using Delphi 2007 and dBase files. I am creating a .csv file. I need to sort my file by RailType and OrderDate. The resultant .csv shows RailType is in alpha order

Re: [DUG] Validate data entry

If the forms are similar you could use Form inheritance or Frames to cut down on the number of different entry points. A master form with all the entry points and validation, with inherited forms showing different layouts. Alister Christie Computers for People Ph: 04 471 1849 Fax: 04 471