Search results for query: *

I have a series of numbers with various precisions: For example a(1)=12.34 a(2)=134.234 a(3)=1343456543.343234323 I wan't to transform these numeric values into strings but I want to retain the original precision. I know that for example, if I wanted to round to 2 digits I could use...

Hi, When programming Excel from VFP 8.0 is there a way to display a sheet in print preview view on entry instead of the standard grid sheet? I also have code to display some text over serveral columns using the merge command, this works fine, except that I would like the row height to adjust...

My question is more of a "what is VFP doing?" For example, I have been performing a search of a character field, named sampleno. This field is indexed and a common search would be to find a sampleno that contains "ABC". The database is located on a server and this search is run from a local...

Hi, I have a menu bar that contains cut/copy/paste items _med_copy etc... This menu bar was created using the wizard and displayed using do menuiso.mpr ( I am using VFP 8.0 sp1) This works fine various cut/copy/paste items are enabled/disabled depending what type of control is being edited...

I have a multi-line edit box and a grid that displays the typed text. The problem is when the user includes a return in the edit box the return appears as a square character in the grid. When I browse the database record the return is represented as a double vertical line character. Anybody...

Hi, I am trying to display the number 0.00000009 using scientific notation. I set the .format property of a text box at ^ and it displays 9.0000E-8. I would like to control the precision of the number displayed. For example I want to display 9.0E-8. I tried setting .format to 9.9^ and #.#^...

I use the following code to scatter a series of records for a view I created from a larger table ar_raw PUBLIC giNberofRawToKeep select tmp_monraw giNberofRawToKeep=RECCOUNT() PUBLIC ARRAY gmRawToKeep(giNberofRawToKeep) GO top FOR t=1 TO giNberofRawToKeep SCATTER NAME gmRawToKeep(t)...

I have an OCX control called Metadraw. This allows me draw and edit graphs. In Visual Basic to print the content of the control (MDdraw) I would type Printer.Print "" MDdraw.ExportDC=Printer.hDC Printer.Newpage Printer.Enddoc The code SET Printer ON SET printer OFF does result in a...

I am trying to add a custom text box to a grid without success. I created a custom textbox called mytextbox using the class editor. In the click event I placed the text messagebox ("Hello") I then created a form and added a grid control to the form. Using...

I have a form and I would like to set it's width to 50. The problem is that VFP 8.0 does not let me set the width property value to less than 106. I tried looking under tools/options but this does not seem to be set anywhere. Anyone have any idea I to bypass this limitation. Thanks, for your...

I have geochemical data which I display in the grid control using VFP 8.0 Sample Sio2 TiO2 etc... A1 65.47 3.45 ... A2 56.67 4.56 ... A3 62.24 1.34.... etc.. My users would like to flag certain data in the grid. For example A1 SiO2 value set to a red background...

Hi, I have a form that contains the tables rockfile and gsc_age in the data environment. In the load event of this form I create a view called tmp_rock which includes fields only from rockfile. Here is an example SQL CREATE SQL VIEW tmp_rock AS SELECT DISTINCT r.* from rockfile r, gsc_age a...

Hi, I have a calculation routine which get its data from a view called tmp_step. I want to make the procedure more generic. lnRatio(1)=tmp_step.m40_39 lnRatio(2)=tmp_step.m36_39 lnRatio(3)=tmp_step.m37_39 lnRatio(4)=tmp_step.m38_39 etc... For example, so that it can get data from either...

Have any of you ever had this problem? For some odd reason on one machine the copy paste is not working properly eventhough it had been working fine in the past. When I start the application I can copy/paste between text boxes without a problem but then after a little while it will not work...

Hi, I want to drag a list item from a listbox to a textbox In my listbox I place the following code in the mousedown event LPARAMETERS nButton, nShift, nXCoord, nYCoord this.Drag(1) and in the dragdrop event of the text box LPARAMETERS oSource, nXCoord, nYCoord...

Hi In my program I want to position 3 forms in my main vfp window *first I maximize the screen _SCREEN.windowstate=2 .. do some other code *make it visible _SCREEN.visible=.t. *load the menu bar do mainmenu.mpr *display the top main toolbar goMainTB.show *display a toolbar to the left...

Hi, I have some code that adds columns to an excel sheet. My problem is when I go behond the Z column, I get an error. I know that Excel numbers form A...Z the AA AB etc... My question is does anyone know of a different way of accessing each column and avoiding writing a complex string building...

I have an x-y diagram consisting of a few data points. I would like to draw a line around these data points. So essentially what I need is a routine to calculate the polygon that contours these data points. I am not looking for the routine to draw the polygon but only to calculate the points...

I have a series of bitmaps line1.bmp line2.bmp etc... That represent different line styles that I want to user to pick from How can I create a combo box (list style) that will display these bitmaps as items? Thanks for your help Linda

I have a gif of a notebook which is from a web page. I would like to tile this gif from top to bottom on my form. I want it to appear as a background behing my controls. Any suggestions on how I can do this. Thanks Linda