help: tcursor/resync 
Author Message
 help: tcursor/resync

2 tables are linked by a code field that I'd like to fill
automatically, whenever a new record is inserted in the master. The
Confusion Ref book didn't help... I wanted to do it through Tcursor,
then resyncing field to tc to have user enter data. What do I need to
write?

Also:  What are your best buys in terms of Pdx books? In general, I
need some ideas on structure/OPal/delivering etc.

Much oblige'

Thanks
Sven

PS: pls. email



Thu, 17 Dec 1998 03:00:00 GMT
 help: tcursor/resync



Quote:
>2 tables are linked by a code field that I'd like to fill
>automatically, whenever a new record is inserted in the master. The
>Confusion Ref book didn't help... I wanted to do it through Tcursor,
>then resyncing field to tc to have user enter data. What do I need to
>write?

>Also:  What are your best buys in terms of Pdx books? In general, I
>need some ideas on structure/OPal/delivering etc.

>Much oblige'

>Thanks
>Sven

>PS: pls. email

Sounds like you need to describe the strucure of your database, because
I think you need to look at re-design to use the power of built
in functions of Paradox such as referential integrity etc

--
Brian Trevis



Fri, 18 Dec 1998 03:00:00 GMT
 help: tcursor/resync

Quote:
> 2 tables are linked by a code field that I'd like to fill
> automatically, whenever a new record is inserted in the master.

If the two tables are linked in the datamodel, adding a value to the
master will automatically add the key value to the child record. For
example:

tc.open("master.db")
tc.edit()
tc.insertRecord()
tc."KEY FIELD" = SomeValue
tc.unLockRecord()
tc.endEdit()
tc.close()
uiObjectName.reSync(tc)

Remember to rename the uiObject so that you are not referring to it's
"noise" name. For example if is a tableframe with client names rename it
to tfClients so your reference would be tfClients.reSync(tc).

Daniel Morgan
EXE Solutions



Sat, 19 Dec 1998 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. TCursor.Locate() and TCursor.qLocate() both fail

2. PLEASE HELP ---- Resync Problems....

3. PW5/Help with OPAL Filter/Locate/Resync

4. HELP--TCursor Problem

5. Help! TCursor and UIObject

6. Help! TCursor and UIObject

7. help with form / tcursor pointer problem

8. TCursor help

9. TCursor help

10. HELP! Linking DropDownList to TCursor

11. Help With Tcursors in PDXWIN 5.0


 
Powered by phpBB® Forum Software