Bill, What are the data types of the two columns Block and Lot? If they are not text, you may be losing their values in the conversion.
Try: SELECT Sektion, (CTXT(Block)), (CTXT(Lot)) + INTO vSektion vi1, vBlock vi2, vLot vi3 + FROM sbj + WHERE propid = .vpropid On Mon, Oct 8, 2012 at 10:06 AM, Bill Eyring <[email protected]>wrote: > ** > Bill, > > All variables are preset to TEXT except vPropid which is integer. > sel Sektion,Block,Lot into vSektion vi1,vBlock vi2,vLot vi3 fro sbj + whe propid=.vpropid > > Bill > > ------------------------------ > *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Bill > Downall > *Sent:* Monday, October 08, 2012 9:57 AM > *To:* RBASE-L Mailing List > *Subject:* [RBASE-L] - RE: Capture_From_Window Question > > 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]> 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 >> >> >> >
