SQL and Record Locking

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
    - Remove classes from memory? Tricky problem: I'm creating a framework. One of its components is a form manager class, based on the Custom class. My form manager class has an OpenForm() method. The OpenForm() method can accept a form name and some optional parameters, and it will open the named form, whether it's a .scx requiring "DO FORM..." or a .vcx or .prg class requiring "CREATEOBJECT()". All forms in the framework are based on a form class that contains code in the Init and Destroy methods to register the form with the form manager when the form is created and unregister it when it's destroyed. All of this works great while my program is running. I can create and destroy forms with no problem. And the program shuts down fine, leaving no visible trace. Until... If I run my uncompiled program in the VFP IDE, and my form manager opens a form using CREATEOBJECT(), then after my program shuts down I'll get a "Remove classes from memory?" dialog when I try to open my base form .vcx library in the Project Manager to edit a class. If I run the same program as a compiled .exe, and my form manager opens a form using CREATEOBJECT(), I don't have any problem opening the .vcx afterwards. The only way that I can stop this from happening in the IDE is to issue an explicit CLEAR CLASS [class name] command, for the class that was opened using CREATEOBJECT(), at the very end of the program, just before it shuts down. Obviously, in a production environment this is not good, because I'd have no sane way of knowing which classes had been instantiated with CREATEOBJECT() and I'd have to loop through all the records in all the .vcx files, and parse all the .prg files, to get all the class names and issue CLEAR CLASS for them, before shutting down. Please note the following: 1. This problem does not occur when the framework invokes DO FORM to open a .scx that is based on a .vcx class. 2. This problem occurs whether the class being instantiated is in a .vcx or .prg file, and whether it's based on my base form class or a subclass of that class. It is not dependent on any particular class; it occurs for any use of CREATEOBJECT() to open a form. 3. I've tried SET CLASSLIB TO and SET PROCEDURE TO at the end of my program and this doesn't solve the problem. SET("CLASSLIB") and SET("PROCEDURE") both return an empty string, but the problem doesn't go away. 4. RELEASE ALL at the end of the program doesn't help either. On the other hand, RELEASE ALL doesn't actually seem to release all--the handful of PUBLIC variables that my main program sets up are still there in a DISPLAY MEMORY even after issuing RELEASE ALL. 5. CLEAR MEMORY also doesn't do it. 6. Issuing CLEAR CLASS [class name] from the Destroy() or Unload() method of the problematic class does not work. It doesn't cause an error, but it doesn't CLEAR the CLASS either. For the CLEAR CLASS to work, it has to be issued at the very end of the program. 7. My form manager STOREs .NULL. to all form reference variables when the forms are destroyed. 8. And the program shuts down fine--nothing left in the Task List, and the class library that contains the form manager class can be opened with no problem after shutdown. To me, this implies that there are no dangling object references. I think CLEAR ALL would solve the problem (it does in the Command window), but I can't issue CLEAR ALL anywhere inside my program, not even as the second-to-last line, just before QUIT. If I do, then, due to VFP's perplexing event sequence (which doesn't actually release objects at the moment when their Release() methods are called or when a RELEASE command is issued, nor does it actually destroy objects at the time when their Destroy events occur), something or other that is dependent on some memory variable can't actually finish releasing, and I get a cascading series of errors. (Yes, I've read the help on that. Since my program works fine as long as I don't issue CLEAR ALL, do I really need to care about this? Should I really have to expect to issue CLEAR ALL in order to ensure that what SET CLASSLIB TO is supposed to do actually gets done?) I've deliberately kept a lot of detail out of this post. I CANNOT reproduce this problem in a simple scenario outside of my framework, which leads me to believe I've made a mistake somewhere, but I can't find it for the life of me. On the other hand, since the problem doesn't occur in a compiled .exe, do I really have anything to worry about? I'd be glad to post more code--even the whole project in a zip file--if someone would like to take a look at it. I'd appreciate the benefit of your experience. Thanks in advance. Ken Dibble Southern Tier Independence Center Tag: SQL and Record Locking Tag: 178209
  - 2
    - Re: VFox link with MS Word Hello, I have a request for the Vfox link with MS Word, anyone can suggest me how to do? Since I have no idea to work with it, actually they just want to use the program as a Filing System to type the Letter and Fax. But the Vfox only provide us a Memo and it doesn't have any function like a word to change the Font, indent, border and etc. Please tell me how to do if anyone have related experience, Thank You Very Much ! Wingo Tag: SQL and Record Locking Tag: 178208
  - 3
    - Dymo Labels Problem Hello Everyone, I've created few labels in different formats in VFP6.0 under WIN 2000. After upgrading to Win XP and to VFP7.0 all my labels don't work. All of them appear on size of Address label 30252. I am changing size of the label to 30334 or 30333, saving and closing it. But when I am openning it label size comes back to Address label 30252. How can I solve this problem? Why it happens? Thanks a lot, Natella Tag: SQL and Record Locking Tag: 178206
  - 4
    - c5 with CR9 - HELP! Hi Everyone, I'm having problem after problem migrating from CR 8.5 to CR 9.0 and Crystal technical non-support is batting 1000. My latest can be reproduced with a code snippet from Craig Berntson's "KB014: Integrating Crystal Reports with Visual FoxPro" (great article by the way, I'm going to order the book) at http://www.craigberntson.com/Articles/kb014.htm ================== LOCAL oCR AS CRAXDRT.Application LOCAL oRpt AS CRAXDRT.Report oCR = CREATEOBJECT("CrystalRuntime.Application") oRpt = oCR.OpenReport("i:\crtest\crtest.rpt") IF oRpt.HasSavedData oRpt.DiscardSavedData() ENDIF oRpt.PrintOut() ================== The first time the .PRG runs, everything is fine. After that I get: "OLE exception error: Exception code c0000005. OLE object may be corrupt" on the OpenReport line. If I close and restart VFP, the .PRG will print once, then fail every time after that until VFP is shut down. Can anyone else reproduce this? Is there a work-around? I've sent Craig a copy of this message in the hopes that he's not too busy to take a look. Thanks. -- William Fields MCSD - Microsoft Visual FoxPro MCP - Win2k Pro US Bankruptcy Court Phoenix, AZ The secret to creativity is knowing how to hide your sources. - Albert Einstein Tag: SQL and Record Locking Tag: 178204
  - 5
    - one-to-many form..... need more than 2 tables Hi, When I create a one to many form it allows only 2 tables in designer mode. I add a third table and grid to link to the parent table creating the relationship. It displays and goes through the data correctly until I try to add a record. The add function only acknowledges the grid & table created using the wizard. Also any way to stop it asking the question of parent or child and always just allowing both? Any help appreciated.. Steve Tag: SQL and Record Locking Tag: 178201
  - 6
    - FoxPro 6.0 with Windows XP Anyone know of any reason I cannot install and run Visual Foxpro 6.0 on Windows XP? Thanks, Sam Tag: SQL and Record Locking Tag: 178194
  - 7
    - HERE MAKE MONEY FAST AND EASY!!! Hello amigo(a)s.. First that all I ask it excuses by sending him this message without ustéd have requested it me, I know that its time is worth gold but I assure it that if reads this letter, the time that invest in her itself edge a great deal more than well rewarded. Something as well as to receive in few weeks some OR$S 15,000.00!!! Fast Money****************** It wants to gain quick and easy money? If is thus, please, continue reading. This really functions. It is the way more jousts and honest to be able to gain some money extra without investing barely nothing. INVEST 5 MINUTES OF ITS TIME IN READING THIS AND CHANGED ITS LIFE. Internet has grown, and is growing constantly. Its size is duplicated each 4 months. It be chirped that if sees each time with more asiduidad this type of news, is because functions. It given that are more the positive points that the negatives. Are only $5.00 Dollars. Swims but! One it is spent more any tomorrow in the breakfast and the gasoline to go al I work. So I decided to send those five dollars, and al to write this letter I am sending for mail the 5 envelopes, and putting this announcement in the News. Many skeptics can think that is a deceit. THINK IT FOR A MOMENT! ... There is so many new subscribers to Internet - of the entire World - without counting to the large suppliers of E.E.U.U., they will be interested and they will cause they will function it for the simple thing of the system. I have here the testimony of persons that functioned them: Henry Toy of San Francisco: I wrote after 2 weeks to place the announcement in Internet, and envoy the $5.00 Dollars, I began to receive money by mail. It it could not believe. Al principle were only some hundreds of dollars. A week later some thousands of dollars, suddenly ¡¡ BOOOM!!!, at the end of the quarter week, I received near $47,000.00 dollars!! They came from all parts of the World. Each hundredth one is perfectly legal and the best of all is that I could pay all my debts, and I remain money for some holidays with my family. Did not only it function for me, gave result also to other persons. Markus Valppu says that he managed to join $57.883 dollars in four weeks. Dave Manning $53.664 in the same time. They give Stepstone $17.000 in two weeks. I know to some of these individuals? Not, but when I read how had they achieved I was done it myself logical. So much is so I decided to take the same risk and to invest $5.00 dollars. Is not a great risk in exchange for the potential that can have to change. That it is all the capital that invested Henry, Mark, Dave, Give,..., and even so its 5 dollars produced thousands of dollars to each one, in a way sure, without risks and totally legal. Thus is how functions in 3 simple steps: STEP NUMBER 1: Invest its 5 dollars, writing its name and direction in five leaves with the legend " please add me to its list of mail ", (please add me to your mailing list) in English and Spanish together with the dollar, of this way is not giving a dollar to someone. It is paying for a completely legal service). Wrap each dollar with role carbónico in each sheet of paper that wrote its name and direction, putting in air the envelope being assured of hitting it with a pegamento strong and envíelo by mail to these five directions: (a dollar to each direction) 1. Luis A. Carranza Obese Cienfuegos, 186 Urb. The Mercy Trujillo - PERU 2. Fortune Rodriguez Garcia Crta. Caravaca, 30 30440 Moratalla Murcia - SPAIN 3. Enrique Moral Colliure, 31 2º 1ª 07010 Palm of Majorca Balearic islands -SPAIN 4. Ricard Palm i Adsuar Plaza Father Claret,3 08650 Sallent Barcelona - SPAIN 5. Miguel C. Zavala Yáñez Calle Genaro Sanginéz #863 casi esquina catacora, Último timbre de arriba Tel-2284506 La Paz - Bolivia STEP NUMBER 2: Now eliminate the #1 of the list, and travel through the other names up, so that the #2 be the #1, the #3 be the #2, etc., and put its name and direction in the #5 of the ready Osea should copy this article of principle to end such as is, unicamente should eliminate the direction Not 1 of the upper list putting the direction Not 2 where was1, the Not 3 where it was the Not 2, the Not 4 where was the Not 3, the Not 5 where was the Not 4 asi all travel through a booth up remaining the booth Not 5 blank so that alli write the its as the others. STEP NUMBER 3: Publish I articulate this in at least 250 groups of news. There are at least 20.000 groups of news in any hour of the day. In as many as more groups be announced, more people will see it and more money will receive. STEP NUMBER 4: Now is when begins the business for you. It will begin to see results among the next 7 to 14 days. Recall that the Internet is in constant growth. There is not possible way to lose. ********************************* Now I will tell It as and reason the system functions: Of each block of 250 publications that does, receives 5 answers. If, only 5. With that earns $5.00 dollars in cash, not checks neither orders of payment, but hard cash with its name and direction in the #5 Each person that send it $1.00 dollar publishes its letter in 250 groups with its name and direction in the #4, that is to say, 1000 announcements. On the average, they will send it $1.00 dollar 50 persons. This are $50.00 dollars. Now you are 50 persons are announced in 250 groups each one with their name and direction in the #3, that is to say, 10.000 announcements, of which on the average they will respond 500 persons, that is to say $500.00 dollars more. Those same 500 persons are announced in 250 groups each one with their name and direction in the #2, that is to say 100.000 announcements of which on the average will respond 5.000 to $1.00 dollar each one, that are $5.000 dollars in cash. Al final 5.000 persons are announced in 250 places each one with its name and direction in the ·1 and will obtain $50.000 dollars before leave of the list, only to an average of the 1% of answer of its letter, is fabulous. Only in a cycle, will average $55.000 dollars. Only to a performance of a 1%, is simply fabulous!! When do not see its name in the list, take the last announcement, and begin again if desires. The final result depends on its PERSON. It should continue this article and to announce it as many times be able and where be able. How much more be announced, more money will arrive it for mail. It is too much simple and simple as to leave passing this opportunity!! IF NOT THIS COMPLETELY SURE one, OR THINKS THAT it can NOT be CARRIED OUT, do NOT DO IT. BUT PLEASE, PRINT THIS I ARTICULATE AND you PASS IT SOMEONE THAT REALLY NEED THE MONEY. GENERAL STEPS FOR AUTOMATIZAR THE PROCESS: Do all the necessary steps to change this article and to announce it as is explained in the STEP NUMBER 2, and when be satisfied, record it in format. txt to import it in the body of the program of the reader of news (example: Internet News). Of this way only will have to change the name of the group or direction of mail to distribute it. Important counsel: It is important for those done not very familiarize with the E-MAIL. For all the media utilize a processor of texts to be assured that the article it véan clear and correctly. Reformatear this article with a simple publisher as "Notepad", 0 "WordPad" if utilizes Windows 95. Try that the text be clearly visible and do not be necessary to move to the right to read it. To do it of this forms assures that the article will be seen well in all the readers of news. It can verify it with its reader before being connected in line, reading it in its own reader. Begin to seek immediately the groups of news where thinks to announce. Netscape 3.0 is a very good reader, for which can select several dozens of groups at the same time, permitting him to distribute his I articulate to thousands of places in less than one hour or two. He select all the groups where he want to send the I articulate. Of this way various groups in a past can be selected, perhaps a dozen each time. After that it will see the groups selected in the field of groups. Later select its group of news and press "To News". Try to put a regular adequate one in the Theme, then press in aggregates ( "Attached"), where another window will appear. Locate the file that desires to send, press the file, open it and later envíelo, . and already is! Repeat this process time and again selecting of 10 in 10 the groups, select the of greater affluence and do not announce this I articulate with very grandiose titles as" gain millions of dollars in two days" that only scare away to the people, but bién describe the title as DESCENDING THIS FILE AND LEO AS CAN RECEIVE MONEY BY MAIL, or tambien DO MONEY RAPIDO or well AQUI MONEY FACIL or anyTo the people. This it is a legitimate and honest way to do money regularly. But only it will be thus if the message is sincere and clearly understood by the others. Only thus it will achieve the success desired. AS HANDLING THE "NEWSGROUPS" Not. 1 you do not need to edit again all this letter to do the its own. Only put its cursor al beginning of this letter, do click, leaves it pressured and descend it to the end of the letter and lárguelo. All the letter should be "sombreada". Then do click in "Edit"(Editar) above its screen, here select "Copy"(Copiar). This it will do that all the letter remain in the memory of its computer. Not. 2 Open a new blank page and carry the cursor al start. Pressure "Edit" and of the menu select "Paste"(Pegar). Now it will have this letter in the "notepad" and will be able to add its name and direction in the place #6 continuing the instructions of more higher than. Not. 3 Record this letter in its new file of the notepad as a. txt file. (File of Text). And each time that want to change something will be able it to do. FOR THE ONES THAT HANDLE NETSCAPE Not. 4 Inside the program Netscape, go to "Communicator" and select "Group of news", then go to "File" and to select "to Subscribe". In seconds a list of all the "Newsgroups" of its "server" will appear. Do click in any newsgroup. Of this newsgroup do click under "TO NEWS", which should be up, in the extreme left of the page of newsgroups. This it will carry to the box of messages. Not. 5 Fill this space. This it will be the title that will see all when they travel through for the list of a group particularly. Not. 6 Mark the complete content of the file and copy using the same previous technique. Return al Newsgroup "TO NEWS" and you are creating and empastando this letter inside its program or "posting". Not. 7 Pressure "send" that is in the upper part left. And you. It HAS FINALIZED WITH ITS FIRST one! ...FELICITACIONES!!! THE ONES THAT USE INTERNET EXPLORER STEP Not. 4: Go al Newsgroups and select Post go Article". Or in they Classified select "to put an Announcement". Or in the Forums of Discusion, etc. STEP Not. 5: Copy the article of the notepad and peguelo in the place of the text that is going to send or to announce. Utilize the same previous technique. STEP Not. 7: Pressure the button "Post", "to Send" or "to Put", etc. THAT IS ALL! What it has to cause is to become in different "Newsgroups" and empastarlos, when already have practice, alone will take it some 30 seconds by each newsgroup! **REMENBER, AS MANY AS BUT NEWSGROUPS OBTAIN, BUT ANSWERS (AND MONEY) RECEIVE! BUT SHOULD ENTER AT LEAST 250** ALREADY THIS! !!.... *************** Another system to be communicated is obtaining private e-mail of persons, should be, al less, 250 as a minimum. This has an effectiveness from among the 5% al 15%. The form but easy to do it, is to seek boards of directors of e-mail, that appear in Internet. If you want to contact with persons that speak Spanish or close to yourself seeks by latin american surnames and / or in your same region, country or continent. *************** NOTE OF REQUEST: The system is bases on that all we be honest, but is too much tempting not to be bothered in sending for mail the envelopes with the bills of 1 dollar inside. The success of this programs depends if is carries out and distributed in a 500%. The system will neither function if the people takes advantage of ustéd and does not continue the instructions. If it desires to remain in the anonymity, can use a pseudonym, being assured that direction is the correct one. *************************** Note: This is a service and a product 100% legal (Defined in US Postal & Laws of the lottery, Regular 18, Sections 1302 and 1341 or Title 18, Section 3005 of the American Code, and also in the Federal Code of Regulations, Volume 16, Sections 255 and 436, Which establishes that a product or a service should be exchanged with money received.) ************************************************************* FINAL NOTE: Many of the ideas to do money, it does not matter that so well planned and implemented simply itself do not raise. And in many of the cases due to the costs of publicity, but the publicity obtained by Internet is honestly very impressive. So, please, study I articulate this meticulously and be taken the time that want, since when decide to participate, will be underway to receive important quantities of money. By the same nature of this system, will not see the results the first week, but from the second, ITS INCOMES BY ORIGINATING MAIL OF THE ENTIRE WORLD ARE GOING TO SURPRISE!!!. Please, this it be chirped seriously because is one of the few opportunities to do quick money that really functions. GOOD LUCK!! BUENA SUERTE!! Tag: SQL and Record Locking Tag: 178190
  - 8
    - take a picture of customer Hello again all you helpfull fox type people out there. This weeks project is to hook up a web cam to the terminal acting as a POS system and snap a picture of the customer and clerk when the cash,check,charge button is pressed. I was thinking of hooking up one of them little logitec ball type webcams, but havent taken step 1 yet. My question is; Has anyone done this already and if so how? Glen Tag: SQL and Record Locking Tag: 178186
  - 9
    - Where to get VFP8 Anyone have suggestions on where to get VFP8 (upgrade)? Tag: SQL and Record Locking Tag: 178183
  - 10
    - NUll dates in Crstal Report v9 (OLE DB and VFP 8) I hope someone can answer this for me. Null date values in a report field shows it as 12/31/1899. Please help! Thanks. John Tag: SQL and Record Locking Tag: 178181
  - 11
    - Import TXT How can I import TXT files into FoxPro? Thanks Tag: SQL and Record Locking Tag: 178179
  - 12
    - Moving VFP6 app to VFP7 Hi all, I'm trying to compile a project that was originally built in VFP6 in VFP7. About the time it would normally be done, I get a "Compile Error in C:\MyPath\MyFile.app". I've converted the menus to 7.0 format. Any other ideas as to where to look? If it is menus, I do have one or two prg-based shortcuts that have not been touched. TIA, John Tag: SQL and Record Locking Tag: 178177
  - 13
    - =?iso-8859-1?Q?Error_reading_file=22_error__number_1104?= I've been getting an "Error reading file" error number 1104 on workstations running windows XP PRO. It happens intermittently, but when it happened it usually does upon execution of the calculate command. The other day I got the message when I issued a seek() on a table. The applications is running on a network with Windows 2000 server with service pack 1. The other workstations are Windows 2000 service pack 3 and don't seem to have this problem. I wonder if this is Windows XP problem or if I should switch to a different type of file sharing schema. Since only a few users access the system at any one time I currently use the following settings: SET MUTILOCKS ON SET REPROCESS TO Perhaps I should switch to a table buffering system. Thanks for your help. Tag: SQL and Record Locking Tag: 178168
  - 14
    - Replacing tables in a database Because a client does not have a copy of VFP, I emailed myself a table which needs to be reindexed. (Adding a reindexing function to their software is high on the list!) If I open these tables at my office, reindex them, then simply overwrite the tables at the client's site, will the database container somehow be offended? :) Or will it relatively seemlessly reintegrate these files into the container even though the files themselves were last opened outside the container? VFP 6. TIA. -S- Tag: SQL and Record Locking Tag: 178167
  - 15
    - Unwanted classes and files. I have a project under construction which uses a base class and a second class, for the project only, based on the base class. The base class is common for several apps. There are various forms based on the second class. I find that, when I build the app, it includes an old class which has no relevance (and is in a different folder) and some old forms based on the old class which also are unwanted. I have checked everything I can think of for reference to those and can find nothing. Nevertheless, when I remove them from the project and build it again, they reappear. Any ideas please as to what is going on and how to correct it ? -- Tim Hobson Tag: SQL and Record Locking Tag: 178153
  - 16
    - Command line parameter opening a databse I have two programs and I need program A to call program B. Program B will then open the same database that program A is using. To do this I implemented a command line parameter in program B that will open the same database. If I try to run program B from say run in the start menu and put the name of a database for the parameter everything runs fine. But if I try to run it from program A I get an error. The code is RUN /N B.exe "c:\Database\database.dbc" Note that this is an example, the database will actually be a string variable When I try to call an Open Database on the parameter, it does not open and then I get an error when I try to do something saying "No Database is open or set as the current database." Tag: SQL and Record Locking Tag: 178150
  - 17
    - Passing arrays I have a procedure and I need to pass an entire array from another procedure. How I can do that? Regards. Tag: SQL and Record Locking Tag: 178142
  - 18
    - Different print layout in Win98 and W2k Hi, I use VFP6 on W2k to do development. Some of my client's OS are Win98 while some of them are W2K. However, it is found that the print layout in Win98 and W2K are difference. While the print layout is suited in Win98, it is not suied in W2K, or vise versa. Can anyone give advise?? Thx billion. Yan Tag: SQL and Record Locking Tag: 178131
  - 19
    - Updating accName property for IAccessible objects programmatically We are trying to get our VFP7 application to work with a screen reading program (for the visually impaired). That program (JAWS) uses MS Active Accessibility (which VFP7 supports) to access our VFP apps screen objects. VFP7 automatically sets the value of the accName, accValue properties etc. As our form textboxes are named "txtSurname" (for example) vfp7 assigns the IAccessible property accName for that object as "txtSurname" which the screen reader speaks to the user. We would like to keep txtSurname as the object name in VFP but somehow set the IAccessible accName property to "Surname of client" (for example). Has anyone had any experience with this? The MSAA SDK looks a little daunting to me as all the doco seems to show things using C structures, definitions etc. I understand I'll probably have to use olcacc.dll to do this. Thanks for any help or advice. Andrew Grandison SA Dept Human Services Adelaide, South Australia Tag: SQL and Record Locking Tag: 178130
  - 20
    - Legal Developer Question Hi all, I have just completed a system that I want to sell, however, someone told me that my employer could claim rights to the software package. I talked to my employer and he told me to draft a legal document in which I should state that they have no rights to the software and that I am free to sell it to anyone. Does anyone have a template of such contract or can anyone point me in the right direction??? Thank you Hutch Tag: SQL and Record Locking Tag: 178127
  - 21
    - EARN$£$600\week downloading free software http://131695.PlugUsIn4Cash.com We know it sounds TOO good to BE true, but it?s REAL! Our International Technology firm will pay you hard cash each time FREE software is downloaded. Best of all you will only have to download ONE piece of software ONE time for FREE and you can be on your way to earning BIG! FIND OUT MORE BY VISITING http://StevenBrown1.PlugUsIn4Cash.com/ Tag: SQL and Record Locking Tag: 178126
  - 22
    - Play mp3 from VFP Can anyone tell how I can play mp3-files from VFP (8.0)? I have tried using shellexececute in shelll32, but I haven't succeeded to avoide the interface (i.e. Winamp) to show up. Any ideas? Krister Tag: SQL and Record Locking Tag: 178110
  - 23
    - Re: VFox link with MS Word Hello, I have a request for the Vfox link with MS Word, anyone can suggest me how to do? Since I have no idea to work with it, actually they just want to use the program as a Filing System to type the Letter and Fax. But the Vfox only provide us a Memo and it doesn't have any function like a word to change the Font, indent, border and etc. Please tell me how to do if anyone have related experience, Thank You Very Much ! Wingo Tag: SQL and Record Locking Tag: 178103
  - 24
    - Transferring records Ver 6.0 Hello all, I'm trying to find the best way to transfer records from one table to another. The two tables have the same file structure. Would 'append from' and 'delete for' be the most efficient way to transfer records? How about transferring one record only. Thanks the input. Tag: SQL and Record Locking Tag: 178101
  - 25
    - Large tables - changing the strcuture.... it all crashes! Hi I have had a problem that has occurred with two different but large FoxPro tables. They both have around 0.37million rows. One takes up around 350Mb of space the other ~200Mb. Both tables have between 30 to 50 fields. One or two of the fields may be > chr(100). Remaining fields are int, date and smaller chrs. There is around 80Gb left on my 120Gb HDD. When I do anything to alter the structure of the tables, or delete a record and pack the tables, the operation seems to work fine till after about one third/half way through the process. Then FoxPro stops or jams! Nothing recovers the situation apart from switching the PC of at the power button. I can not kill the process or most any other apps in task manager. I can only think that there is a problem changing the structure or deleting and packing recs in large & wide tables. I am running VFP 6 on XP Home. PC is a Dell 8250 (or something) with ).5Gb Ram Anyone have any thoughts? TIA Andrew www.jmdata.co.uk Tag: SQL and Record Locking Tag: 178088
