collapse the expanded strutcure

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - list item - go top I use list box to show the item .I add over 100 items in that list box (after adding, How can I move the cursor to the 1st item of that list box) Tag: collapse the expanded strutcure Tag: 229536
  - 2
    - Strange problem 3 In a grid (subclassed), grid.recordsource="table1" grid.columns[1].contorl="field1" The grid becomes read-only. After I changed it to: grid.recordsource="table1" grid.columns[1].contorl="table1.field1" the grid can allow changes. What could cause this? -- iTech Consulting Co., Ltd. Specialized in providing ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: collapse the expanded strutcure Tag: 229535
  - 3
    - rlock() & multiple instances of app I have to run multiple instances of an app on the same desktop. I thought I could use rlock() on a shared table so each instance would know what data it can't process.... but, although I seem to remember doing this successfully many years ago, it doesn't seem to work any more. My work around, testing for the ability to fcreate() a flag file works fine. What's up with rlock(), vfp9 & xp? -- -Lew The workers took the robot for Maria. Tag: collapse the expanded strutcure Tag: 229529
  - 4
    - bring an object to the front programmactically object.zorder(1) send it to the back, how about bringing it to the front? -- iTech Consulting Co., Ltd. Specialized in providing ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: collapse the expanded strutcure Tag: 229493
  - 5
    - Strange Problem [2] Anyone interested to remote into my computer and see the endless loop error I encountered during *HONG KONG OFFICE HOURS* (ie, 09:00-17:00 Hong Kong Time)? I could set it up for your pleasure. -- iTech Consulting Co., Ltd. Specialized in providing ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: collapse the expanded strutcure Tag: 229492
  - 6
    - MOUSE Is there an easier way to move the mouse pointer to hover above a certain thisform.control? Right now, I need to compute the coordiantes myself. (reason: sys(1270)) -- iTech Consulting Co., Ltd. Specialized in providing ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: collapse the expanded strutcure Tag: 229490
  - 7
    - Record Used by another user Hi, I have a Form that when run, uses the RLOCK() to lock multiple records but there are times that I get an Error "Record is Used by Another User". Is this possible? RLOCK() returned .T. I also tried to locate if other user is Editing that Record but I couldn't find anyone with that record open. Am I doing something wrong? I use TableUpdate(.t., .t.) -- Thanks, Karma Tag: collapse the expanded strutcure Tag: 229477
  - 8
    - Phone Dialer Does anyone have VFP code to dial a phone? I don't want to buy a control for this. It does not need to be fancy - just dial the specified phone number. Thanks. Charlie Parker Tag: collapse the expanded strutcure Tag: 229476
  - 9
    - MI5 Persecution: Dirk Gently on the Toronto Case Dirk was on the West Coast when he got the call. An old friend at the Toronto police department thought he would like to fly up and take a look at a homicide which had occurred the previous evening. He decided to skip the last day at the World Holistics conference and take the next plane out of San Francisco. The flight was bad; Dirk had been hit on the back of the head by the Newspaper trolley, the drinks trolley, the dinner trolley and now the gift trolley. When the hostesses weren?t trying to tear his arm off they pestered him to stop leaning into the aisle - ignoring the fact that the guy next to him was taking up one and a half seats. Air Canada used to be the flight which was so good you just didn?t wanna get off - on this occasion Dirk would be glad to see the back of the plane and the over sized alternative comedian wedged into the window seat. After breathing in a couple of lungfulls of crisp Canadian air Dirk took a taxi into town. There was a small group of demonstrators outside the MacDonalds and the taxi driver insisted on stopping on the opposite side of the street. ?Don?t Eat Meat? the placards read and the demonstrators chanted. A couple of policemen where stopping the crowd entering the restaurant itself - one held up his arm and challenged Dirk. A wave of the fax he had been sent and the policeman pushed open the door. There were few customers in the restaurant. Not surprising really with a demonstration going on outside, half the dining area roped off with tape and a dead body seated at one of the tables. ?Mr Gently sir? the officer in charge called out as he peeled one end of the tape off a column ?We were told not to touch anything til? you got here?. The body of the man slumped awkwardly in a chair. Then even a dead body would start getting uncomfortable in a MacDonalds chair after twenty minutes - and this one had been there for at least eighteen hours. Two back legs and the tail of a cat hung out of the man?s gaping mouth. Dirk turned to the officer, ?I suppose you are going to tell me this is the darndest thing you ever saw?? ?Ain?t this the darnd...?. The officer seemed annoyed that Dirk had second guessed him. ?We?re removing the body in a few minutes, so if you can get through as quick as possible? ?Many people eat cats in fast food restaurants?? Dirk asked and without waiting for an answer leant over the table to pick up an untouched burger. ?And what?s this?? he asked waving it in front of the officers face. ?It?s a Vedgie Burger? The waitress, who was cleaning one of the adjacent tables, shouted across. She walked over to Dirk. ?We started doing them because of that lot out there? she nodded towards the protesters who were pressing there faces against the windows ?They?re called Linda McCartney Vedgie burgers - ever heard of them?? Dirk suddenly felt faint, perhaps a combination of hunger and jet lag. ?This is deja vu all over again? he thought to himself. He glanced at policemen - at the badge on his shoulder ?OPD? but this wasn?t Ontario this was Toronto. OPD - Officially Pronounced Dead. It dawned on Dirk what was happening, he knew what he would see if he looked out of the window. Sure enough, there it was, the Volkswagen Beetle parked across the road - number plate 28IF - 28 IF Paul McCartney had lived. And amongst the lyrics of the song blaring out into the restaurant he could pick out the words ?I buried Paul?. Now it was though Dirk was viewing the whole scene though a TV screen. This was conspiracy. Not -a- conspiracy, or -the- conspiracy, but just plain conspiracy. ?You look faint - are you OK mister? The waitress asked. Dirk shook his head ?Probably a bit hungry? Then to economise on dialogue took out a pack of cigarettes and held it out towards the girl. She was about to take one but Dirk snatched the pack away, held it up to his mouth and drew out two cigarettes. He lit both then passed one of them to the girl. It was the closest he had come to a sexual encounter in three months. ?Want a Burger?? the waitress asked. Dirk looked down at the Vedgie Burger on the table. ?No thanks - just a plate of fries? The waitress walked away and Dirk looked around the room. Apart from a family seated in the far corner there was only one other person in the restaurant - and he wasn?t eating. The guy was about mid twenties and had straggling, shoulder length hair. On the table in front of him were lots of pieces of paper cut into squares. Every so often he would pick up a camcorder and pan it around the room and then, when he was finished, speak into a microphone which was attached to a tape recorder. Dirk walked over to where the man was sitting. The small pieces of paper had paragraphs of text written on them and were stuck to the top of table with blobs of mustard. Lines had been drawn, some solid some dotted, on the table top with a marker pen. The lines ran from one piece of paper to another. ?What are the lines for?? Dirk asked, realising straight away that ?What the hell are you doing?? would be more appropriate. ?You see? The man replied nervously ?The dotted lines are weak links and the solid lines are strong links. The dotted lines are things which are happening in the rest of the world and the solid lines are things which are happening to me. Now you see I draw over a dotted line, replacing it with a solid line, when I can link something back to me. Like this? The pen squeaked over the Formica and before Dirk could interrupt the man added. ?You see I lost my short term memory and, as a consequence have a very short attention span. I write down, record and film everything then put it all together later? ?So? Dirk interrupted. ?You filmed what happened here?? ?Yes, yes, it?s here on this tape? The man pushed the cassette across the table. On the label the words ?Grassy Knoll? had been crossed through and replaced with ?MacDonalds?. Suddenly the man sprung from his seat. Dirk turned and saw that the body was being removed on a stretcher. As it passed the man picked a small object off the edge of the stretcher itself. ?This is important? he said, laying a blood stained bullet on one of the small pieces of paper on the table. Suddenly the room was filled with a deafening throbbing sound as a Black Helicopter landed in the street outside. Two men in United Nations uniforms got out and collected the stretcher. Back at the table the long haired man was replacing all the dotted lines with solid ones. Dirk panicked and began to walk backwards at some speed. Barging through the swing doors he stumbled into the kitchen, tripped and felt himself sink slowly into a large vat. ?The guys fallen into the batter? Dick heard someone shout before he sunk below the surface. He came to sitting in a chair with the batter solidifying all over his body. He surveyed the room through two eye-holes someone had cut. Suddenly the chair on which he was sitting was picked up carried through the restaurant and out of the building. As the chair was being lifted and put into the back of a van, Dirk caught a glimpse of the waitress following him. ?Your fries mister, your plate o...?. The doors of the van shut and Dirk tried desperately to steady himself as it sped across town. Eventually the doors flew open and Dirk was flung into the road at which point the solidified batter shattered and set him free. Standing up he found himself outside the international departures terminal of Toronto airport. In the departure lounge Dirk had time to reflect on the day?s events. He had got caught up in the conspiracy theories and the haphazard welding together of pieces of irrelevant information. It was time to catch the person who was operating the bizarre cognitive engine which appeared in front of him like a fairground mirror, distorting any flaw it could find in his own, fragile, map of the real world. Dirk leant into the aisle of the plane as it took off for London. The oversized person next to him swung his arms violently as he complained about every thing from the supper in a plastic tray to the state of British politics. With a shaven head and a badly fitting suit the man looked as though he could have worked behind the reception desk of the Kremlin. However when he spoke he did so in a Liverpudlian accent. ?Me I blame the Con-serv-a-tive government, me. The Tour-rees. That-cher. Me. They need a good kicking? He jerked his feet forward and struck the seat in front with his Doc Martins. ?With these. Me Doc Martins. Doctor Martin?s, Doctor Martin?s, Doctor Martin?s Booots!? The phrase was now being sung over and over again as the man writhed in his seat and clicked his fingers. Dirk looked down at the boots and thought of the reaction most people used to deal with the paranoids at the end of the wire. A nice quick kick. ?Oi nutter - get some therapy?. This is the easy way out and perhaps the safest. After all there you are sat, alone, in front of the screen. No body language between you some paranoid. No way of telling if he really is some gibbering psycho. Look at it too long and you be drawn in. Fall into the tangled database of weird links with him. Who knows he may be watching you, reassembling and linking your experiences with his. How sure are you of you own cognitive threads. After all cognition is only a bug fix for a neurological system which was designed in a hurry - it?s abused by everyone from politicians to advertisers. If people really can convince each other that a bottle of washing up liquid is as exciting as an orgasm using just television God knows what they can do with a computer. Better to avoid the risk. A swift kick. After all if you?re Homophobic you put the boot in because you are scared of any ambiguity in your own sexuality - why not be Nutterphobic as well. Although Dirk would have liked to devoted time to tracking the culprit down he decided to let it rest. The Internet changed over the next twenty odd years. A lot of the people who used it went out and got lives. And those who already had lives burnt them away. The number of users had dwindled after someone had invented a C++ program, with truth as a variable, to deal handle politics and government. Dirk had already retired from finding old ladies cats with the help of obscure science when he got another call from Toronto. It was 4th March 2025 when he booked onto the Air Canada flight from Heathrow. The silver haired woman in the seat next to him painted bright red lipstick around her mouth. ?Of course it was no surprise to be offered the job after Claire Raynor retired? she sneered? After all I used to be a psychiatric nurse... Now if Blokes had periods they would understand...? By chance the taxi ride to Toronto mental hospital took him past the MacDonalds - where the whole thing had started. Of course it was barely recognisable having become a Church Of Scientology Vedgie Bar. Police in riot gear kept the two sets of demonstrators apart. Dirk didn?t really know what to expect when he got to the hospital. The girl at the reception desk directed him to a row of chairs in a wide well lit corridor. There was a strong smell of disinfectant, the furniture and the carpets were immaculately clean and behind the rows of teak veneer doors the ?nutters? were all safely locked away. For some reason Dirk started thinking about CompuServe forums. A tall blond woman in a white coat approached. ?Mr Gentle, I assume? ?Yes? Dirk replied shaking her by the hand. ?You?re the nurse who...? ?Doctor? She interrupted, ?Doctor Killfile? She led Dirk across the corridor towards one of the doors then stopped with her hand resting on the handle. ?Now you know about this person don?t you?? and after Dirk nodded she continued ?Don?t tell him anything about yourself - don?t let him get into you head. If he does he?ll screw it up? The door opened to reveal a frail man sitting in from of a TV screen. He had a keyboard on his lap and next to the television was a computer screen. Dirk glanced at the walls of the room and remembered that his settee at home need upholstering. The nurse left the room and the man looked up ?So you come to my daughters wedding and ask me to kill a man? he said in a dry cackling voice. ?Look? he continued, pointing at the screen, ?I know that man. They?re talking about me now - listen?. The man stared at Dirk. ?What?s your name? Are you one of my friends from the Internet? - Are the lambs still screaming Dirk?? Dirk, at first recoiled in horror, then felt a sense of anti climax. So this is what they hyped up to superstar status on the back of their own fears of madness. Dirk was reminded of the film ?A day on The Beach? where a submarine had set off to search a post nuclear World to track down a signal coming from a remote military base - only to find it was being sent by a Coke bottle half balanced on a Morse tapper. Outside the room the nurse waited for him. Because his nicotine craving had returned - and to avoid an awkward piece of dialogue - Dirk turned to her and asked . ?Patch?? Dirk took two nicotine patches from his wallet the first of which he stuck onto the inside of his arm. Stepping closer to Doctor Killfile he opened her white coat and slid his hand into the opening at the front of her dress. He pressed the patch onto her leg as close to the top of her inner thigh as he dare. She took a deep breath and then slowly breathed out. ?What Bogart could have done with these things? Dirk thought to himself. ?Is he crazy?? Dirk asked tilting his head back to towards the door. ?Who knows? Doctor Killfile replied ?We let him type away. He sees something on the TV in the morning and it keeps him busy all day. What he types doesn?t go anywhere it just stays on a mainframe in the basement. It can be read by anyone else in the building but that?s it. We got them all in here conspiracy theorists, racists, nationalists. They?ve created a world within a world really...? Her voice trailed away and she stared down the corridor for a while then added ?So long are two things are different neither will come to be in the other and so become at once both one and two.? Dirk gave her a puzzled look ?You mean their brains are fried?? ?Fried?? Killfile smiled at Dirk ?No that was Plato?. Then the smile fell from her face. ?You must remember, mister, plate o...? 732 Tag: collapse the expanded strutcure Tag: 229459
  - 10
    - MI5 Persecution: Security Service Tribunal Denies Security Service Tribunal Denies In June 1997 the Security Service Tribunal wrote to me regarding the complaint I had brought against MI5 in February. They say, The Security Service Tribunal have now investigated your complaint and have asked me to inform you that no determination in your favour has been made on your complaint. Again, I do not believe their denials. I think MI5 *has* taken the action against me as described, and is refusing to admit what they have done. To the best of my knowledge, the Security Service Tribunal has *never* found in favour of a complainant. This tends to strongly suggest that MI5 lies on a routine basis, and the Tribunal can't fulfil its functions in the face of Security Service falsehoods. 732 Tag: collapse the expanded strutcure Tag: 229454
  - 11
    - Last object that got focus() at the moment I clicked a button? Is adding codes to all objects' gotfocus() the only/best solution? -- iTech Consulting Co., Ltd. Specialized in providing ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: collapse the expanded strutcure Tag: 229451
  - 12
    - Trapping Mouse Click on a grid Is there a way to trap a mouse click on a grid so as to make that field True or False?? I have a grid on a form that allows the user to change a columns field value to either True or False by typing either a T or F on that field. The user wants to just be able to click his mouse on the field to flip it from T to F and Back. TonySper Tag: collapse the expanded strutcure Tag: 229427
  - 13
    - [surve] what if... The object of a form would not lost focus when a form opens on top of it? Would it make everyone's life easier? -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.10) Linux 2.6.19.1 ^ ^ 17:02:01 up 24 days 23:14 0 users load average: 1.03 1.06 1.01 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: collapse the expanded strutcure Tag: 229400
  - 14
    - Field Type - VFP9sp1 What would be the best field type to work with windows/network file paths? I wanted to use a "filepath c(254)", but this seems short. Thanks!! Tag: collapse the expanded strutcure Tag: 229388
  - 15
    - FOXPROCFG environmental variable We are running a commercial VFP 9 application that respects the setting of HELP=ON/OFF it finds in our configuration file. We set foxprowcfg=<file_name> at login time, primarily for the benefit of users of our custom VFP 6 applications. Because the commercial app uses a different version of VFP than our custom apps, we were wondering if the naming convention for a VFP configuration file exists to allow us to specify _two_ environmental variables and set things differently for each. E.g., back in the day, we would use foxprocfg and foxprowcfg to differentiate between the DOS and Windows versions. Our two VFP versions are, as mentioned above 6 and 9. Thanks in advance. -S- Tag: collapse the expanded strutcure Tag: 229385
  - 16
    - Resetting a Menu For years, my app has set up its menu and then gone merrily along. I now want to have the menu configurable. How do I get the old menuing tossed? If I restart the program after the configuration change, it works. It does not work when I rerun my menu setup code. (The code is executed, and I temporarily see the changes, but when I am back at the read events, the menu is back to as it was before my attempted change.) I have tried set sysmenu to default, set sysmenu nosave, release pad all, and release menus, but none have worked. My basic pattern is set sysmenu automatic set sysmenu to _medit <define pads> <define bars> How do I have to modify this so that the menu is reconfigured on subsequent runs? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: collapse the expanded strutcure Tag: 229384
  - 17
    - VFP9: Cant find AUTOCOMP.DBF Hello, I need to remove some invalid entries from AUTOCOMP.DBF, but I can't find the table. I searched without success. Help please. Thanks RS Tag: collapse the expanded strutcure Tag: 229383
  - 18
    - [VFP 9] strange problem In a form.method(), I have these: local m.xx m.xx=empty(thisform.mode) with thisform.cnCode .cmd.enabled=m.xx .txt.enabled=m.xx endwith When the .txt.enabled was set to m.xx, the form entered endless loop. If I set .txt.enabled to either .t. or .f. without referencing m.xx, it would be ok. What could cause this problem? -- iTech Consulting Co., Ltd. Specialized in providing ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: collapse the expanded strutcure Tag: 229364
  - 19
    - no tableupdate bug ? Hi, I'm using a free MyTable. I have a MyForm with textboxes where the controlsource points to fields of MyTable. In MyForm.keypress I have something like this : if nkeycode = -1 &&F2 thisform.release endif now here comes the tricky part when a user changes a value in a textbox and then hit the F2, MyForm closes. so far so good but the value isn't stored in the table ?!? This also occurs when the users click on the forms X whitout leaving the textbox. So how can I "force" a saving of the textbox.value in the mytable ? regards christophe Tag: collapse the expanded strutcure Tag: 229363
  - 20
    - laskey()=27 Is there a smarter way of stopping ESC from being passed from one form to another? For example, I have a formA.txt.valid() that returns .t. if lastkey()=27 for shutting down the form. I then called up a search form, and pressed ESC. The lastkey() will become 27. Now formA would see it, and formA.txt will react incorrectly. I am doing these in all search forms' unload() method: keyboard chr(254) inkey() -- iTech Consulting Co., Ltd. Specialized in providing ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: collapse the expanded strutcure Tag: 229361
  - 21
    - MI5 Persecution: Communications with Security Service Tribunal in 1999 Communications with Security Service Tribunal in 1999 I took some more potshots at the SS-Tribunal in the first half of 1999. The correspondence between myself and the Tribunal Secretary is detailed on this webpage. Ultimately I decided not to pursue another complaint with them, partly from Robin Ramsay's advice (and that of a solicitor I consulted), but mostly because it was rather obvious from Mr Brooks' replies that the Tribunal has no investigative means of its own and is that useless animal, a toothless watchdog. Included with this first letter was a copy of the leaflet, "Complaints about the Security Service". This tells you that the Tribunal can order "the service to end its inquiries about you; the service to destroy any records it holds about those inquiries; the quashing of a property warrant; financial compensation". Yeah, right. Look, there's a flying pig, oink-flap, oink-flap. My subsequent letter to Nick Brooks, Tribunal Secretary, dated 25 March 1999, said; Dear Mr Brooks, We spoke on the phone last week and you kindly sent a copy of the form, "Complaints about the Security Service". I have a few questions which I should like to ask you, before I undertake the task of making a formal complaint. As you know I made a complaint in February 1997, and in June of that year the tribunal made a bland and unsatisfactory statement that "no determination in your favour has been made on your complaint". During our phone conversation I expressed the view that the Tribunal was incapable of performing its functions and acts as a whitewashing body for the Security Service. My questions are as follows; (1) Has the Security Service Tribunal ever during its existence found in favour of a compaint against MI5? (2) Is the Tribunal able to disclose whether "no determination in your favour" is made because MI5 claims to have no inquiries on a subject, or whether it is made because MI5 admits to actions against a subject but claims justification? If disclosure is not possible for individual cases, then in 1997 for how many cases (out of what total) did MI5 claim justification? (3) Is the Tribunal able to investigate information such as British Airways passenger lists, given that these could conclusively prove MI5 involvement? Would the Tribunal be forced to rely on MI5 to carry out such investigations, or would it have some other means of investigating? It might look slightly ridiculous for the Tribunal to rely on MI5 to investigate their own misdeeds. When I made my previous complaint to the Tribunal in 1997 I gave very little information as to the nature of my complaint. This time I intend to give as complete information as possible; but before I do so, I would ask you to answer the questions above, to outline the "ground rules" for a Tribunal investigation and reporting of its results. Yours sincerely, Mr Brooks replied by sending me a photocopy of two pages from the 1997 Report of the Security Service Commissioner, as follows. The photocopied pages from the 1997 Report follow. In particular, the answers the report gives to my questions are; the Security Service Tribunal has NEVER found in favour of a complainant; see sections 29 and 31 of the scanned report. Nick Brooks has confirmed orally over the phone that he has no memory of the Tribunal ever finding in favour of a complainant. Secondly, the question of whether the Tribunal is able to disclose "no determination in your favour" is because MI5 claims to have no inquiries on a subject, or whether it's because MI5 admits to having inquiries but claims they are justified. The answer to this one is in section 24, which says the ambiguity is intentional; and the Tribunal will in no circumstances give an unambiguous answer of whether MI5 claims or disclaims inquiries on a subject. In section 27 of the report, SS Commissioner Lord Justice Stuart-Smith says the blanket denials "might lead some to speculate that members of the service are carrying out operations involving unlawful interference with property, such as the installation of eavesdropping equipment, without first obtaining a warrant from the Home Secretary." He goes on to try to deny this speculation. But we've heard from Peter Wright that this went on all the time in the 1960s. So why wouldn't it still be happening now? Of course it is. The Tribunal Secretary had avoided answering the question from my previous letter, of whether the Tribunal had any independent investigative capacity. So I asked him again. Dear Mr Brooks, Thank you for your letter dated 6 April enclosing an extract of the 1997 Report of the Security Service Commissioner. This answers two of the three questions asked in my letter of 25 March. The third question remains. In 1993 I travelled on a British Airways flight on which there also travelled four men, one of whom stared at me, laughed and said, "if he tries to run away we'll find him". I took this to mean that these were the men who had been pursuing me for some time in the UK. This leads me to ask again the last question in my previous letter; (3) Is the Tribunal able to investigate information such as British Airways passenger lists, given that these could conclusively prove MI5 involvement? Would the Tribunal be forced to rely on MI5 to carry out such investigations, or would it have some other means of investigating? It might look slightly ridiculous for the Tribunal to rely on MI5 to investigate their own misdeeds. I would very much hope that some means is available to the Tribunal and Commissioner to investigate possible MI5 malefaction, other than relying on MI5 themselves. When I receive an answer to this question from you, I will work to put together a more comprehensive and detailed complaint for the Tribunal's consideration. Yours sincerely, Brooks' reply was; Brooks doesn't want to give a direct reply to the question, since that would place him in a bad light. So he gives an indirect answer; the tribunal, he avoids saying, has no investigative capacity; there is no mention even of any investigative capacity provided by MI5 themselves; nobody can investigate anything, all the Tribunal can do is ask MI5, and they, in their "Alice in Wonderland" world, can redefine the truth as it pleases them, and dissemble, and lie. Before deciding not to put another formal complaint before the Tribunal, I asked Robin Ramsay, editor of Lobster magazine, what he thought of the idea of making a complaint to the Tribunal. He replied; RESPONSE Yes it is a waste of time. They will do nothing. In a further email he elaborated; As for quoting me on the Security Service Tribunal - if you think my comments would mean anything, feel free. The problem people have is this: they almost have to go through the motions of going to the Tribunal for if they don't they will always be asked, 'Why didn't you go the proper authorities?' (This is one of the chief functions of 'the proper authorities'.) Robin Ramsay So the sum of the various parts of this story is; DON'T GO TO THE TRIBUNAL. If you do, then MI5 will open a file on you (if you don't have one already). Don't do as I did, do as I say. If you feel a really deep-seated urge to complain, do so first under an invented name, which will make you understand just how useless the Tribunal is, how little information they provide, and how unpleasant it is to know that you have given MI5 a reason to officially open a file on you in their Registry. 732 Tag: collapse the expanded strutcure Tag: 229354
  - 22
    - How to Read USB Device Dear all I have an application ( VFP 6 ) in which Serial Port WightScale is connected to Computer through Serial to USB convertor, I want weight display of device in computer. How can I read it on USB port ? any idea? Thanx Tag: collapse the expanded strutcure Tag: 229352
  - 23
    - John Harvey at Chicago FUDG on 9 Jan 07 VFP patrols the streets of Memphis! The January Ninth 2007 meeting of the Chicago FoxPro Users & Developers Group will feature Lt. John Harvey of the Shelby County (Tennessee) Sheriff's Department. His application is an integrated Internet system based on SQL Server, Visual FoxPro, Web Connect, ASP, Mapping, and Instant Messenger technologies. It has dramatically improved police tracking of criminals and other law enforcement data. You definitely will get lots of new insights and inspiration. Same time and place: 5:30pm Jan 9th, 2007 at the Monadnock Building, 53 W. Jackson Blvd, in the famous Chicago Loop. As always, all reasonable ideas accepted. It's a community -- indominable. Upcoming meetings: February 13 will feature member presentations, and John Koziol is slated for March 13. More info: http://www.chicagofudg.com/ -- Message posted via http://www.dbmonster.com Tag: collapse the expanded strutcure Tag: 229349
  - 24
    - Subclass programatically defined classes I've inherited an app with numerous classes defined in PRGs. I need minor variations on a few and since there is so much code I want to reuse, not to mention inheritance being such a big plus, it feels like it would defeat the purpose to recreate them. Is there a way to subclass these? If so can you offer suggestions or resources on how to do so? I can't seem to find any info when searching the web. Thanks, Jim Tag: collapse the expanded strutcure Tag: 229344
  - 25
    - Showing decimal places in textbox? I have a form with a textbox and CommandButton. The Commandbutton click event is programed with: SET FIXED ON SET DECIMALS TO 10 thisform.text1.Value = STR(10/3) The result I expect is 3.33(33333...) in the text box. But it showed me only 3 (without decimal point and places). What's the solution?ã??ï¼´ï½?ï½?ï½?ï½?ï½?ï¼? -- Regards, Pedestrian, Penang. Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/foxpro-general/200701/1 Tag: collapse the expanded strutcure Tag: 229333
- Next
  - 1
    - MI5 Persecution: Eye Say, and Lord Gnome Answers Eye Say, and Lord Gnome Answers My interactions with Private Eye started in May 1995, shortly after I'd started bleating on usenet. I tried to get the Eye interested in my case, as I thought they more than anyone have their finger on the pulse, and would surely already know something about my case. In my first email to them, entitled "pas de bouteille?" (wot no bottle?), I asked if they had the nerve to publish what was known to many thousands of people. Their email flunky answered; Date: Thu, 11 May 95 13:40 BST-1 From: strobes@cix.compulink.co.uk (Private Eye) Subject: Re: pas de bouteille? In-Reply-To: <199505102232.SAA19988@freenet.carleton.ca> Bottle? Dunno really - but I've passed your mail on to the Ed for his consideration. Steve Mann (strobes) ========================================================== Date: Mon, 15 May 95 12:51 BST-1 From: strobes@cix.compulink.co.uk (Private Eye) Subject: Re: hello again In-Reply-To: <199505122236.SAA02574@freenet.carleton.ca> Hello yourself... Thanks for the email. Unfortunately, I can't say whether or not the Eye will do anything with this... I'm only the messenger. As the only computer-literate peron in the Gnome organisation, I get to read all the email and then pass it on to the Editor. Sorry -- not very helpful, I know. Steve Mann (strobes) The following year I gave PE another little prod, which yielded the following; Date: Tue, 13 Feb 96 11:38 GMT From: strobes@cix.compulink.co.uk (Private Eye Magazine) Subject: Re: Previous communication In-Reply-To: <199602102320.SAA26182@[snip]> Sorry not to reply sooner... we've been swamped with email and I have very little time to answer it. However, the editor sees all the email received here and I'm afraid he hasn't expressed an interest in your story so I can only assume that he feels it isn't for us. Sorry. strobes Given that I couldn't provide the evidence to persuade the Eye of the credibility of my claims, I did the next best thing, which was to take out classified adverts in their "Eye Say" and "Eye Tech" columns. My motivation for doing so is obvious; the Eye is read both by many thousands of ordinary folk, but also makes its way into the homes and consciousness of the UK's political and media elite. It is also a known favourite with "Five". What better way of taking the fight to the enemy? The first small ad appeared on 10 Jan 1997 in issue 915 in "Eye Say". It ran in that column on 24/1/97 and 7/2/97. On 21/2/97 it ran in "Eye Tech", and on 7/3/97 and 21/3/97 again in "Eye Say". I then changed the ad's wording to read "BBC Newsreaders Conspiracy", and the new wording ran in "Eye Say" from 4/4/97 issue 921, 18/4/97 to 2/5/97. The word "xenophobic" in the first advert had been intended to convey the sense of exclusion through the bigotry of my enemies, both on the basis of race and mental condition, but it seemed a bit too non-specific. "BBC Newscasters Conspiracy" was a little more immediate, although readers had to actually wade through the website to find out what it was that the newscasters were conspiring to do. My next effort tried to spice up the text. "MI5/BBC Conspiracy" ran for six issues in "Eye Say", from 5/9/97 issue 931 until 31/10/97. I suppose there is something a little sad about somebody who knows he has mental illness, placing adverts about a conspiracy in which MI5's watchers enable BBC newscasters to personally and directly communicate with him while reading the news. It is pretty sad, but unfortunately it is also true, both in the objective reality we all inhabit, as well as in my own mind. There followed a hiatus of about a year until I resumed advertising on 2 October 1998. I paid over £200 for six months advertising of the new improved text "MI5 Persecution, BBC Newscasters Spying on my Home". This text ran from issue 960 until issue 972 (19 March 1999) in "Eye Say". Private Eye's editor Ian Hislop denies knowing anything about my case, as the following email illustrates. Date: Tue, 3 Nov 1998 14:10 +0000 (GMT Standard Time) From: strobes@private-eye.co.uk (Private Eye) Subject: Re: PLEASE ANSWER - THANK YOU CC: strobes@private-eye.co.uk Reply-To: strobes@private-eye.co.uk Sorry to take so long to answer. As soon as the editor returned from holiday Steve went away. Steve is still away and so I am answering your letter. I have asked the editor and he knows nothing about any conspiracy between M15 and the BBC. Hope this helps. Mary Aylmer Private Eye I must say I'm quite surprised he knows nothing; the "Eye" is usually well clued up on what's going on. 1908 Tag: collapse the expanded strutcure Tag: 229332
  - 2
    - unique object id Is there such a property? How to access if if available? object.name could not be unique (when using sys(1270)) once you started wrapping things with containers. -- iTech Consulting Co., Ltd. Specialized in providing ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: collapse the expanded strutcure Tag: 229331
  - 3
    - MI5 Persecution: Counter-surveillance sweep by Nationwide Investigations Group Counter-surveillance sweep by Nationwide Investigations Group In July 1994 the private detective agency Nationwide Investigations Group conducted an electronic counter-surveillance sweep of my parents' home in London. They checked for radio transmitter devices, and tested the telephone line for attached bugs. They found nothing. I am afraid that I was unsurprised at their not finding any evidence of covert surveillance. It had been made very clear to me, particularly during 1990-92, that audio, and almost certainly video, surveillance of my parents' home was taking place. But this would not have been made quite so obvious unless the persecutors were confident of their apparatus being undetectable using the technology the police, or a private agency like Nationwide, would be using. I don't know very much about the surveillance technology that has been used against me, but I understand that devices can be built which switch off on receiving a coded command, and may switch on again after a counter- surveillance sweep has completed; that devices may rapidly alter the frequency of transmission, "frequency-hopping" devices which presumably cannot be detected in a sequential scan of the sort employed by Nationwide; and of course "probe" microphones can be inserted "through-the-wall", although I hesitate to believe our neighbours would permit this. We paid Nationwide £411.25 (including VAT) for the surveillance sweep, which took them about an hour and a half to complete, using a "Professional 5000 multi-scanner, CCL UHF scanner and Guideline telephone tap detector." As I said above, I don't know very much about these things, so I can't comment on the capabilities or otherwise of this equipment. But clearly the "watchers" are using technology which in 1994 was beyond the detection capabilities of a good private detective agency. 732 Tag: collapse the expanded strutcure Tag: 229330
  - 4
    - Word Automation I use the following code to open a word document - search for some text, replace it with something else and then save the document with a new name. I have two questions: 1. is there a way to search and replace the entire document with one command rather than having to keep resetting the cursor to the home position and looping round - potentially there could be thousands of instances of the search text. 2. my routine does not take into account any text that appears in the document header / footer (and probably footnotes)...how can I overcome this? ********************************************************************** LPARAMETERS cOpen, cSave, cSearch, cReplace loWord = CREATEOBJECT("Word.Application") loWord.Documents.Open(cOpen) cSelect = loWord.Selection DO WHILE .t. IF !cSelect.Find.Execute(cSearch,,,,,,,,,cReplace) EXIT ENDIF loWord.Selection.HomeKey && Go To Top Of Text Before Next Search ENDDO loWord.Documents.SaveAs(cSave) loWord.Quit RELEASE loWord, cSelect *********************************************************************** Thanks in advance for any help... Tag: collapse the expanded strutcure Tag: 229322
  - 5
    - APPEND FROM TYPE XLS Date Format Q. Hello All, I am appending data from an XLS file and have hit a snag. Your help and knowledge is greatly appreciated. In the excel file, I have a field which the data is date information but looks like this 20061012. When I suck the XLS file into my vfp table, the date field is empty ( / / ). What do I need to do to make this work? Respectfully, Jonathan Morningstar ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Tag: collapse the expanded strutcure Tag: 229303
  - 6
    - .MEM file in old an new Fox I am running an applicatrion partly in FPW2.6, partly in VFP9. What I have realized is that when VFP9 updates a mem file, then when I try to read it in FPW2.6 I get "memory file is missing/invalid". Is this misfeature documented somewhere? Any workarounds? Walter Tag: collapse the expanded strutcure Tag: 229302
  - 7
    - conversion from Netware I'm converting many apps/tables from a Netware server to a Windows server (AD). These are all multi-user, and I've gone to some trouble to make sure all necessary files are flagged sharable (in Netware), and are reflagged if packed, etc. Is there any such requirement for special file attributes on a Windows AD server? Thanks. Chip Tag: collapse the expanded strutcure Tag: 229295
  - 8
    - Incemental Search in Grid Dear all I am using a Text box and Grid VFP6 . In text box whatever we type will search in Grid and make current record highlited ( DynamicBackColor) it works fine. I want that if I Type A in text box , all records started with A in grid would be in bold or visaversa. Will it be possible ? how ? Thanks in advance Tag: collapse the expanded strutcure Tag: 229287
  - 9
    - Visible records Is there a way to tell whether a certain record is being displayed in a grid? I meant not just the recno(grid.recordsource) because it's always in sight. -- iTech Consulting Co., Ltd. Specialized in providing ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: collapse the expanded strutcure Tag: 229282
  - 10
    - mail merge of MS Word from foxpro database Dear all, Is it possible conducting the mail merge of MS Word by using the foxpro dstabase table WITHOUT converting into other file extension (e.g. .xls, .mdb, etc.)? Also, how can I convert a MS Word document into the foxpro report form (.frx)? Thanks and regards, Patrick Tag: collapse the expanded strutcure Tag: 229279
  - 11
    - Image Editor with Crop Hi I have an application which needs to change contrast,brightness, orientation, crop like option and run unver VFP6 . anyboday have any idea?. It is very very urgent for me.. please help. I used Gripicture but it it doen't meet my reauirement thanks in advance Tag: collapse the expanded strutcure Tag: 229278
  - 12
    - MI5 Persecution: Observer article Observer article 9/March/1997 Fame at last! In an alleged book review in the Observer (Books p16), Jay Rayner writes about a "man called Bob" (one of my many pseudonyms) in whom "a lot of people have shown an interest". Read and ponder! Perhaps the Chinese curse "may you live in interesting times" could be re-worded into "may you be considered an interesting person". Infamy, infamy, they've all got it in for me! 1639 -- Posted via a free Usenet account from http://www.teranews.com Tag: collapse the expanded strutcure Tag: 229277
  - 13
    - MI5 Persecution: .net magazine article net magazine article March/1998 Britain's .net Magazine featured my website on page 17 of their March 1998 issue (number 42). They quote from the "FAQ" pages, and also include some details of the evidence I have tried to present on my website. The age of some of the material on the website shows in this review, which says the case "has been discussed in uk.* newsgroups during the past year". At this time (March 1998) it has been discussed on uk.misc for three years, and there are still occasional traces of the discussion going on. 714 -- Posted via a free Usenet account from http://www.teranews.com Tag: collapse the expanded strutcure Tag: 229276
  - 14
    - Protection from decompilatition I've just finished new version of protection utility DeFoxII. Major Changes Since Previous Version (DeFox) a.. Significantly increased protection level. In particular, new protection against debugging protected modules with most common debuggers (including SoftICE) was added to DeFoxII. b.. It is now possible to protect APP applications, COM servers,-both out of process (.exe) and in process (.dll), both single-threaded and multi-threaded,-as well as program files (.fxp, .mpx, .qpx). c.. DeFoxII can be launched from the command line with parameters now (this feature may be used in Project Hook). Here is the link you may get more information and download a copy (it's free) http://www.grada.lv/defoxii Leonid Tag: collapse the expanded strutcure Tag: 229274
  - 15
    - Runtime Printing Issues with VFP 9.0 I have completed my application and created an EXE. Everything works great except when I attempt to print any of the forms. I get an error "Invalid Path or File Name" I have confirmed that the file is there and sometimes the header of the report prints with the rest of the page being blank. Listed below is my line of code....... Any help would be appreciated.... Thanks Nick REPORT FORM reports\TRAIN_THERM TO PRINTER PROMPT NODIALOG preview FOR thisform.txtTrainingNo.Value = narcs.train_no Tag: collapse the expanded strutcure Tag: 229255
  - 16
    - SQL Insert into Remote Views i have a data entry form that can add new records to a remote view to a ms sql table i can't make any additional changes to the new record because the identity column is 0 is there a way to get the identity column to be populated without refreshing the view? or atleast have it returned from the inserting process? the record shows up right away on the server with its identity column set, but its isnt in the view... help? suggestions? Tag: collapse the expanded strutcure Tag: 229254
  - 17
    - zorder maximum value? How to set an object to be the bottom-most (I meant in the background) one in its init()? -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.10) Linux 2.6.19.1 ^ ^ 20:49:01 up 17 days 3:01 1 user load average: 1.04 1.03 1.00 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: collapse the expanded strutcure Tag: 229250
  - 18
    - How to create a multi installation with install shield (VFP9)? [XP.PRO.SP2][VFP9.SP1] Hi, I'm new in install shield installations... my program structure installation is: - <program folder> generally in local machine (C:) - <database folder> generally in network server (F: or G: .... ) How i can in the intallation process ask to end user both path for <program folder> and <database folder>? it seems that the installation process only ask for <program folder>.. and i want for both folders! Note: i don't use "c:\program file\<my aplication folder>\".. i use "c:\<program folder>\" and the same way for database folder... TIA, ATSP Tag: collapse the expanded strutcure Tag: 229248
  - 19
    - Help Files for VFP Application I'm about ready to put a VFP app up for market. I have another person writing the help files for me. The dbf style help seems the easiest route to go, but it isn't very sophisticated. At the same time, asking this person to write html files might be a bit over his head. I would like to know what alternatives other people might be using. I'd like to find something simple to create, but, at the same time, have a good look to it. It will need to be able to be indexed, TOC, link to other sections of help, and display some graphics. TIA. BR Tag: collapse the expanded strutcure Tag: 229244
  - 20
    - Progress bar during sqlexec() I want to update a progress bar during a sql select using sqlexec(), but haven't found a way to get the progress information. A work-around I have tried is to put a timer control on the form and let this update the progress bar. But this only "works", since it is lacking real progress informaiton. Can anyone give me a hint how to do this? Tag: collapse the expanded strutcure Tag: 229241
  - 21
    - Buffering failure in multi-user environment Records added by user A are showing up in user B's edit form. I setup a simple form with a Parent and Child table. There is an "Add Parent" button and an "Add Child" button. There is a relationship set between the parent and the child. The child records are shown in a grid. Buffering is set to 5 - Opt. Table buffering There are Next, Previous and Save buttons In a 2 user environment, both users first add a Parent record. Then each user adds several detail records. The user who added the first parent record then clicks Save, then Next, then Previous. If the other user moves to a different record in the Child Grid, records added by the other show up. Tag: collapse the expanded strutcure Tag: 229239
  - 22
    - Report Writer Dynamic Font Adjustment VFP9 Is there away way to dynamically change the font bold property depending on a certain condition. Kind of like print when. I would like certain lines of the report to be bolded and others not. I know I can overlay two controls and conditionally print one bold or one regular. I've done this with colors and fonts before. This is a maintenance issue I'm trying to avoid. Thanks Tim Tag: collapse the expanded strutcure Tag: 229238
  - 23
    - MI5 Persecution: cost of the operation -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -= MI5: cost of the operation -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Here's what a couple of other people on Usenet (uk.misc) had to say regarding the cost of running such an operation... PO: >Have some sense, grow up and smell reality. What you are talking about PO: >would take loads of planning, tens of thousands of pounds and lots of PO: >people involved in the planning, execution and maintenance of it. You PO: >must have a very high opinion of yourself to think you are worth it. PM: >But why? And why you? Do you realize how much it would cost to keep PM: >one person under continuous surveillance for five years? Think about PM: >all the man/hours. Say they _just_ allocated a two man team and a PM: >supervisor. OK., Supervisor's salary, say, #30,000 a year. Two men, PM: >#20,000 a year each. But they'd need to work in shifts -- so it would PM: >be six men at #20,000 (which with on-costs would work out at more like PM: >#30,000 to the employer.) PM: > PM: >So, we're talking #30,000 x 6. #180,000. plus say, #40,000 for the PM: >supervisor. #220,000. Then you've got the hardware involved. And PM: >any transcription that needs doing. You don't think the 'Big Boss' PM: >would listen to hours and hours of tapes, do you. PM: > PM: >So, all in all, you couldn't actually do the job for much less than PM: >a quarter million a year. Over five years. What are you doing that makes PM: >it worth the while of the state to spend over one and a quarter million PM: >on you? Those are pretty much the sort of calculations that went through my head once I stopped to consider what it must be costing them to run this operation. The partial answer is, there have been periods when the intensity has been greater, and times when little has happened. In fact, for much of 1993 and the first half of 1994, very little happened. Although I don't think that was for reasons of money - if they can tap into the taxpayer they're not going to be short of resources, are they? The more complete answer is in the enormity of what they're doing. Relative to the cost to British pride of seeing their country humiliated for the persecution of their own citizens, isn't is worth the cost of four or five people to try to bring things to a close in the manner they would wish? To the government a million or two is quite honestly nothing - if they can convince themselves of the necessity of what they're doing, resources will not be the limiting factor. 714 -- Posted via a free Usenet account from http://www.teranews.com Tag: collapse the expanded strutcure Tag: 229207
  - 24
    - MI5 Persecution: Capital Radio - Chris Tarrant -=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-= -= Capital Radio - Chris Tarrant -= -=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-= Capital Radio DJs have been "in on it" from the start. One of the first things I heard in the summer of 1990 was from a Capital DJ who said, "If he listens to Capital then he can't be all bad" (supportive, you see. We're not bastards). Much of what came over the radio in 1990 is now so far away the precise details have been obliterated by time. No diary was kept of the details, and although archives if they exist may give pointers, the ambiguity of what broadcasters said would leave that open to re-interpretation. In spring 1994, Chris Tarrant on his Capital morning show made an aside to someone else in the studio, about a person he didn't identify. He said, "You know this bloke? He says we're trying to kill him. We should be done for attempted manslaughter". That mirrored something I had said a day or two before. What Tarrant said was understood by the staff member in the studio he was saying it to; they said, "Oh no, don't say that" to Tarrant. If any archives exist of the morning show (probably unlikely) then it could be found there; what he said was so out of context that he would be very hard put to find an explanation. A couple of days later, someone at the site where I was working repeated the remark although in a different way; they said there had been people in a computer room when automatic fire extinguishers went off and those people were "thinking of suing for attempted manslaughter". Finally, this isn't confined to the established radio stations. In 1990 after I had listened to a pirate radio station in South London for about half an hour, there was an audible phone call in the background, followed by total silence for a few moments, then shrieks of laughter. "So what are we supposed to say now? Deadly torture? He's going to talk to us now, isn't he?", which meant that they could hear what I would say in my room. 713 -- Posted via a free Usenet account from http://www.teranews.com Tag: collapse the expanded strutcure Tag: 229204
  - 25
    - Object reference count dll I'm relatively certain that I've seen a public domain dll that returns the number of references the fox is tracking for a native object, but I don't remember it's name, programmer, or where I can get a copy. Does this ring any bells? -Lew Tag: collapse the expanded strutcure Tag: 229198

Suppose a sample table (abc.dbf) contained the following data record:

a b c d e title
1 USA
10 USA
100 USA
1000 USA
10000 USA
11 Japan
110 Japan
1100 Japan
11000 Japan
12 Peter
121 Mary On
1210 Mary On
12100 Mary On
122 Sharon Li
1220 Sharon Li
12200 Sharon Li

How can I make into the following result:
a b c d e title
1 10 100 1000 10000 USA
11 110 1100 11000 Japan
12 Peter
121 1210 12100 Mary On
122 1220 12200 Sharon Li

The fields (a,b,c,d,e,title) are characters!!

I am using Visual FoxPro 6.0

Thanks and regards,
Patrick

Top

Re: collapse the expanded strutcure by Man-wai

Man-wai
Wed Jan 10 03:18:22 CST 2007

1. Must it be done in one single SQL statement? :)

