finding string of one table in another

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
    - using double-byte character sets (DBCS) Hey everyone! I'm working on a program that takes keyboard entered words (whose letters each have an ANSI value between 0 and 255) and converts them to charcters and expressions in a given double-byte font. To do this, what I really need is a double-byte equivalent of the CHR() function. But since there isn't such a function, there must be some other way of going about it. Related to all this, when I copy characters to the clipboard using the Windows XP Character Map, they paste fine into all my other windows programs (WordPad, Photoshop) but they always paste in as "???" in VFP6 even though I've selected the display font to show the desired double-byte font. Any help would be appreciated. Scott Tag: finding string of one table in another Tag: 195964
  - 2
    - MSMAPI question I did a form that try to send an email with some attachments. It works great under W98 2nd edition. In Win 2000 in some workstation it said that the class was not registered. I registered using regserv etc.. and it is not working properly I always get the same message, the class was not registered. In other WK under Win 2000 I got an error message in the following line. oform.Message1.send(1) the error was: exception code OLE dispacht 0 de MAPImessages. Unespecified failure has occurred. I do not know what to do. The aim of my program was to built a form that run in almost any environment (Win 98, 2000, XP, etc) using Outlook Express. Any advice will be welcome Thanks in advance Mariano Tag: finding string of one table in another Tag: 195962
  - 3
    - Manuel for ODBC Could you suggest some manual for using ODBC. I am interested in basic concepts and how to work with MySql server... Thanks Tag: finding string of one table in another Tag: 195959
  - 4
    - Playing a WAV File over a Modem We want to play a .wav file over a our PA system in the warehouse when a condition is met. I am told all we need to do is have a modem call an internal for the PA system and then play the .wav file. Does anyone have any experience with doing this. Figured I would ask before investigating this. Thanks Tom Tag: finding string of one table in another Tag: 195955
  - 5
    - Tableupdate always true with cursoradapter and ado Hi, I'm using VFP8 with sp1. I'm connecting to a DBC by using an ADODB connection. Retrieving and updating data works fine. To do that i use a cursoradapter that uses the adodb connection as activeconnection. So far no problems. But when the following situation occurs, tableupdate behaves very strange: User 1 opens a record for edit User 2 opens the same record for edit User 1 updates and closes the record, the data in the record is changed User 2 updates and closes the record, because the data has changed this user should receive an update error but i don't get an error either on the recordset, the connection or with the TABLEUPDATE(1,.F.). I tried several locktypes but i cannot solve the problem. Hope someone can help me out with this. Pat Tag: finding string of one table in another Tag: 195954
  - 6
    - Class Instantiating Problem I have a DLL project with two classes (Let's say ClassA and ClassB). From ClassA I want to call a method in a different class, which is also called ClassB (this is not the same ClassB that is included in the project). Now if I use NewObject('ClassB', Path of ClassB), instead of creating the ClassB from the path I specify, it creates the ClassB that is included in the project. How can I instatiate the ClassB that is stored outside this project? (I guess I did not confuse!) Best Regards, Y. Sivaram Tag: finding string of one table in another Tag: 195951
  - 7
    - Universal Thread Messed Up? Hey folks, Is anybody else having a problem getting the UT message treeview nodes to expand this morning? I can't get any of them to open up in either IE or Mozilla; both browsers report Javascript errors when I try it. Ken Dibble Southern Tier Independence Center Tag: finding string of one table in another Tag: 195950
  - 8
    - How can I insert data into SQL Table from vfp table(dbf file)? Hi, all, I have table named daykj in SQL SERVER, now I want to append data from a vfp native table named _daykj(locate in kjdata), I try the following code, but It seems to be uneffective. cCs="Driver={SQL Server};Server=(local);Database=zwhrp;Uid=sa;Pwd=;" nHandle = SQLSTRINGCONNECT(ccs) nStat=SqlExec(nHandle,"INSERT Into zwhrp!DayKj Select * From kjdata\_DayKj") Anyone can give me idea? Thanks in advance! Chuen Tag: finding string of one table in another Tag: 195947
  - 9
    - How to send a simple HTTP request Hi all, 1- I have a small service running on my server with a little web server. All I want to know is how I can send a simple HTTP GET request to it through my form in VFP9, such as : http://127.0.0.1:8800/?ph=3774&Text=test+123 2-In the same case how can I retreive the HTTP response from the web server ? TIA Tag: finding string of one table in another Tag: 195932
  - 10
    - On Label Key I need to create "Hotkeys" with "+" and "-" in my application. Is there a way to do this? They are not options in the On Key Label command. Thanks, Scott Tag: finding string of one table in another Tag: 195929
  - 11
    - VFP and MySQL Hi, 1. using VFP and MySQL, does it the exe can update data in webserver from remote pc using internet connection ? eg: open table with IP address ? 2. is VFP update speed as good as compare to VB on MySQL ? Regards Hoe Tag: finding string of one table in another Tag: 195926
  - 12
    - CodeMine Framework I'm rebuilding an application in 8.0 using the new version of CodeMine. But, the original developer didn't use, or else save, the original CodeMine environment. Has anyone any experience with this kind of situation? Thanks Steve Tag: finding string of one table in another Tag: 195921
  - 13
    - can u shed some light on this weird class instantiating err Hi friends i created class (class name is ctrHeight.VCX) with container,a label ,commandbutton a textbox in it. when i add this to this a form from toolbar everything works fine. but when i add this control thr code like following thisform.AddObject('cnt','container') thisform.cnt.visible=.t. thisform.cnt.newObject('cntheight','ctrlheight','D:\VSSLocal\vip\ctrHeight.VCX') thisform.cnt.cntheight=.t. i am getting following error "Error instantiating the object "txvalue" (actually it is a textbox)" i am wondering what i am doing wrong here. i just found when i add this control from toolbar and add another control thr code like abv everything working fine??? what i am missing here?? many thanks for ideas -- cheers Tag: finding string of one table in another Tag: 195920
  - 14
    - Shortcut evaluation Hi, I'm having a bit of a headache because of the following: I want to let the user type an expression and check whether it's valid or not eg "x=1 and y=2" Now, the tricky part is that I can't be sure that y (or whatever variable the user makes up) exists at this point. Now, if x equals 0, the "y=2" part is not evaluated, so I won't get an error if Y does not exist and therefor I cannot report this error (so my "expression-validation" routine will not indicate that this expression cannot be used for all values of x). Now the user can make quite some difficult statements (with brackets etc) eg: (x=1 and y=2) or ((b<=3 or c=3) and c>2) or InList(q, 'a', 'b', 'c') So my question is: does anybody have an idea about how to generate a list of all variables used in an expression? R Robert Tag: finding string of one table in another Tag: 195917
  - 15
    - Moving Classes Around I should like to move my classes to another folder. How can this be done without messing-up all classes lower down in hierarchy and object based upon them? Thanks in advance. Shmiel. Tag: finding string of one table in another Tag: 195915
  - 16
    - Nesting of For loops Can the "for" loops be nested in vfp? My program is giving nesting error. for i = 1 to 6 for ..... if.... ---- ---- endif endfor endfor Tag: finding string of one table in another Tag: 195889
  - 17
    - compatible? Can I use Foxpro for the Web? May I create aplications, put them in an internet server and run in the usersÂ´s browsers? How does this works? -- Lorenzo MÃ¡rquez Tag: finding string of one table in another Tag: 195887
  - 18
    - Assigning objects I have a situation. From container1 I am zooming into container2 by trapping the click event of container1. Both containers represent the same thing, except that container2 looks big. When I come back to container1, I want all the control settings that I had made to container2 to appear in container1 and also when zooming to container2 from container1, I want all the settings of container1 to appear in container2. What is easiest and the best way to do this? Using a base class to represent both the containers. And creating 2 objects to represent the normal and zoomed versions of the container and assigning one object to the other when zooming back and forth. Can this be done? Is this the best approach to this? Regards Tag: finding string of one table in another Tag: 195883
  - 19
    - How to determine PC regional setting ? How to determine current PC's regional setting through VFP ? E.g. i have one external function call which return a value base on current PC regional setting. in order for my program to manipulate the return value, i need to know the client PC's regional setting. one common problem will be american and british date format. Thanks in advance. Tag: finding string of one table in another Tag: 195877
  - 20
    - parameter for WEb Pages Hi, sorry.. this is off topic but maybe somebody can help me.... I have a very simple question, maybe a stupid one.... but I have done several excercises building WEBpages using dynamic HTML with VB scripting, and found documentation and theo bject model hard to understand :-( what I need to do is to call a web page from a hyperlink and let such called web page to receive a parameter let say that I have the following hyperlinks <P><A href="http://checaproducto.htm?product=A123">producto A</A></P> <P><A href="http://checaproducto.htm?product=A235">producto B</A></P> the idea is that for any hiperlink the same tarjet web page will be called but passing thru a parameter (product ID) my question is what kind of instruction should I need to use in the called web page (checaproducto )to know the value of the parameter(productID) I would prefer to use stadard HTML rather than ASP, is it possible? thanks thanks in advance Oscar Taboada Tag: finding string of one table in another Tag: 195875
  - 21
    - Graphics in VFP In one of my applicatoins I use office automation (Excel) to display business graphics. Now this application will be deployed to a client that doesn't use MS Office. Is there any other package (e.g. Active-X) that I can use so I can keep most of the code? The graphics I produce is ordinary bar and pie charts and diagrammes. Tag: finding string of one table in another Tag: 195873
  - 22
    - Total count of contained controls H iAll, Is there a way to loop through all the controls within a container till all the controls are visited? Something like, for i = 1 to container.totalcountOfContainedControls .... .... endfor Regards Tag: finding string of one table in another Tag: 195866
  - 23
    - Moving the record pointer backwards Hi, Is it possible to move the record pointer one record previous to its current position when traversing theough a query result stored in a cursor? Regards Tag: finding string of one table in another Tag: 195863
  - 24
    - PassArray To Ado,Xml hi all i looking for Exsample To pass data beetwen Form And Com Server like Passarray Prg i found in unvirsalthread.com but pass data with ado or xml tankes Tag: finding string of one table in another Tag: 195862
  - 25
    - Shamanism, Normism & Declaration of Heaven on Earth2792 Please visit http://www.normism.org for details! 151415dhfubm151415 dhfubm151415dhfubm ----------------------------------------------------------------------------- --This Message Has Been Posted Using A Trial Version Of Message Poster 2003-- ----------------------------------------------------------------------------- Would you like to reach millions of customers for only the cost of bandwidth? You can post messages like this to thousands of newsgroups with a simple to use software application called Message Poster 2003. For more details on this extremely affordable software, visit: http://www.exibitionsoftware.com Tag: finding string of one table in another Tag: 195861
- Next
  - 1
    - Spellcheck Can anyone share their experiences trying to incorporate spell checking in a vfp app( for editbox and/or rtf text)? I can't even find the spellchk.app mentioned in the kb. -Lew Tag: finding string of one table in another Tag: 195848
  - 2
    - To save web server resources, To save web server resources, do anyone know how to launch a VFP Report writer from a web page to print report? and can I check the VFP is being loaded to keep one copy EXE in memory only? KL Tag: finding string of one table in another Tag: 195839
  - 3
    - VFP9 ReportListener Talent Search This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C45578.E8CB4A90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, =20 I'm looking for interesting and innovative ideas for putting the VFP 9.0 = ReportListener class to use, for publication in either FoxTalk 2.0 or in = another alternative format. You might call this a "talent search" or = "competition" to see who can come up with the most outrageously useful = subclasses of ReportListener. =20 As you probably know, you can subclass ReportListener (or in some cases = just set properties of the standard ReportListener) to accomplish = customized output, alternative output formats, specialized preview = windows, and transformed rendering, as well as hooking together several = listeners on the same report run. =20 If you can come up with an interesting use of ReportListener, please = email it to me for consideration for publication. The code is the thing. = You should also write a few paragraphs explaining what the code does, = and the code should have some comments in it, but don't worry about = writing perfectly -- I'll take care of grammatical corrections. =20 If your example is chosen for publication, you will receive a small = author's fee or royalty as a reward. If your example is not chosen, you = will have at least learned something by exploring the ReportListener = class and the overall changes to the VFP 9 Reporting System, and you = can, of course, post your sample online at that point. =20 I would love to publish dozens of cool examples that can help educate = the VFP community worldwide about how to leverage VFP 9's extensibility = features in creative ways. We need to build up a knowledge base of = various approaches to jump-start other ideas. =20 Go ahead. Jump in and create your special listener, then email your code = sample to me at "david -AT- topstrategies. COM" (obviously, fix up the = address first). Happy experimenting! =20 David Stevenson=20 Editor, FoxTalk 2.0 www.pinpub.com ------=_NextPart_000_0008_01C45578.E8CB4A90 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> <DIV> <P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><FONT = face=3DArial><FONT=20 size=3D2>Hi all,<?xml:namespace prefix =3D o ns =3D=20 "urn:schemas-microsoft-com:office:office" = /><o:p></o:p></FONT></FONT></P> <P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 style=3D"COLOR: black"><o:p><FONT face=3DArial = size=3D2> </FONT></o:p></SPAN></P> <P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 style=3D"COLOR: black"><FONT face=3DArial><FONT size=3D2>I'm looking for = interesting=20 and innovative ideas for putting the VFP 9.0 ReportListener class to = use, for=20 publication in either FoxTalk 2.0 or in another alternative format. You = might=20 call this a "talent search" or "competition" to see who can come up with = the=20 most outrageously useful subclasses of=20 ReportListener.<o:p></o:p></FONT></FONT></SPAN></P> <P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 style=3D"COLOR: black"><o:p><FONT face=3DArial = size=3D2> </FONT></o:p></SPAN></P> <P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 style=3D"COLOR: black"><FONT face=3DArial><FONT size=3D2>As you probably = know, you can=20 subclass ReportListener (or in some cases just set properties of the = standard=20 ReportListener) to accomplish customized output, alternative output = formats,=20 specialized preview windows, and transformed rendering, as well as = hooking=20 together several listeners on the same report=20 run.<o:p></o:p></FONT></FONT></SPAN></P> <P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 style=3D"COLOR: black"><o:p><FONT face=3DArial = size=3D2> </FONT></o:p></SPAN></P> <P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 style=3D"COLOR: black"><FONT face=3DArial><FONT size=3D2>If you can come = up with an=20 interesting use of ReportListener, please email it to me for = consideration for=20 publication. The code is the thing. You should also write a few = paragraphs=20 explaining what the code does, and the code should have some comments in = it, but=20 don't worry about writing perfectly -- I'll take care of grammatical=20 corrections.<o:p></o:p></FONT></FONT></SPAN></P> <P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 style=3D"COLOR: black"><o:p><FONT face=3DArial = size=3D2> </FONT></o:p></SPAN></P> <P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 style=3D"COLOR: black"><FONT face=3DArial><FONT size=3D2>If your example = is chosen for=20 publication, you will receive a small author's fee or royalty as a = reward. If=20 your example is not chosen, you will have at least learned something by=20 exploring the ReportListener class and the overall changes to the VFP 9=20 Reporting System, and you can, of course, post your sample online at = that=20 point.<o:p></o:p></FONT></FONT></SPAN></P> <P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 style=3D"COLOR: black"><o:p><FONT face=3DArial = size=3D2> </FONT></o:p></SPAN></P> <P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 style=3D"COLOR: black"><FONT face=3DArial><FONT size=3D2>I would love to = publish=20 dozens of cool examples that can help educate the VFP community = worldwide about=20 how to leverage VFP 9's extensibility features in creative ways. We need = to=20 build up a knowledge base of various approaches to jump-start other=20 ideas.<o:p></o:p></FONT></FONT></SPAN></P> <P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 style=3D"COLOR: black"><o:p><FONT face=3DArial = size=3D2> </FONT></o:p></SPAN></P> <P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 style=3D"COLOR: black"><FONT face=3DArial><FONT size=3D2>Go ahead. Jump = in and create=20 your special listener, then email your code sample to me at "david -AT-=20 topstrategies. COM" (obviously, fix up the address first). Happy=20 experimenting!<o:p></o:p></FONT></FONT></SPAN></P> <P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 style=3D"COLOR: black"><o:p><FONT face=3DArial = size=3D2> </FONT></o:p></SPAN></P> <P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 style=3D"COLOR: black"><FONT face=3DArial><FONT size=3D2>David Stevenson = <o:p></o:p></FONT></FONT></SPAN></P> <P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 style=3D"COLOR: black"><FONT face=3DArial><FONT size=3D2>Editor, FoxTalk = 2.0<o:p></o:p></FONT></FONT></SPAN></P> <P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 style=3D"COLOR: black"><FONT face=3DArial = size=3D2>www.pinpub.com</FONT></P> <P class=3DMsoPlainText style=3D"MARGIN: 0in 0in 0pt"><o:p><FONT = face=3DArial=20 size=3D2></FONT></o:p></SPAN></P></DIV></BODY></HTML> ------=_NextPart_000_0008_01C45578.E8CB4A90-- Tag: finding string of one table in another Tag: 195838
  - 4
    - VFP 8.0 unstable and unreliable ? Hi I was asked about some weird behaviour of VFP 8.0 executables and IDE. The network is a mixture of Novell 5.x and Windows 2000 Server, Win2k box is running SQL Server 2000, and Novell 5.x holds several .DBFs for a legacy Clipper DOS system still in use and printing services. The workstations are mainly Win98 (several) and Win98SE, mainly with 32MB RAM and slow disks (I guess there is a lot of legacy computers still in use, Pentium II MMX 266 and K6s 300). There are a number of serious problem in the stability of the clients. And the programmer's team experienced some real problems with VFP´s IDE stability, even on Windows XP Pro, suddenly VFP 8.0 crashes and deletes the form o report you were working on until that moment. There are some other glitches at the clients, the mouse pointer frozen, no blue screen but a "Windows 98 must close.." and similar issues, with a lot of problems at the help desk (the whole network compromises about 200+ computers). They are going to switch to Delphi or .NET in these days, that unstability isses upset all the programmer's team and in-house IT crew, they almost do not want to hear about VFP anymore. Can anyone here drop any advise, any idea? Thanks in advance Carlos A. Pérez Tag: finding string of one table in another Tag: 195836
  - 5
    - DLL Scope, etc... I'm writing a wrapper for blat.dll and I've got a couple of questions. In a method I: declare integer send in blat.dll string blatstring What is "send"? type("send") and vartype(send) tell me nothing. What is the scope of send, everywhere in VFP, ie is it kind of public? A language addition? Is there any way to limit the scope of send? Similarly, what's "blatstring"? -Lew Tag: finding string of one table in another Tag: 195834
  - 6
    - RTF Toolbar & Menu I'm writing a shot app that includes the ability to add/edit rtf text via the MS active-x RTF control. Is there a ready-made (eg as in Outlook) formatting menu/toolbar available somewhere? -Lew Tag: finding string of one table in another Tag: 195831
  - 7
    - LB's, arrays, VFP9b vs earlier versions & my memory I haven't been writing any VFP for a few months, but I wasn't able to get a lb to display all the rows in its rowsourcetype=5/rowsource="arrayname" until I began manually to update the numberofelements property to match the number of rows in the array. I don't remember having to do this in earlier versions. Is my memory slipping? -Lew Tag: finding string of one table in another Tag: 195827
  - 8
    - how to get connection count Hi all, How can I get connection count when I connect to SQL vis pass through? I.e. when I issue: nCon = SQLCONNECT('SDSN', 'user', 'pw') I get a (postive) number in nCon. However if I issue this again and again there will several connections numbers. TIA Kamran Tag: finding string of one table in another Tag: 195825
  - 9
    - OLE Automation - Excel I have a program where I create excel spreadsheets from a cursor. Then, I use ole automation to format the spreadsheet. The spreadsheet is being used as a report. However, people who will use this spreadsheet would like the ability to sort the spreadsheet on different columns. How can I programmatically add code to the spreadsheet to give an user the ability to sort on any column by clicking on it. Note: In my spreadsheet, I'm adding a couple of columns and placing in headers. Tag: finding string of one table in another Tag: 195814
  - 10
    - $$ always displays $ not Currency Symbol In my grid I have a column which is bound to a numberic I want my column to display the numberic as currency (although I want to store it as a number) I have set my currency up: set currency to '£' I set my column inputmask propery up to be "$$9,999,999" format is none, but when run it shows a $ i.e. $12,345.67, should this not show £12,345.67 ? I have tried other combinations of format and input mask, none of which give me what I want format $, inputmask 9,999,999, result: "$ 12,345.67" format $, inputmask $$9,999,999, result: "£$12,345.67" format $, inputmask £9,999,999, result: "£ £12,345.67" format <none>, inputmask £9,999,999, result: "£ £12,345.67" format <none>, inputmask $$9,999,999, result: "$12,345.67" format <none>, inputmask $9,999,999, result: "$ 12,345.67" How can I get it to display "£12,345.67" ???? TIA, Fergus. Tag: finding string of one table in another Tag: 195812
  - 11
    - vfp and MSexplorer (no error this time) Hi again, Is there way to override or to bypass the Security issues/restrictions that are stored in MsExplorer itself ? christophe -- \|||/ (o o) ----ooO-(_)-Ooo------------- ¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`° º Tag: finding string of one table in another Tag: 195811
  - 12
    - vfp and MSexplorer ole error Hi, I've made an easy form with just a olecontrol (internet explorer) on it. in the init I've set this.navigate2("http:\\www.irs.be") So far no problems but when running the form I get this error : OLE error code 0x80004005 but it does navigate to the site. So that is not the problem. Anybody an idea ? thanks in advance christophe -- \|||/ (o o) ----ooO-(_)-Ooo------------- ¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`° º Tag: finding string of one table in another Tag: 195795
  - 13
    - Access to dbf from Excel (ODBC problem) Hi, When trying to import a dbf into Excel 2003 (using Data/Import...) I get "Unexpected error from external database driver (8961)." I dl'd and installed the latest vfp odbc drivers and now have version 6.01.8629.01. Yet, when I try to import using the older "DBase Files (*.dbf)" driver I get the same error. The installation of the new vfp driver set up a System DSN called "Visual Foxpro Tables". But that dsn doesn't appear in Excel. I finally realized that instead of Data/Import, File/Open worked fine even though using the older "DBase Files (*.dbf)" driver. But shouldn't Data/Import work as well? How do I get the new driver to show up as a file type in Excel? Thanks, Frank Tag: finding string of one table in another Tag: 195791
  - 14
    - NT4 & VFP 8 I see that it the developer version requires Win2k but in a run-time will NT4 work? Thanks Tag: finding string of one table in another Tag: 195788
  - 15
    - Calling Oracle Stored Procedure Is it possible to call an Oracle stored procedure? I know that I can execute an SQLEXEC statement, but I have additional processing beyond a SQL query. Tag: finding string of one table in another Tag: 195781
  - 16
    - Order entry sample Is there a good Order entry sample out there? I'm a newbee, and trying to make a order entry system. Need desperatly a sample on how to use Parent/Child forms with lookup functions and calculations on forms and reports. Would be nice with a complete simple order entry sample... James Tag: finding string of one table in another Tag: 195773
  - 17
    - vfpro 7.0 Have created two new forms in an application. When the command DO FORM is executed, the forms flash on the screen for a matter of seconds. The WindowType under Properties is set to 2 Read (as it is for all other forms in this application) no other forms have this behaviour. The project has been rebuilt. Am approaching a serious deadline, please help. Tag: finding string of one table in another Tag: 195769
  - 18
    - Cursor....HELP ME!!! I create a cursor with XMLTOCURSOR(), i want to read the records (by SCAN) without the name of field, but with the index of the field. es: MyCursor.FieldName (Wrong way) ----- MyCursor(0) or MyCursor[0] is my way... HELP ME!! Tag: finding string of one table in another Tag: 195763
  - 19
    - Manual or book I started programing with Foxplus for unix in the 80's and I am back with Visual FoxPro Beta version 9! but I am a little bit lost with so many new things and the object programing. Can someone please recommend me a good book of VP9 easy and complete? -- Lorenzo MÃ¡rquez Tag: finding string of one table in another Tag: 195762
  - 20
    - INSERT INTO I create a cursor by XMLTOCURSOR() and I must to read his record because I must to insert into a table on SQL SERVER. I don't know to do this....help me!!! Tag: finding string of one table in another Tag: 195750
  - 21
    - Backspace in a textbox Currently if a user presses backspace in the textbox it moves to the previous textbox. I though Set Confirm handled this but I was wrong. The problem is that users like to hold the backspace button down and then it just deletes every textbox on the form if they hold it too long. I'm thinking FoxPro has something to prevent this but I cannot find it in the documentation. Can someone help me? -- Altman VFP8 SP1 Tag: finding string of one table in another Tag: 195749
  - 22
    - multiselect getfile ? Hi, somebody, somehow ? (instead of making my own one.) thanks christophe -- \|||/ (o o) ----ooO-(_)-Ooo------------- ¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`° º Tag: finding string of one table in another Tag: 195745
  - 23
    - VFP6 rpoject upgrade to VFP8 Hi, I had developed a commercial app in VFP6 a few years back and now I intend to start work on the next release of the software but I intend to developeit in VFP8. I need to know if there are any special concerns about this upgrade, anything I should change so my VFP6 code is run & compiled seamlessly in VFP8 ? Can anyone point me to an online atricle on this issue ? TIA Saeed Tag: finding string of one table in another Tag: 195733
  - 24
    - how to read this memo field? i've table (table2) with a memo containg primary keys of the table table1 the data in the memo will be like this AUVrPkTOrcAx4CIHXFhE AWH87WotZhAuyI67JnCc each 10 char set is a pkey .how can i read this memo 10 char by 10 char to find orphan records? many thanks for ur ideas? cheers -- cheers Tag: finding string of one table in another Tag: 195732
  - 25
    - IE Automation I often use Automation similar to the lines below: oie=createobject('internetexplorer.application') oie.navigate(m.myurl) ** do something here with the web page. I may extract 100s of pages from the web. but: this puts each URL into IE History. How can I clear IE History *USING AUTOMATION* when I'm done.? THANKS Mike Farnesi San Diego Tag: finding string of one table in another Tag: 195718

Hi All,

I have a table:

id1 fld1
----------------
1 hand
2 feet
3 leg

and second table is:

id2 fld2
-----------------
1 I have two hands
2 six feet under
3 last leg of his tour
4 nothing
5 these two go hand in hand

How can I get records of second table THAT CONTAIN text of 'table1.fld1' in
'table2.fld2' by using SQL-SELECT in VPF7. (There should be 4 resultant
records).

TIA

Kamran

Re: finding string of one table in another by Josh

Josh
Tue Jun 22 17:28:41 CDT 2004

not pretty but:
SELECT id2, fld2 from tbl2,tbl1 HAVING ALLTRIM(fld1)$fld2

On Tue, 22 Jun 2004 17:42:01 -0400, "Kamran" <k-a-q@bigmailbox.net> wrote:

>Hi All,
>
>I have a table:
>
>id1 fld1
>----------------
>1 hand
>2 feet
>3 leg
>
>and second table is:
>
>id2 fld2
>-----------------
>1 I have two hands
>2 six feet under
>3 last leg of his tour
>4 nothing
>5 these two go hand in hand
>
>
>How can I get records of second table THAT CONTAIN text of 'table1.fld1' in
>'table2.fld2' by using SQL-SELECT in VPF7. (There should be 4 resultant
>records).
>
>TIA
>
>Kamran
>

---
Remove x's to send.

Re: finding string of one table in another by Anders

Anders
Wed Jun 23 05:09:31 CDT 2004

SELECT * FROM Table1 JOIN Table2 ON Table2.phrase LIKE
'%'+TRIM(Table1.keyword)+'%'

-Anders

"Kamran" <k-a-q@bigmailbox.net> wrote in message
news:eW#YaIKWEHA.1128@TK2MSFTNGP10.phx.gbl...
> Hi All,
>
> I have a table:
>
> id1 fld1
> ----------------
> 1 hand
> 2 feet
> 3 leg
>
> and second table is:
>
> id2 fld2
> -----------------
> 1 I have two hands
> 2 six feet under
> 3 last leg of his tour
> 4 nothing
> 5 these two go hand in hand
>
>
> How can I get records of second table THAT CONTAIN text of 'table1.fld1'
in
> 'table2.fld2' by using SQL-SELECT in VPF7. (There should be 4 resultant
> records).
>
> TIA
>
> Kamran
>
>