rcathens
vfp9:
When I attempt to open a memo field (double click) while using a browse statement I receive an error message:
Program with error: App_Application .TMRREFRESH.ERROR
Error number: 1734
Line of Code with error : IF TYPE(¡°loForm.Parent¡±)= ¡°O¡± and INLIST(loForm.Parent.WindowType,WindowType_modal,Windowtype_readmodal)
I know it's not the best thing to execute a browse statement from within a program; I have attempted to use the field on a grid and the same thing happens. I found that Error #1734 means "property not found" but that doesn't help me much.
When I am in design mode it works fine, it is only when I run it as an application either as a app. or exe.. Interestingly, it does work properly on an old computer which has vfp6 on it
I have renamed the file, and reset the properties of the file containing the memo field to no avail.
Thanks
memo field in browse
Visual FoxPro General
-
- Previous
- 1
- Why my VFP exe file cannot be launched? How do I refresh *.dll files Thanks. Tag: memo field in browse
- 2
- I can't see the content of the last field of the record It is not a VFP table (I'm sure of this) but I never found problems to read its records with VFP, recently the table was updated by the Software House with a new field added that I can't read, when I use BROWSE or any other EDIT command I see the right structure with the field addedd, but the value is every spaces. Do you think I need to use another program to manage this data Tag: memo field in browse
- 3
- replace image with own name thanks for your reply how do i control lc file or use dtos cos i take more than 25 image a day thanks Tag: memo field in browse
- 4
- date problem Hi, I have to append data from an excel file to a fox file. A cell in excel has date data in format : "dd/mm/yyyy" and in fox the table has a character field. When I execute the command, it sometimes appear in the fox table a number that doesn't have any resemblance to the date data. How can I solve this . Thanks, Tag: memo field in browse
- 5
- Close system toolbar of foxpro c y h wrote: I use foxpro 5.0, is there any way to remove the system toolbar by writing a short program I am not Christof, but here goes: LOCAL lnCount, LOCAL ARRAY laToolbars DIMENSION laToolBars[ 11, 2 ] *** Initialize array property with VFP system toolbars *** and a flag to indicate whether or not they are visible laToolbars [ 1, 1 ] = 'Form Designer' laToolbars [ 2, 1 ] = 'Standard' laToolbars [ 3, 1 ] = 'Layout' laToolbars [ 4, 1 ] = 'Query Designer' laToolbars [ 5, 1 ] = 'View Designer' laToolbars [ 6, 1 ] = 'Color Designer' laToolbars [ 7, 1 ] = 'Form Designer' laToolbars [ 8, 1 ] = 'Database Designer' laToolbars [ 9, 1 ] = 'Report Designer' laToolbars [ 10, 1 ] = 'Report Controls' laToolbars [ 11, 1 ] = 'Print Preview' FOR lnCount = 1 TO ALEN ( l aToolbars , 1 ) laToolBars [ lnCount, 2 ] = WVISIBLE ( l aToolbars [ lnCount, 1 ] ) IF WVISIBLE ( l aToolbars [ lnCount, 1 ] ) HIDE WINDOW ( l aToolbars [ lnCount, 1 ] ) ENDIF ENDFOR Tag: memo field in browse
- 6
- SQLServer's scope_identity() and VFP's remote views Hi, I'm using VFP9 and I use remote views that back into SQLServer 2000. What I'd like to be able to do is use SQLServer's scope_identity() function to return the identity value generated upon inserting (and performing a tableupdate()) a new record into an updatable remote view that backs into a SQLServer table with an identity field as its primary key. The problem I'm having is that scope_identity() returns null in this situation. eg. insert into my_remote_view (field1) values ("blah") tableupdate(0, .T., "my_remote_view") Sqlexec(Cursorgetprop("ConnectHandle", "my_remote_view"), "select scope_identity() as LastIdentity", "ScopeIdentity") ScopeIdentity.LastIdentity && this prints null If I use sql pass-through (sqlexec()) to insert the record then there is no problem, scope_identity() returns the identity value as expected. If I use @@Identity instead of scope_identity() then an identity value is returned, but since @@Identity is not 100% reliable this is of marginal benefit. It seems like a remote view's update action has its own scope that ends once the update is committed, while its session persists - hence @@Identity works and scope_identity() does not. I suppose I could try using a cursoradapter and alter the UpdateCmd property to include code to use scope_identity(), but I don't really want to go down this route since I'm working on a large application that makes extensive use of remote views and only peripheral use of cursoradapters. Has anyone found a way to use scope_identity() with a remote view Thanks in advance. Paul S. Elliott Tag: memo field in browse
- 7
- SQL Server Express & Foxpro-populating SS from Foxpro This is my first foray into SQL Server and I'm trying to do a small test run before expanding my code. Thanks for your patience. I wasn't populating my key fields, so I changed this line to this: lcStr = [INSERT INTO SAUTHORS(APKEY, firstname,lastname) values (] + M.PKEY + [,'] + m.firstname + [','] + m.lastname + [')] And I get the Operator/operand mismatch error. With PKEY and APKEY being integers, is there a different syntax I have to use since it's not character or string type Tag: memo field in browse
- 8
- impersonateloggedonuser and Getfil() Logon and impersonateloggedonuser have my rights...just plain user but I have addedthe following user rights to myself... 'Act as part of the operating system', 'Bypass Traverse Checking' and 'Replace a Process Level Token'. From what I have read in MS docs these are the required rights needed to call these dll functions. I will start checking out some od the other rights as well. thanks Tag: memo field in browse
- 9
- Column totals for report Ok I understand now. I was clicking the ... box to do it before. Thank you. Tag: memo field in browse
- 10
- Application cannot run after compile Cannot run...it means that the when starting the application, it just appear for a second time and dissappear again.....I'm using VFP version 9 and compile in the project window with Build command..... Tag: memo field in browse
- 11
- file question Hi, I want to to know if there is a function or command to create a directory in visual fox pro 7. For example, I want a new directory called: 'c:\users\test' . Thanks, Tag: memo field in browse
- 12
- Help With Earlier Verison of FoxPro No...it doesn't have to be Foxpro for Dos or Foxpro for Windows. It can also be Visual Foxpro. All these files are VFP files as well. As a matter of fact, if the softwaer was developed in 2001, its probably VFP. Now... The fact that you're talking about 'modern IDE' may point to the fact that this is Foxpro Dos. Tag: memo field in browse
- 13
- Errors running FoxPro Stored procedures in .NET windows app I think you misunderstood my previous post. I am not using SelectCommand (it happens to be part of variable name used in the original code snippet, VFP7SelectCommand). Correct me if I am wrong. I am attaching the stored procedure in the sample VFP database below (created using VF9.0 Software): Please note there are 3 procedures and I am trying to execute PROCESS_LOCATION_VIEW_TABLES from the windows application. Tag: memo field in browse
- 14
- SQL query too long doesn¡¯t work with SQLEXEC() There¡¯s no error message simply it don¡¯t returns my result records, cursor is not created, despite the query structure is correct (as I wrote in console it works!) I working with VFP 8 SP1. I was wondering if "sliced" the whole query by using cWhere1, cWhere2, cWhere3...variables, and putting them all together at end. Any other ideas fellows are accepted. Thanks! Tag: memo field in browse
- 15
- Why my VFP exe file cannot be launched? How do I refresh *.dll files Thanks. Tag: memo field in browse
- 16
- Possibly a bug using report listener HI All; When using a summary band with no other options (like "Include page header with summary"), AND The number of lines in the generated report is such that the summary band has to print all by istelf on a new page, The generated HTML file when using a report listener is cut short and the last page (Summary all by itself) is not generated. Anyone saw a bug report on this Thx. Tag: memo field in browse
- 1
- Next
- 1
- How to find a ref in a class lib? Hi Again; I'm trying to build my app and I'm getting the following error: Visual Class Library c:\devel\srvfp\krcb.vcx has the following errors: Form 9CUSTSERVICE01 - Undefined I'm trying to find the class that references this form. I tried to use the "Code Ref" tool in VFP9 to find this - no success. I manually opened up most of my classes and there is no ref to this form. I even "use"d the class library in VFP and did a 'locate' on SOME of the fields. Is there a way to find what is the class causing this Thank you all! Tag: memo field in browse
- 2
- Open Source VFP? >> Yeah, but this article is more recent. Which article The one I referenced was from yesterday. It only reflects what was mentioned back within a day or two after the announcement was official plus the added news that Fox developers are petitioning. Nothing has changed since the original official announcement from MS. Based on what I've seen over and over in the media, they aren't too accurate and they collate the thoughts, correct or not, from other reporters. They make incorrect information look more and more legitimate by repeating it in multiple locations, many of which you can get to through casual Googling as you just did. [I wonder what MS Live returns in its search. ] Tag: memo field in browse
- 3
- subtotal field thanks for reply fielda and fieldb is table field and i want to see result in field c ( field c is not table field) Like invoice if you put qty , product price and it will calculate automatic net total in bottom thanks Tag: memo field in browse
- 4
- Buttons Disappear Spoke too soon. If you move the form off the screen, and after you run a print routine, some of the elements dissapear again, several command buttons and a graphic. This is after a refresh is issued also. Tag: memo field in browse
- 5
- How can I trap ALT key in KeyPress Event of TextBox or Form ? Aren't you reading half of the messages Tag: memo field in browse
- 6
- intermittent failure to display jpegs on form It works! I would like to discuss at a little greater length your suggestion: <in the code that sets picture property of the Image control to the image file, there should be added a line CLEAR RESOURCES thisform.myImage.value = alltrim(MyTable.MyJPGField) && where this field contains path to the jpg file (if it just contains the name, add Image Dir in front) > Here is the code for my main.prg, which I assume is where I where I would need to insert the lines you suggested. =myInstance("programname") close tables Clear All IF FILE('forms\welcome_screen.scx') Set Default To 'C:\os_efx' ELSE SET Default TO SYS(5) + CURDIR() ENDIF Set Path To 'os_efx' AddI Set Path To 'forms' AddI Set Path To 'classes' AddI Set Path To 'database' AddI Set Path To 'code' AddI Set Classlib To pvbase,pvmus Additive _screen.AlwaysOnTop = .T. _Screen.BackColor = 2 _Screen.Visible = .F. _screen.AutoCenter = .t. _screen.MinButton = .f. _screen.Enabled = .F. _Screen.Closable = .F. _Screen.AutoCenter = .T. _Screen.WindowState = 2 _Screen.Caption = "" set escape off set bell on Set Talk Off Set Status Off Set Status Bar Off Set Sysmenu Off SET SAFETY OFF PUBLIC PagesArray DIMENSION PagesArray[1] Open Database 'CENTRAL' Exclusive use person PACK use USE p_data PACK use use cat_lin PACK USE Public oApp As Object _Screen.AddProperty('curr_form','') _Screen.Visible = .T. _Screen.AddObject('oApp','papp') *-do shutdown Clear All Release All Extended _Screen.RemoveObject('oApp') Do doshutdown Set Sysmenu To Defa Set Status On Set Status Bar On ****************************************** PROCEDURE myInstance PARAMETERS myApp =ddesetoption("SAFETY",.F.) ichannel = DDEINITIATE(myapp,"ZOOM") IF ichannel =>0 =DDETERMINATE(ichannel) QUIT ENDIF =DDESETSERVICE(myapp,"define") =DDESETSERVICE(myapp,"execute") =DDESETTOPIC(myapp,"","ddezoom") RETURN ****************************************** PROCEDURE ddezoom PARAMETER ichannel,saction,sitem,sdata,sformat,istatus ZOOM WINDOW SCREEN NORM RETURN ********************************************************** ** EOF ********************************************************** The workaround was that I used Irfanview to batch convert/rename the files from their previous names to "imagexxx" ( xxx means 001-999 )and after that I was able to use all the images with no problem. I had also tried using Irfanview to remove exif tags, but that had not enabled the display of the problem images. Is there a limitation for file name length, as applied to image files Anyway another lesson learned! Many Thanks, Marc Tag: memo field in browse
- 7
- Combobox too short, no show of element Try to play with ColumnWidths property of the combobox. Tag: memo field in browse
- 8
- VFP to SQL2005 OLE DB "errors" Still not getting it I'm afraid. I've set up a linked server in SS2005 using the VFPOLEDB driver pointing to a free table directory and that is my connection. I don't see any way to "set null on" (which if it is the default should already be the case). There doesn't appear to be a property in the properties box for the linked server settings at least. Beyond that it is just plain old sql in a query window... select * from linkedserver...tablename If there is some other way or place to do this, I don't know it. What do you mean when you say to set null on for the connection Beyond that, I don't mean to start a discussion on the semantics of null vs. empty vs. not empty or null. As you note, it depends on the application. In this case, empty needs to be null when moved to SS2005 and not converted to 0. Tag: memo field in browse
- 9
- fast / draft mode printing in vfp Dan, I think you misinterpreted my words. I didn't say we need to embed printer codes. I said, how can we go to this option. The Printer environment should stay unchecked. Tag: memo field in browse
- 10
- VFP Fax Integration Direct convert VFP reports (with graphic) to other format (doc, pdf, ..) is not feasible, Alternative is to convert the printer output (which already rendered garphic/image objects with text) to it (pdf, tiff,..). Then, you have to deal with different printer driver languages (PCL, PS,..). That's why I prefer method #1, but I need a way to pass parameter to Send Fax Wizard to make it transparent to users. Emery Tag: memo field in browse
- 11
- SUBSTR() STRTRAN() with Large Text Files Thanks so much Cetin for your thoughtful reply. I'm removing certain *peculiar* div sections, not all. I'll research/experiment DOM and strextract() and see what becomes. Tag: memo field in browse
- 12
- How to create a Word document? I don't have any message in Word. (I am using Word 2000) Tag: memo field in browse
- 13
- EULA or such... Aleniko wrote: I need something that covers hourly rates. I have a customer which I periodically do stuff for, and I charge them hourly. There is no pre-set cost for the software. Any further help would be apreciated although I have a feeling I'll have to go to one of those you know whats... (Lawyers). I work on a handshake 90% of the time and have not had any problems doing business that way. As a matter of fact, the only time I have had issues with client not wanting to pay me is when I have had a written contract - go figure. I also work on a time and materials basis and never do fixed bid work. However, as a professional, I feel that I should accurately be able to estimate the amount of time it will take for me to implement some bit of functionality that the client wants ( plus or minus 20% ). That seems to work out very well for everyone involved - and, yes, on occassion I send my client an invoice for 20 hours work and then issue him a credit for 2 hours due to developer stupidity . You could probably come up with some sort of document that outlines your terms of business without seeing an attorney if the purpose is merely to set client expectations. Why is it that you feel the need to put this in writing That will tell you whether or not you need to seed an attorney. Tag: memo field in browse
- 14
- Report Builder Error with XP Media Center Edition Thanks again, Andy. I checked that scenerio out as well, but the file opens with VFP8.0 without errors. I have pretty much determined that Media Center does not work with the new reportbuilder. I have contacted Gateway on how to revert to XP Pro. Tag: memo field in browse
- 15
- ole erro class not registered i ment mam ..... its not my fault they put the n right next to the m on the keyboard. Tag: memo field in browse
- 16
- Ole Driver corrupting indexes.... As Carl explained records are marked for deletion and not physically removed from the table (unlike SQL server). So 4000 and 4010 would still be existing records (because you could 'recall' deleted records and thus VFP doesn't let you reuse them as PK). You could however besides deleting replace those records' PK value with their negative counterparts. ie: 4010 becomes -4010 so 4010 could be used as a key. Or alternatively if the key exists you could 'recall' and recyle that record replacing other columns with the new '4010' values. Tag: memo field in browse
- 1
- Previous
Re: memo field in browse
Aleniko
I use memo fields in browse in VFP9 all the time.
I'm not sure what could be the problem, but just a few ideas:
- Make sure your table is NOT included in your project.
- Try setrting Enginebehavior 80.
- Add a simple prg to your project with just a simple browse command in it and see if you can open the memo field.
All these are long shots, but since I didn't see any other answers here, I thought I'll give you some ideas.
Alen.
I use memo fields in browse in VFP9 all the time.
I'm not sure what could be the problem, but just a few ideas:
- Make sure your table is NOT included in your project.
- Try setrting Enginebehavior 80.
- Add a simple prg to your project with just a simple browse command in it and see if you can open the memo field.
All these are long shots, but since I didn't see any other answers here, I thought I'll give you some ideas.
Alen.
Re: memo field in browse
rcathens
Thanks but none of those helped. I don't know if this has anything to do with it but I am constantly finding a reference to fox pro classes being at program files\visual studio\vfp98\wizards instead of vfp9. The only computer it works on is the one that does have visual studio/vfp98 on it .
My program is a work in progress since the early nineties and several foxpro editions so it is hard telling what is going on.
Thanks but none of those helped. I don't know if this has anything to do with it but I am constantly finding a reference to fox pro classes being at program files\visual studio\vfp98\wizards instead of vfp9. The only computer it works on is the one that does have visual studio/vfp98 on it .My program is a work in progress since the early nineties and several foxpro editions so it is hard telling what is going on.
Re: memo field in browse
Naomi Nosonovsky
The error indeed sounds strange, but if I'm allowed to hasard a wild guess, I would suspect that this error is coming from timer's code which gets instantiated by application object.
Also check your ON ERROR routine and try to get stack info using new astackinfo function.
Re: memo field in browse
rcathens
By setting exclusive on before opening the file I no longer got the error! Why the error indication "Windowtype not found" I do not know.
By setting exclusive on before opening the file I no longer got the error! Why the error indication "Windowtype not found" I do not know.
Re: memo field in browse
Naomi Nosonovsky
Perhaps it's not a form, but a toolbar, which produces an error. WindowType is form's property.
Though it is still hard to tell why you're getting the error. Try to search your project for the line giving you an error.
Re: memo field in browse
CetinBasoz
Why don't you check loForm.Parent.windowtype instead of loForm.Parent Your code is assuming loForm.parent is an object and not null and has windowtype property.
Why don't you check loForm.Parent.windowtype instead of loForm.Parent Your code is assuming loForm.parent is an object and not null and has windowtype property.