--
iTech Consulting Co., Ltd.
Specialized in providing ePOS solutions
Website: http://www.itech.com.hk (IE only)
Tel: (852) 2325 3883 Fax: (852)2325 8288

Top

Re: collapse the expanded strutcure by Anders

Anders
Wed Jan 10 06:26:20 CST 2007

Given two columns called code and ref, in your source table X :
In one step:

CREATE CURSOR x (code Char (6), ref Char(6))
* populate

*Then
* in one step:

SELECT * FROM ( ;
SELECT a1.CODE AS code_a, b1.CODE, c1.CODE, d1.CODE, e1.CODE , a1.ref ;
FROM x AS a1 ;
LEFT JOIN x AS b1 ON VAL(a1.CODE)*10=VAL(b1.CODE) ;
LEFT JOIN x AS c1 ON VAL(a1.CODE)*100=VAL(c1.CODE) ;
LEFT JOIN x AS d1 ON VAL(a1.CODE)*1000=VAL(d1.CODE) ;
LEFT JOIN x AS e1 ON VAL(a1.CODE)*10000=VAL(e1.CODE) ) AS A2 ;
WHERE A2.code_a = ;
(SELECT MIN(code_a) FROM A2 AS a3 WHERE A2.ref = a3.ref)

* In two steps:

