Memo Field Comparaison

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
    - Find directory of my executable I have an executable that takes a filename parameter, this makes it so I can double click on a file and it starts my program. The problem that I am having is that it starts the program with the default directory being where the file was and not where my executable is. I have looked through the home function and can't get it to show where my executable is. How can I figure this out? -- Altman VFP8 SP1 "No matter how foolproof you make a system, 'fools' can be remarkably ingenious." Tag: Memo Field Comparaison Tag: 194540
  - 2
    - Image is not changing for each record in a report The information suggested by Lee Mitchell in his reply to the following post was very helpful in solving my issue with presenting images stored in a general table field into a report Subject: RE: Image Click Code To Transfer A Jpeg Into A General Or Binary Field In A Table 5/19/2004 10:29 AM PST I now have my images stored in a binary memo field (froogle.newpath), and have written the following, simple program function to extract the image into a file called bob.jpg PROCEDURE bertudf(lpFileName, lpMemoBinFld DELETE FILE bob.jp SET SAFETY of STRTOFILE(lpMemoBinFld, "bob.jpg" SET SAFETY o RETURN lpFileName My OLEBOUND report control points to "file" with the following reference bertudf("bob.jpg",froogle.newpath) where "froogle" is the table name and "newpath" is the binary memo field containing the image I know the UDF is being called and is working, because the image in "bob.jpg" is changing when it is opened from Windows Explorer and the status bar shows File Deleted (as called for in the UDF) as I step through the pages when previewing the report. I put that delete file step in to make sure the file is actually changing. All of the data in the report is changing appropriately as each table record is reported, except for the image. Only the image for the first record is displayed, and is repeated for each subsequent record in the report. When I Preview the image inside of the OLEBOUND report control, it displays the first record's image (which is not the latest image displayed in Windows Explorer) What am I missing to get the reported images to match with the other data being reported? Tag: Memo Field Comparaison Tag: 194535
  - 3
    - Updating a field in Browse our users want to update records in browse window but we need to automatically update a date field and a modby field when they change a record. How can this be done? Tag: Memo Field Comparaison Tag: 194531
  - 4
    - VFP7 application running as a service Hi all, I've got a VFP application and I'm trying to get it to run as a service on a NT or 200 machine. I've managed to use a utility to register it as a service. When I got the control panel and start the service the application starts as expected. after a short time windows complains that the app hasn't started in a timely fashion Error 1053. Then the App is closed down but it runs ok without error Is there an API Call or something that I need to return to the Service Control Manager to tell it that the app has opened correctly ? I don't really want to use the srvany.exe in the nt res kit as it would mean that my customers would all have to buy it pushing the price of our application up! :o( Is there a solution to this problem? I've read various articles online about it and I can't see anything that is of use Thanks in advance Rob Tag: Memo Field Comparaison Tag: 194526
  - 5
    - application installation reports unable to access drvvfp.cnt (vfp6) I have an application installation program generated in vfp6 that includes the vfp odbc driver My client is unable to run this on a windows xp pc because the setup program reports that it cannot access the drvvfp.cnt (one of the vfp odbc help files) Is there a soulution to this? Any help gratefully received John Tag: Memo Field Comparaison Tag: 194523
  - 6
    - AS400 ODBC Connection Fatal Error We are trying to establish a connection to a AS400 database using the client access ODBC driver. When we use the connection string to establish the connection, the SQLSTRINGCONNECT returns successfully, but when we execute a SELECT, SQLEXEC crashes with a fatal exception C0000005 error. But if we use the DSN instead of the connection string, the SQLEXEC works fine. Any ideas on why it fails? We are using VFP 7.0 SP1. Tag: Memo Field Comparaison Tag: 194521
  - 7
    - Help Files I am wondering if anyone has a good reference on how to build the actual help files themselves. I understand how to make the forms and objects point to "topics" etc, but I cannot find anything that shows me how to build the actual help file itself. Thanks, Scott Tag: Memo Field Comparaison Tag: 194518
  - 8
    - Getting an IP Address Assuming I receive lets say that I receive an email from machine x which is connected to network(s) y this in turn is connected to the internet Is it possible, given the domain name to resolve the actual IP address of the machine that sent me the original emai So for example "FRED" who works for "ACMEBALLBEARINGS" and who have a domain called "ACMEBALLBEARINGS.CO.UK sent me an email from his computer at work his works email is not suprisingly "FRED@ACMEBALLBEARINGS.COM" how do I find FRED'S IP Address and if I wanted to how would I go about communicating with FRED'S computer WITHOUT using Email. Lets say I wanted to say "Hello" to fred BUT NOT USING EMAIL - How would I do it chers John Tag: Memo Field Comparaison Tag: 194517
  - 9
    - ERROR MESSAGE BOX IN A PRG I'M OPENING DATABASES AND TABLES.EXCLUSIV IF TABLE IS IN USE I GET A POPUP MESSAGE BOX BOX SAYING FILE ACCESSS DENIED HOW CAN I KEEP THE POPUP AWAY. IF IT WON'T OPEN THE TABLE I JUST WANT THE PRG TO CONTINUE ON IF YOU SUGGEST ONERROR() PLEASE BE SPECIFIC AS TO WHERE TO PLACE THE INFORMATION WITH IN THE PRG THANK SHERRY Tag: Memo Field Comparaison Tag: 194504
  - 10
    - ShellExecute API call, detect completion? I'm using ShellExecute to kick off a BCP job from within FoxPro. I'm wondering if there's a way to detect the process has finished? Here is the DECLARE I'm using DECLARE INTEGER ShellExecute IN SHELL32.DLL INTEGER handle, STRING @cDo, STRING @cFile, STRING @cParms, STRING @cDir, INTEGER ncm Then nResult = ShellExecute(0, "Open","bcp.exe","[bcp params]", "", 1 Perhaps a way to make it not return control to FoxPro until the BCP exits or something? I am pulling data down, so I could poll the output filesize until it stops growing for X amount of time, but this seems cludgy. I've looked into the ShellExecuteEx API call, which has a SEE_MASK_NOCLOSEPROCESS flag that seems like it would do the trick, but frankly constructing the SHELLEXECUTEINFO structure passed into the call is beyond me. Any pointers to examples of this would be appreciated. Any help at all is apprecated, really Thanks Dirk Tag: Memo Field Comparaison Tag: 194496
  - 11
    - API calls from VFP and timers Does anyone know if there is a way to define a variable in Foxpro (Vfp 8) and prevent its location in memory from being changed. I have a STRING that is passed by reference to an API function, which then modifies the string. When the API call finishes the string now contains the new information. The problem I am experiencing is that when the timer fires, the memory seems to get shuffled, so the location in memory that the API control is modifiing is no longer my foxpro variable. I do not wish to disable the timers (multiple reasons). Is there a way to define a variables location as static? I appreciate your help, -------------------------------- Dan Tallent Tag: Memo Field Comparaison Tag: 194493
  - 12
    - Stretch with overflow in Summary band I have a field in the Summary band and I checked Stretch with overflow, however it won't stretch. I know that it has multiple lines, yet no stretching occurs. It prints a variable, so I changed it to print a value stored in a memo field, but this did not help. A search of the KB shows no bug like this, at least when searching on Stretch with Overflow (there is one similar bug listed, but I'm not doing what it says causes that bug). Anybody seen this? Thanks, Russell Campbell Tag: Memo Field Comparaison Tag: 194487
  - 13
    - Format datetime as date? Is it possible to set the properties of a textbox that has a controlsource that is a datetime field to act like a date field? I don't want the user to see or inpiut the time part. Format YS is too restrictive as we need years earlier than that allows This has all come about with cursoradapters from SQL and I know I can set the cursorschema to set the structure but I will have over 100 tables here so it is a huge effort to do that Thanks for any help Bernie Tag: Memo Field Comparaison Tag: 194484
  - 14
    - Why do views leave open tables behind? Greetings! When I open a view and then look in the Data Session window, I see workspaces for the view and for each table the view uses. When I select the workarea that is using the view and enter the USE command by itself to close the view, the view obediently disappears from the data session window, but the tables remain open. Is there a reason for this, and how can I close the tables associated with a view when I don't need the view any more? Thanks very much! Rob Richardson Tag: Memo Field Comparaison Tag: 194481
  - 15
    - Triple Click problem with Citrix Metaframe XP / Win32 ICA Client We have a problem with our Metaframe XP installation. Our users are using the Win32 ICA and we run Visual Foxpro applications. We have found the double clicking does not work in list boxes and other controls and you have to triple click instead. I have found two references to fix this exact problem on the Citrix website - one is a hotfix for Metaframe 1.8 and also Presentation Server for Unix. Has anyone else experienced this problem and is there a hotfix that we can apply? Kind regards Phil phil@wrltd.co.uk Tag: Memo Field Comparaison Tag: 194480
  - 16
    - Win XP and Email I have a program that send emails with pdf's files attached in win98 2nd edition using mapi.session but it doesn't work in win 2000 and win xp Does anybody know how to solve it? and one more, how could I know the operating system so the program could send emails in win xp and win 98 Any help will be welcome Thank Marian Tag: Memo Field Comparaison Tag: 194479
  - 17
    - automatic system strart is there any way to automatically computer start.. on specific time Tag: Memo Field Comparaison Tag: 194477
  - 18
    - Help connecting FP Application to a mail server OK, this might be a bit of a newbie question, but the last time I used FoxPro was in 1990 and I am trying to get to grips with Visual FoxPro (though I am using VFP 6.0 until I can get my copy of Visual Studio Can somebody point me in the right direction to find some resources. What I want to do is have a a FoxPro application be able to send an email via a mail server. (I'd also like it to be able to connect to an FTP server at a later date as well Anybody got any ideas or suggestion Tag: Memo Field Comparaison Tag: 194474
  - 19
    - FoxPro newbie help I am a VB/VB.Net developer working on a foxpro project. I need some directions in how to get up to speed on FoxPro. I don't seem to find many FoxPro beginner sites. Please help Any suggestion swould be apreciated. Web sites, books, magazines,etc. Tag: Memo Field Comparaison Tag: 194469
  - 20
    - [ANN] Singapore VFP User Group meeting today 20-5-04 Organizational Meeting is on Thursday, May 20th, at 7:00 PM - at Quantum Media Offices - at 60 Kaki Bukit Place / Eunos Tech Park #2, Unit 01-12 / ZIP = 415979 . If there are more than 10 people attending, please note we will go to the roof and hold the meeting around the swimming pool. If you need directions, please call 68486313 during the day on Thursday. see http://efgroup.net/sing and http://groups.yahoo.com/group/singfox for more information. Hope to see you there ! Bring a friend ! -- William Sanders / Electronic Filing Group Remove the DOT BOB to reply via email. Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html Mondo Cool Satellites -> http://www.efgroup.net/sat VFP Webhosting? You BET! -> http://efgroup.net/vfpwebhosting mySql / VFP / MS-SQL Tag: Memo Field Comparaison Tag: 194467
  - 21
    - VFP6 - Help (F1) I have loaded VFP6 onto my new machine from the original disks - no problem. However, the help screens seem to be missing as F1 does nothing. I called for the recommended installation when loading. Do I need to load something else from a different disk ? -- Tim Hobson Tag: Memo Field Comparaison Tag: 194460
  - 22
    - VFP under Mac OSX Does anyone have experience running FoxPro under the classic environment in MacOS X? Some of my forms run, but there's trouble with FoxPro remembering where files (such as Wizstyle.vcx) are. Setting file location options in the Options dialog doesn't work. In fact, if I set file locations, close the dialog, and then re-open it, the options I just set are gone. Does anyone have any ideas, or is this a lost cause? Thanks. -- Tag: Memo Field Comparaison Tag: 194456
  - 23
    - C0000005 on ListView using XP Tablet Edition Hi, All! I have experiencing a problem with our application while running it on XP Tablet Edition Service Pack 1. The application, one of our legacy programs, designed with VFP 6.0 SP3 has been in the field and used with many OS including 95,98,NT,2000, XP. However, when clicking on a ListView control and running it on XP Tablet Edition SP1, the program generates the following error: Fatal Error: Exception code=C0000005 Any ideas would be appreciated. Thanks! Tag: Memo Field Comparaison Tag: 194452
  - 24
    - NetWkstaGetInfo of NetApi32 and Custom Data Type I was able to get a sample code from the internet about how I can get a list of users of a particular computer. Currently, I am having problem with the NetWkstaGetInfo function. I need to create a customized data type like the one written below. I wonder if we can do this in VFP? If anyone of you was able to use the said function from NetApi32, I will be very grateful to know how you were able to use the function successfully. So far, all the sample codes that I was able to get are written in VB or Pascal (I guess) Private Type WKSTA_INFO_10 wki100_platform_id As Lon pwki100_computername As Lon pwki100_langroup As Lon wki100_ver_major As Lon wki100_ver_minor As Lon pwki102_lanroot As Lon wki102_logged_on_users As Lon End Typ They assign this "data type" to a variable like this way nVariable = WKSTA_INFO_10 and access the values of each sub items this way nVariable.pwki100_computername as if the sub items are properties and the nVariable is an object.. Thanks, Noy_P Tag: Memo Field Comparaison Tag: 194441
  - 25
    - Autofit Grid column Hi all, how to programmaticaly autofit grid columns when columncount = -1 ? vfp8 Tag: Memo Field Comparaison Tag: 194439
- Next
  - 1
    - Image Click Code To Transfer A Jpeg Into A General Or Binary Field In A Table Hello All & Cindy Too I need some button click code that will transfer the contents of a JPEG (Iamge) file into a general or binary field in a table I have a list of JPEGS in my listbox each of which is displayed as you move through the list. Waht I am trying to get the user to do is to select one such image and have it or the contents of it transferref into a general or binary field in my table cheers John (UK) Tag: Memo Field Comparaison Tag: 194437
  - 2
    - Connecting to Access datafile Hi How to connect to Microsoft Access data file to pull data from it TIA Tag: Memo Field Comparaison Tag: 194436
  - 3
    - Why I can't execute prg file in Runtime? Hi,Everyone Sometime, I want to automate create some codes in runtime and put them into a temp file (such as temp.prg),and compile project into a exe file, if execute such exe file which includes these codes in vfp environment, it works well. but if I execute such exe file solely, it always comes a error message indicate that there is a error in line 7. The following is my example: && A edit object is in thisform named edit1 && A command object is in thisform named cmd1, caption:execute && Those codes what I want pc to do is write in edit1 object In Click event of Cmd1 I put such code in it: LOCAL TempCurs,tmpDir,RetVal,ErrMessage TempCurs=SYS(2015) RetVal=ALLTRIM(ThisForm.Edit1.Value) STRTOFILE(RetVal,ADDBS(GETENV("Temp"))+TempCurs+'.prg') TRY Do (ADDBS(GETENV("Temp"))+TempCurs+'.prg') CATCH TO ErrMessage MESSAGEBOX(ErrMessage.Message+"ÔÚ(µÚ"+TRANSFORM(ErrMessage.LineNo)+" ÐÐ)",0,"Çë×¢Òâ!") FINALLY ENDTRY No Matter what code I put into thisform.edit1.value, it will always come a error message. Anyone can tell me the reason? Tks In Advance! Chuen Tag: Memo Field Comparaison Tag: 194434
  - 4
    - VFP Report : Century On / Off Hello I wrote 'set century off'. Then I executed a VFP report. I can see the dates properly. e.g. 19/05/04. But if I click on the report (preview mode) the date becomes 19/05/2004. This happens everytime Any solutions Thanks Prashant Tag: Memo Field Comparaison Tag: 194433
  - 5
    - how to make avi file hi all i want to put the avi file in my project. I know how to incorporate it into the project but dont know how to create your own avi file, i mean to say i have the company's logo i want the logo to rotate and show on my main for please suggest me any avi making software regard gibbs Tag: Memo Field Comparaison Tag: 194432
  - 6
    - cursorfill displaying query inside form! We are changing our forms to use native cursoradapters. Sometimes when the selectcmd contains some outer joins to other tables, the query cursor appears in the topmost form until you press a key at which point it disappears and the form loads perfectly with the correct information. I'm not sure what's causing this. It only seems to happen with some selects and not other similar ones. It doesn't happen if the selectcmd is changed to do a simple select * from tablename. It also doesn't happen when the cursoradapter is SQL Server rather than native Any ideas anyone Thank Bernie Tag: Memo Field Comparaison Tag: 194431
  - 7
    - Member classes (Grids, Columns & Headers) I'm trying to use the Member class feature of VFP 8 to create classes for 1). Grid class (which uses the Member class feature for mapping Columns) 2). Column class in a PRG (which uses the HeaderClass for mapping Header class) 3). Header class in a PRG (for the Column Class). I've created a Visual class for the Grid, & have set the Member Class & Class Library properties of the grid for the Column class (in the PRG). The contents of the PRG (for the Column & Header classes is as follows) DEFINE CLASS uColumn AS Column HeaderClassLibrary = 'F:\Research\VFP 8\Base Classes\_Grid.FXP' HeaderClass = 'oHeader' ENDDEFINE DEFINE CLASS oHeader AS Header Alignment = 2 FontSize = 8 Caption = "Header" Name = "Header" ENDDEFINE When i drop the Grid class on a form & use it, its all fine, The caption of the Header is Center Aligned. But, if i go & change this Alignment of the Header caption to Left (0) in the PRG, then the changes are NOT reflected in the GRID (form). The changes APPEAR ONLY IF, i change the column count in the Grid (on the form) to a greater value, & run the form. Ie, I HAVE TO REFRESH the GRID to retrive the Column class from the PRG once again, which in turn refreshes its setting for the HEADER CLASS from the HeaderClass & HeaderClassLibrary. Am i doing something wrong here. Cuz, if this is how it works, then I'll have to modify ALL my forms, when ever i make a change to the Header Class in the PRG. Best Regards, Thilaka Tag: Memo Field Comparaison Tag: 194428
  - 8
    - Return value of ShellExecute() API I'm using ShellExecute() API to print a Word Document, & at times ShellExecute() API returns the value 2. Which means the FILE CANNOT BE FOUND. But this isn't so, the file does indeed exist. The code fragment is as follows, ShellExecute(lnHandle,"Print",lcFile,"","",1) Where lcFile is the FULL PATH & NAME of the FILE. NOTE : The word document doesn't have any Macros. & at times the ShellExecute() function works (ie the word document gets printed out, ONLY at times does this fail). Ie, only on certain occasions does ShellExecute return the value 2 (also the file is the same in all such calls). Does anyone out there know, why ShellExecute returns 2 (ie why ShellExecute says that the file cannot be found). Best Regards, Thilaka Tag: Memo Field Comparaison Tag: 194424
  - 9
    - Data will not save I have tried using all methods I can think of, but the data will not save. The code pulls data from a table, runs it through calculations, then resaves it to the table. The data will not re-save to the table; however, if I debug (set step on), it works. I tried slowint the scan down. I tried using begin transaction, end transaction but it still doesn't save. The code is something like the following (too long to include the whole scan). This code is not in a screen nor is it user dependent for any interaction. I tried removing the the buffering and the multilocks. Nothing works. It use to work, then 'out of the blue' it stopped working. Any ideas? scan code stuff going on lnvariable = filename.value1 run computations on lnvariable and save to lnvariable2 set multilocks on cursorsetprop('buffering',5,'filename') replace filename.field2 with lnvariable2 =tableupdate(.t.,.t.) more code stuff going on endscan Tag: Memo Field Comparaison Tag: 194421
  - 10
    - Beginner to VFP I just took over at a new company that originally used dbase to build some processes/reports and later converted it all into VFP 7.0. However, I noticed in looking at the VFP projects, that no database files were used and therefore, there are no primary keys established and/or relationships defined. In addition, there are no views used in any of the projects since those are only supported when using a database file Being a beginner to VFP and programming (8 years using Access only), can anyone give me some thoughts on why you would use a database file and why you wouldn't?? To me, having primary keys is critical to data integrity so I'm not sure why they weren't used. However, the old manager learned VFP from a book and didn't have a lot of dbase experience so that would explain why. Is using a database file important and/or critical?? Thanks. Tag: Memo Field Comparaison Tag: 194409
  - 11
    - FoxFix 5.2 detecting memo corruption after COPY TO? Hello, We create a .DBC and export preformatted data files to disk just before running reports against them. I just scanned the resulting tables (that were created with the "COPY TO FileName DATABASE DatabaseName" command) and both FoxFix 5 and FoxFix v5.2 detect memo file corruption. Here are some of the results from the error logs: 311 (0x00000137) Memo Next Available Block (NAB) invalid 312 (0x00000138) Memo block size invalid 304 (0x00000130) Memo file truncated by 43 bytes. Probably benign and due to restructuring within FoxPro. Can anyone else confirm this behavior? We're having some weird Crystal Reports issues and were wondering if this could be an issue. FYI - Xitech tech support is difficult to deal with.... Thanks. -- William Fields MCSD - Microsoft Visual FoxPro MCP - Win2k Pro US Bankruptcy Court Phoenix, AZ "I love deadlines. I love the whooshing sound they make as they fly by." - Douglas Adams (R.I.P.) Tag: Memo Field Comparaison Tag: 194408
  - 12
    - Spell Check programs by Wintertree Software. Problem with VFP timers. Has anyone used the Sentry spell check program from Wintertree Software? I am experiencing a problem when the timers in my application fire, while doing a spellcheck. When I disable the timers, the spellcheck works perfectly. The calls to the spellcheck program are done using API calls. It is not realistic to disable the timers themselves, due to the fact I am using them throughout my application (dynamically created as needed) Does anyone have a suggestion for fixing this issue. -- Thx in advance, -------------------------------- Dan Tallent Tag: Memo Field Comparaison Tag: 194404
  - 13
    - When saving getting Fatal Exception: Exception Code = C0000005 Hi All, I've got a wierd problem when i'm doing a batch save. What I'm doing is trying to import some data files into my application so I'm going down the import files and copying them to live data files & saving them using tableupdate. The files I'm updating are quite big ie they contain over 150 fields. Whats happening is during the update I'm crashing out with the following error: Fatal Exception: Exception Code = C0000005 . However there seems to be no consistency as to when it does this, infact sometimes it does actually go thru the update OK & it never seems to crash in the same place. Can anyone explain whats going on here because i'm at an absolute loss. Cheers Simon Tag: Memo Field Comparaison Tag: 194400
  - 14
    - Fox-ML v1.0 Fox-ML is a markup language used to represent the components that create = fully functional applications in Visual FoxPro, like forms, menus, = toolbars, data, events and methods using an xml tag library specifically = designed for Foxpro. You can go to http://georgenava.com/foxml/foxml.html and take a look at = the basic tags or download the source to play with it. You can also go to http://workspaces.gotdotnet.com/foxml and be part of = the message board to exchange ideas. And what a better place to collaborate than the fox wiki? = http://fox.wikis.com/wc.dll?Wiki~Fox-ML~VFP Thanks for your input Tag: Memo Field Comparaison Tag: 194399
  - 15
    - Directory() Hi Fo(l)x, cPath = (connected network path e.g. "x:\test") Directory(cPath) returns .t. even if the network cable is disconnected How to do determine the access to the network location without reading/writing files from/to "cPath" Norbert Tag: Memo Field Comparaison Tag: 194392
  - 16
    - Send data directly to printer on network, FPW2.6a Hello, I know this is a topic that comes up fairly often but I haven't managed to get anywhere :( I have an Epson printer that uses Epson ESC/P2 language. I want to write a report in ESC/P2 language and send it directly to the printer. I have written reports in native printer language before but the printers were always connected locally to a parallel port. After forming the data for the printer I'd use Foxpro RUN command to copy the data file to the relevant parallel port. Now I want to do this to a shared Windows printer. I have set up the printer on my computer with the "Generic/Text only" driver and now commands such as "LIST TO PRINTER" come out at draft speed. I always understood the way to get Foxpro to write directly to the printer was by using the ??? command. Unfortunately all this does is create a nasty white error box saying "Cannot write to device PRN ." then causes a GPF. I am using FPW2.6a, is there a decent way to do what I want? Is it any easier in later versions of Foxpro? From my experience it does seem as if there is a massive oversight in the Windows world by assuming that people will never want to write raw data to a networked printer. Maybe I'm missing something? -- Thanks in advance Andrew Howell Tag: Memo Field Comparaison Tag: 194385
  - 17
    - Windows NT Security Hi Anybody here who could teach me how to use the NT Security in my Program??? I need to know who the users are? Or, at least, know who the current user is and its access rights... Any help will be highly appreciated.. Thanks in advance.. No Philippines Tag: Memo Field Comparaison Tag: 194382
  - 18
    - SQL optimization question I have 2 tables with same structure: BIGTABLE ( WORD C(10) ) && 10,0000 RECORDS SMALLTABLE ( WORD C(10) ) && 2 RECORDS both are indexed on WORD. SMALLTABLE has 2 recs: "CAT" "DOG" BIGTABLE has numerous 'words' including those found in SMALLTABLE the following in fully optmized: SELECT WORD FROM BIGTABLE INTO CURSOR TEMP WHERE WORD IN ("CAT","DOG") the folloinw is not optmized at all: SELECT WORD FROM BIGTABLE INTO CURSOR TEMP WHERE WORD IN ( SELECT WORD FROM SMALLTABLE ) Why is the 2nd example not optmized? And I'm am missing in the 2nd example to make it optmized? I need to use SMALLTABLE in table form rather than in sting form. THANK YOU Mike Farnesi Tag: Memo Field Comparaison Tag: 194378
  - 19
    - Visual Foxpro version 8 with Chinese Star I used Chinese Star XP to do chinese character intput in a textbox in development enviroment with Windows XP OS. It functioning OK. After I compile the program into EXE file and run the EXE program, It not allow me to input the chinese character. It just do nothing in the textbox. I has been check and set all the setting may happen in the Regional and Language Option but still cannot work. Is that something miss or any other setting has to be done on Window XP. Thank you Tag: Memo Field Comparaison Tag: 194375
  - 20
    - WinFax I am currently using a Visual FoxPro program to load a daily batch of outgoing faxes into WinFaxPro version 10.0. Sometimes the process of sending the faxes to WinFax stalls. Sometimes WinFax shows that the fax wasn't sent successfully when it really was. So the fax is resent which annoys the recipient. Here's the question: Is there a more reliable tool than WinFax that I can use to send faxes in VFP? Thanks, Kimball -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: Memo Field Comparaison Tag: 194374
  - 21
    - Recover 4.0 This is a multi-part message in MIME format. ------=_NextPart_000_0020_01C43C21.0D2C4950 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Has anyone used the Abri Tool "Recover 4.0" There is no 4.0 demo and the 2.0 does not work correctly with vfp8 Mik ------=_NextPart_000_0020_01C43C21.0D2C4950 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.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Has anyone used the Abri Tool  = "Recover=20 4.0"</FONT></DIV> <DIV><FONT face=3DArial size=3D2>There is no 4.0 demo and the 2.0 does = not work=20 correctly with vfp8</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Mik</FONT></DIV></BODY></HTML> ------=_NextPart_000_0020_01C43C21.0D2C4950-- Tag: Memo Field Comparaison Tag: 194368
  - 22
    - SQL question I have 2 tables with same structure: BIGTABLE ( WORD C(10) ) && 10,0000 RECORDS SMALLTABLE ( WORD C(10) ) && 2 RECORDS both are indexed on WORD. SMALLTABLE has 2 recs: "CAT" "DOG" BIGTABLE has numerous 'words' including those found in SMALLTABLE the following in fully optmized: SELECT WORD FROM BIGTABLE INTO CURSOR TEMP WHERE WORD IN ("CAT","DOG") the folloinw is not optmized at all: SELECT WORD FROM BIGTABLE INTO CURSOR TEMP WHERE WORD IN ( SELECT WORD FROM SMALLTABLE ) Why is the 2nd example not optmized? And I'm am missing in the 2nd example to make it optmized? I need to use SMALLTABLE in table form rather than in sting form. THANK YOU Mike Farnesi Tag: Memo Field Comparaison Tag: 194367
  - 23
    - Visual Fox and routing table Hi IÂ´ve been looking averywhere for something like this I donÂ´t know how to manipulate the routing table using Visual Foxpro. The only way I found was byt using de RUN command, like RUN "route add 0.0.0.0 mask 0.0.0.0 192.168.1.1 I would like to know if there's another way of doing this, without having to open the DOS shell I'm doing an aplication to allow/disallow internet access through a gateway and keep a record of users connected, thatÂ´s why I need to add/remove this route Please, I've been searching for this but can't find anything, I know there are other solutions for this, but now I kinda want to know IF I can do it this way Thanks a lot!!!! Tag: Memo Field Comparaison Tag: 194365
  - 24
    - Exclusive Open Table Problem Hello - I'm having a strange problem where I can't seem to open a table for exclusive use just a few procedures after my program starts up. I get an Access Denied error. But, I've checked and the table does not appear to be opened any where else. If I do a MessageBox("test") right before I try and open the table for exclusive use it will work. If I don't issue the MessageBox then it won't work. I've tried a FLUSH command but that doesn't help. I can open it for shared use with no problem at all. It's as if it needs a delay (which is what the messagebox allows for) before issuing the command and I'm not sure what the problem is. Thanks, Mike Tag: Memo Field Comparaison Tag: 194356
  - 25
    - aGetFileVersion / aSetFileVersion I need to be able to programmatically change the version information associated with/contained within a file (ie: the stuff on the â??Versionâ?? tab when you right-click on a file in Explorer and select Properties) aGetFileVersion will READ everything I need, but Iâ??ve found no easy way to SET/CHANGE the information. Obviously this isnâ??t built into VFP, so itâ??s going to be some kind of getObject call, I just am clueless as to where to look. Tag: Memo Field Comparaison Tag: 194353

It looks to me that a memo field that is different in the first bytes
(<255???) is detected, but one that is different past that limit is not.
Is this a true assumption?

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.675 / Virus Database: 437 - Release Date: 03/05/2004

Top

Re: Memo Field Comparaison by Stefan

Stefan
Sat May 22 04:41:11 CDT 2004

"Erik Vandamme" <erik@tunwand.com.au> schrieb im Newsbeitrag
news:40aeb40a$0$9409$5a62ac22@freenews.iinet.net.au...
> It looks to me that a memo field that is different in the first bytes
> (<255???) is detected, but one that is different past that limit is not.
> Is this a true assumption?

I think not, the test.prg below seems to be able to get the difference.
Index expressions are limited to 240 bytes though...

hth
-Stefan

* memocomptest.prg
LOCAL cString, oError
cString = REPLICATE('x',300)
CREATE CURSOR temp (memo1 M, memo2 M)
CLEAR
INSERT INTO temp VALUES (m.cString, m.cString)
? memo1 == memo2 && equal
INSERT INTO temp VALUES (m.cString, m.cString + 'a')
? memo1 == memo2 && .F., not equal

TRY
INDEX ON memo2 TAG memo2
CATCH TO oError
? oError.ErrorNo, oError.Message
ENDTRY
SET COLLATE TO "MACHINE"
INDEX ON LEFT(memo2,240) TAG memo2
? SEEK(m.cString) && .F., not found
*

Top