invisible form

Visual FoxPro General

‹ Visual FoxPro
- Archive
  - IE
  - Architecture
  - VB
  - SharePoint
  - Dotnet
  - Visual C#
  - VS Express
  - Office
  - Smart Device
  - VS 2008
  - Windows Vista
  - Game
  - Windows Live
  - ISV
  - SQL Server
  - VFP
  - Visual Studio
  - VC++
  - Windows Forms

- Previous
  - 1
    - Merge 2 text file if u know the layout of destination.txt, you can create a blank structrue and say use destination appe from desitnation.txt sdf or u can open destination.txt in excel and save it as dbf. then u can match product and destination to get a 3rd file i.e. sele a.productid,a.description,a.productgroup,b.destination from product a,destination b where a.productid = b.productid into dbf prddest.dbf your prddest.dbf will have all product codes with destination,description and group Tag: invisible form
  - 2
    - fast / draft mode printing in vfp Telling someone to embed printing control in a report is VERY BAD ADVICE. Removing those same embedded controls is one of the most frequently asked questions. This setting is best made in the Windows Control panel for the installed printer (assuming the printer driver supports draft printing), where it will not affect reports that sometimes need to be sent to other printers. It's nothing to do with VFP at all. Control printers through the printers control panel. Tag: invisible form
  - 3
    - How to Filter Records in a Grid I've become a big fun of Cursor Adapter lately, so I would probably use Cursor Adapter here as well. Anyway, let's try to work out textbox and SET KEY idea. In the textbox interactive change try: lcKey = alltrim(this.value) ** Assuming the table is ordered by Customer and it is the current alias SET KEY TO m.lcKey && This should filter all records matching the entered value ************************************************************************************************************************ If this would not exactly work as you want, you may construct lcKeyMin, lcKeyMax and use the second version of SET KEY command. Check details in the help. Let me know, if you would be able to make this idea work. Other ideas would be using local parameterized view. Tag: invisible form
  - 4
    - OLEDragDrop errors Thanks Naomi and DNI. I have fixed the problem and it turns out that it was not anything to do with the OLEDragDrop method - it was simply that I was referring to a property which did not exist. However, I would not have discovered this if I hadn't been trying to re-work the code so that I could provide a comprehensible example as requested by Naomi. I'm still baffled as to why the error crashes VFP rather than simply producing a 'property does not exist' error, but it is all working fine now in any case. Tag: invisible form
  - 5
    - descending order in grid What can i do if my index is desceding order in Gid Column. It will automatically descending order in column 1 For example in grid column1 i have 02/02/06 but if i will add 02/02/07 it will automatically go to the top row. Please help. Thanks Tag: invisible form
  - 6
    - ADO and NULL in VFP tables When I use the AddNew() method of a recordset the new record has all the fields set to .NULL. Unfortunately the tables I am accessing do not allow NULL values in the fields. Can you tell me please is there a simple way to change this behaviour of the recordset so that the fields are set to empty values instead such as "", 0, {} etc Otherwise I am guessing that I would have to write a routine of my own that changes any null values that haven't been set by the client. At the moment when I call the Update() method of the recordsetit throws a pretty general exception saying something went wrong. I am guessing that it is because of the NULLs. As a bit of background I am trying to use ADO to access VFP native tables so that I can easily use the recordsets as business entities that can be passed between my classes without having to specify dozens of parameters in the method calls. I am hoping to also pass these business entities between my COM server and the calling client application. Regards Darren Tag: invisible form
  - 7
    - GENDBC and Filters Hi Andy, In my Primary Keys (PK) I'm used to add a filter clause "NOT DELETED()". When I run GENDBC on my Database that has some filters on some PKs, I get the warning: "Filters no PRIMARY keys are not supported at this time. A comment will be added to your output file specifying the filters" I see that the latest GENDBC file was created in 1997, and it generates a commented line: ****** These filters need to be added manually ****** * Table Name: TESTE1 * Primary Key: ID * Filter Expression: .NOT.DELETED() **************************************************** I'd like to know if someone has modified the GENDBC program in order to generate the tables with the correct filter expressions. Thanks in advance Cesar Tag: invisible form
  - 8
    - Outlook contact details Here's a program from my book on automating Outlook. This reads some of the information for each contact and puts each into a new record: * MakeContactList.PRG * c 2000, Tamar E. Granor and Della Martin * From: Microsoft Office Automation with Visual FoxPro * Hentzenwerke Publishing. www.hentzenwerke.com * Read Outlook contact information into a cursor #DEFINE olContacts 10 #DEFINE olNone 0 #DEFINE olHome 1 #DEFINE olBusiness 2 #DEFINE olOther 3 LOCAL oNameSpace, oContacts, oContact LOCAL cFirst, cLast, cAddr, cPhone IF VarType(oOutlook) <> "O" * Start or connect to Outlook * Make it public for demonstration purposes. RELEASE oOutlook PUBLIC oOutlook oOutlook = CreateObject("Outlook.Application") ENDIF oNameSpace = oOutlook.GetNameSpace("MAPI") * Get Contacts folder oContacts= oNameSpace.GetDefaultFolder( olContacts ) * Create a cursor to hold contact information CREATE CURSOR ContactInfo ; (cFirstName C(15), cLastName C(20), mAddress M, cPhoneNum C(30)) * Go through contacts FOR EACH oContact IN oContacts.Items WITH oContact cFirst = .FirstName cLast = .LastName cPhone = .PrimaryTelephoneNumber * Choose the right address. If the primary phone number is empty, * pick up the phone number associated with this address. DO CASE CASE .SelectedMailingAddress = olHome cAddr = .HomeAddress IF EMPTY(cPhone) cPhone = .HomeTelephoneNumber ENDIF CASE .SelectedMailingAddress = olBusiness cAddr = .BusinessAddress IF EMPTY(cPhone) cPhone = .BusinessTelephoneNumber ENDIF CASE .SelectedMailingAddress = olOther cAddr = .OtherAddress IF EMPTY(cPhone) cPhone = .OtherTelephoneNumber ENDIF CASE .SelectedMailingAddress = olNone cAddr = "" ENDCASE INSERT INTO ContactInfo VALUES (cFirst, cLast, cAddr, cPhone) ENDWITH ENDFOR * Show the results BROWSE RETURN Tag: invisible form
  - 9
    - VFP9 freeze at startup with a superimposed image of a folder title....!!! If you have access to menu>Tools>Options you may restore defaults. You may also run setup.exe with option repair (you may need original cd) from: C:\Program Files\Microsoft Visual FoxPro 9\Visual FoxPro 9.0 Professional - English Tag: invisible form
  - 10
    - vFox9 vs PHP+SQL... Hi Mr Claude, Thanks for the answer.... so PHP kind of slow.... If someone ask what would be the 10 best Business Application Developer Tools... (including VFOX9).... would you be please to answer and Why COBOL not around us anymore... even It is, at first to be design for building business application (But VisualBasic still be use in most window application....) Thanks again! Tag: invisible form
  - 11
    - arabic Fox Me Up wrote: i would like to write in russian but when ever i try to put something in a text box i see " " Fox Me Up: Please do not hijack someone elses thread with a different question. His problem is Arabic adnd Right-to-Left issues. If you want to ask about Russian fonts (like " ER Bukinist 1251") and how to work with Russian in VFP you should start a new thread. Make sure you have Windows settings and fonts set to Russian. In VFP, add CODEPAGE=1251 to config.fpw Tag: invisible form
  - 12
    - Export to Excel with multi-language Hi, guys I'm fixing some multi-language function for our application software, we use FoxPro 9.0 and SQL server. For now, I can successfuly extract data from SQL, display it in FoxPro Form (using OLE object); or import data from Excel, then save it into SQL server (thanks to Rick Strahl , http://www.west-wind.com/presentations/foxunicode/foxunicode.asp ). But then, I stuck. When I try to extract data from SQL, then export them to Excel, I always get a lot of strange mark instead of my Chinese, Japanese or Arabic data shown in SQL server. I've try to STRCONV() data to Unicode or UTF-8, it just not work. Following are how I convert data in FoxPro: ** when extract data out of SQL server, convert data into VarBinary first SQLEXEC (nConn,"SELECT CAST(CAST(p_wname as nVarChar(4000)) AS VarBinary(8000)) AS p_wname FROM program ","temp") **convert data into UTF-8 SELECT CAST ( STRCONV (p_wname,10) AS M) p_wname FROM temp INTO CURSOR TFData ** After above steps, I can show multi-language data in form normally ** And if I want to save the data back to SQL, I need to .... ** Coonvert data back to Unicode then to VarBinary SELECT CREATEBINARY ( STRCONV (p_wname,12)) AS p_wname FROM temp INTO CURSOR TFData1 ** then Convert data into nVarChar SQLEXEC (nConn, " INSERT INTO program (p_wname) VALUES (CAST( TFData1.p_wname as nVarChar(50)))") So how can I show data normally when exporting to Excel Thanks a lot. Tag: invisible form
  - 13
    - Creating Audio Hello, I am not technically talented in any way. I am a writer and a painter. I often cruise this forum to try to learn things from you folks. I sometimes have a hard time getting around the niche language but I am very good at researching some of the terms you use. I told you all that so you would take it easy on me if you answer this question. I would like to be able to dictate material to be typed up and edited later. It would save me an amazing amount of time as well as make it easier for me to record ideas. Except for writing programs, (talking text not programming) my system is pretty basic. Windows XP w/media player. Can anyone tell me if this is possible and how I could accomplish it Thank you for your help. Tag: invisible form
  - 14
    - Validations on Textbox I believe in your case you're looking for EMPTY() function which correctly works for every data type. In other words: if empty(thisform.myTextbox.value) =messagebox(...) endif Tag: invisible form
  - 15
    - How to create a calendar in report? Thank you both for your reply. I feel scan ....replace.....scan will do. But what about the first issue Can I NOT put all the heading in the group head band Tag: invisible form
  - 16
    - Object assisted report in dot matrix printers I encountered a problem using object assisted reporting. Preview works fine but when I tried printing it in dot matrix printers like Epson FX-890 or Epson LQ-2170, it printed smaller fonts and the whole letter size paper was only printed 3/4 of its size, what could be the problem To further determine the cause of the problem, I tried printing it using report behavior 80 and it came out fine, thus report behavior 90 is to be attributed as the problem for these printers. Please enlighten me on why this is happening. Thanks. Tag: invisible form
