Answer Questions
Sperin Bug in VFP 9? Adding an object to an array with AddObject.
We have this base class that basically implements a collection (I know there are collections in VFP, but we can't change this overnight). Part of the process is to add an object to an array. This code word flawlessly on VFP6 for years. this.ItemCount = this.ItemCount + 1 Dimension this.Item[this.ItemCount] Local cItemPlace cItemPlace = "Item[" + LTrim(Str(this.ItemCount)) + "]" this.AddObject(cItemPlace, this.ItemClassName, &tInitParame ...Show All
Khaled Hussein WinSock
I just tried Microsoft WinSock OLE Control 6.0 (SP4). It binds to a port and it goes into a LISTEN state but I cannot figure out how to unbind the connection. Close() method does not work, SendComplete() does not work either I do not know why Other methods do not seem to be relevant. Does anyone have any experience with WinSock Thanks. I don't have any experience with Winsock as I don't use it, but maybe these Wiki entries may be o ...Show All
crimzonthunder MSGraph.Chart.8 control
I need to make charts. I started with MSChart Control and so far I've accomplished almost all I wanted except for one thing which totally eludes me. I need a simple line chart, not columns or a pie. I need to display a row of data like DJIA or similar indices with no additional vertical bars or other embelishments. The curve comes out nice but a lot of space on the chart is wasted because the curve is being plotted too high on the chart in ve ...Show All
Dawa how to change field values?
I am looking for a way to address fields to change their values. I cannot understand how it can be done in VFP. For instance, if I use two statements which open a database table with a few fields in it, what do I do next USE DatabaseVfp1 tcp_ip IN 0 as cTableAlias SELECT ALL FROM cTableAlias cTableAlias.fieldName1 - what does this expression give me Is it the field value or just a field name Can I write: cTableAlias.fieldName1 = ...Show All
BRao Help in VFP 6
Hello! I would like to know how can I auto-increment a field in VFP 6.0. The field is for storing an ID and it's of type numeric. Can anyone suggest a piece of code I would like to know how can I auto-increment a field in VFP 6.0 First you need to create a table to store the next value of the integer primary key for each table in your database. Table with this structure: Structure For: SYS_TABLE.DBF ...Show All
emuesch Another question for the day, Listbox limits
Hi, sorry for posting two questions in one day. I was wondering if there is an easy way to limit the amount of items in a listbox. For example, i am getting information off of a SQL server and putting the information in the listbox. However, there is a lot of information, and I don't want more than the newest 200. Is there a simple way for me to do this lil_isie wrote: Also, I'll make sure I keep myself posting here then. I ...Show All
Anandan foxpro exe and dbf's, fpt's, bak's, tbk's, but now prgs etc.
foxpro exe and dbf's, fpt's, bak's, tbk's, but now prgs etc. I was given a foxpro program and i would like to see the code (the formulas)... i'm not sure how to do this... thank you... modify command <insert your prg file here> modify form <yourformname> use <yourdatabasename> thank you... after reading the replies, i guess i'm asking how to read the code behind the form ...Show All
zobrakster Foxpro ODBC -- Call failed
Hi, I recently upgraded from 2000 to 2003 and have hit a problem with new ODBC calls. I have an ODBC link to a foxpro table using the Visual Foxpro driver. When I open an existing database I can open the tables but if I try to link to more tables using the same ODBC driver I get the above error. If I log on either locally or on the network as Administrator I have no problems creating new links and I can even open these new connections when I log ...Show All
Davidcw Word in Visual FoxPro?
Hello, new to the forums, and I have a quick question. I am currently working on a program for a Community Health Clinic, and I am working on a form for diagnosises. What I want is a dropdown box for which diagnosis to pick (which is fine), a text box for the date this diagnosis was diagnosed (done with ease), and one other thing that is giving me trouble. I would like to have a Microsoft Word style text area where a doctor can put his/her infor ...Show All
edy604 migrating VFP app to .net (architecture question)
Hello everyone! I'm a fairly experieced database developer (SQL Server primarily, and Oracle quite a bit less). My experience with .net is primarily vb.net to built asp.net applications, using web services as my middle man. I just started at a new company which has a few legacy systems, one of which is a rather large FoxPro application. There are a host of problems associated with it, primarily data conflicts. Because the company has grown so mu ...Show All
SDCripps RSA Public/Private Key Encryption in VFP 9.0
Hi, I need to be able to decrypt data pulled from a MySQL table encrypted with RSA public/private key encryption within a FoxPro application. I am currently using the FoxPro Foundation Class known as _cryptapi as a wrapper to the CryptoAPI interface. The problem I'm having is that I can't seem to figure out how to decrypt a RSA encrypted string of data. I know that the _cryptapi class provided by Microsoft uses the Microsoft B ...Show All
mgalliers selectedItem problem
Very unexpectedly I ran into this problem today. I think similar statements are working fine in many parts of my forms. o_Ole_TreeViewP7 is a treeWiew on page7. When I turn the pageframe to page 7 I want to make sure that accidental clicking on some buttons on the page won't result in a break up. I mean BEFORE the cursor is positioned on a certain item of the treeView. After the first selection has been made the treeView.SelectedItem is defined. ...Show All
Baskar Joshi Using SQL Pass Through to Access my Remote Data Source
Here's the source code which I copy from QUE Book('The One Source for Comprehensive Solutions' by Menachem Bazian) //*using SQL PASS THROUGH TO ACCESS DATA SOURCE *// LOCAL lnHandle lnHandle = SQLConnect("My Remote text") IF lnHandle > -1 SQLExec(lnHandle, "SELECT customers.* FROM customers","Results") SELECT Results BROWS SQLDisconnect(lnHandle) ENDIF I try that sample, and a ...Show All
V&#237;tor Ferreira how do i get a result in 4 tables in SELECT- SQL command?
good day to the experts... My transaction has 4 tables, 1 for recording the amount of loan, 1 for check payment, & 1 for cash payment, and the vendor table. Below is the tables and its corresponding fields *// vendor table 1 (FIELDS=acct_no, acct_name,address, totalamount) * // loan table table 2 (FIELDS=or_number,acct_no, loanamount, or_date) *//cash payment table ltable 3 (FIELDS=child_numb, or_number,acct_no, amountpaid, ...Show All
jattali DISKSPACE() trouble
I have an ActivX OleControl Microsoft treeView V6.0 and as a part of Init() procedure I use DISKSPACE() function just to determine which disk drives (physical as well as mapped network drives) are currently available. If the drive A: does not have a disk in it I get repeated error messages: " Drive is empty, please insert...." It does not do anything like this with DVD/CD R/W drives. They are empty and it is OK. Likewise, if I simply click o ...Show All