Print Structure

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
    - TextBox & EditBox Question Hi all, Is there a way to do this? When either a TextBox or EditBox have focus it highlights the entire entry? i.e. when I tab through a form with many fields, it will highlight the contents of the Text & Edit Box. Right now when I tab to a field, the cursor is at the beginning of the box. Thanks, Mark Tag: Print Structure Tag: 186253
  - 2
    - Set(Color) doesn't work in VFP7 glen_gillman@countrywide.com In the command line you type as shown below: SET COLOR TO W/B messagebox(set("color")) I expected it to return "w/b" and it returned "n/w*" I clearly set the color to white/blue yet when issuing the set("color") command it returns n/w* (WHITE). My guess is that the default color scheme is n/w* so it is picking it up from there. But this is also randomly affecting an application of ours that has a mix of forms and class libraries but a few screens using @ say, get, etc. Any help in understanding this will be greatly appreciated. Thanks Tag: Print Structure Tag: 186252
  - 3
    - XML-Like Data structures I am considering storing some pertinent session/file information in an XML style format. Has anyone used MS XML for storing information within an App? Has anyone written a standalone parser that will handle "Tagging" as XML/HTML does? I have never used MS XML so I would have a learning curve that I fear would be longer than just writing my own parser with fgets/fputs/etc. I am using this style of data storage to allow interoperability between a couple of applications. (i.e. Dynamic Fore/Back colors established in one program will be retained in another - For a very simple example) Any thoughts are appreciated. Thanks, Scott Tag: Print Structure Tag: 186247
  - 4
    - blat versus cdo I've heard it said that cdo was not all that reliable. I've played with blat, and it seems to work quite well. Which would be preferred? It's a mission critical 24/7 application running VFP7 that sends out occaisonal emails. Tag: Print Structure Tag: 186235
  - 5
    - Visual FoxPro 8 Spanish IDE released Spanish IDE for Visual FoxPro 8 SP1 just released !! (new in spanish & english) http://www.portalfox.com/article.php?sid=937 Web page from the project http://www.portalfox.com/vfpespanol/ -- Saludos, Pablo Roca - Microsoft Visual Foxpro MVP Sysop de PortalFox (http://www.portalfox.com) La Coruña, España "Apoya a FoxPro, utiliza software legal" Tag: Print Structure Tag: 186234
  - 6
    - newbie question - command box I am trying to create a save, next and previous buttons in my form. What is the syntax for the click method for these buttons? Tag: Print Structure Tag: 186232
  - 7
    - Calculator Needed. ActiveX control Available? I put calculator buttonss on my form for the user to press to bring up a calculator and then have it return the value back to the flow of the program. Now I need a calculator to use. Is there a good activex control available or maybe a class library with such controls? I played around with the ACTIVATE WINDOW calculator but it would not lock itself to my pre-made calculator form and I really do not want to use a form just to run a calculator. Running the calculator itself runs independantly of the calling form and I do not want that because I am linking the calculator to specific numeric fields. I am also concerned with running something that is windows based ? thus if they do not have the calculator installed then the calculator does not run. I prefer a pre-build library or activex and would not even mind building a library myself even though that would be time consuming. Any ideas or code would be appreciated. Rick Tag: Print Structure Tag: 186231
  - 8
    - cannot update cursor error... Intermittently, I get an error "cannot update cursor" when trying to write to a table. This table is opened at system startup, and gets read and written to all day. It never gets closed, and it most certainly doesn't get opened read only. But from time to time, this code: select <mytable> replace.... Generates error 111, cannot update cursor. I suspect something external, though I really have no clue what. The code is clean and simple, and I can't find a reason for this. Tag: Print Structure Tag: 186227
  - 9
    - VFP8 Form name changes upon compliation I have created a formset called FormSet1 which contains just one form at the moment with a Pageframe on it. I have named the form 'frmMain'. However I cannot reference any objects on the form from my toolbar because it says 'unknown reference frmMain'. The following message was displayed when I had an error on one of the pages - "...... in Program Formset1._13V1BUQUS.Pageframe1.pgClient" which shows that the name of my form has been changed to a generated one upon compilation as this differs each time I recompile. How do I make it use my name, frmMain? Thanks Kate Tag: Print Structure Tag: 186218
  - 10
    - MAX date from two tables... Hello this keeps baffling me.. Can I do this in one SQL statement? SELECT date ; FROM bookin ; WHERE part="X" ; UNION ; SELECT date ; FROM bookout ; WHERE part="X" ; INTO CURSOR tempbook SELECT MAX(date) ; FROM tempbook -- TIA Andrew Howell Tag: Print Structure Tag: 186217
  - 11
    - Passing Parameters to Forms ! Am sure will be an easy task but am unable to Pass parameters to a form ? I have checked both Init & Load Event but have not received the Params there ? Tag: Print Structure Tag: 186212
  - 12
    - I want no value selected in the combo box. I fill a combo box with '1, 2, 3, 4, 5' using additem and tie it to a data source. When the form first opens there is no value in the combo box if the data source has no data. I choose a 2 from the combo box. I change my mind. I do not know the value I want in the combo box. But, how do I get the combo box back into its no value stage? The workaround I use is to create a two dimensional array (' ',1), ('1',2), ('2',3), ('3',4), ('4',5), ('5',6) and tie the data source to the second column. There are better ways to do this, I guess. Please enlighten me. Sincerely, Jan Nordgreen Tag: Print Structure Tag: 186211
  - 13
    - forcing "Verify" in Expression Builder Is there a way to force the user to click the Verify button in the expression builder dialog ? Thanks Tag: Print Structure Tag: 186209
  - 14
    - ALT key can't open menu when running exe I have designed a menu 'MAINMENU' and define the ALT key in [keypress] in menu designer. This menu will be called from a form 'MAIN', The ALT key works while in the design time, after that, I compile it to build an exe file. The ALT key doesn't work when running the exe file. Inside the initial main.prg, I have several environment settings and at last, there is as do form MAIN read events and in the INIT event of form MAIN, the content is do mainmenu.mpr with thisform, .t. Below are some setting of the form MAIN ShowWindow - 2-As Top-Level Form WindowType - 0-Modeless MDI Form - .f. Please, can anyone give me a hand on this issue. thanks lot Edward Tag: Print Structure Tag: 186203
  - 15
    - opening remote view and VFP's annoying wait window Hullo, If you "use" a remote view that retrieves a lot of data then VFP (I'm using VFP8 (SP1)) displays a wait window saying "Executing remote.... press ESC to cancel". How can I disable this message? It is a particular problem in OLE servers using sys(2335, 0) since the message causes an error condition. 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: Print Structure Tag: 186201
  - 16
    - How to copy the Picture into a ClipBoard Just wondering if anybody can help me on how to copy the Picture into a clipboard from Visual Foxpro, I know How to transfer the screen shot but I want to send a BMP file or a jpeg file to a clipboard. Is there any command like _clipPicture as we do the _ClipText . Hope I am Not expecting too much Any help on this would be appreciated Cheers Raj Tag: Print Structure Tag: 186198
  - 17
    - VFP7R.DLL is damaged I use VFP7 to develop and release my project. I found that the system can not be run on some computers of Windows 95 and it shows the error message when going to run, "VFP7R.DLL is damaged", even though the version is 4.00.950C. But some computers of also Windows 95 can have no problem. I would like to know how I can fix these problems. Thank you very much! Christopher HF Tsang Tag: Print Structure Tag: 186197
  - 18
    - Print to TIFF Anyone have any favorites? Or recommendations to avoid? I'd like to print reports and pdfs to a TIFF image and rename programmatically. I've downloaded (but not yet installed) a trialware of NED's Image Driver. Opinions? Thanks, Dave Tag: Print Structure Tag: 186194
  - 19
    - Newbie Question Hello newsgroup. I have a form that I created and I am running it directly from the IDE. I am using VFP 8.0 It has a PageFrame and a Text Box. I have a database also associated with in. I am trying trying to set a property on one of textbox at runtime. When I run the form I get an error. frmItem.pgfMaint.pagSearch.txtItem.fontsize = "9" I get an error saying that frmItem object is not found. Am I missing something? Thanks, Daniel Tag: Print Structure Tag: 186188
  - 20
    - File is in use by another Since converting many of our applications to VFP8.0 from VFP6.0, we are getting persistent "File is in use by another" errors when USEing a file, when the file is definitely not in use, excl is off etc etc. Usually trying again immediately allows it to open OK!!!!! This has happened across several unrelated applications on various platforms. We have both Novell and Win2K servers, with both XP and NT4 clients. Unfortunately we do not have sufficient XP clients to determine whether an XP client resolves this issue - but I doubt it. We also have vfp8 applications where the tables are still in Foxpro 2.6 format, some with tables in VFP6.0 format and some with tables in VFP8.0 format. Happens across all when app is VFP8.0. Revert back to 6.0 with everything else the same and the problem goes away. I believe this to be a bug in VFP8.0. I have seen similar complaints from others on various forums, but no one has come up with an answer as yet. Any help appreciated. Maybe next service pack this will be fixed.... And while I'm moaning - anyone know of any fix yet for the dropped table handles issues with VFP apps running on terminal server when data is not on the Terminal server drive? Regards, Brian Wood Tag: Print Structure Tag: 186178
  - 21
    - How to get rid of the white "backdrop"? Evertime I put together an application in Foxpro it comes with this large white "container" obect in the background that gives the app a less than independent appearance. Does anyone know how to hide this at runtime? Tag: Print Structure Tag: 186177
  - 22
    - Report with images with different height in detail band. I am using vfp 8. I just managed to print images in the detail band using only stored path names. However, the images have different heights and neither clip nor scale are satisfactory solutions. Clip will not guarantee that the entire image will show, and if the image is low a lot of space will appear before the next record. Scale will blow up small images and look ugly. Any ideas what to do? Sincerely, Jan Nordgreen PS: The report's view was called vviewtest and had a field vviewtest.imagepath with the complete path of a picture. Most of the records had vviewtest.imagepath empty. To get the images to print in the detail band, I added a picture control with 'Picture from file' set to 'vviewtest.imagepath' and 'object position' to 'float'. In 'Print when' I checked 'remove line if blank' (if not the frame would always take up space, even when empty) and for 'Print only when expression is true' I put 'not empty(vviewtest.imagepath)' (if not, the report wouldn't even be created). Tag: Print Structure Tag: 186172
  - 23
    - Keyboard Macros in VP6/8 Many thanks for the help given to me regarding the Command Window and the Expression builder. That problem appears to be laid to rest, I'm pleased to say. Can anybody help me now on the apparent idiosyncratic behaviour of my keyboard macros (I have some 200+)in Memo fields in VFP8 which didn't happen when the same ones were used in VFP6? The trouble appears to be limited to those macros containing Enter and Home or Shift+Home used in Memos in the middle of text to break a line and start a new one and when used to start a new line, linked by an inserted colon, at the end of a body of text. What happens is that the new line is not forced open but the text in the macro is placed in the existing line at the 'correct' place. Searson Tag: Print Structure Tag: 186164
  - 24
    - Binding Data Is there a way to unbind data from a form during run- time. On loading the form, the bindcontrol property is set to false. It then gets sets to true upon the first action on the form. Customer wants to clear the form entirely after an action takes place, basically unbind the data. Going to the end of file won't work because he wants to search on a combination of six fields. TIA Mark Tag: Print Structure Tag: 186162
  - 25
    - how to use winsock to send and get .bmp images, memo field and general field ? how to use winsock to send and get .bmp images, memo field and general field ? Tag: Print Structure Tag: 186161