- Next
  - 1
    - VFP8: text... endtext Hello. Is there a possibility to merge the text from the memo field to a method or variable and to execute this method or variable like a normal procedure in run-time environment. Maybe with the TEXT... ENDTEXT? M.Kujawa Tag: SQL and Record Locking Tag: 178079
  - 2
    - VFP6.0 and Palm Greetings: I have an application that handles my appointments and calendar. I would like to export this data to the date book in my palm pilot but the date book only accepts 'date book archive' (*.dba) and vcal (*.vcs) file formats. Does anyone know how I can do this? Tag: SQL and Record Locking Tag: 178077
  - 3
    - Fwd: Latest IISState has released I have no experience with this tool. But because it now has some kind of support for VFP queries, I thought maybe one of you is interested. -- Eric den Doop www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8 ========================================================================== * Forwarded by Eric den Doop <ericdendoop@xspamblockxfoxite.com> * Newsgroup: microsoft.public.inetserver.iis * From: "Pat [MSFT]" <patfilot@online.microsoft.com> * Date: Fri, 25 Jul 2003 23:26:32 -0700 * Subj: Latest IISState has released ========================================================================== IISState 3.1 is now live. It is available via (free) download from www.iisfaq.com/iisstate. Special thanks to Chris for finding the last bug and posting the tool so quickly. For the most part IISState 3.1 does the same thing that it has always done, but it is getting smarter. All of the changes came as a result of the folks on this group using the tool and posting their logs. Thanks to everyone for the good feedback and data. I really appreciate it, and please keep it coming. Going forward, I want to improve the .Net debugging capability and increase the number of 'known problem signatures' that it detects. Change list: Added a check for Jet (MS-Access) Queries Added a check for a bug in OLEDB32.dll (Q320696) Added aditional check for SQL queries Added awareness for Visual Foxpro queries Added awareness for threads being blocked by pop-up message boxes. IISState will now try to find the text of the message box and print it to the log. Added awareness for Code Red attacks. IISState can identify the 'signature' of a standard attack. It cannot tell if this is the first attack or if a payload was included. //Big Change// Added .Net Framework awareness and simple debugging capability. Limitations: IISState can only debug .Net Framework 1.1.4322 IISState will dump the managed thread stack, but not perform analysis on what the code is actually doing Fixed a memory leak. Fixed some spelling errors Fixed problem with IISState failing to initialize on some systems //Big Change// Modified IISState.log file generation. IISState will now create a separate log file for each process that is being debugged. The format is now: IISState-<PID>.log. This will also allow for IISState to be run in parallel. As always, if you run into questions, please post them to the newsgroup. Pat Tag: SQL and Record Locking Tag: 178075
  - 4
    - Form errors - why doesn't this work? If an error occurs in a form's method then why doesn't this code in the form's Error event work? LPARAMETERS nError, cMethod, nLine messagebox("Error " + ltrim(str(nError)) + " occurred") thisform.Release() The messagebox() fires OK, but the form doesn't release - it just carries on processing. This seems such an obvious and simple thing to do that it really puzzles me. -- Steve Thomas There has been an alarming increase in the number of things you know nothing about. Tag: SQL and Record Locking Tag: 178073
  - 5
    - Excel automation - a couple of basic questions I've just started using Excel automation and can't figure how to do a couple of things - any help would be appreciated. 1. I want to find the number of 'used' rows in the worksheet so I don't have to process 65,000 rows. I tried the following but it returns the total number of rows:- lnRows= oExcel.ActiveSheet.ROWS.COUNT 2. Once I have found the number of rows I want to create names based on the text in the first column. I recorded the following macro in Excel - how would I convert it to VFP code? Rows("2:9").Select Selection.CreateNames Top:=False, Left:=True, Bottom:=False, Right:= False Thanks in anticipation John Pugh Adelaide, South Australia Tag: SQL and Record Locking Tag: 178072
  - 6
    - Obtaining VFP 7 We have VFP 5 and 6 and didn't go further than that. A client of our is upgrading a rather old Visual Accountmate installation to the current version, which is built in 7.0. We would like to have a full development version of 7.0 but have been told that only 8.0 is being sold now. Is there a way to get 7.0? I know compatibility issues can be dealt with but life would still be simpler with the "proper" version of FoxPro. Thanks in advance. -S- Tag: SQL and Record Locking Tag: 178068
  - 7
    - XMLTOCURSOR() converted characters in numeric Problem: the charcter field that has numbers only ("1928299") after running CURSORTOXML ( to variable ) and XMLTOCURSOR converted cursor with numeric field . What parameters shoud I use in CURSORTOXML and XMLTOCURSOR ? Tag: SQL and Record Locking Tag: 178056
  - 8
    - Foxtools I forgot to ask in my last post, where can I find a list of the functions in foxtools.fll? I have only found the new functions in the current version in my VS documentation. Thanks again. Tag: SQL and Record Locking Tag: 178050
  - 9
    - .dll, .fll, FAR, and foxtools question I'm just starting to learn about using the API library routines and I had a couple questions. Can I use the API library routines in a .dll? Is a .fll a .dll with the FoxInfo and FoxTable structures added to it and a #include <pro_ext.h> statement? What is a FAR? Thanks! Tag: SQL and Record Locking Tag: 178049
  - 10
    - I want to suppress the message: "Cannot Quit Visual FoxPro" Are there a way not to appear this message? TIA Nick Pofiris, ErmisPliroforiki Athens-Greece www.ermis-pliroforiki.com.gr Tag: SQL and Record Locking Tag: 178041
  - 11
    - Install VFP6 with InnoSetup Hi, all I want to install my VFP exe with InnoSetup (my original installation VFP product is 'broken') It seems to me that I must register : Source: "D:\medor\VFP6R.DLL"; DestDir: "{sys}"; Flags: confirmoverwrite regserver sharedfile uninsneveruninstall uninsrestartdelete Source: "D:\medor\VFP6RENU.DLL"; DestDir: "{sys}"; Flags: confirmoverwrite regserver sharedfile uninsneveruninstall uninsrestartdelete Source: "D:\medor\VFP6RFRA.DLL"; DestDir: "{sys}"; Flags: confirmoverwrite regserver sharedfile uninsneveruninstall uninsrestartdelete ... but, when I use the install programm, it say : Error DllRegisterServer Any help ? -- Olivier (enlever les 3X pour la réponse) Tag: SQL and Record Locking Tag: 178029
  - 12
    - graphics in tables Hi All, Okay, Eric says I should put my .bmp's in a table (I wanted to put them in a .dll but he believes that can't be done). I tried to put graphics in a table last year and gave up after a couple of hours playing with it. Can someone explain how to store and retrieve graphics from a table? TIA, Tom Clark Tag: SQL and Record Locking Tag: 178023
  - 13
    - AutoInc Value Hi, Can anybody tell me the correct sytax to change the next value in an AutoInc field? Ive tried something like the following but can't get it to work. "Alter Table MYTABLE Alter Column MYFIELD FieldType AutoInc NextValue 150 Step 1" Thanks Terry Tag: SQL and Record Locking Tag: 178010
  - 14
    - Problem when antivirus software installed My application, amomng other things, at startup do this: - create an instance of Word.Application using createobject - copy a dot file in Wort startup folder On some Win2000 systems, not all, with antivirus software installed (TrendMicro or Symantec, but maybe others) my app crashes at startup. I think the problem is the copy of the dot file in the Winnt\Documents and settings\<usarname>\Application data\Microsoft\Word\startup folder. I think the antivirus stops the copy and make my application crash. Anyone experienced this problem? How can I solve? My "on error" event simply returns ignoring errors. I can't debug my application on customer machine. (VFP version: 5) -- Andrea Mariottini Tag: SQL and Record Locking Tag: 178004
  - 15
    - a problem with barcode fonts Hello all Barcode fonts doesn't work properly with my vfp5.0, -the font can not be previewed correctly, (previewed as another normal font and printed so) 4Exp: "12345" in "Epson128" barcode font will be previewed 12345 and printed so. -Using vfp6.0 solve the problem, but one or more of other values(a non barcode font) will not be printed. Help me please. THANKS. Tag: SQL and Record Locking Tag: 178003
  - 16
    - Word 2002: Unable to Open Data Source Hi All, I've got a Visual FoxPro app that uses COM to run a mailmerge using VFP data. It's been running on various OS's (W95b through Win2K Pro) w/ Word 2000 for some time. A new PC has been set up (Win2K Pro) that runs Word 2002. This machine gives an error that "Word was unable to open the data source." Likely related, it has a User DSN for Visual FoxPro Tables. However, if I try to manually go into Word and create a mailmerge document from scratch, it does not display VFP as a data source type. If it helps, here's the code that dies: MergeTable = ADDBS( SYS(2023) ) + "MyFile.dbf" oWord.ActiveDocument.MailMerge.OpenDataSource( MergeTable, 0, .F., .F., .T., ; .F., "", "", .F., "", "", ; "DSN=FoxPro Files - Word;UID=;PWD=;SourceDB=" + ; JUSTPATH( MergeTable ) + ";SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;" + ; "Collate=MACHINE;Null=Yes;Deleted=Yes;", ; "SELECT * FROM " + JUSTFNAME( MergeTable ), "" ) For thos unfamiliar with VFP, the first line just stores the file name of the file located in the PC's temp directory. Any areas I should start looking? TIA, - John Tag: SQL and Record Locking Tag: 178001
  - 17
    - Alter Table - adding multiple column at same time Hi, I want add multiple column with the following code This code is in a For ... Next Loop lcCompteur = PADL(ALLTRIM(STR(lnCompteur,2)), 2, "0") lcAnn_FiscPP = "Ann_FiscPP" + lcCompteur + " n(4) " lcAnn_FiscPA = "Ann_FiscPA" + lcCompteur + " n(4) " lcPeriode = "Periode" + lcCompteur + " n(2) " lcTotAnnPA = "TotAnnPA" + lcCompteur + " n(6) " lcTotAnnPP = "TotAnnPP" + lcCompteur + " n(6) " lcTotCliPA = "TotCliPA" + lcCompteur + " n(6) " lcTotCliPP = "TotCliPP" + lcCompteur + " n(6) " lcTotPriPA = "TotPriPA" + lcCompteur + " n(12,2) " lcTotPriPP = "TotPriPP" + lcCompteur + " n(12,2) " ALTER TABLE curStatistique ; ADD COLUMN &lcPeriode ; ADD COLUMN &lcAnn_FiscPA ; ADD COLUMN &lcAnn_FiscPP ; ADD COLUMN &lcTotAnnPA ; ADD COLUMN &lcTotAnnPP ; ADD COLUMN &lcTotCliPA ; ADD COLUMN &lcTotCliPP ; ADD COLUMN &lcTotPriPA ; ADD COLUMN &lcTotPriPP But when I execute the program, it's telling me that I have duplicate field or invalid name when I try to alter table. Can I add more that one column at the same time? -- Philippe Harnois PS Excuse me for my poor english... Tag: SQL and Record Locking Tag: 177984
  - 18
    - VFP7 Bug I keep getting an error on VFP7. I have created a method in a formset called qfPricing and it takes 2 parameters. When I try to call this method by typing THISFORMSET.qfpricing(parameter1,parameter2), it will error on me as soon as I type in the left "(" the error is: Fatal error: Exception code=C0000005 @ 07/17/03 09:00:36 AM. Error log file: C:\Program Files\Microsoft Visual FoxPro 7\vfp7err.log and yes I do have the service pack installed. My only workaround that I found is to type in () on the next line and then copy and paste the parantheses to the end of my method and then insert the parameters. This is kind of a pain though. Tag: SQL and Record Locking Tag: 177978
  - 19
    - Can't save PATH ? This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C351D8.CD099950 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Weird,=20 For some reason VFP8 is not saving the path I set in tools/options/file = locations go to tools/options change your path click 'set as default' apply ? SET('PATH') path is there exit fox8 (optional: check the registry, path is there) run fox8 ? SET('PATH') nothing go to tools/options nothing exit fox8 (optional: check the registry, path is not there) Not that I care cuz I always reset the path in my ClearAll program Just wondering... ------=_NextPart_000_0008_01C351D8.CD099950 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Weird, </FONT></DIV> <DIV><FONT face=3DArial size=3D2>For some reason VFP8 is not saving the = path I set=20 in tools/options/file locations</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>go to tools/options</FONT></DIV> <DIV><FONT face=3DArial size=3D2>change your path</FONT></DIV> <DIV><FONT face=3DArial size=3D2>click 'set as default'</FONT></DIV> <DIV><FONT face=3DArial size=3D2>apply</FONT></DIV> <DIV><FONT face=3DArial size=3D2>? SET('PATH')</FONT></DIV> <DIV><FONT face=3DArial size=3D2>path is there</FONT></DIV> <DIV><FONT face=3DArial size=3D2>exit fox8</FONT></DIV> <DIV><FONT face=3DArial size=3D2>(optional: check the registry, path is=20 there)</FONT></DIV> <DIV><FONT face=3DArial size=3D2>run fox8</FONT></DIV> <DIV><FONT face=3DArial size=3D2> <DIV><FONT face=3DArial size=3D2>? SET('PATH')</FONT></DIV> <DIV>nothing</DIV> <DIV> <DIV><FONT face=3DArial size=3D2>go to tools/options</FONT></DIV> <DIV>nothing</DIV> <DIV>exit fox8</DIV> <DIV> <DIV><FONT face=3DArial size=3D2>(optional: check the registry, path is = not=20 there)</FONT></DIV> <DIV> </DIV> <DIV>Not that I care cuz I always reset the path in my ClearAll=20 program</DIV> <DIV>Just wondering...</DIV></DIV></DIV></FONT></DIV></BODY></HTML> ------=_NextPart_000_0008_01C351D8.CD099950-- Tag: SQL and Record Locking Tag: 177975
  - 20
    - Modif.Forms in low-level and Compiling Hello, I have a complete routine to manage all the form objects in the form manipulating it's memo fields on the SCX files. Everything is ok, except with the optiongroup, when I modify it's methods and then recompile the form, using COMPILE FORM, it doesn't reflect the changes on the form when I open it in the designer. I tried refreshing project, updating the project, etc, etc. Thee METHODS filed is updated and should work OK. but the form doesn't reflect the changes ANY suggestion wil be appreciated, Thanks in advance... Bastian V. Tag: SQL and Record Locking Tag: 177970
  - 21
    - FPW2.6 and RUN oddity Hello, I am needing to upload data to a secure website from FPW2.6 I have downloaded curl which is a command line tool that can be used to do this, fought my way through the documentation and examples and pretty much got it going how I want. Now I come to integrate it into Foxpro and I see an unusual error, if I issue RUN curl.exe then I just see a message "This program cannot be run in DOS mode" on my (win95) computer. I have checked the foxrun.pif and it is pointing at "command.com" If I go to start->run and type "command.com" and then "curl.exe" then it runs fine! To add insult to injury, it works OK on a 2k machine in a NTVDM box from Fox. Does anyone have any idea what is upsetting it? I have a feeling it is working with the /N switch but it closes too fast to see and I very definately DO want foxpro to wait until this command is processed. I have tried RUN command.com curl.exe and also calling curl from a batch file and RUNning the batch. All the same. -- TIA Andrew Howell I am using FPW2.6a. Tag: SQL and Record Locking Tag: 177966
  - 22
    - Modelling Tools I am trying to use a UML modelling tool with VFP. However I can't get any to run. They each (VisualUML Foxpro interface & Micrsoft/Rose) seem to generate OLE error codes when I try to run them, inside or outside of VFP. I get the selection screen where I can choose code generation or reverse engineering but when I press Run it gives me nasty OLE errors. Eg. Trying to run visual modeller from MS site. DO vfpmodel.APP and I get OLE error code 0x80029c4a Error loading type library/DLL. The microsoft documentation for the modeller says to run the application to update the registry but there is not a separate executable to run. -- Darwood - MCP, MCSE Tag: SQL and Record Locking Tag: 177961
  - 23
    - [OT]: How to prolong & maintain notebook's battery life? Hi all, First of all; sorry this is off topic. I feel that I relate more with people on this community than with anybody elsewhere. When I bought my laptop, the battery could last for three hours. Lately the battery life is shorten. About three months ago, the battery last for about 2 and a-half hours. And then two hours. And now, even if I have 100% battery power, it will only last for about 1 and a-half hours. The time shown by the Power Applet (x% remaining followed by the approximate time) is about the same as the real time (counted manually with stopwatch). Unsurprisingly, the charge time to get to 100% is also reduced! Seems like there are some battery cells (?) that's not in used at all. This last few days I tried to reduce several programs that run on the background while using battery power, but that doesn't help much. I also lower the screen brightness and turn off sound -- but again that doesn't help much. Most of the time I use my laptop for developing software (w/ VFP7 or VFP8 IDE), typing on MS Word or designing database with SQL Server Enterprise Manager. The laptop is Compaq 1700 running on PIII 1.13GHz with 256MB SDRAM. The battery is a Lithium-On with 4.0 AHr capacity running on 14.4 Volt. Question: 1. Anybody knows how to 'revive' my battery (besides buying a new one obviously!) 2. Got any idea about how to maintain (and prolong) battery life? TIA, Willianto Tag: SQL and Record Locking Tag: 177959
  - 24
    - How to delete completely a memo field? replace memofield with '' ??? Bastian Tag: SQL and Record Locking Tag: 177950
  - 25
    - Exception code=C0000005 HELP PLS!! ASAP I was forced to shut down our main data and applications server with people in .dbf tables and running VFP 6.0 apps. Upon restarting the server and people attempting to print reoprts, they now get this error: Fatal error: Exception code=C0000005 Called from - line# {path/program} Called from - fgenerate line# {path/program} Called from - pgm._s3x0kqu9z.pageframe1.page1.cmgpb_generate17.valid line 3 Called from - line# {path/pgm} Called from - line# {path/pgm} Called from - line# {path/pgm} any HELP ASAP would be appreciated. Thanks Tag: SQL and Record Locking Tag: 177945

