Jan Me, you, Jason, Dennis and Bill, but most of all me, missed the real problem. For some obscure reason, probably from making backup forms,copying etc., I discovered the problem and I could kick myself in the you-know-what. Sometimes when you are dogged on the trail, something from left field jumps up and bites you. I was composing an answer to your email to show code, variables etc. for all to look at. When I clicked on List of Expressions in my form I saw 2(TWO) sets of variables with each set of variables based on the same form table duplicating the variable list. It did not show when I clicked on Add/Edit Variables just when I clicked on List Variables. How this happened I do not know, but problem resolved. My form now runs perfectly. Many, many thanks. Bill Eyring _____
From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Monday, October 08, 2012 1:51 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Capture_From_Window Question Bill, Where does this code live? Sometimes you just need to SET TRACE ON before you start your form and figure out when it occurs. Then the why becomes obvious. Jan -----Original Message----- From: "Bill Eyring" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 8 Oct 2012 13:31:38 -0400 Subject: [RBASE-L] - RE: Capture_From_Window Question Jason Thanks for your help. It was partially successful. However, the main variable which calculates all my other vars keeps getting cleared for no apparent reason and I'm getting really frustrated. In my defined variables I have ; vpropid INTEGER = propid I have located a DBEdit field defined with the field PROPID What I can't comprehend is why my variable vPropid keeps getting cleared when there is absolutely no code or setting to clear ANY field, variable or eep in the entire form. It seems when I tab through bit buttons, the variable is clearing, destroying the file location variable before it can save the file. Bill Eyring _____ From: [email protected] [mailto:[email protected]] On Behalf Of Jason Kramer Sent: Monday, October 08, 2012 10:09 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Capture_From_Window Question Bill, Give this a whirl. I just used it in a Push Button OnClick EEP and it worked. Since you (probably) don't have a user named jjkramer on your system, you will have to edit the vmyfpath variable, but otherwise it should work. I ran this code on 9.5.2.11008 x64 on Windows 7 Ent x64. Jason SET VAR vsektion TEXT = '21' SET VAR vblock TEXT = '11' SET VAR vlot TEXT = '22' SET VAR vmyfname TEXT = NULL SET VAR vmyfpath TEXT = 'C:\users\jjkramer\desktop\' SET VAR vmyfile TEXT = NULL SET VAR vmyfname = .vsektion + .vblock + .vlot + '.jpg' SET VAR vmyfile = .vmyfpath + .vmyfname PROPERTY RBASE_FORM 'CAPTURE_FROM_WINDOW|1,1,100,100' &vmyfile CLEAR VAR vsktion,vblock,vlot,vmyfname,vmyfpath,vmyfile RETURN Jason Kramer University Archives and Records Management 002 Pearson Hall (302) 831 - 3127 (voice) (302) 831 - 6903 (fax) On 10/8/2012 9:56 AM, Bill Downall wrote: Bill, What data type are the variables vblock and vlot? Or the columns vblock and vlot? You might need CTXT(.vblock) + CTXT(.vlot) Bill On Mon, Oct 8, 2012 at 9:10 AM, Tony IJntema < [email protected] <mailto:[email protected]> > wrote: I think there is something wrong with vMapimage = ''C:\Village\Maps\211121.jpg' There are double quotes or two single quotes at the beginning, which makes the variable null. Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring Sent: maandag 8 oktober 2012 14:57 To: RBASE-L Mailing List Subject: [RBASE-L] - Capture_From_Window Question When I issue the following command for some reason it is setting variables to null and not capturing to the proper file name. Here are my variables set v vPropid int=4558 sel Sektion,Block,Lot into vSektion vi1,vBlock vi2,vLot vi3 fro sbj + whe propid=.vpropid set v vMapimage=(.vSCMapLoc+.vsektion+.vblock+.vlot+'.jpg') My variable values are as follows; vSCMapLoc = 'C:\Village\Maps\' vsektion = '21' vblock = '11' vlot = '22' vMapimage = ''C:\Village\Maps\211121.jpg' When this command is run PROPERTY RBASE_FORM 'CAPTURE_FROM_WINDOW|10,40,617,601' &vMapImage the image is saved to a file named .jpg. The .jpg file has the correct image, it is just not naming it properly. There are no recalc variable commands in my code. Why is the command dropping variables ? Thanks for any help Bill Eyring
