Trimming combobox length display

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
    - ToolTipText How does it work? I set textbox.tooltiptext="xxxxx", but when I mouseover the textbox, there was no tooltip! -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.06) Linux 2.6.18 ^ ^ 19:42:01 up 26 days 22:07 0 users load average: 1.00 1.00 1.00 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: Trimming combobox length display Tag: 227265
  - 2
    - VFP 5: view parent code I couldn't find the button to view parent codes. Where is it? -- iTech Consulting Co., Ltd. Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: Trimming combobox length display Tag: 227256
  - 3
    - Installing VFP6 on Win2K3 Hey All, I'm trying to install VFP6 on our new development "server" (my new workstation...) and I'm stuck at the point where it wants to install the Microsoft JVM. Since that's no longer supported and I'm running Win2K3 64 Bit I'm a little leery... Any words of wisdom? Thanks! Matt P.S. I do have the latest JDK and JRE from Sun installed if that matters. Tag: Trimming combobox length display Tag: 227240
  - 4
    - VFP 9 Display/Screen Big Problems Hi! All of a sudden, I can't see VFP 9 screen anymore. I deleted the foxuser files and I got a command window floating on my desktop. When I issue a command (like DIR), I can't see the output but it pauses for me to press a key. If anyone has any clue, please help!! Thanks -- Monique. Tag: Trimming combobox length display Tag: 227237
  - 5
    - Assigning colors to grid cells I wish to display a series of change records in a grid on a form. They are ordered by change date, so that the newest record is on top. I wish to change the color of any cell who's value is different than the cell below it, but am not able to make the grid work this way. I have played with the Dynamic* properties of the columns but this does not really work: On the initial load it seems to work by calling an EXECSCRIPT() which does skip 1 m.Val = table.val skip -1 if table.val = m.val return m.nHIGHLIGHT else return m.nNORMAL ENDIF However, as soon as you start moving through the grid, the colors are assigned strangely. Is there any way to do this using the Grid control, or do I need to build my own control from scratch? Tag: Trimming combobox length display Tag: 227230
  - 6
    - Class & Project menu popups... How can I get the pad & popup names for the pad/popups that are dedicated to active vfp desktop items? Eg I'm interested in adding stuff to the Class and Project popups. TIA -Lew Tag: Trimming combobox length display Tag: 227228
  - 7
    - buy fpd2.6 Hi I want to buy a legal version of FPD 2.6 for personal use. Where can I get it and how do I buy it? Thanx Charu -- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/foxpro-general/200610/1 Tag: Trimming combobox length display Tag: 227221
  - 8
    - RS232 port Dear All, I have a digital scale connected to my PC through RS232 port. I would like to write a program - in VFP9 - what can read the scale's weight. Could anyone help me how can I start programming? Thank you in advance. -- Sandor Tag: Trimming combobox length display Tag: 227220
  - 9
    - VFP 9: window name What's the name of the window after the command window docked with the property window? I can't close them individually using their own names after they became one. -- iTech Consulting Co., Ltd. Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: Trimming combobox length display Tag: 227215
  - 10
    - VFP 9: Command Window Display I have run into an bothersome difference in VFP 9. I am debugging an program and have a browse in the middle to look at a generated cursor. The command window now displays over the browse. This knocks out using a full-screen browse which I occasionally need. If I click on the command window to move it, I can, but at the cost of the browse disappearing. Is there a setting that I am missing? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: Trimming combobox length display Tag: 227213
  - 11
    - Printing All, I am trying to get FP 9 to print using a print preview component that consists of an ocx wrapper for a dll. The dll will not register as an activex in FP, even though it is registerable with regsvr32. I can get all the way through defining the page layout, and send copy to the printer. At that point nothing appears to happen. No job in the printer object in the control panel, no print preview. I see this in "What's New if FP 8" (haven't got around to 9 yet): "You still can't print reports from within a dll-based vfp com object." So, I'm wondering, does this apply to what I am trying to do as well? Is this still unchanged in 9? Gleason Tag: Trimming combobox length display Tag: 227210
  - 12
    - FPW 2.6 + Windows 2003 Server + DHCP problems I think we've solved it, but looking for input from others that may have experienced this problem. We have 12 XP Pro clients running our FPW 2.6 application. We recently decommissioned the trusty old Netware 3.11 server and put the DBFs on a Windows 2003 Enterprise server shared folder. Each client has a mapped network drive to the shared folder. We were experiencing problems with the application getting sporadic "File read errors". We found http://support.microsoft.com/kb/297684 and ran "net config server /autodisconnect:-1" on the server. The file read errors continued. We finally traced the disconnects to the time of client DHCP lease renewal. Since we set all the stations to static IP addresses the problem seems to have disappeared. -- Paul Tag: Trimming combobox length display Tag: 227206
  - 13
    - Getting Started I want to develop a system using client/server using Visual Foxpro... 1. The Microsoft SQL Server, what version should I need if my OS is Windows 2000 Standard Edition? 2. If my OS is Windows 2000, what version of SQL should I need? I need your opinio please...Help me? Tag: Trimming combobox length display Tag: 227172
  - 14
    - VFP GRID PROBLEM hi all, i am working on client/server application, front hand VFP and backened SQL Server. I am facing the problem in grid. It acts very weird. If the record source of the Grid is SQL Table, sometimes it shows only one record and sometimes blank. In some places, just calling the child form and close it instantly, grid of parent form shows the records properly. It seems to like some refreshing problem. I already breakhead on this thing for long time but i cant get any solution. If any one knows about this problem, please let me know.. Thanks Regards Tassadique Humayun Tag: Trimming combobox length display Tag: 227169
  - 15
    - Report hangs in FPW 2.6 I am still using FPW2.6 for an application on a Windows2003 Server, with workstations that run Win2000 or XP. Until last week, every report printed fine, but now there is a report that always hangs (hangs both on preview and on printer). The report preview window opens up, but it remains blank for ever, until I kill the ntvdm.exe in the Task Manager. The config.fpw file contains MEMLIMIT=80,16384,32768 since ever. I get the same error on different workstations. I have tried with other MEMLIMIT configurations, but every time it still hangs. Any further suggestions? Tag: Trimming combobox length display Tag: 227158
  - 16
    - SYS(1104) returns a string value. As per Fox documentation, Sys(1104) should return numeric (0 if successful) data type. I am consistently getting a string value of '956' from within my application. I am using VFP8. Making this call in FoxPro, without starting my application, correctly returns 0. Anyone seen this before? Is this a bug? Thanks Sati Tag: Trimming combobox length display Tag: 227156
  - 17
    - case statement in remote view? Hi, I would like to create a remote view that includes a field that is populated based on a range of another field in VFP 9. For example, I have a view that returns contact last name, first name. For example: CREATE VIEW contacts CONNECTION contactdb SHARE AS ; SELECT RTRIM(contact.last_name) + ', ' + ISNULL(RTRIM(contact.first_name), ' ') as contact_name ; FROM contact ; ORDER BY contact.last_name I would now like to add another field, an integer, the value of which is determind by the first letter of the last name. The CASE statement appears to be the best choice to me but I'm not sure how to implement it in a view like this. I'm thinking last names starting with A - E = 1, F - J = 2, K - O = 3 and so on. DO CASE CASE BETWEEN(LEFT(contact.last_name, 1) , 'A', 'E') contact.sort = 1 . . . ENDCASE Of course adding the column sort as an integer. Any suggestions? Thanks in advance, Linn Tag: Trimming combobox length display Tag: 227155
  - 18
    - Data Type Mismatch??? Hi everyone. Can someone please take a look at this code? It's very simple. What I am trying to do here is insert a default date of "12/31/xx" into all inv_date column fields, xx representing the last two digits of the year that the user previously entered. I need to do this so that the original application still accepts the proper date format mm/dd/yy. Here is my code: y = Substr(Transform(lcinput),3,2) replace ALL inv_date WITH ("12/31" + (y)) If I type this code into the Command Window and type ?"12/31/" + y, I get the 12/31/02, if the user entered 2002. However, if I run this in my program, I get and error that states "Data type mismatch". Can anyone help me out with any ideas? Thanks. Arvin Tag: Trimming combobox length display Tag: 227149
  - 19
    - Microsoft Visual FoxPro Sedna - Community Technology Preview (CTP) October 2006 From http://www.microsoft.com/downloads/details.aspx?FamilyId=808E96E1-3D87-421F-9BA5-4AAFE70C7B21&displaylang=en This download contains latest binaries that are part of Microsoft Visual FoxPro Sedna and the Visual FoxPro 9.0 SP2. This CTP contains two downloads: The Sedna CTP download contains four components: Upsizing Wizard, Data Explorer, NET4COM and MY library for VFP. The VFP 9.0 SP2 CTP download contains a patch that can be applied to VFP 9.0 or VFP 9.0 SP1. This patch includes fixes to the core product and enhancements to the Reporting features. -- Cindy Winegarden MCSD, Microsoft Most Valuable Professional cindy@cindywinegarden.com Tag: Trimming combobox length display Tag: 227143
  - 20
    - Combobox Displaying Value VFP7 XPSP2 I have a combobox by builder to display 4 fields. when i click on the combo the 4 field are displayed near each and after selecting an item from the combobox, only one field is displayed. My question: i want when i select an item from the combo, the display value to be the 4 fields.as it is displayed when click on the combo before choosing an item. ths in advance Samir Ibrahim Tag: Trimming combobox length display Tag: 227136
  - 21
    - method parameter I am trying to use an activex method that takes a parameter described as (text as string @) . I know that an @ in front of a parameter makes a variable passed by reference to a function. The compiler gives the same error with the @ in front or without. Placing the @ after the variable name doesn't work either. What is the above syntax telling me? Gleason Tag: Trimming combobox length display Tag: 227126
  - 22
    - VFP Runtimes Hi, If I have PCs with locally installed runtimes and also the runtimes in the network application directory, do you know which ones it will use? Just thinking of some machines with VFP9 rt installed locally, and want them to ignore those and pick up VFP9 SP1 rt copied to the app directory. Will this work - can I be lazy? Thanks, Neil Tag: Trimming combobox length display Tag: 227119
  - 23
    - reportlistener orientation problem i can chain two reports together using the report listener just fine, but... report 1 in in portrait report 2 is in lanscape the second report previews only showing half the report. how do i get it to handle this corectly? Tag: Trimming combobox length display Tag: 227107
  - 24
    - How to reference control within a column Dear Programmers, If you want to set the property in/on a control within a column within a grid if it is a textbox, how do you refer to that. Here is some code within the INIT of the Grid, every thing works great except where noted. DoDefault() *** If the grid does not scroll horizontally, make sure the columns are sized *** properly so the grid doesn't scroll when you tab off the last column Local lnTotColWidth, lnCnt With This .lgridoverridecaption = .t. .AllowHeaderSizing = .f. .AllowRowSizing = .f. .HighlightRow = .f. .Highlight = .t. * set resizable properties For lnCnt = 1 TO .ColumnCount .Columns[ lnCnt ].Resizable = .f. .Columns[ lnCnt ].Movable = .f. .Columns[ lnCnt ].Readonly = .t. The following code generates an error **************** If alltrim(upper(.Columns[ lnCnt ].CurrentControl.class)) = "TEXTBOX_" .Columns[ lnCnt ].loverridewidth = .t. .Columns[ lnCnt ].lgridoverridecaption = .t. Endif ***************** Endfor If INLIST( .ScrollBars, 0, 2 ) *** Calculate the total width of all columns lnTotColWidth = 0 For lnCnt = 1 TO .ColumnCount *** Add-on the width of this column lnTotColWidth = lnTotColWidth + .Columns[ lnCnt ].Width + 1 *** work out if this is the last column If .Columns[ lnCnt ].ColumnOrder = .ColumnCount lnLastColumn = lnCnt Endif Endfor *** Add-on the width of the scroll bar (if required) lnTotColWidth = lnTotColWidth + ; IIF( .ScrollBars = 2, SYSMETRIC( 5 ), 0 ) + 2 *** Add-on the delete mark (if required) lnTotColWidth = lnTotColWidth + IIF( .DeleteMark, 8, 0 ) *** Add-on the record mark (if required) lnTotColWidth = lnTotColWidth + IIF( .RecordMark, 10, 0 ) *** Resize last column to ensure grid is completely filled .Columns[ lnLastColumn ].Width = .Columns[ lnLastColumn ].Width + ; ( .Width - lnTotColWidth ) -1 Endif Endwith Any suggestions ? Regards Craig C. Hudson Sr. Tag: Trimming combobox length display Tag: 227104
  - 25
    - VFP 9: Alternative to sys(1037) I have been using a keyboard-sys(1037) sequence to change printer orientation. This is a kludge, of course, and occasionally, when I was using the app, it would hang up wait on the printer form. (I never did identify exactly when, but it was when I had switched focus to another program, and only occasionally.) Surely, there must be a better way, one that does not count on the operator being "friendly". I have looked for code to do this. I found two on Universal Thread, but the documentation is rather sparse. Except for my recent excursion into the kernel API, I have not used external routines before in VFP. Is there a good writeup somewhere, something with examples so I can be sure I have it right? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: Trimming combobox length display Tag: 227103
- Next
  - 1
    - Report printer driver error with new listener / preview I have just tried creating my first VFP report listener. All I want to do with it is be able to detect whether a user printed from a preview. I subclassed the ReportListener class, but the only change I made to it was to capture lPrint in OnPreviewClose and save it to a property so I could look at it later. I am using the default Preview Container that ships with VFP, with no changes except cosmetic ones (caption, height, etc). This works correctly in that it does allow me to detect whether the print button was hit in the preview. However, I'm having two problems. The first one is that the preview takes quite a long time to load, probably twice as long as if I have SET REPORTBEHAVIOR 80 and scrap the listener. The second problem is that when the user presses the print button, they get an error - 1958 Error loading printer driver. I don't specify print drivers in my reports, they generally just go to the user's default printer. Do I have to set a printer driver somewhere for the listener to work correctly? And has anyone experienced a speed problem using the custom preview? TIA, Jen Tag: Trimming combobox length display Tag: 227099
  - 2
    - Alias not found error Hi, I have the following code which occasionally errors out on the last line with Alias 'INSTSTOCK' is not found. It's part of a much bigger app. The This.msource property contains pathing information. Can anyone think of any circumstances why this error would happen, because I'm out of ideas. Thanks, Neil ** start code ** if not used("inststock") select 0 use (This.msource + "lb_stock") order lb_stock again alias inststock shared noupdate endif if not used("instcmpnt") select 0 use (This.msource + "lb_cmpnt") order lb_cmpn2 again alias instcmpnt shared noupdate endif if not used("instsalit") select 0 use (This.msource + "lb_salit") order lb_sali8 again alias instsalit shared noupdate endif lnThisavail = 0 select inststock ** end code ** Tag: Trimming combobox length display Tag: 227097
  - 3
    - Generate a "green application" from VPF Is a possible for VPF to generate a "green application" ? ( It means no need to install the program, just double click the exe file to run the application ) Does any one know it ? Derek Tag: Trimming combobox length display Tag: 227081
  - 4
    - Aggregate function Count I was wondering if someone can help with a specific select statement. This is the following data: Depodate Casenumber Deponent 10/10/06 06CV112 John Smith 10/10/06 06CV112 Mary Smith 10/10/06 05CV555 John Doe I want to get a table that has the following: DepoDate Casenumber depCnt 10/10/06 06CV112 2 10/10/06 05CV555 1 What I need is, For each case number a total deponent count. So I am trying to use the aggregate function Count. I just can't seem to use it properly. Tag: Trimming combobox length display Tag: 227074
  - 5
    - View Tree Control ! Hi, Can someone recomend a View Tree Control to implement like a menu with graphics in the options icons and be able to create folders , could be active X control o something easy to implement. Thanks Bye Oscar from Miramar/FL Tag: Trimming combobox length display Tag: 227071
  - 6
    - blink taskbar Hi, How can I blink my form "reference" in the taskbar. I think that this feature started since XP. Some want to shut it off ... ;-) I want it to act like that with certain "as top level"-forms. thanks in advance regards christophe Tag: Trimming combobox length display Tag: 227062
  - 7
    - Move control from one container to another My question is : How to copy/move control (eg Commandbutton) from one container (eg From) to another (eg Container) ? Thanks in advance Robert Tag: Trimming combobox length display Tag: 227056
  - 8
    - Weird year() function results Hi everyone. I am using the year() function to retrieve the four digit year from two different fields from two different tables. The dates are formatted as follows: mm/dd/yy. I set the century on and although I do get the proper results, for some reason, some of my mm/dd/00 dates are returning 2000 and others are returning 1900. Does anyone have any idea why some dates are being properly translated while others are not? Thanks in advance. Arvin Tag: Trimming combobox length display Tag: 227047
  - 9
    - VFP 9: Line Numbers in Debugger's Trace Window In "Debugging Visual FoxPro Applications", p. 38, the section on the trace window ends with "The option that I set here so that all my Visual FoxPro sessions share it is the line number display." That looks to be something of use, but how do I turn it on? I see nothing for it in the debugger menu or the trace window right-click menu. I do not see anything for it in VFP 6 either. Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: Trimming combobox length display Tag: 227035
  - 10
    - Select query Hi, I am using a listbox to display all the states in USA and also give the user an option 'ALL' to select all states.So now my rowsource query is select 'ALL' from tab_emp union select distinct states from tab_emp This query works fine and serves my purpose even though the tab_emp does not consist of an 'ALL'. Is this the right way to do it ? Please suggest any other method if I am going wrong.Thanks. Tag: Trimming combobox length display Tag: 227033
  - 11
    - null inconsistencies This is causing me problems, so I'll have to create a workaround. ? .NULL. AND .T. && prints .NULL. as expected ? .NULL. AND .F. && prints .F., contrary to null logic and the documentation Tag: Trimming combobox length display Tag: 227032
  - 12
    - JPEGS stored in a general field displaying <filename>.BMP Hi, In our application we store a photo against each record in a general field. These are only stored temporarily, and are created by inserting the photo from a JPG in a common directory. For some reason, some of these pictures are getting resized and pixelated and the general field then shows the resized image, along with <filename>.BMP (none of the files are BMPs). I can't find any reason why it would be doing this - anybody have any ideas? Tag: Trimming combobox length display Tag: 227028
  - 13
    - Temporary table missing ALIAS Temporary table is created in the local directory. This table is a part of a database in the same local directory. lcLocalTable = SYS(2015)+".tmp" lcFullLocalTable = SYS(2023)+"\"+lcLocalTable This table is then opened using the command USE (lcFullLocalTable) in 0 alias (lcLocalTable) exclusive SELECT (lcLocalTable) This table is used and then deleted (and removed from the database) lower down in the same function that created this table. All the command lines in the function execute only once (i.e. no WHILE, FOR .. etc loops) When we started using VFP8, we found that intermittently the "SELECT (lcLocalTable)" command line failed. I have determined that 1. DBF() correctly returns the value of lcFullLocalTable 2. USED(lcLocalTable) incorrectly shows .F. 3. While viewing the datasession window, the alias does not show. However, I can click on the blank space (where the name should have been) and click the browse button to view the contents of this table. The data is correct. 4. Error does not occur if debug window is open. 5. I am using Symantec anti virus. 6. The error is greatly reduced if I slow down the system by using SLEEP (win API) or a wait command with timeout 7. I have already taken care of weeding out duplicate names in SYS(2015) 8. My network people tell me that I have admin rights to the temporary directory. Anyone faced this before? I'll appreciate your idea's Thanks in advance. Tag: Trimming combobox length display Tag: 227024
  - 14
    - BindEvent - User Activity Hey guys, is there anyway that I can bind to an event that will tell me when the user is active? (i.e. they are moving the mouse or doing something in Windows or another app.) I have looked at the Windows Message Notifications, but all of those seem to be related to your app. & not any other app. For example if I use the WM_MOUSEMOVE with BindEvent, I only get notification when they move the mouse inside of my app. But what I want to do is just have an icon in the sys tray, so they wont really be in my app at all. Basically like what MSN Messenger does...if you aren't doing anything on your computer for xx minutes, it will set your status as "Away". Any ideas?? Thanks in advance, Jerry Tag: Trimming combobox length display Tag: 227014
  - 15
    - corrupt tables Is there some way to search a table for bad data? We want to be able to check all tables for bad data. We can access tables and a DBValidate does not always find the bad fields. Tag: Trimming combobox length display Tag: 227011
  - 16
    - Problem with grid I am unable to see the values in the grid though I can see them in the cursor using data session window. I am able to select the no/of rows but am unable to see the values int he grid. I specified the racordsourcetype to alias and recordsource as parent. please help me. Thanks, Raghu Tag: Trimming combobox length display Tag: 227007
  - 17
    - Store Web page with picture and retrieve it. VFP7 XPSP2 how i can store the website with all it is image in VFP table, maybe memo field or memo binary, and then put an IE activex on the form and retreive the website from stored table to IE Activex. if some one can tell me the headline of how to do it. thx in advance Samir Ibrahim Tag: Trimming combobox length display Tag: 227006
  - 18
    - Picklist Editor Coding an application in VFP9 and was wondering if there were any code samples for picklist editor. I am using quite a few different lists in this application and hate to code a maintenance screen for everyone of them. Any help will be appreciated Tag: Trimming combobox length display Tag: 227003
  - 19
    - Need help with an SQL statement Hi everyone. I need a little bit of help with an SQL statement. I have a table called lcpay. This table has a column called pay_date. The values for this column are 4 digit years (i.e. 1999, 2000, etc.). I need to have an inputbox that allows a user to select a year. I then need an SQL statement to only pull the records for that particular year and insert them into another table. Here is what I have so far: lcinput=INPUTBOX("Please select a year") SELECT * from (lcpay); where VAL(payconvert.pay_date)=VAL(lcinput); into table (lcselectpay); ----------------------------------------------------------------------------------------------------------- My SQL statement above is giving me this error: "Function argument value, type, or count is invalid" Can someone please help me out. I know it's supposed to be a simple task, but I can't seem to figure out what is going on. I have a feeling that I am comparing a number to string, but am not quite sure how to tell VFP to go ahead and compare the fields. Thanks in advance. Arvin Tag: Trimming combobox length display Tag: 226992
  - 20
    - Excel in batch mode This is an addition to my other questions. In order for me to automate my processes, it's important for excel not to do anything that might put it into a wait state. So far I've dealt with the following: AutomationSecurity on high (3) to disable macros DisplayAlerts to .f. Prevents modal dialogs (does excel have non-modal dialogs?) AskToUpdateLinks = .f. Don't query to pull in data from the internet (Talk about security holes!) ... does anyone know of anything else that should be on this list? I'll post this in excel.programming as well. I'm not personally available to be disabled, yet. -Lew Tag: Trimming combobox length display Tag: 226985
  - 21
    - Screen flicker Hi, I have a form with a lot of containers on it. The containers are used as buttons, so they have an (button) image and a label as childs. The picture source is a bmp/gif excluded from the project. They are loaded at runtime and can be changed by the user. The label is on top of the image. The user can switch to an other mode to use shapes instead of images. THE FLICKER ------------------------------------------------------------------------------- ONLY IN VFP9 ---- NOT IN VFP7 ONLY WHEN USING IMAGES INSTEAD OF SHAPES ------------------------------------------------------------------------------- At runtime there are some events that changes the caption of the label. Whenever the label in only one (!) container changes, the whole form will be redrawn. Before and after the change the thisform.lockscreen property will be set. The same happens when "MyMessageBox" (dialog form) will be closed - the whole form will be redrawn. :-O Help Norbert Tag: Trimming combobox length display Tag: 226980
  - 22
    - newobject I am writing a standalone foxpro 9 exe program. The forms are contained in a global vcx file. When creating an instance of a form with the newobject command, the vcx file must be accessible to the runtime exe. This works fine on my development computer. If I install the exe with dependencies including the vcx file on a client computer, and reference the correct location of the vcx file when instantiating a form, I get an error message stating the class was not created. Is there something I am missing? Noah Sombrero Tag: Trimming combobox length display Tag: 226968
  - 23
    - multiple detail bands in a report. Hi all, I have a question regarding the multiple detail bands in VFP 9.0. The reason I have this question is because I am trying to get it to work in my application and couldn't get anywhere. Here is the scenario: I have a table called Traffic as the initially selected table for my report. There is a related table called TrafficPhotos which is the many table to the Traffic table in the one-to-many relationship. The Traffic table contains details about a traffic accident and the TrafficPhotos table contains path to photos of the accident, it could be one photo or 20 photos. In my report I created a detail band for the TrafficPhotos, and it works great if I use any field in the table, however when I put a picture/OLE bound control on the TrafficPhotos detail band and set the ControlSource Type to "Expression or Variable" and in the Control Source I target the field TrafficPhotos.PhotoPath, I keep getting an error. How would you solve this problem? all I need is to show, in a report, all the photos for an accident but keep in mind the photos themselves are not part of the table, I simply have a path pointing to where the photos are. Thank you for your help. 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: Trimming combobox length display Tag: 226964
  - 24
    - Reference controls at runtime How do I reference a textbox control at runtime that's on a pageframe. I am using code like For each lobj in thisform.objects ... Endfor I get all the objects (including the pageframe) on the form but no objects within a pageframe. Tag: Trimming combobox length display Tag: 226939
  - 25
    - VFP6 Structure via Query I'm currently using the following command to get the structure out of a VFP 6 database via the VFP6 ODBC Driver. Is there a way to modify this so that I get the data type of the column as well? SELECT distinct alltrim(d1.objectname) AS table_name, alltrim(d2.objectname) AS field_name FROM DBC() d1 JOIN DBC() d2 ON d1.objectid = d2.parentid WHERE d1.objecttype = 'Table' AND d2.objecttype = 'Field' ORDER BY table_name,field_name I've tried variations on... type(alltrim(d1.objectname)+"."+alltrim(d2.objectname)) ... with no success so any ideas would be appreciated. Thanks! Matt Tag: Trimming combobox length display Tag: 226929

