Answer Questions

• Johny_Extreme FoxPro v9 vs Visual dBASE Plus 2.01 BDE 5.2.02

  Hi there. I just installed a Visual FoxPro 9.0 and started "playing" with it. Tried to create a table - it is straightforward and then a form. It seems to be a rich platform. Something puzzles me though. I do have extensive experience with Visual dBASE PLUS and previous versions in terms of OO language and form/table designer. Thus I am trying to compare. I am attempting to migrate to MS software/platforms wholesale since the dBASE is offering l ...Show All

• Robert135 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

• LonelyPixel 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

• Nathan Baulch VFP 7.0 and ASP.NET

  Friends, I developed an application with VFP7.0 and ASP.NET . Every thing is going good except one problem. Once in a while application is crashing when I am executing sql statements and it is giving error like "Object Reference not set to an instance of an object". I tested the connection status and it is good. I am thinking that, it is happening due to some Record Locking mechanisms. My application is intranet application. ...Show All

• Lare select with alltrim bug???

  Please try this... CREATE TABLE C:\FOX\TEST (STRNG C(5)) INSERT INTO TEST (STRNG) VALUES ('A ') INSERT INTO TEST (STRNG) VALUES ('AAA') INSERT INTO TEST (STRNG) VALUES ('AA ') INSERT INTO TEST (STRNG) VALUES (' AA') INSERT INTO TEST (STRNG) VALUES ('B ') INSERT INTO TEST (STRNG) VALUES ('AB ') INSERT INTO TEST (STRNG) VALUES ('ABB') INSERT INTO TEST (STRNG) VALUES (' AB') INSERT INTO TEST (STRNG) VALUES ('C ') INSERT ...Show All

• Kenny Lyon can i just use sql to get this?

  date           transfer 20050101    200.00 20050103   -100.00 20050530     95.30 ... SQL to get： date         transfer          balance 20050101   200.00         200.00 20050103   -100.00 &nbs ...Show All

• def0 How to get IP Address on Clien of LAN....? Help me!!!!!!

  Hi,! I want get IP Address on Clien of LAN, but I don't know what to use for get it. I need your help, please. Thanks all...!     How about :- o = CREATEOBJECT("MSWinsock.Winsock") o.LocalIP HTH, Robbo. If you need to get IP address of any client i LAN, you can use something like this : DECLARE INTEGER WSACleanup IN ws2_32 ...Show All

• Jasmine_Yen table manipulation

  Two tables exist, call them tableA and tableB. They share some data. which was easy to get select a.work_id, a.sp_id, b.work_id, b.sp_id; from tableA a inner join table b on (a.work_id = b.work_id); order by work_id; into cursor hold1 there is still a matter of getting all the data from tableA and tableB that they don't share. i tried doing a left outer join, but i still get duplicates. Any ideas MP dave, you all over these threads....ur ...Show All

• elmoman Find Object by caption

  Dear Experts There are some command buttons on a form and one button's caption is "Close". I want to findout that button and click on it. How is it possible What commands should I write on the click event of another command button to findout "Close" button I got following codes from somewhere but did not work. Please modify or suggest some others. LOCAL i FOR i= 1 to thisform . controlcount IF thisform . controls (i). baseclass = 'commandB ...Show All

• rcdias Customising RI messages

  Hello I'm after a bit of advice. I'm currently revisiting Foxpro after a period of 10 years. I am in the process of designing a database for a customer that will include Referential Integrity. I have RI working - no problems. What I would like to find out is how you customise the RI error messages. I would like the user to see an error message they could understand rather than something like "Table insert fail:trigger failed". I have looked t ...Show All

• Matthew Petersen VFP

  In VFP 8.0 I have a table build and need to write a prg that well look in a fold and what ever files it sees it import or append in the existing table. The files that it will import or append will always be in the same format and have the same structure. I'm new at this. Any help would be great. Thanks, Brian Something like: use myTable lcFolder = getdir() for ix = 1 to adir(aFiles, addbs(m.lcFolder)+'*.txt')   append from (addbs( ...Show All

• macky100 Grids are readOnly. How do I put text in them?

  Hi there. Kind of embarrassing asking simple question when other people post such advanced requests. I am new here. I got as far as creating a form with two grids and other controls I need. There is a Pageframe that switches between pages and I have each grid on the corresponding page. All the way I am making comparisons with dBASE stuff which I hope soon will be a thing in the past. Anyway, when I run the form all rows in grids appear to be rea ...Show All

• mthierauf what is the maximum field VFP9 can handle

  Good day to everybody... just a little problem with my update at VFP interface with my back-end database I dont have this problem updating my employees table in SQL2000 with 35 columns at my VFP interface, but recently I add another 3 columns at my table, that's where I encounter this problem. Inserting a new record or deleting there's no problem, but when i edit a particular record then saved the changes,the update is OK.. but after I clo ...Show All

• Igor Taranov -- MSFT editbox control snaps.

  It is a fairly mild problem but still an inconvenience. I have an editbox and a text is assigned to it in the following manner: THISFORM.Pageframe1.Page4.Edit1.ControlSource = "(ThisForm.cData)" All other operations are done programmatically. I may force it to count the number of lines and go to a specific line and highlight it. It does. But then after a while, perhaps in about 2 minutes, it snaps to the first line (beginning of ...Show All

• nickblair0 connecting to foxpro table from asp or php

  I am having a problem and I can't seem to find any info on the internets to help me.  I'm trying to connect to a VFP free table that is on a separate machine on the network.  I want to do it inside of either PHP or ASP.NET.  Doesn't matter which at this point.  I seem to be able to establish a connection with the table, but I get an error when I execute the query.  Example php code: < php include('adodb.inc.php'); in ...Show All