Answer Questions

• Spyros Sakellariadis Populating a grid - strategy.

  Hi all - another newbie question: I'm trying to have a grid populated by a sql statement. I am wondering if the proper strategy is to create the grid in the form designer by dropping the original table from the DE into the form, and then tweek the fields, record source etc, or do the whole thing in code Thanks, Aleniko I create a table from the sql as readwrite exactly as it will appear then use the form d ...Show All

• asbuilts Character string

  I have  textbox.how can i select the first letter in it for example if 1st letter in textbox1="a" then messagebox ("ok") thank you all You need to test each List Item in this case, not the value (the value is only the currently selected item). Code like this will do what you want: loTgt = ThisForm .AllPages.Page6.cListBox WITH loTgt   FOR lnCnt = 1 TO . ListCount     IF LEFT ...Show All

• Bill Sabey Strange Visual FoxPro provider error

  Hi, I'm getting a really strange error. I use the Visual FoxPro OleDb provider to access a FoxPro .dbc database. I have a table where I have several Numeric fields that're giving me problems. When my application tries to access the .dbf table, most of the time it runs OK, but on certain rows the provider cannot access the data in them and throws an InvalidOperationException. For example, I have a field called BMI, type: Nume ...Show All

• Michael__H ensuring data integrity using cursoradapters

  What is the best way 2 ensure that no partial updates occur when using cursoradapters on VFP8 Currently am issuing different TABLEUPDATES for all the cursors open. I am using an Access databases. Is there something like BEGIN TRANSACTION...END TRANSACTION when using CursorAdapaters Please give me the best approach to ensure data integrity and consistency. Thanks. Ooops.  Craig is right, of course.  I ...Show All

• Chris Haas Projector - I want to display only part of the screen to a projector

  I have a program for displaying the lyrics of the gospel songs. We use the projector. Question: I don't want everything on my screen to be displayed on the projector. I want to hide some buttons and grids on the projector but still I want to see them on my main screen. Please help. Thank you and God bless you. Rolly Militar Sydney, Australia Projectors are really just a fancy ...Show All

• Naraine HOW TO CONNECT TO MSDE 2000????

  Hi... I have a problem: I want to connect the FoxPro to an MSDE 200 server...because I need to create an MSDE database and interrogate it! I want to use the OLEDB, but I don't know how I can make the connection to an MSDE server in Fox! So, I need a help to:     make a connection to MSDE server     the command that allow me to create and administrate an MSDE         server wit ...Show All

• pp11oo22 string func failures? bugs?

  I found that when applied to THISFORM.Edit1.Text, VFP native EDIT control, the following functions always return 0: AT( ), ATC ( ), ATLINE( ), OCCURS ( ) They cannot be used for any purpose. The following functions work: LEN ( ), $, SUBSTR ( ) I did not bother checking RATLINE( ) , RAT( ) and RATC( ). I presume, they would fail also. Is it a bug Also I found oddly enough that command COPY FILE fileName1 to fileName2 fails i ...Show All

• SQL Sifu ListBox: Default to single record in list?

  I am using the form designer and I know that there must be a way to default to a single record in a list box, but I am having difficulty figuring it out. I want the value of the list box and the bar to default to a preselected record. I am using a table as the rowsource and fields as rowsource type. I am using SEEK to goto the default record, but I cannot find a way to return the value of the record within the list. Thanks in advance. ...Show All

• abrisham help!!! how to show record no - recno() in grid vfp6

  hi, i have tried to search a lot but i have not been able to get code how to show the recno in the grid. in browse command i could easily show tempfld=recno() i have tried thisform.grid1.column1.controlsource = recno() - this gives error thanks, gagan sachdeva_g@yahoo.com You can show calculated fields in grid too. tempfld correspond to header.caption and recno() to controlsource. ie: Public oForm oForm = Cre ...Show All

• silgenfritz only VFP can control VFP

  is there a posibility that we can open a VFP appilication at a remote location without using any 3rd party software like pcanywhere .  Example...I am at the server and want to re-open a VFP client application which is closed by the user at the client PC.  i am using winsock for the communication between my VFP server applic. and VFP client applic.  pc How could we do that Is anybody has an idea ... Because I want m ...Show All

• CharlesLing there is a problenm when save unicode data into SQL Server

  Dear Expert: I am facing a problem which is after the Asia characters saving to SQL server (MSDE version), the field will show all question marks, the develop enviroment is VFP 8.0 and the Windows system is already configured to Unicode, the VFP collecting Sequence is configured to Machine. I have also set the field format in database is nVarChart, when I manually key in these Asia characters, the SQL server is accepted. Any response is ...Show All

• cerulean47 VFP9: Customizing the location and size of autocomplete dropdown?

  Is it possible to customize the autocomplete dropdown feature introduced in VFP 9 so that the dropdown is left aligned with and sized to the width of its parent's control Perhaps there's a way to bindevent() to a Windows message associated with the dropdown's creation so that our applicaiton can PostMessage() a request for the dropdown to size and align itself based on our specifications VFP9 ROCKS! Malcolm ...Show All

• HKSunny small test on transaction atomicity

  Need help with small test on table in database with transaction. Could somebody show state of table after execution this code: CLOSE ALL CLOSE DATABASES OPEN DATABASE "c:\ path to database\data1.dbc" SHARED BEGIN TRANSACTION UPDATE data1! table 1 SET name = 'BBBB BBBB BBBB BBBB BBBB' = Messagebox ('END TRANSACTION') END TRANSACTION if in table1 before execution was 500K records with value "AAAA&q ...Show All

• codeless Pageframe color problem

  I'm having a problem with using a pageframe. The problem is that I can't set the backgroundcolor properties of any of the pages. It defaults to 236.233.216 which is a some kind of pink but it shows as a light grey. I can change it but it stays light grey. I've tried this on a few differant computers. Very wierd. Anyone have any info on this Thanks That's it! I don't know how it got set this way. It was working ...Show All

• jagotaas access to this.propery

  I've made a class 'adreslijst' and in it's init method I added a string property 'lijst' like this:    this.addproperty('lijst', "bla") in an other method ('export_lijst') that I added to the class adreslijst I want to print the contents of the property 'lijst' like this:     this.lijst when I execute the following code:    object1 = CREATEOBJECT('adreslijst')    object1.export_lijst() ...Show All