I have a an array populated from a table [tablename(cid c(8), cdesc(100))]
and bind it into a combobox as the rowsource. The problem that I have is
the length of the display when using the combo box is showing the whole 100
characters even I only have a maximum 30 characters from my table. Is there
anyway i can trim the display using the method above?

Thanks.

apa

Re: Trimming combobox length display by Bernhard

Bernhard
Tue Oct 17 10:21:57 CDT 2006

Hi apa,

> I have a an array populated from a table [tablename(cid c(8), cdesc(100))]
> and bind it into a combobox as the rowsource. The problem that I have is
> the length of the display when using the combo box is showing the whole 100
> characters even I only have a maximum 30 characters from my table. Is there
> anyway i can trim the display using the method above?
Use VarChar for the cdesc field.
Or (in VFP 9) SELECT cid, cast(trim(cdesc) AS varchar(100)) INTO ARRAY laArray
Or use a loop to trim the array elements
Or fill the combobox (using AddItem) in a loop where you trim the cDesc field

Regards
Bernhard Sander

Re: Trimming combobox length display by tim_witort

tim_witort
Tue Oct 17 12:45:38 CDT 2006

apa seemed to utter in news:uTCh6Zf8GHA.4632@TK2MSFTNGP02.phx.gbl:

> I have a an array populated from a table [tablename(cid c(8),
> cdesc(100))] and bind it into a combobox as the rowsource. The problem
> that I have is the length of the display when using the combo box is
> showing the whole 100 characters even I only have a maximum 30
> characters from my table. Is there anyway i can trim the display using
> the method above?

If you're asking how you can control the width of the combo's
dropdown list, then that can be done by using the ColumnWidths
property. Set ColumnCount to 2, ColumnLines to .F., then
ColumnWidths to 100,0. Then tweak the first number of the
ColumnWidths setting until the dropdown is the width you want.

-- TRW
_______________________________________
t i m
a t
w i t o r t d o t c o m
_______________________________________