I'm using pdox4.5 and need some direction, as usual.
The task I need to perform is this:
I have two tables, identical. One is the history table. I need for the user
to be able to enter a social security number in the data entry form and have
a method to look(locate) into the history table to see if this person ever
applied before. If they have I need to be able to view that record in a form
so the user can view the data.
If the SSN is new I need to allow the user to continue data entry.
I have been able to locate the record using TCursor and I have been able to
copy the record into the data entry table from the history table.
I haven't been able to view the record without closing the form and bringing
it up again and having the user re-enter the SSN.
I continually get a conversion error pertaining to the SSN. It consists of
not being able to convert a string to a long interger. The field is A11
picture ###-##-####.
I use TCursor to open and locate but haven't got an attach to work for some
reason.
Any suggestions, snippets of code or additional ObjectPal references would be
greatly appreciated.
Thanks
Frank
--- GEcho 1.11+ OS/2
---------------
* Origin: The CoCoNut Palms Hotel Spfld. Mo. (417)887-6048 (1:284/3)
|