- Next
  - 1
    - how to use winsock to send and get .bmp images, memo field and general field ? how to use winsock to send and get .bmp images, memo field and general field ? Tag: Print Structure Tag: 186160
  - 2
    - Grid on selection? Dear All, My program need one text box and one combo box on the same column in a Grid. My program is simple like that: If column1 =A, column 2 is a text box else column2 is a column box. I have put the "InteractiveChange" event on column1( in fact, it is a combo too.) I chg. the "CurrentContre" for column2 and make some necessary eg. something "Enabled", "Visible"... That works fine for input data. But when I load the Grid (start the program again), column2 can't show properly. I set back "Sparse" to True, the (Grid) data seems to be correct. My question is that:- 1. Can I show column2 correctly (Combo) when I start the program at the beginning ? ( the condation is depend on column1) (If I first make the selection on column1, the column2 show correctly. But if I first "Click" on column2, the combo can't show, also no selection.) (I try to put the "BeforeRowColChange" event on the grid, but failed) 2. My grid allow user to add and modify data, in such case, How can I do that ? Thanks in advance, SY Tag: Print Structure Tag: 186153
  - 3
    - newbie question - combo box Dear all, I would like to do this... a combo box have this value - apple, boy, cat for user to select but underlying the value - a, b, or c will store to table instead. I would like to know how to set up properties properly and how to show the value correctly to user when retreive from table. Many thanks. Wandy Tag: Print Structure Tag: 186150
  - 4
    - Feature not available in demo version Windows XP, VFP50 I have just migrated to XP and now i get a message in my application "Feature not available in demo version". I have seen a similar message when I inadvertantly leave a suspend in my form, but I have never seen this I get the message when I am examining several tables for a key. If I don't find it, I add it to another table. The process is determining what invoice numbers are not currently in a table Any thoughts TIA Tag: Print Structure Tag: 186145
  - 5
    - Text boxes becoming disabled. What would cause all text boxes on a form to become disabled? I have checked the enabled and readonly properties and they are set correctly. This did not start happening until I run it over my XP network. Folders are set to share files. This only happens on one form not on the other forms in the application. Tabstop is also set to .t. on each text box. The command buttons and other controls are enabled and work properly. Thanks in advance, John. Tag: Print Structure Tag: 186144
  - 6
    - problem with vfp8 in _screen resize to define the class with the procedure hook problem with vfp8 in _screen resize to define the class with the procedure hook doesn't work Tag: Print Structure Tag: 186139
  - 7
    - Returning focus after scan...VFP8.0 I have 3 computers each running a VFP 8.0 application. Each computer is of the same brand running XP and each computer is using a Symbol LS1908 USB bar code scanner. On 2 of the computers when I scan the bar code, the application returns focus to the same field and awaits another scan. On the 3rd computer control does not return to the text box for another scan. Each system is running the same exe. Each system has set confirm on. What else could cause this? Thanks in advance, John Tag: Print Structure Tag: 186137
  - 8
    - Bug? The arrow keys are not working properly in a grid. If rows in a grid are more than the height of a grid, that means you need to use up or down keys or mouse to move the grid. It's fine to use a mouse to control the scroll bar. But up or down arrow keys can not go through the whole range. The grid will be stopped somewhere and seems missing many records. I am using VFP 8 SP1 and tested it in 2000 and XP machines. Any ideas? TIA Tag: Print Structure Tag: 186136
  - 9
    - including a header file in reports? Hi all, Is there a way to use header files for reports? Help would be appreciated. Greetings, Zakaria al Azhar Tag: Print Structure Tag: 186132
  - 10
    - mutex, criticalsection, threading issues??? Hi, I have an app which has as one of its components an activex control which is constantly processing data from the serial port. I need the event handler for this code to be able to interrupt anything else I'm doing so that I don't lose any data. I also have a timer which I need to run once a second and do some processing of the data. I also of course have a form with which the user can interact. Because of the serial port handler, I have the application autoyield property set to .f. My problem arises from the unfortunate need for all three of these "threads" to access some of the same data structures and objects. I'm wondering if I can use some of the Windows control structures such as critical sections mutexes or semaphores to handle this? In trying to read about them, it seems important that the various items which are competing for the resource be either in different threads or different processes (or the WaitForSingleObject() function won't wait). Can someone tell me if these components are running in different threads, and then could someone recommend which of these Windows features might be best suited to allowing short exclusive use of resources? thanks for any help, Chip Tag: Print Structure Tag: 186131
  - 11
    - Converting FPW2.6 reports to *.jpg, *.doc, *.xls Well, I would like to generate my FPW2.6a reports as jpg, doc or xls. I found frx2any, but it works only for VFP. Any hint? Tag: Print Structure Tag: 186127
  - 12
    - Help cannot access program from new xp client I copied the VFP6r.dll and VFP6rEnu.dll files from the server onto the XP client folder where a copy of the setup files was stored. I was able to launch the program but it does not run. the following error occurs: Error loading file- record No. 9 Vprostandard form 1 <or one of it members> Loading form or the data environment: Connectivity error[MS ODBC drivermanager] Data source name not found&no default driver specified. ANY SUGGESTIONS Tag: Print Structure Tag: 186124
  - 13
    - Help cannot access program from new xp client I copied the VFP6r.dll and VFP6rEnu.dll files from the server onto the XP client folder where a copy of the setup files was stored. I was able to launch the program but it does not run. the following error occurs: Error loading file- record No. 9 Vprostandard form 1 <or one of it members> Loading form or the data environment: Connectivity error[MS ODBC drivermanager] Data source name not found&no default driver specified. ANY SUGGESTIONS Tag: Print Structure Tag: 186123
  - 14
    - ODBC vs. OLEDB I have posted a comment before stating a problem I was having with VB and updatebatch method and getting the error "Row Cannot Be Located for Updating...." I have found that if I use an Update SQL statement instead though it works fine (to do this though would be a hell of alot of extra programming). It also used to work before and I think it was the change from VFP 6 to VFP 7 that brought the error. Anyway, what I'm wondering is, the VB code uses a DSN ODBC connection to VFP. I'm wondering if I use the OLEDB connection, would this make any difference? I am also wondering what the difference between ODBC and OLEDB is. Also I'm wondering if maybe moving to VFP 8 would fix this problem. Tag: Print Structure Tag: 186118
  - 15
    - Is it possible that Norton Antivirus can cause data corruption in VFP tables? I have a client running NAV and my VFP6 app data keeps getting screwed. I tried disabling NAV & the problem went away - is this a known problem? Thanks John Tag: Print Structure Tag: 186115
  - 16
    - Unable to release form.. Hi I use VFP7. I have a top level form and top level menu. A form is displayed for each meu item. I run a programme to release the displayed form when another menu item is chosen. When a "grid" in the form has the "focus", I am unable to release the form. I have tried all the commands like release window, object.release etc.. None works. But there is no problem with other controls like combo,text boxes etc.. Please help me .. Thanks in advance. Bala . Tag: Print Structure Tag: 186114
  - 17
    - old annoying bug or a feature? Hi, In order to validate user's imput, I place in Valid Event of Textbox some code, wich calls a form for data lookup or entering new data in related tables. Depending on lookup results, the focus stays in the Texbox or jumps to other controls with a help of RETURN n command. This seems to be very clear and convenient, but... If in some other form, launched from Valid Event, there is a SetFocus Method - the error comes: SetFocus method can not be called within Valid Event. But SetFocus is called in other form! And what more, in a way can be several more form calls that has nothind to do with the first one, but the error comes nevertheless :( I wonder, if MS will ever fix this annoyance or it is treated like a feature? Vitas Tag: Print Structure Tag: 186113
  - 18
    - VFP8 Command window - Expression builder I have recently upgraded from VFP6 to VFP8 (although at the moment I feel as if I have stepped backwards)and am not a programmer or developer in any way. XP/SP1 is the OS. Keyboard macros are much used in my hobby. Could anyone spare the time and trouble to tell me how to get rid of the expression builder that pops up as soon as the macro issues the Locate or Seek command etc. This slows up things tremendously, especially where the Locate command is used in Memo fields, by comparison with VFP6. Searson Tag: Print Structure Tag: 186112
  - 19
    - Bug? The InteractiveChange Event in a combobox in a grid cannot be trigged? I found the InteractiveChange Event in a combobox in a grid cannot be trigged properly if 1) RowSourceType is 6 and you hold the left button of a mouse and move to the row you want and release the mouse. 2) RowSourceType is 1 and you click the down arrow and release the mouse and then move to the row you want and release the mouse. RecordSourceType in the grid is the default value 1. It works if you use method 1) when RowSourceType is 1 or you use method 2) when RowSourceType is 6. Any ideas? TIA Tag: Print Structure Tag: 186111
  - 20
    - InstallShield and MSDE Hya Folks, I've tried to create a setup via installshield (the free 3.5 Express with VFP8). Right now, i've got a big problem with my MSDE2000 merge module. Everything runs fine with the build of the disk image, but when installing, the setup stops either with either "not enough free space on drive MSSQL" or "cannot find drive MSSQL". Anyone knowing this problem and able to help? Pierre Tag: Print Structure Tag: 186103
  - 21
    - VFP to VC++ I'm wondering if creating interfaces in VC++,populating list boxes and grids is similar and as easy and as flexable as VFP. I'm thinking of developing the same app I developed with VFP in VC++ so I can say I did it in VC++ as well. Are the VC++ controls similar to VFP controls with methods and properties etc. Are classes just as easy to work with? Thanks in advance Tag: Print Structure Tag: 186095
  - 22
    - Controler Print hi, everybody. Please, i need controler the number is send to print in XP?. for example, in the morning i send to one print but this print is with two paper. I need registration in my database the number of impresion and the number of pages. But this impresion no is only the vfp, is also send word, excel, or other program. Thanks my friend. Tag: Print Structure Tag: 186087
  - 23
    - Can't print from memo field in VFP 5.0a I have a little application I created for someone which is simplicity itself. One screen, one table with two fields - a character field and a memo field. The screen has 3 buttons: Search New Exit Problem is, although Print is enabled on the File menu when viewing the memo field, executing the Print function does not activate the printer! Is there a way I can fix this? The application was originally created in FPW 2.6a and converted in VFP 5.0a and otherwise seems to run OK. Thanks for any help! Dan Tag: Print Structure Tag: 186083
  - 24
    - FPW 2.6a, closing DOS window after RUN command Hello, I'm running a batch file from FPW with the RUN command. I have the "Close program on exit" option enabled in foxrun.pif but the DOS window stays on the screen if I use RUN /N. It disappears with just RUN - I actually want to use just RUN but for some unknown reason that produces "RUN / ! command failed". RUN /N works fine except for this window being left behind.. Any ideas? Maybe shellexecute API call would fix this but I've no idea [not entirely true but for the purposes of explaining I have no idea..] how to call this function from FPW2.6 -- TIA Andrew Howell Tag: Print Structure Tag: 186069
  - 25
    - foxprow2.6a exe Hello Could anyone please send me or give a link to where I could download patched files of foxprow 2.6a so than could run in XP. I downloaded patches themselves but they state the file is not the right size, internation patch does not work either. After playing with them, I do not have 'divide by zero' message anymore, but fox crashes after 'invalid path or filename' message. I do not have any installation disk anymore so I cannot follow the official patching procedure. Maybe I could download installation kit form somewhere? Best regards and thanks for any help, Piotr Tag: Print Structure Tag: 186065

How do i print the structure of a table? I know i have done this before but
I am having a brain fart.. Thanks in advance

Keht

Top

Print Structure by anonymous

anonymous
Mon Dec 01 15:04:02 CST 2003

disp stru to print
or
list stru to print
>-----Original Message-----
>How do i print the structure of a table? I know i have
done this before but
>I am having a brain fart.. Thanks in advance
>
>Keht
>
>
>.
>

Top

Re: Print Structure by Wolfgang

Wolfgang
Mon Dec 01 17:06:19 CST 2003

If you're using VFP>=6 there is a report to print the documentation of a
DBC. If you use long field names (>10 characters) the
LIST STRUCTURE TO PRINTER
is not really the appropiate method, because it truncates the variable names

--
_________________

MFG
Wolfgang Schmale

MS Visual FoxPro MVP

--------------------------------
"Keht" <no@novirusthankyou.com> schrieb im Newsbeitrag
news:eQa322EuDHA.3220@tk2msftngp13.phx.gbl...
> How do i print the structure of a table? I know i have done this before
but
> I am having a brain fart.. Thanks in advance
>
> Keht
>
>

Top