TIP: Click on subject to list as thread! ANSI
echo: paradox
to: ALL
from: FRANK STOGSDILL
date: 1995-02-16 15:14:00
subject: Best Way

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)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.