This is another query concerning converting my app to multi-user.
I am using VFP 6 build 8492 (SP 3?).

How do you ensure update integrity in *hybrid* xBASE/SQL code?

In xBASE, I know more or how to handle the locking, but I do not
know how to do it in SQL. Is it just begin/end transaction? How do
xBASE and SQL commands interact? Pointers to the docs or even better
to Hacker's 3 or Hacker's 6 would be quite appreciated.

I think that I would prefer to avoid using a .dbc if I can. Is
this viable? If not, how does one send a complete set of data to
another (as when I have to debug a situation)?

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

Top

Re: SQL and Record Locking by Gene

Gene
Tue Jul 29 06:22:39 CDT 2003

SQL uses Begin Transaction/ End Transaction/ Rollback Transaction

You have been around here a while so I am sure you already no about
the Client Server/ Hacker's Guide books at http://www.hentzenwerke.com/

For VFP Transactions are supported only for tables in a database

There realy isn't any Interaction between using SQL functions for
SQL and VFP commands, they are used like any other function
returning some kind of result back to VFP.

hth....

"Gene Wirchenko" <genew@mail.ocis.net> wrote in message
news:3f25ff3b.1568408@news.ocis.net...
> This is another query concerning converting my app to multi-user.
> I am using VFP 6 build 8492 (SP 3?).
>
> How do you ensure update integrity in *hybrid* xBASE/SQL code?
>
> In xBASE, I know more or how to handle the locking, but I do not
> know how to do it in SQL. Is it just begin/end transaction? How do
> xBASE and SQL commands interact? Pointers to the docs or even better
> to Hacker's 3 or Hacker's 6 would be quite appreciated.
>
> I think that I would prefer to avoid using a .dbc if I can. Is
> this viable? If not, how does one send a complete set of data to
> another (as when I have to debug a situation)?
>
> Sincerely,
>
> Gene Wirchenko
>
> Computerese Irregular Verb Conjugation:
> I have preferences.
> You have biases.
> He/She has prejudices.

Top