How do I get the system date?

[Sunit Katkar]

I wanted some expert guidance.

In my application I need to ad osme bells and whistles.

I have many forms with text fields. The text fields are filled with text that I retrieve from the database. Incase a new record is being created then , obviously, there is no pre-existing text.

I have a text field, which gets filled with text from the database record in the frmOpenEvent
If there is no databse record then the text field is blank.

Okay, now when I am creating a record for the first time, this is what I do :
1) I tap on the text field
2) The cursor starts to blink
3) In my fldEnter event I set the FieldAttr to autoshift = true
4) hence the first character gets typed in upper case
5) Then rest of the text is eneterd in lower case
6) Now I go to another text field.
7) Then I come back to the baove text field.
8) In the fieldEnter event I check if there is any text in the field.
9) There is text as we just had entered it.
10) So set autoshift to false
11) Here is where my problems start -
        a) I cannot make the cursor visible on just re-entering the field
        b) I cannot drag my pen and select any text as I would be able to in a normal text field.

I have tried FldSetInstPosition, FldSetInsertionpoint, FrmSetFocus, FldGrabFocus, etc.. but to no avail.

Could you please help? Suggest some code?

Thanks a lot,

Sunit

Thanks,