Input field name (VFP9)

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
    - FoxPro and MySQL field size does not match Hi everybody, I am connecting via ODBC and sqlstringconnect to a MySQL server. Let's assum I have a numeric field named my_id with length 3 defined in the MySQL table "test_table". After connecting and doing a SQLExec "select my_id from test_table" the resulting FoxPro table will have a field length of 11 for the field my_id. That causes problems when displaying the no in a combo box. What's wrong here? Thanks for your help Andi Tag: Input field name (VFP9) Tag: 224067
  - 2
    - Local view and buffered table Hi all, Can I get data in local view from buffered table? In sample SELECT I can use WITH (BUFFERING=.T.), but I don't find way use something similiar with local views. Meskis Tag: Input field name (VFP9) Tag: 224048
  - 3
    - Test a SQLSTRINGCONNECT() connection handle This is a multi-part message in MIME format. ------=_NextPart_000_005F_01C6856E.9336B290 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, I create a Shared Connection Handle to MySQL using SQLSTRINGCONNECT()and = saved in a _SCREEN property, so far so good, in other parts of the = application I would like to test if this Handle is still a valid one, I = could not find a function that will allow me to do just that, then here = is the question: =20 What would be the way to test if my _SCREEN property for the = connection handle is still a valid one? Thanks! --=20 Edhy Rijo www.progytech.com Bronx NY ------=_NextPart_000_005F_01C6856E.9336B290 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.2900.2873" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi all,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I create a Shared Connection Handle to=20 MySQL using <FONT face=3D"Courier New" color=3D#0000ff=20 size=3D2>SQLSTRINGCONNECT</FONT><FONT face=3D"Courier New"=20 size=3D2>()</FONT></FONT><FONT face=3DArial size=3D2>and saved in a = _SCREEN property,=20 so far so good, in other parts of the application I would = like to=20 test if this Handle is still a valid one, I could not find a function = that will=20 allow me to do just that, then here is the question:  </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>    What would be the = way to test if=20 my _SCREEN property for the connection handle is still a valid = one?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks!</DIV> <DIV><BR>-- <BR>Edhy Rijo<BR><A=20 href=3D"http://www.progytech.com">www.progytech.com</A><BR>Bronx = NY</DIV> <DIV> </DIV> <DIV></FONT> </DIV></BODY></HTML> ------=_NextPart_000_005F_01C6856E.9336B290-- Tag: Input field name (VFP9) Tag: 224046
  - 4
    - Foxpro to VFP6 I have a number of source code applications in Foxpro 1. I purchased VFP6 when it was then offered, but I have not yet updated my old applications. A few questions: 1 - Does VFP6 have a separate runtime for inclusion with client applications? 2 - Should I update to VFP9, or would my current 6 be easier for me to re-code, since my programming skills still are back there with Foxpro 1? Thanks in advance. Tag: Input field name (VFP9) Tag: 224039
  - 5
    - time function Hi all, What is the best way to define a field in a table to contain Time? should it be a character or datetime? also, once it is defined in a table, how is best to utilize that field in a form? like what input mask should it have and how do you stop the user from entering an invalid time? Is there a control (or does anyone have one?) that could be dropped on a form that is already validated as a time field? Thanks HME -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com Tag: Input field name (VFP9) Tag: 224033
  - 6
    - finding procedures in a procedure file I came across some odd behavior today, and would appreciate feedback on this. To demonstrate the issue, create two files: File 1: zoot.prg Procedure zoot =zoot1() set procedure to =zoot1a() return File 2: zoot1.prg PROCEDURE zoot1 WAIT WIND `ZOOT1' TIME 1 RETURN PROCEDURE ZOOT1A WAIT WIND `ZOOT1A' TIME 1 RETURN Then in the command windows, DO ZOOT. It does the zoot1 wait window as expected. Surprisingly, it also does the zoot1a wait window. Why? I added the SET PROCEDURE TO line to clear any open procedure files, thinking that DOing zoot1 did an implicit SET PROC TO ZOOT1, but it still works. CLEAR PROGRAM stops it from working. Is this an undocumented feature? I was not aware that DOing a PRG file would load make all procedures in the PRG available, even after the top level procedure was exited, and therefore no longer in the call stack. We also discovered that suspending VFP would clear it from memory, as if VFP arbitrarily clears such stuff when it wants to or thinks it needs to. Tag: Input field name (VFP9) Tag: 224031
  - 7
    - Chado spell editor and mailmerge A post elsewhere had me asking about recordsets for use with Chado spell Editor, which now works. However mailmerging with the Chado spell-editor is proving rather troublesome, and whilst their help file is good, it doesn't cover vfp <sigh>. Has anybody done mailmerging with the recent Chado SpellEditor and could they give some pointers as to how to actually merge and print. Many thanks Stephen Tag: Input field name (VFP9) Tag: 224024
  - 8
    - VFP and ADO.NET I'm wondering if anyone has come up with a way yet to load ADO.NET data into a read/write BROWSE window. Thanks ahead for any leads. Tag: Input field name (VFP9) Tag: 224012
  - 9
    - ADO recordset This is a multi-part message in MIME format. ------=_NextPart_000_000E_01C6840F.7BBD7EB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable This is a completely new area for me. I am looking at the Chado spell = editor, which now has mailmerge - great! However the reply to a query to = Chado states: Unfortunately, you have to use an ADO recordset in order to have = mailmerge work properly. What I have got in my application is a temporary cursor called CUSTOMER = from which I want to do the mailmerge. Could somebody handhold me through the commands I need to issue to get = an ADO recordset from this. Many thanks Stephen =20 ------=_NextPart_000_000E_01C6840F.7BBD7EB0 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.2900.2873" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>This is a completely new area for me. I = am looking=20 at the Chado spell editor, which now has mailmerge - great! However the = reply to=20 a query to Chado states:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV>Unfortunately, you have to use an ADO recordset in order to have = mailmerge=20 work properly.<BR></DIV> <DIV><FONT face=3DArial size=3D2>What I have got in my application is=20 a temporary cursor called CUSTOMER from which I want to do the=20 mailmerge.</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>Could somebody handhold me through the = commands I=20 need to issue to get an ADO recordset from this.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Many thanks</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>Stephen</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_000E_01C6840F.7BBD7EB0-- Tag: Input field name (VFP9) Tag: 224005
  - 10
    - Timer/Interval Q. Is there a Interval amount that cuts a timer off? Does 0 cut it off? Respectfully, Jonathan Morningstar ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Tag: Input field name (VFP9) Tag: 224001
  - 11
    - Strange printing with reportBehavior to 90 In VFP 9 SP1, i've an invoice report containing - title - header - group header - 1 detail band - group footer (with new page) - page footer - summary (with new page) When i print it with reportBehavior set to 80, it works fine. (It works for many years !) When i print it with reportBehavior set to 90 - page 1 is correct - page 2 to n-1 have a blank space above (+- 5 cm) and the content seems to be vertically condensed - last page is correct There is no special code in the reportListener. Just created from the base class (VFP ReportListener, not the FCC) Any idea or tool to solve this problem. Thanks in advance, Guy Tag: Input field name (VFP9) Tag: 223998
  - 12
    - Which one is better option ? I am using Visual Foxpro 8.0. In my application i have two panes, on left pane i have product categories and on right pane respective products are being shown. Currently i am using FILTER command to show respective items. But it is getting slow and slow as data is increasing. Right now i have more than 10,000 records in products table and system is not responding quick enough. There is another way to do same job using INDEX command with FOR condition. Before going in any optimization work, i would like to have your expert opinion which option can work better for such kind of requirements. OR any other new suggestion. Thanks in advance. NR Tag: Input field name (VFP9) Tag: 223992
  - 13
    - New VFP multi-threading example posted I've updated the VFP MT example (at http://codegallery.gotdotnet.com/SednaY) based on Calvin's example to be sort of like .NET: Example Use: * t=CREATEOBJECT('testserver.thread') * t.start(5,"do c:\MTmyVFP\MyThreadFunc WITH p2") * && start method params:(1)#threads,(2)VFP code to MT,(3)Silent mode * ?t.check && returns .T. if completed * t=null && cleanup Simple, fast, efficient - it is VFP!! And, yes, it's really multi-threaded... Tag: Input field name (VFP9) Tag: 223991
  - 14
    - Inserting a page in a report - VFP 9.0 Hello, Within a VFP 9.0 report, i would like to insert a blank page between page 1 and 2, if the total number of pages of my report is uneven. Would be perhaps possible with the new reportListener object. But i don't see where to start. Thanks in advance for help, Regards, Guy Tag: Input field name (VFP9) Tag: 223990
  - 15
    - Items color in listbox Is there any way to have different colors for items in listbox (I want to have some items green, some red, some blue) Tag: Input field name (VFP9) Tag: 223987
  - 16
    - Opening Cursor aychee wrote: > *Re the above: > Forgive my stupidity it is the Hand_cursor I get not the wait_cursor > - the latter would be tolerable * Further stupidity (senility?) -I'm in the wrong forum. Trying to delete -- aychee ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: Input field name (VFP9) Tag: 223983
  - 17
    - Can I develop the VFP project in Pocket PC? I need to develop an application which can be run in Pocket PC and Windows Mobile 5.0. I have VFP8 on hand. I want to ask whether I can develop or not? If yes, how to do? Thanks for your help! Tag: Input field name (VFP9) Tag: 223976
  - 18
    - Connecting to remote VFP database using ASP We are having a difficult time connecting to a Visual Foxpro database located on a remote server using ASP. It is a security issue because the web application can connect if the database is located locally on the web server. When we point to the remote database and run the code, the application cannot find the location. We tried everything in the Microsoft KB article located at: http://support.microsoft.com/kb/175801/en-us but nothing seems to help. Our connection is through an ODBC System DSN that uses a UNC path to the remote database. Any advise or help would be appreciated. Tag: Input field name (VFP9) Tag: 223966
  - 19
    - Copying a Database (DBC) Is there a trick to copy a database from one directory to another? I am trying to set up a test area for a system on my computer. I have duplicated the file structure for the drive on which the DBC is located. I have copied the files for the database and the tables in the database. I have used the SUBST command to map part of my drive to the same drive letter as the DBC is expecting. But it doesn't work. The Validate database command shows errors for just about every table in the database. For most files it says: "Table is not in a database." If I use modify database and then click on a table, it says "Cannot resolve backlink." Is there anything I can do short of recreating the whole database from scratch? Kevin Clark Seton Home Study School Tag: Input field name (VFP9) Tag: 223959
  - 20
    - Converting to pdf I use XFRX to convert VFP reports to PDF. I want to append my report to a previously existing pdf file, and I have been told that in order to merge, the original document must NOT be LINEARIZED. Does anybody know how can I generate a non linearized pdf document from Word ? Tag: Input field name (VFP9) Tag: 223947
  - 21
    - hierarchical grid Hi, Can anyone recommend a hierarchical grid control to use with VFP? Preferably one that can bind to an ADO recordset (I assume none will use a VFP view). Thanks. Yours faithfully Paul S. Elliott (Senior Developer) 4technology Ltd P.O. Box 1681 Christchurch New Zealand ph : +64 3 3771170 fax : +64 3 3771172 Tag: Input field name (VFP9) Tag: 223936
  - 22
    - File is not open One of my client is using English version windows XP ,when she run one Invoice form (it will show File is not open) The application is placed in the server, the PC will create a shortcut and run that application . When she run the application in Chinese version windows XP , everyting work fines. I am using visual foxpro 6.0 (English verison) to complie . (All chinese version window XP can run it very well) Does anyone know what's wrong it is ? From Agnes Tag: Input field name (VFP9) Tag: 223931
  - 23
    - VFP6: Getting Lousy Output I have a dot-matrix printer that I use for Q&D output. When I print from DOS programs, it works great and spits out the output quickly. When I print from VFP (or any other Windows app), it insists on making it better quality. This takes several times longer. How do I set the printer driver to give me low-quality (and fast) output? Sincerely, Gene Wirchenko Tag: Input field name (VFP9) Tag: 223930
  - 24
    - Application based authentication Hi, I'm sure I've read about this before somewhere, but may have dreamed it. Is there a way to allow a user to run an app, but give read/write/modify permissions to the app instead of the user. That way the user can access the data but only via the app. I know I can effectively do this locking down with group policy, but I have some very awkward accountants in at the moment. They're all security expert<s> these days. Thanks, Neil Tag: Input field name (VFP9) Tag: 223922
  - 25
    - Foxpro 2.6 Error 1104 Hello Everyone, I've been searching through all of the posts here about error 1104 and can't seem to find a solution that has worked for us. First off, we are not using Terminal Services or Citrix. The apps are being run on each local machine, accessing data files on a Windows 2003 server. The network is mostly gigabit with a few of the machines still using 10/100 cards. So far we have tried the following: - Disabling antivirus on both server and workstation - Disabling all automated backups - Changed from Foxpro 2.5 to Foxpro 2.6 - Set CATMAN = OFF We have an error control program that is currently working around the problem, but it is more of a band-aid as opposed to actually fixing the problem. Whenever the 1104 occurs, the error control program logs it to an error file and then tries again. The second try has worked every time. Lately, the error occurs mostly on the SEEK command, but has occured during the USE, APPE, GO, and SKIP commands in the past. We changed one of the apps so that instead of using a CDX file, it uses an IDX file. We have not had an error with that program since then. We ran a simple disk check on the server and did not find any errors, but we have not had a chance to run a more in depth disk scan due to the number of users that are dependant on using the data. We have checked the cables and NICs, recrimped cable ends, etc and we can't seem to find any problems with any of the hardware, but we haven't ruled it out completely. If anyone has any ideas, we are open to all suggestions. Any and all ideas are welcome. Thanks, Ben Jitima bjitima@gmail.com (304) 525-3293 Tag: Input field name (VFP9) Tag: 223914
