visitor (0 QPoints)
  • FR
  • EN
  • NL
  • DE
  • ES
315 experts, 1193 registered users, 1659 questions already answered
European Experts Exchange, the very best site for high-quality IT solutions

New Improved Search!

 


05/10/2011 1h30 : Steve Jobs is dead, the father of Apple ][ is gone, we are all orphaned.

Languages :: General :: Passing Table variables from 1 form to another.
By: LOUISBOUDVILLE U.S.A.  Date: 19/07/2003 00:00:00  English French  Points: 50 Status: Answered
Quality : Excellent
I have 2 tables. Table A and TAble B.

1. I have a login form that uses table A to pickup the userid and password field to compare
with the entry. Also I have another field dept in table A which I want to pass to another form jobnofrm when
the login entry is successful.

2. In this jobnofrm i would like to have the variable in dept of table A be string as such "dept+serialno+mthyr".
then save the results in Table B.

How do I pass the variable dept to the form jobnofrm so that I concatinate it ?
How than do I save it to table B ?
Can I use select and replace statment, if so how do I use it ? Some sample source code would help.

Which method or event should I put my code in ? i.e Init,Focus,Valid,Load etc.... or do I need to create a method for it ?

Thanks
Louis

By the way I would like to thank CARL for providing the hint on using Install Shield for distribution of VFP exe.
But you also have mention that the VFP files req. e.g VFPRUN.DLL is automatically pickup by install shield when one set
up the parameters in the merge module in IS.

For you information I have got my distribution disk working and Thank You again.
By: VGR Date: 20/07/2003 18:18:00 English  Type : Comment
? VFP ?

anyway, to pass your value from a form to an other : either pass it as a global variable of your program (if such a concept exists), or as a parameter in a call to jobnoform.init() - for example -

saving this value to the table B should be a mattre of INSERT INTO ... or UPDATE ... depending on your needs

I can't help more precisely, I don't have enough technical details
By: LOUISBOUDVILLE Date: 20/07/2003 19:05:00 English  Type : Comment
DEAR VGR,
My e-mail address is louispb@tm.net.my, if your kind self could provide me your e-mail address I could send
you the details ( Forms, tables and class ) for your perusal in order to provide a workable solution.

Thank You for your effort. But your ans is very limited for a newbie like myself in VFP.

Louis
By: VGR Date: 20/07/2003 19:21:00 French  Type : Answer
Cher Louis,

Ce serait avec plaisir, mais je ne connais rien à VFP ;-)

Cordialement,

Vincent
By: LOUISBOUDVILLE Date: 22/07/2003 13:22:00 English  Type : Comment
Thank you Vincent,
I set as Public lgdept,lgusername
and transfer the variable to it. And when I call up the other form the variable was pass onto it

I did not know that VFP 7.0 could also used the DOS Foxpro2.5 methods. I thought it was some other new methods
to do so.

Louis

Do register to be able to answer

©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page! Post to Twitter Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to Facebook Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

EContact
browser fav
page generated in 347.357990 milliseconds

Why Google AdSense ads ?
compteur
 Ranking-Hits PageRank for this page