make yourself one...

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
    - Is it possible to draw a table in vfp8? Hi All, I think this question sounds stupid! Anyway, here it goes... Is it possible to draw a table with rows and colums like in MS Word? I did think of using a grid. But, I won't be populating the grid with multiple record from a table/s. The contents to be displayed on the table would be a result of a join of several tables which fetches exactly, one entity's data from all the tables in the database. But I would be displaying the whole lot of information in a several rows and columns. Can anybody suggest me how to do this? Thanks. Tag: make yourself one... Tag: 207196
  - 2
    - want to remove the read only status of label.lbx I wrote a label program, the program run on different computer, different site and different printer. I want to print 22 labels on one sheet on different situation. so I removed the printer driver in label.lbx before printing in order to the labels can be printed 22 labes on one sheet on each computer. the templabel.lbx is read only a error occured , when I created a setup.exe. how can I remove the read only status of templabel.lbx ? the following is the code of label program. thank you for your help ming *********************************************** COPY FILE 2x11.lbx TO templabel.lbx COPY FILE 2x11.lbt TO templabel.lbt *** Open the temporary report file USE templabel.lbx IN 0 -------------------------> problem occured right here. SELECT ("templabel") GOTO TOP * Strip some information from EXPR. Remove the driver info. lcExpr = Expr lcExpr = STRTRAN(lcExpr, 'DEVICE=', '*DEVICE*=') lcExpr = STRTRAN(lcExpr, 'DRIVER=', '*DRIVER*=') lcExpr = STRTRAN(lcExpr, 'OUTPUT=', '*OUTPUT*=') lcExpr = STRTRAN(lcExpr, 'DEFAULT=', '*DEFAULT*=') lcExpr = STRTRAN(lcExpr, 'PRINTQUALITY=', '*PRINTQUALITY*=') lcExpr = STRTRAN(lcExpr, 'YRESOLUTION=', '*YRESOLUTION*=') lcExpr = STRTRAN(lcExpr, 'TTOPTION=', '*TTOPTION*=') lcExpr = STRTRAN(lcExpr, 'DUPLEX=', '*DUPLEX*=') REPLACE TAG WITH '', TAG2 WITH '', EXPR WITH lcExpr -------------> error occured here , as it is read only, so it can be replace with everything *** Close the temp report file so we could run it. USE IN ("templabel.lbx") && Close the FRX file Tag: make yourself one... Tag: 207185
  - 3
    - Auto Increment records like a new emplyee number In VFP9 I used the wizard to create an emplyee table, and indexed it on employeeid. Then I used the wizard and created a form to view and enter employee data. The first time I ran the form I used the command buttons and created a new employee and gave the employee an employeeid of 101. Entered all the rest of the table data and exited. The next time I ran the form, it automatically presents the data from the last record (which I thought I could hide by telling the data environment "no data on load", but it still shows the last record) The second thing is when I click add button, there was no indication as to where the cursor is (and I wanted it to start at the top of the form in Employeedid) so I editied the add button in the command group and tried this code, and it does put me where I want to be, but all the other data is still there) On the click event of the add button ThisForm.EMPLOYEEID1.SetFocus Lastly if I gave the first employee the ID of 101 and add a new employee what would you need to to to get it to assune the next emplyee should be 102? Any help greatly appreciated. Dan Tag: make yourself one... Tag: 207173
  - 4
    - Bill Anderson at LA Fox February 8/Using Software Design Patterns Here's a synopsis of the topic at LA Fox this Tuesday...for further details, visit us at http://www.lafox.org. All well structured object oriented architectures are full of patterns. Focusing on these common patterns (Design Patterns) during a system's development can yield an architecture that is smaller, simpler, and far more understandable than if these patterns are ignored. Using these Design Patterns in your development can provide a significant maintenance advantage during an application's lifespan. Like a Japanese haiku (a three line poem consisting of exactly 17 syllables), Design Patterns have a simple construction, but also can be rather hard to fathom. In this session Bill will outline the most common Design Patterns and use familiar Visual FoxPro terminology to illustrate each Pattern. While Design Patterns aren't specific to any software development language, attendees should be familiar with Visual FoxPro terminology and the principles of object orientation. The Jump Start will feature a tour of xCase 7.5. See you there! Tag: make yourself one... Tag: 207172
  - 5
    - FPD report help My client runs a mature many-featured FPD application and I've been asked to modify a couple of the PRG-generated reports. These reports use ?, no FRX involved, and are powered by cursors for the data. The reports have numerous options driven by selector windows. Once the selections are made, the user picks between Screen and Printer. I'm being asked to include an option to create an Excel spreadsheet. I did something like this for them a couple years ago. It was a bunch of work, but I came up with a satisfactory solution. I thought I'd ask here before really getting into this. The printed version supports some stuff that I don't know how I'd support in a spreadsheet. I mean, I can do a COPY TO FILE (lcFilename) TYPE XLS, and if my fieldnames are sufficiently descriptive, it might be satisfactory. But it would be nice if I could include nice things like a page heading and a total line at the end. Is that stuff possible without some weird kludge? Tag: make yourself one... Tag: 207167
  - 6
    - simple outlook example with attachment Here is one using Outlook adapted from past examples posted that works ok for me. Save the code below as a program ie 'the_following_program' Say your file to be attached is in C:\Temp DO \~\the_following_program with 'the_filename_to_be_attached' PARAMETER f_file *ON ERROR DO \SOMEDIR\MY_ERROR WITH ERROR() SET DEFAULT TO C:\Temp f_file="C:\Temp\"+f_file oSession = CREATEOBJECT("MSMapi.MapiSession") oMessage = CREATEOBJECT("MSMapi.MapiMessages") oSession.LogonUI = .t. oSession.SignOn *-- The message control needs to reference the session control's ID. oMessage.SessionID = oSession.SessionID oMessage.MsgIndex = -1 *-- Set up our message and send it. oMessage.Compose oMessage.RecipDisplayName = "receiveremailname@ABC.com" oMessage.msgsubject = "file for :"+ALLTRIM(CDOW(date()))+" " +ALLTRIM(DTOC(date())) oMessage.msgnotetext = " Dear ABC "+CHR(13)+" - Attached is the latest file." *-- Attach the file. oMessage.AttachmentPathName = "&f_file" *-- Send the message on its way. oMessage.send(1) * oSession.Signoff() oSession.Signoff() * ON ERROR SET DEFAULT TO C:\Temp RETURN Tag: make yourself one... Tag: 207165
  - 7
    - Use of MoverBar Listboxes. Help please. Hi VFP Fans, Just having a bit of a problem with Movers (or listboxes with Moverbars = .t.) It is most likely the problem is with me in fact, not the listbox, but you get the idea! The Mover Listbox has 2 columns that I use. 1 A description 2 A number (as a string) I use to identify a record for processing The following properties are probably also relevant. Mylistbox.Rowsource type = 0 Mylistbox.Sorted = .f. Mylistbox.moverbars=.t. I add the items to the listbox in the order I find them in a folder (as they relate to filenames). I currently use the following code to process the items after the user has interacted with the listbox. FOR nCtr = 1 TO mylistbox.LISTCOUNT nScrapID = VAL(mylistbox.LISTITEM(nCtr,2)) IF SEEK(nScrapID) *Do stuff with nScrapID Endif Endfor Now this works fine for working through the items in the list box from the start in sequential order, however I wish to process them in the order they have been moved to by the user. eg A user may move the items up and down the list. I want to process them in the users requested order. (using vfp9) Hope that makes sense. Can you help? Thanks in advance. Darren. Tag: make yourself one... Tag: 207164
  - 8
    - Drag & Drop Hi all, Assuming I want to drag a picture from a folder on my HD to a photo location on my form, how can I get the path of the dragged photo? thank you Hutch -- --------------------------------------------------------------------- "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: make yourself one... Tag: 207163
  - 9
    - Auto Login VSS in VFP Hi, Anyway to set VFP to login to VSS using network name automatically while project opened? I have set "Use network name to automatically login user" to true in VSS admin| tools | options. Thank you Tag: make yourself one... Tag: 207162
  - 10
    - Resetting a grid after a relation I have an application where the users can set relations between any files they have open. My problem is that after they clear the relation, the child grid only shows the last "found()" set of records. What do I have to do to refresh the child grid so that it shows all records after the relation has been removed? Thanks, Scott Tag: make yourself one... Tag: 207157
  - 11
    - 'Use' Command question Hi Everyone; Some of my apps use a text file to store the path to data. When the path has blanks in it such as "c:\program file\..." foxpro does not like the DOS style path. (I am using "use evaluate('variablename')..." The only solution I found was to map the location as a drive such as "K:" and use this in the text file. Is there anyway to use the full path of a directory that has blank spaces or must I stick to using a network path?. TIA Mike Tag: make yourself one... Tag: 207148
  - 12
    - FoxPro 2.6 printer problem I use FoxPro 2.6 for windows on a windows xp machine. The printer is an HP Laserjet 2100TN, and the printout which appears is: PCL XL Error Subsystem: Kernel Error: UnsupportedProtocol Operator: 0x0 Position: 0 What do I have to do to get it to print properly? Reports now are just garbage. The printer prints the way it should stuff from Excel and Word. Regards, Jan Nordgreen Tag: make yourself one... Tag: 207138
  - 13
    - MAILTO: and attachments I am using MAILTO: and shellexecute to send emails from a vfp app. Is it possible to automatically include attachments, found by GETFILE(), and if so could somebody post a sample piece of code? Many thanks Stephen Tag: make yourself one... Tag: 207134
  - 14
    - How i can create a letter template in word ... os: win xp pro vfp: 6.0 sp5 hi, i have some customers that have a company letter template... with logo and adress... how i can create a letter template that my end user can't change logo and adress...only write the letter? TIA ATSP Tag: make yourself one... Tag: 207132
  - 15
    - Compiling to a win32 exe results in DECLARE DLL 'not found' errors I'm attempting to compile a VFP9 project into an EXE. It requires some ActiveX controls that need to be registered, so I've found a handy program by William GC Steinford to register ActiveX DLLs and included it in my project. The function RegSvr has the following lines: DECLARE INTEGER LoadLibrary IN kernel32 As "LoadLibraryA"; STRING lpLibFileName LOCAL lhLib lhLib = LoadLibraryA( pcOCX ) When compiling my project, I get an error: Unable to find Unknown LOADLIBRARY [Locate][Ignore][Ignore all][Cancel] I get the same error for all DECLARE'd DLL functions. If I just ignore them, the project will finish compiling with errors and still be able to use these functions. Does anyone know how to prevent these errors from occurring, though? Tag: make yourself one... Tag: 207131
  - 16
    - mailto and attachments Is it possible to include attachments when using mailto: and shellexecute? Many thanks Stephen Tag: make yourself one... Tag: 207129
  - 17
    - PDF printing Found this: PDFcreator - opensource PDF printer driver (works from any windows app) http://sector7g.wurzel6.de/pdfcreator/ (also on sourceforge) Has two interesting abilities, 1>. print to pdf and email straight away 2>. Automated print to pdf file, you specify directory and file name structure. Just thought I'd share! Have good weekend. Steve Tag: make yourself one... Tag: 207127
  - 18
    - read a file to return a byte array Hi all, How can i use VFP 5.0 to read a file and return a byte array? Thank you. Tag: make yourself one... Tag: 207106
  - 19
    - VFP9 problem with _screen Hello All, I am currently looking at VFP9, and I have a problem with the following code. _screen.addobject("oHook","MyHook1") Define class MyHook1 as Custom oScreen = _Screen procedure oScreen.resize _Screen.sScreen1.resize endproc enddefine sScreen is a container object that resizes when the main screen resizes. In VFP6 this works great, but in VFP9 I get the following error: Unknown member OSCREEN. Is there a quick solution? -- To reply remove 'NoSpam' from email address Tag: make yourself one... Tag: 207104
  - 20
    - Does anyone know what is release date of VFP9 Does anyone know what is release date of VFP9 Developer version? Tag: make yourself one... Tag: 207098
  - 21
    - Control's destroy events don't fire Hi, I have observed strange behaviour. When releasing a form its Destroy event does fire, but Destroy events of this form's controls do not. This happens rather seldom and I have no way to reproduce it. Does anyone has any idea what to do? Thanks, Janusz Czudek WORD Software www.wordsoft.com Tag: make yourself one... Tag: 207093
  - 22
    - Need more solution... This code is origanated from DOS Version of Foxpro and it's really work.. How comes that it doesn't work in Visual Foxpro 7. Is there something missing on this code? This code is to print a Barcode sticker... the '3344556688991' in line 7 is the barcode to be print CLEAR SET PRINT ON SET PRINTER TO LPT1 ESC=CHR(27) STX=CHR(2) ?? STX + ESC + "A" + ESC + "#E3" + ESC + "IG0" + ESC + "CS4" ?? ESC + "V20" + ESC + "H200" + ESC + "BD302040" + '3344556688991' ?? ESC + "V1" + ESC + "H420" + ESC + "WDH0180V001X230Y095" ?? ESC + "Q"+ ALLTRIM(STR(4/2)) + ESC + "Z" + CHR(3) SET PRINTER OFF Tag: make yourself one... Tag: 207089
  - 23
    - Data Environment Hook doesn't work in VFP9 Hi guys, I found that in VFP9 the following is not working: I have de_hook.prg: [vfp_code] PUBLIC oDEHook m.oDEHook = CREATEOBJECT ("DEHook") RETURN DEFINE CLASS DEHook AS DataEnvironment Name = "DataEnvironment" PROCEDURE BeforeOpenTables Messagebox ("I'm in the hook") SET DELETED ON SET TALK OFF SET CONSOLE OFF SET CONFIRM ON SET CENTURY ON SET CONFIRM OFF SET EXCLUSIVE OFF SET SAFETY OFF SET TALK OFF SET MULTILOCKS ON ENDPROC ENDDEFINE [/vfp_code] After I run de_hook.prg in VFP7/8, each time I run any form, the procedure BeforeOpenTables in de_hook would run (hence the messagebox appear). But in VFP9, the procedure wouldn't run. After I run de_hook, I tried ?m.oDEHook in the command window and it returns (Objects) as it should be. Seems like VFP9 just by pass the hook. Are there something I miss? Can anybody help me? If this behaviour is by design (I hate those sentences, 'by design'), are there any way around? TIA, Willianto P.S: I got this method from Igor Korolyov. Hi Igor, have you notice this VFP9 behaviour as well? Tag: make yourself one... Tag: 207088
  - 24
    - How to Keep Mouse Pointer from Changing on Click I have an Image control that performs a task when clicked on. I would like to keep the Mouse Pointer from changing to an Hourglass when it is Clicked but have not been able to by way of the MousePointer property. Does anybody know of a way to keep the MousePointer static while clicking on an Image control? -- Jim D Tag: make yourself one... Tag: 207084
  - 25
    - make copy, not reference, to object? I'm trying to make a temp copy of an object created with SCATTER NAME so i can fiddle with its properties without affected the original, and I am unable to figure out how to copy the object. Every method I've tried results in the temp var being a reference to the original, meaning properties changed in the temp are reflected in the original! Example: CREATE CURSOR Mewp (Foo C(10), Bar C(10), Narf C(10)) INSERT INTO Mewp (Foo, Bar, Narf) VALUES ('do','re','me') SCATTER NAME oMewp oTemp = oMewp oTemp.Foo = 'FAIL' oTemp.Bar = 'FAIL' oTemp.Narf = 'FAIL' ?oMewp.Foo ?oMewp.Bar ?oMewp.Narf How do I make a copy, rather than a reference, to a type EMTPY object? There's no CloneObject() method. I've tried toggling SET COMPATIBLE, does not appear to change the behavior? It seems this should be simple to do! Please help! Tag: make yourself one... Tag: 207074
- Next
  - 1
    - Report form not launching on PC's Hi, On the pc I develope the app, when I click my command button with the following code: REPORT FORM s:\agland\reports\rb_0013rpt.frx PREVIEW it launches no problems. When I do the same procedure on a end user pc, it dows not launch, but no error either. Tag: make yourself one... Tag: 207073
  - 2
    - Adding Textbox to Excel sheet I've gotten most of the elements tocreating Excel sheets and adding data to them. I one to add a textbox to a sheet for some free flowing data. I'm having a problem getting the code from VB to VFP. Here is the VB code: ActiveSheet.OLEObjects.Add(ClassType:="Forms.TextBox.1", Link:=False, _ DisplayAsIcon:=False, Left:=11.25, Top:=322.5, Width:=428.25, Height _ :=47.25).Select Selection.Characters.Text = " .selection.font.Underline = 2" If anybody would know how to add text to it, I'd much appreciate. Thanks. BR Tag: make yourself one... Tag: 207065
  - 3
    - Modifiying a single grid cell Hi, I am developing an application in which I am building a calander grid. Each row in the grid has a control source connected to a foxpro table which determines which day of month it is. I am trying to make it so that todays day will be displayed in bold but I can't find a way to locate todays individual cell in the grid. Anyone have any suggestions on how I would do this? Thank You, -- Kevin Markvenas Software Developer Tag: make yourself one... Tag: 207063
  - 4
    - DLL Creation I'm using VFP7 and created a multi-thread DLL. In VFP the DLL works perfectly. The problem is that everytime the dll is rebuilt the case of the properties change. For example, a property named cAppid will switch between all upper ("CAPPID") or lower ("cappid") or stay as "cAppid". VFP doesn't care about the case, however C# does. After the dll is rebuilt we have to change the C# program to use whatever the new property case. There doesn't appear to be a pattern to what the final case will be. I found a reference in MSDN to the property case problem. The solution was to define the class pragmatically to keep the case of the methods and properties as defined. It didn't work!! The case still changes. Has anyone run into this issue? Is there a work around? Does VFP8 or 9 have this issue? Doug Tag: make yourself one... Tag: 207062
  - 5
    - c compiler capable to create a FLLl Hello, does anybody know a compiler other than Microsoft Visual C++ capable of creating a FLL? (It must be able to process pro_ext.h and winapims.lib from HOME()+"\Samples\API"). It would also be sufficient to be able to return foxpro string type values from a "normal" dll, but so far I'm only able to modify strings passed to a c function by reference. I tried MS VC++ Toolkit 2003 and the lcc-win32. I heard it could be done with borland c++ builder?? TIA, Olaf. Tag: make yourself one... Tag: 207057
  - 6
    - refdef.dbf & reffile.dbf in application data directory? What does VFP8 use these files for and how do we change where they are located? Because they are in this folder, they get copied backwards and forwards to the network when we log off and log on. If the files are large, this can cause unwanted delays in shutting down machines. Thanks for any help. Bernie Tag: make yourself one... Tag: 207056
  - 7
    - REPORT FORM X TO PRINTER PROMPT If you use the above report form command, how can you tell if the user chose to Cancel from the print options dialog that is displayed? Surely there must be a way? Thanks for any help. Bernie Tag: make yourself one... Tag: 207050
  - 8
    - Caption property in a CURSOR Hi, I am using VFP 8 SP1. I have a CURSOR created with CREATE CURSOR command. How can I change the "Caption" of a field of the above CURSOR so that when I do a BROWSE command the "Caption" of the field will be visible. Thanks in advance. Regards, Derek Tag: make yourself one... Tag: 207043
  - 9
    - sqlsetprop option ? hat are need to be set in sqlsetprop property to make the db server wait longer if the network is busy instend cutting the connection ? I'm currently using all default value any help/advice ? Sen Tag: make yourself one... Tag: 207036
  - 10
    - image in report is just printing the filename (vfp6) (Please ignore if this is a duplicate - I tried to send this about an hour ago and it still has not shown up in my news client) I have a workorder report that my clients want to have their company logo on I am loading the company.bmp into a general field in a cursor and the field is referenced in the image control on the report This is working fine on my pc (and other pc's in my office) but not on the client pc has anyone heard of this before? Is there a resolution? TIA John Tag: make yourself one... Tag: 207035
  - 11
    - image in report is just printing the filename (vfp6) I have a workorder report that my clients want to have their company logo on I am loading the company.bmp into a general field in a cursor and the field is referenced in the image control on the report This is working fine on my pc (and other pc's in my office) but not on the client pc has anyone heard of this before? Is there a resolution? TIA John Tag: make yourself one... Tag: 207030
  - 12
    - Suggestions to learn .Net for developers who only know VFP I will like some suggestions how to train VFP developers who do not know VB or VC to learn .Net. Are there any good books, webcasts, and articles that will help? Thanks. Tag: make yourself one... Tag: 207029
  - 13
    - Forms Hello, I was wondering if there is a way to tell FoxPro to skip printing a page of a report if a specific variable is zero for example. Emily Tag: make yourself one... Tag: 207024
  - 14
    - Filer Hi. Finally had a chance to the VFP6 filer. I've been trying to modify = it to be more like the Foxpro 2.6 filer. Here's what I have so far: In Foxpro 2.6, when you edit a file selected by filer, you can do a = [Ctrl]-[G] for the next occurence of your search text. For the VFP = filer, I modified the filer.scx form. In the first search textbox, I = added _CLIPTEXT =3D ALLTRIM(This.Value) to the LostFocus of the 1st = search textbox. When I run the VFP filer, however, I have to first = [Ctrl]-[F], then [Ctrl]-[V]. Question. Does anyone know a way to get = ALLTRIM(This.Value) directly into the VFP find dialog box? Here's a tip: The Foxpro 2.6 filer automatically MODI COMM all selected = files. To do the same thing in the VFP filer, do a MODIFY FORM = filer.scx METHOD FIND. Find the following lines in the find procedure: = THIS.lstFiles.AddItem(IIF(LEFT(m.cFileName,2)=3D"\\","\"+m.cFileName,m.cF= ileName)) ENDFOR Before the ENDFOR, add: THIS.lstFiles.Selected(THIS.lstFiles.ListCount) =3D .T. To the very end of the find procedure, add the line: THISFORM.EditFile Getting close. Any help about the find dialog box would be greatly = appreciated...Dennis Tag: make yourself one... Tag: 207023
  - 15
    - Password Protect a report on a command button Hi, It has been a long time since I worked in VFP, and I recently got the new V9. I have imported an old project no trouble, and am working with it. I have a Commandgroup that I want the user to be able to clic to view a report. In the "click event" on the command button I have: REPORT FORM y:\agland\reports\rb_0013rpt.frx PREVIEW However I require that the user has to provide a password before any info is show, Any assistance greatly appreciated. Dan Tag: make yourself one... Tag: 207022
  - 16
    - disable "save as" "open" in word automation os: win xp pro vfp: 6.0 sp5 hi, i need to disable some menu options... like "save as" and "open"... is it possible? if so..how i do that? TIA ATSP Tag: make yourself one... Tag: 207018
  - 17
    - Automating Excel Right now I have an excel sheet which gets created in foxpro and was wanting to freeze pane the first row in that excel sheet. Does anyone know how the freeze pane from excel's Window menu gets called on a row? Thank You all Travis Tag: make yourself one... Tag: 207012
  - 18
    - label problem please help I have a label application. it didn't work after I had created setup.exe with installshield express. the error message is " cannot update the cursor templabel, since it is read only." the code in the program is following. ____________________________________________________________ COPY FILE 2x11.lbx TO templabel.lbx COPY FILE 2x11.lbt TO templabel.lbt *** Open the temporary report file USE templabel.lbx IN 0 SELECT ("templabel") GOTO TOP * Strip some information from EXPR. Remove the driver info. lcExpr = Expr lcExpr = STRTRAN(lcExpr, 'DEVICE=', '*DEVICE*=') lcExpr = STRTRAN(lcExpr, 'DRIVER=', '*DRIVER*=') lcExpr = STRTRAN(lcExpr, 'OUTPUT=', '*OUTPUT*=') lcExpr = STRTRAN(lcExpr, 'DEFAULT=', '*DEFAULT*=') lcExpr = STRTRAN(lcExpr, 'PRINTQUALITY=', '*PRINTQUALITY*=') lcExpr = STRTRAN(lcExpr, 'YRESOLUTION=', '*YRESOLUTION*=') lcExpr = STRTRAN(lcExpr, 'TTOPTION=', '*TTOPTION*=') lcExpr = STRTRAN(lcExpr, 'DUPLEX=', '*DUPLEX*=') * Replace TAG, TAG2 and EXPR REPLACE TAG WITH '', TAG2 WITH '', EXPR WITH lcExpr *** Close the temp report file so we could run it. USE IN ("templabel.lbx") && Close the FRX file _____________________________________________________________ do you know how I can fix the problem. Thank you for your help Ming Tag: make yourself one... Tag: 207010
  - 19
    - FRX2Any v. 10.00.00 released FRX2Any now has its own Chart Engine. FRX2Any Chart Engine allows you to analyze and display data graphically on the web, or within a FoxPro desktop application. www.frx2any.com Tag: make yourself one... Tag: 207004
  - 20
    - Frameworks? Hi Guys, During my lunchtime Google I kept coming across Frameworks. What exactly is a framework? Steve Tag: make yourself one... Tag: 207002
  - 21
    - should set decimals do this? Small oddity in testing some code SET DECIMALS TO 2 pcdiff=((120001/100000)*100)-100 ?pcdiff && shows 20.00 as expected ?pcdiff>20 && shows .F. as expected SET DECIMALS TO 10 ?pcdiff && shows 20.00 - I expected to see 20.0010000000 Clearly the variable pcdiff has precision beyond the display setting because of the logical comparison. Why can't I see it in the debug window (or anywhere) unless I set decimals before the calculation?: SET DECIMALS TO 10 pcdiff=((120001/100000)*100)-100 ?pcdiff SET DECIMALS TO 2 ?pcdiff Admittedly the help entry for SET DECIMALS says **************** SET DECIMALS specifies the minimum number of decimal places used to display the results of division, multiplication and trigonometric and financial functions. **************** and one could argue that this magic display setting was made at the time I assigned the calculation to pcdiff and hence subsequent changes to SET DECIMALS makes no difference. But I would then argue that this should show 10 decimal places: SET DECIMALS TO 2 pcdiff=((120001/100000)*100)-100 SET DECIMALS TO 10 ?pcdiff*2 && shows 40.00 - I expected to see 40.0020000000 Do I have to use a workaround such as ?pcdiff+0.0000000000 ?str(pcdiff,14,10) etc. I was rather puzzled the debug window did not show all the significant figures. -- Regards Andrew Howell Tag: make yourself one... Tag: 206999
  - 22
    - HTML sript Hello! I can write html sript from web pages (example: www.microsoft.cz) to fox variable. Have You any experience? Karol Tavac. Tag: make yourself one... Tag: 206996
  - 23
    - Ordering within a table Hello, I would fist like to thank all who replied to my previous post. It helped tremendously. I have another issue, now. Let say I have a table called customer. And in customer we have a field called Invo_num, Lastname, and invdate. How can I get my table that looks like this: Lastname Invo_num Invdate Smith 100 1/15/05 Smith 101 1/15/05 Smith 102 1/15/05 Lewis 103 1/15/05 Lewis 104 1/15/05 Smith 105 1/16/05 To look like this: Smith 100 1/15/05 Smith 101 1/15/05 Smith 102 1/15/05 Smith 105 1/16/05 Lewis 103 1/15/05 Lewis 104 1/15/05 So I need them to be ordered by the lastname, but also within the sub group of lastnames, it needs to be ordered by invoice number. Thanks in advance. Tag: make yourself one... Tag: 206985
  - 24
    - Can't double click joins in VFP8 view designer This is something I've noticed but never bothered to discuss. In VFP7 and prior versions, in the view designer in the upper portion where you have your tables displayed and the links between them represented as lines connecting table to table - you can double click on the link and a dialog appears that lets you choose the join type. In VFP8, double clicking does nothing. Is this a "feature" of VFP8? If so, it's a rather annoying feature. Is there another way to get to the join dialogue? Right now I'm making a lot of my queries in VFP7 and the importing the produced code into VFP8. Tag: make yourself one... Tag: 206974
  - 25
    - barcode Hi. I have a VFP6 client who wants to start printing barcodes off her = application. I haven't seen it yet, but she's getting a barcode printer = to print AIGA labels. I'm not sure how this will work. Will I be = sending printer control codes to the printer, which would print the = graphics? Or will I need a third-party add-on for VFP6? Tag: make yourself one... Tag: 206970

hi ppl,

why don't you make your onw code bar?! i 've make my self an EAN-13 and
EAN-8 code bar.. and work perfectly as much in screen ou printing!!! and
isn't so dificult to do it!!!

the only problem is that a can resize the code bar..the code bar is fixed to
a height and width...

ATSP

Top

Re: make yourself one... by Andrew

Andrew
Mon Feb 07 09:29:22 CST 2005

AP wrote:
> hi ppl,
>
> why don't you make your onw code bar?! i 've make my self an EAN-13
> and EAN-8 code bar.. and work perfectly as much in screen ou
> printing!!! and isn't so dificult to do it!!!
>
> the only problem is that a can resize the code bar..the code bar is
> fixed to a height and width...

Was this meant to be a reply to another question?

I don't bother drawing my own barcodes because it's a lot easier to let my
printers do it themselves, they have a command for it.
If you're looking for general information regarding drawing them, there are
a series of excellent articles [in C++] by Neil Van Eps here:

http://www.codeproject.com/script/Articles/list_articles.asp?userid=27953

--
HTH
Andrew Howell

Top