- Next
  - 1
    - Linked Server VFP, error OLE DB Hi, SQLExpress on Windows XP SP2, authentification mode Windows I trie to link a Visual FoxPro database with OLEDB provider (yet installed) That query : EXEC master.dbo.sp_addlinkedserver @server = N'MyLinkedServer', @srvproduct=N'Visual FoxPro 9', @provider=N'VFPOLEDB', @datasrc=N'"C:\MyPath\MyDirectory\"', @provstr=N'VFPOLEDB.1' works fine (no error) but that one : select * from MyLinkedServer...MyTable return following error message: Cannot create an instance of OLE DB provider VFPOLEDB for linked server "MyLinkedServer". What's wrong ? Tag: Input field name (VFP9) Tag: 223912
  - 2
    - Cheap OLE DB tool for dbc/dbf access? Any suggestions on available tools (free, cheap, common) which can open VFP8/9 dbc tables and issue DDL statements (alter table stuff...) SQL Queries, execute stored procs etc.... I'd like to have a few options to give to our customers who don't have VFP, and I'd rather not provide an interface myself. Thx. -- William Fields Code Contortionist MCSD - Microsoft Visual FoxPro US Bankruptcy Court Phoenix, AZ ".dll hell - .rpm hell - whatever. The grass is always greener" Tag: Input field name (VFP9) Tag: 223911
  - 3
    - Issues with menus Hi, Running VFP 9.0, trying add a menu to my application. I have created the menu, added three pull down items, File, Reports and Help. In the File menu I put a Close option to exit the application. Here's the setup: Prompt: \<File Result: Submenu Options: Key Label: ALT+F Key Text: ALT+F Container: Left Object: None Pad Name: File Menu Level: File Prompt: \<Close Result: Bar# _mfi_quit Options: Key Label: CTRL+F4 Key Text: CTRL+F4 Skip For: .F. (I tried leaving this blank originally, same result either way.) Resource: _mfi_close (I tried _mfi_exit too, didn't work either.) Also, in the general options for the menu I turned on Top-Level Form. In the Init() of my form I have: DO menus\mainmenu.mpr WITH THIS, .F. (Tried .T. too) Form.ShowWindow = 2 - As Top-Level Form. When I run my application the menu appears like I expected except the Close option is greyed out. I can't seem to find any property settings to adjust this, any ideas? Is this the default state of a menu option and do I have to control that in code somehow at run time? All I'm trying to do at this point is be able to exit the application. The other thing I want to do is include an About item in the Help menu, what's the best way to do this and be able to display the version number of my application, not just the version of VFP? Beyond that I'll want to add some items for reports but I suspect those will be easy once I understand these first issues better. Thanks in advance, Linn Tag: Input field name (VFP9) Tag: 223905
  - 4
    - Opening Cursor My applets irritatingly open with a Wait_Cursor and a tool tip "Click to activate this control", neither of which is part of the applet. To activate the applet eg by clicking on a 'Play' button I have to click twice. The first click just seems to re-position the screen and the second click initiates the applet correctly. Am I doing something wrong or is this a feature of Java? -- aychee ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: Input field name (VFP9) Tag: 223904
  - 5
    - Opening Cursor aychee wrote: > *My applets irritatingly open with a Wait_Cursor and a tool tip > "Click to activate this control", neither of which is part of the > applet. To activate the applet eg by clicking on a 'Play' button I > have to click twice. The first click just seems to re-position the > screen and the second click initiates the applet correctly. > Am I doing something wrong or is this a feature of Java? * Re the above: Forgive my stupidity it is the Hand_cursor I get not the wait_cursor - the latter would be tolerable -- aychee ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: Input field name (VFP9) Tag: 223903
  - 6
    - Image control replacement I'm looking for an ole replacement for the image control. I need to have at least as much image quality as the windows thumbnails view and, hopefully, more functionality. The image control (VFP9)'s resolution is terrible, imo. Inexpensive and/or public domain would be a great help, too. Recommendations? -Lew Tag: Input field name (VFP9) Tag: 223875
  - 7
    - Just an observation In some of the Microsoft magazine adds you see a guy at a desk and just behind him a bookcase. The bookcase shows various flavors of development tools in colorful retail boxes. How hard do you think it would be for Microsoft to slip a VFP box into that cabinet with the other tools? Tag: Input field name (VFP9) Tag: 223870
  - 8
    - how to use SafeArrayCreate API in VFP? Hi Does anyone know how to use the SafeArrayCreate API in VFP 8.0? Tham Tag: Input field name (VFP9) Tag: 223867
  - 9
    - Exception Code=C0000005 from upgraded VFP app Hello all. I just upgraded my distributed app from VFP 6.0 SP5 to VFP 7.0 SP1. The upgrade went very smoothly. I did a clean install on a users computer and all is well. I then installed it over the top of the old program and got the C5 error. Any idea what files were not properly replaced with new ones. I recompiled all my classes and project files so I don't know where to look next. Thanks for the assistance. Cory Bonalllo Retail Service Developer Tag: Input field name (VFP9) Tag: 223854
  - 10
    - No Disk in Drive Error All, My application is VFP8 and installs via Installshield VFP limited edition. Just recently when users install the application they have been getting the following error: programname.exe No disk in drive. Insert disk in drive E Cancel Tryagain Continue I thought it may have been because a CD was in my CD drive when I built the application (exe). I have built the exe again with nothing in my disk drive and distributed it but the error still comes up. Of note: My project is on my E: drive but has been their for years and years and I have never seen this before but it makes me think it may be related. One client has three Windows XP Home edition comptuers and this only does this one one of them.....Does anyone have any ideas of what to look for? Best Regards, Brian Hiatt Collectopro Software Group Inc. Tag: Input field name (VFP9) Tag: 223851
  - 11
    - preventing file display on status bar Hi; I thought I saw this post a while ago but can't seem to find it. Under VFP8, Is there a way to have the status bar on (I like to display the clock and ins/del) but not display the currently open file? Any help appreciated. TIA. Mike Tag: Input field name (VFP9) Tag: 223850
  - 12
    - Reading user name Hi, I'm running VFP 9.0 and I've built my installation program using Instalshield Express 5.0 and it works fine. But I'm wondering, when I install the application it prompts for User Name and Company Name, is it possible to retrieve that information from within my program? Not during the installation but during normal application use. I tried sys(0) but that returns the logged in user if I'm not mistaken. Now that I think about it, the logged in user name would probably be a better way to go but I'm still curious about the answer to my original question. Thanks in advance, Linn Tag: Input field name (VFP9) Tag: 223848
  - 13
    - Strtran() not working with special characters I am using VFP9, SP1. Some text fields in a table have CTRL characters embedded at the end of the field preceded by spaces. This renders the alltrim() function useless when used prior to output. When pasted into a text file and viewed in binary they are =chr(2). I need to remove them. The at() function, however fails to detect them. When I use the following code (field=applics1): x=alltrim(applics1) x=STRTRAN(x,CHR(2),'') replace applics1 WITH ALLTRIM(x) strtran also does not detect chr(2) and the string remains unchanged. I have a workaround(kluge!) that senses the next last charater after alltrim() is used. Tag: Input field name (VFP9) Tag: 223837
  - 14
    - Graphing in VFP? Help? Example in post... Ok, I've visited this page:http://support.microsoft.com/default.aspx?scid=kb;EN-US;129533 And see this code: #DEFINE cr CHR(13) #DEFINE tab CHR(9) USE datafile IN 1 USE grphfile IN 2 SELECT datafile cGraphString = "" * Build tab-delimited string of field names: FOR iCounter = 1 TO 5 cGraphString = cGraphString + FIELDS(iCounter) ; + IIF(iCounter < 5,tab,cr) ENDFOR * Concatenate the data, converting numeric fields to character: SCAN FOR iCounter = 1 TO 5 cGraphString = cGraphString + IIF(TYPE(Fields(iCounter))='C',; EVALUATE(FIELDS(iCounter)) ; ,str(EVALUATE(FIELDS(iCounter)),16,2); ); + IIF(iCounter < 5,tab,cr) ENDFOR ENDSCAN SELECT grphfile APPEND GENERAL mgraph DATA cGraphString ----------------------------------------------------------------- I tried to set up both datafile and grphfile, and then run the program. I get nothing in the GENERAL field that is in grphfile. Just a lowercase "gen". In datafile, I have five fields, first is a character field with values in, the next four are integer fields, with values there as well. There are five records total in the table. What am I doing wrong? What should I see in the GENERAL field, the actual graph? A data string that will be used in some way to actually display the graph? Really confused on this. Right now, I'm using FP to generate a text file, that then is used by Excel to actually create the graphs I need. I'd really like to be able to generate them completely in VFP. Thanks! Shawn Tag: Input field name (VFP9) Tag: 223830
  - 15
    - width of a form I need to create a long thin form (to act as a pseudo-sidebar). It seems that the minimum width is 115. Is this correct or can it be over-ridden? Many thanks Stephen Tag: Input field name (VFP9) Tag: 223826
  - 16
    - Minimum width of form This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C67DD2.6F505E60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I need to place a long thin form down the left side of the screen - a = pseudo sidebar containing buttons to fire the favourite options. The = minimum width I can achieve for a form is 115. Is there any way around = this? Many thanks Stephen ------=_NextPart_000_0006_01C67DD2.6F505E60 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.2900.2873" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I need to place a long thin form down = the left side=20 of the screen - a pseudo sidebar containing buttons to fire the = favourite=20 options. The minimum width I can achieve for a form is 115. Is there any = way=20 around this?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Many thanks</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Stephen</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0006_01C67DD2.6F505E60-- Tag: Input field name (VFP9) Tag: 223819
  - 17
    - Eliminating orphans in grouped data Using VFP9 I have a report with grouped data. There can be anywhere from 1 to 21 detail lines. Is there any way to eliminate orphans short of insisting on at least 21 times the detail band height + group header height before starting a new group? This solution will skip to a new page much more often than is necessary. What I'd like to say is "start a new page if and only if there isn't enough room on this page to complete the group". Dave Tiffany Tag: Input field name (VFP9) Tag: 223818
  - 18
    - combobox automatically dropdown in grid Hi, I've got a comboxbox in a grid; the column's sparse property is set to .f. I want the combobox to dropdown for the active cell as soon as the cell receives the focus. How do i do this? Thanks in advance. Greg Tag: Input field name (VFP9) Tag: 223815
  - 19
    - Create multiple threads from VFP Create multiple threads from within your application by Calvin Hsia http://blogs.msdn.com/calvin_hsia/archive/2006/05/16/599108.aspx I've been playing with the code and I really think it's a start to giving VFP GUI apps MT capability at least the equivalent of VB6 which has some basic MT capability and is similar to VFP as far as Apartment multi-threading. Calvin's example actually blocks on the main thread so I redid it somewhat to avoid that and replaced some commands to make it backward compatible with earlier VFP versions. Not perfect but I think it's a start. This new version can be downloaded at Sedna Y: http://codegallery.gotdotnet.com/SednaY (project is called MTmyVFP)... Claude Fox, SednaY Tag: Input field name (VFP9) Tag: 223809
  - 20
    - Please help me Please help me I m Programmer and working with multinationale company i have a some problem in VFP used time. I m also used Foxpro 2.6 Some Querries 1. Dos Mode Prinitng through report file in VFP (Any one who's knows about method can he give me with example.) 2. Column Size change in VFP in report writer 10*12*1 10*12*3 3. How Can we compress report 220 column to 80 column. Please Help me Regards Titu Tag: Input field name (VFP9) Tag: 223807
  - 21
    - Renaming a field name I don't think this can be done in the following scenario, but then I am sure somebody here has figured it out. I need to rename a user defined field when the table is not in an exclusive mode. In the Customer table I have created some user defined fields with default names (NewField1, NewField2....). I have to allow the user to rename the field Name, Type, Width etc. Cannot open the customer table in Exclusive as there may numerous users hitting it at once. Creating a caption, comments etc on the fly for the field is a no brainier , But for reports etc rather than every time one or two of these fields are need, checking if the caption is blank with empty(field("fname","tablename",1)) will be a major PIA and a nightmare for support. Any and all suggestions will be greatly appreciated. Mohammed www.imaginecorp.com/whatwedo.htm Tag: Input field name (VFP9) Tag: 223802
  - 22
    - show tips property I have a form with buttons on it which contain tool tips. The form itself has SHOW TIPS set to TRUE. For some reason, in the program where this form is used, the tips will not show. When I use the same form in another program, the tips show perfectly. The command I am using is: DO FORM myform READ EVENTS What could possibly cause the tips to not display? I don't think the problem is with the form, because it works correctly when in placed in other programs. --Elliott Tag: Input field name (VFP9) Tag: 223797
  - 23
    - program location I am building a standalone ap with vfp9. I want the exe to find a set of free tables in the directory where it is run from. I know I can hard code a set of tables into the project. The exe finds them from where ever it is run. But that file set won't be where the exe expects to find them after being put in place by a program installer on a user's machine. My thought was that there would be a way for the program to tell itself where it is (like app.path in vb). I have found home() and a set of sys() functions that provide a lot of paths, but, as far as I can tell, none of them will tell the program what directory it was started from. Yes, the program can find the Windows current directory, but that won't necessarily be the same thing. Is there a way to for a vfp exe to find out where it is? Noah Sombrero Tag: Input field name (VFP9) Tag: 223792
  - 24
    - locking bug? I've never run into this before, perhaps because I almost never have a reason to issue an explicit lock. (This is VFP8.) * Process 1: USE mytable ALIAS mytable1 SELECT 0 USE mytable AGAIN ALIAS mytable2 FLOCK() * Process 2 (another FP instance, perhaps on a separate computer): * Open mytable, attempt an edit. If SET REPROCESS is AUTOMATIC, it just sits there waiting for a lock. * Process 1 again: USE IN mytable2 * At this point, Process 2 should be able to continue with its edit, but it does not, not until Process 1 also unlocks mytable1. Even worse, Process 2 sometimes becomes unresponsive. Any comments? Tag: Input field name (VFP9) Tag: 223791
  - 25
    - Language Support I have a customer from Greece that is interested in my software. Do I have to re-write everything in Greek or does Microsoft have some sort of Language Support Files that will translate the software for the end user. Any help is greatly appreciated. Thanks Nick Tag: Input field name (VFP9) Tag: 223788

I need to let the user suggest a field name for a free table. I use
chrtran(cInputval, cCrapCharacters, "") to remove illegal characters. I feel
that this way of doing it is a bit "home made". Is there any other good way
to do it?

Re: Input field name (VFP9) by Cindy

Cindy
Fri Jun 02 12:27:28 CDT 2006

Hi Krister,

I don't know why you think it's "home made," - ChrTran() was designed to
remove unwanted characters, which is what you're doing.

--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@cindywinegarden.com

"Krister" <nospam@nospam.com> wrote in message
news:r6Ufg.3292$E02.763@newsb.telia.net...
>I need to let the user suggest a field name for a free table. I use
>chrtran(cInputval, cCrapCharacters, "") to remove illegal characters. I
>feel that this way of doing it is a bit "home made". Is there any other
>good way to do it?
>

Re: Input field name (VFP9) by Krister

Krister
Sat Jun 03 09:07:44 CDT 2006

Thanks for your reply, Cindy. What I had in mind was that there might be
some format or filter to apply to a textbox and that I just had not found
it...
/Krister

"Cindy Winegarden" <cindy@cindywinegarden.com> wrote in message
news:%232B2lqmhGHA.988@TK2MSFTNGP03.phx.gbl...
> Hi Krister,
>
> I don't know why you think it's "home made," - ChrTran() was designed to
> remove unwanted characters, which is what you're doing.
>
> --
> Cindy Winegarden MCSD, Microsoft Most Valuable Professional
> cindy@cindywinegarden.com
>
>
> "Krister" <nospam@nospam.com> wrote in message
> news:r6Ufg.3292$E02.763@newsb.telia.net...
>>I need to let the user suggest a field name for a free table. I use
>>chrtran(cInputval, cCrapCharacters, "") to remove illegal characters. I
>>feel that this way of doing it is a bit "home made". Is there any other
>>good way to do it?
>>
>
>