SELECT a1.CODE AS CODE, b1.CODE, c1.CODE, d1.CODE, e1.CODE , a1.ref ;
FROM x AS a1 ;
LEFT JOIN x AS b1 ON VAL(a1.CODE)*10=VAL(b1.CODE) ;
LEFT JOIN x AS c1 ON VAL(a1.CODE)*100=VAL(c1.CODE) ;
LEFT JOIN x AS d1 ON VAL(a1.CODE)*1000=VAL(d1.CODE) ;
LEFT JOIN x AS e1 ON VAL(a1.CODE)*10000=VAL(e1.CODE) ;
INTO CURSOR A2

SELECT * FROM A2 WHERE code_a = ;
(SELECT MIN(code_a) FROM A2 AS a3 ;
WHERE A2.ref=a3.ref)

Result:
Code_a_a Code_a_b Code_b Code_c Code_d Ref
1 1 100 1000 10000 USA
11 11 1100 11000 .NULL. Japan
12 12 .NULL. .NULL. .NULL. Peter
121 121 12100 .NULL. .NULL. Mary_On
122 122 12200 .NULL. .NULL. Sharon_Li

SET NULLDISPLAY TO ''

-Anders

"Patrick" <someone@microsoft.com> wrote in message
news:eLm4hQJNHHA.4912@TK2MSFTNGP02.phx.gbl...
> Suppose a sample table (abc.dbf) contained the following data record:
>
> a b c d e title
> 1 USA
> 10 USA
> 100 USA
> 1000 USA
> 10000 USA
> 11 Japan
> 110 Japan
> 1100 Japan
> 11000 Japan
> 12 Peter
> 121 Mary On
> 1210 Mary On
> 12100 Mary On
> 122 Sharon Li
> 1220 Sharon Li
> 12200 Sharon Li
>
>
> How can I make into the following result:
> a b c d e title
> 1 10 100 1000 10000 USA
> 11 110 1100 11000 Japan
> 12 Peter
> 121 1210 12100 Mary On
> 122 1220 12200 Sharon Li
>
>
> The fields (a,b,c,d,e,title) are characters!!
>
> I am using Visual FoxPro 6.0
>
> Thanks and regards,
> Patrick
>
>

Top