- Next
  - 1
    - how do i disable the windows logo key? i did not use any user rights, it's just if you use my workstation it was controlled at the server.. only recently that someone got a way to use without permission...thanks Tag: invisible form
  - 2
    - Problem with Browser activex control You can take a reference to the HTML form: oFrm = This.Object.Document.myForm Then refer to the form's objects: If oFrm.elements.Length > 0 For Each oElem In oFrm.elements oElem.Name EndFor EndIf HTH Tag: invisible form
  - 3
    - How to keep VFP standard toolbar up all the time? I tried WVISIBLE("Standard") in command winmdow in vfp 6 and if vfp 9 and is working fine. In 6 I receive .F. Tag: invisible form
  - 4
    - Microsoft is going open-source the core portions of the Visual FoxPro DBMS! If you consider the VFP core going into .Net, then it will be free in the Express versions. Tag: invisible form
  - 5
    - why does Read Events release Main window I thought I figured it out. I put the following into the Formset.Load public main main=THISFORMSET and now i can use main to refer to the formset. thanks a lot! Tag: invisible form
  - 6
    - Validations The code seems to be correct, I don't understand what are doing return .f., you may try just return. You may put it in valid method. Tag: invisible form
  - 7
    - VFP7 crashes with "Fatal error: Exception code=C0000005" during data import from Excel I always start with deleting the Fox resource files when I occasionally get a C5 error. (foxuser.*) If that doesn't solve it, read on. Obviously, you feel you must use a CURSOR. Just for testing purposes to rule in or out the use of a table, try doing the same task, except create a temporary free table instead of the cursor and see whether that makes a difference. Sometimes a workaround, especially in older versions of VFP, is the only way to go. CREATE TABLE (SYS(2023)+"\Main") FREE ..... Tag: invisible form
  - 8
    - stupid (?!?) function Scan While ( Recno ()+ 1 < Reccount ()) And stop != 1 If Atc (m.var1,def)> 0 Thisform .list2. AddItem (cuv) Endif Endscan Tag: invisible form
  - 9
    - Foxpro Power! It's very powerful. It just shouldn't ever be confused with a server-based back-end database engine. Top Reasons Why Our Clients Should Use Vfp Apps http://fox.wikis.com/wc.dll Wiki~TopReasonsWhyOurClientsShouldUseVfpApps~VFP Tag: invisible form
  - 10
    - Proper practice - using class properties in forms/reports. Tamar, Naomi; So if I'm running a report limited by range of date, my call would be something like this report form myform for trdate >= thisform.container.txtFromDate.value .AND. trdate <= thisform.container.txtToDate.value Or do I call the sugested 'getrange' method of the container Can you give me some detail re this method Thanks. Tag: invisible form
  - 11
    - Side effects of leaving SET STEP ON in code Actually, The results we like is that SET STEP ON does not cause the program to stop in the runtime environment. If it is accidentally left in the code, the program does not crash after being deployed. Tag: invisible form
  - 12
    - Record Pointer Position i am already doing like this. The code is written on form Init event. When i run the form the pointer is on first record and according to code the button move first and next shoudl be disabled but they are not. Tag: invisible form
  - 13
    - Foxpro version compatibility I have many applications written in Visual Foxpro 6.0. I probably should upgrade to Version 9.0. My major concern is whether my old applications will run in Version 9. Can someone advise me Will I have problems How major Thanks. Tag: invisible form
  - 14
    - FoxPro Source Code Analysis VFP 8 and later have the Code References tool that let you search an entire project for a string, so you can see everywhere something is used. Tamar Tag: invisible form
  - 15
    - Errors running FoxPro Stored procedures in .NET windows app VFPOLEDB drivers are not for VFP7/9 specifically, it's for any foxpro version. It just gets updated as all drivers do. First download the latest driver from MS VFP site downloads and install that one. OTOH what you can use in a stored procedure is version dependant. ie: VFP7 doesn't know what SetResultSet() function is. I don't understand what do you mean by "I am calling this procedure from VFP7. Is this even possible...". If it weren't possible VFP wouldn't even have something called stored procedure, no Reread my previous post carefully. At this point I think that you are not calling a stored procedure but you think you do. From your OleDbCommand.CommandText there can be no such stored procedure call, in VFP, SQL server, Oracle or whatever. It is wrong, see OleDbCommand help on MSDN. Second, I repeat it's a little suspicious you do it on SelectCommand and yet say it's creating for tables (and of course I repeat again, it's not wise to create tables over and over again in a dbc be it once a month or once a year - if that is for reporting, use a resultset or a view etc, if none helps use free tables. I am not sure your site admin understands the tables in a database. If it were SQL server or Oracle, would he still be creating tables just for reporting each month Really weird approach). You tried my sample, so far so good but did you create the stored procedures If you did, did you debug for the offending code in your stored procedure Show your stored procedure code, so I might have an idea what you did wrong. Tag: invisible form
  - 16
    - Opening VFP tables with Fox2.6 (Dos) 0x03 in header means it's a Foxplus file. 0x30 is for fox2x, VFP tables have 0x31. So I'm not sure what type of conversion you need. Just changing the first byte is not sufficient for conversion. For example fox2x files field header records are followed by a header termination flag (0x0D) followed by data records while VFP tables have an 263 bytes baclink info following the terminator. Use VFP for conversion if you need (copy ... type fox2x). But I'd use data manipulation routines directly from within VFP with some modification if necessary. Tag: invisible form

RavindraPatil

Dear friends,

I use vfp 6. I have a form with 10 fields and a grid. When I run the form. The form is not displayed at all. But it is there. Because after each tab the cursor moves to the next field. I can see only blinking cursor and neither form nor the fields.

please help

Re: invisible form

dni

You may check in properties for form:

Visible = .T.

BackColor =212,208,200 (or as you prefer)

Enabled = .T.

WindowsType = Modal (may be)

You may check the "fields" to be Visible = .T.

Re: invisible form

Alex Feldstein

Depending on how you created/instantiated the form, this may not be visible.

Take a reference to the form (from within it would be THISFORM), then do a ThisForm.Show()

See:

http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/d2b4b0e3-f3d3-456f-82b7-f8a15819e146.asp frame=true

Re: invisible form

Naomi Nosonovsky

Could it be that you put some object (say, shape or container) above the fields Just guessing in addition to excellent advices by dni and Alex.

Re: invisible form

CetinBasoz

Hunt for lockscreen in your code.

Re: invisible form

RavindraPatil

Hello everybody,

thank u for responding to my query.

the problem was with lockscreen property ofthe form which was turned on unknowingly.

thanx