Answer Questions

• Shamez Hyperlink to launch VFP8 executable program with parameters

  Hi, My client has asked me if I it's possible to start his VFP8 exe from say, a hyperlink in Word and get it to open the relevant item on a certain screen. So I need to pass a parameter to the program with the ID of the item he needs to open. I've tried various formats such as ... c:\Program Files\Company\AppName\Program.exe -001 and "c:\Program Files\Company\AppName\Program.exe -001" but I can only get the program to start and the f ...Show All

• ppkapo n-tier design

  I am designing an application and I want to start using n-tier design. I have no problem with the user interface but have some questions about the business and data tiers. My application will probably be all in one vfp exe so I don't particularly have to get into ADO or XML. Am I correct in assuming the actual data reading and writing statements (eg Replace, Insert etc) go into the data tier I am thinking that I would need some sort of data hand ...Show All

• Nick.Muguira Connecting VFP applications on Wide Area Network (Client-Server).

  How do I connect VFP Application running on windows Small Buisness Server through WAN Dear Sir, We are using a VFP application running on Windows small business server 2003. We are conneted to different clients in-house using LAN and a switch. Now we want this application to be available on WAN to different branch offices located more then 50 KMS away and more. How do we establish a online connections fo ...Show All

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

• Daisy34001 CRLF --chr(13)+chr(10)--> .Selstart Dilemmas in myEditBox

  MyEditBox.SELSTART CHANGES during keypress events, interactive change events and/or programmatic change events when line-feeds (LFs) aren’t paired with (CRs): E.g., ‘LineFeeds’ [chr(10)] …seem to… insert themselves after every ‘carriage return’ [chr(13)] during *certain* run-time keypress events. Likewise…COM imports (e.g., oWord values) don’t seem to have paired CRLFs in them, but CRs only. VFP-9 seems to *prefer* paired ...Show All

• tori K empty field

  is there a better way of checking for empty fields than select *; from myTable; where field1 = " "; into cursor data1 i need to run a complete check on the database for empty records in every field. How would i check for a 'date' data field Mike It appears that one needs to do EMPTY(ALLTRIM(Memo1)) for it to return .T. Dennis Unfortunately alltrim() doesn't trim all whitespace characters. ch ...Show All

• Jezz Santos Limit edit box

  I have a issue with an fox app where I need to limit a editbox to no more then 3 lines of 40 characters. three text box controls will not provide the word-wrap support I am looking for.. Is there away to do this chris krelle I'm a little late in responding, however, why not use the interactivechange event. This will give you complete control of what's typed. Don, Thank you, however from what I ...Show All

• JPD how can i get the current active control's name in a form?

  thank you Jet Hi Jet, if you don't don't need the name of the control inside a grid you can use code like this to get the name of the active control: IF TYPE("Thisform.ActiveControl") == "O"   lcName = Thisform.ActiveControl.Name ENDIF It's important to check the type beforehand, because the ActiveControl property doesn't exist if there's no active control. For grids this code would return the name of the grid, not the name of th ...Show All

• NF Good references for a beginner?

  I've already done most of the sample walkthroughs and read the documentation that comes with VFP9, however I still feel as if I'm lacking understanding on the bigger picture. Could someone please cite some good reference material for a beginner in both programming and VFP9 Also, when looking for reference materials, how different is VFP9 from VFP8, 7, etc The reason for my asking is that I found some suitable books online but they're written for ...Show All

• mhtmht Obtaining a web page's title

  I'd like to get the titles of web pages, and would prefer not to do this by loading all the web pages into a webbrowser, because that seems a bit heavy handed. In VB6 I used some APIs to achieve this, but I'm not having any luck in getting it to work in .net. Here's the code I'm trying: Module Module2 Private Const INTERNET_FLAG_RELOAD = &H80000000 Private Declare Auto Function InternetOpenUrl Lib "wininet" Alia ...Show All

• HwaH Encryption Questions

  I have written two Functions one for encryption and one for Decryption (using _crypt.vcx), I would like to encrypt all data in my app . I have a few Questions… 1) When creating my tables what do I use for datatypes 2) What about indexing Do I index on Decypt(field1). 3) What about SQL Do I do Select Decypt(field1), Decypt(field2)… 4) What about select * . Is it supposed to be this big of a pain or am I just going ...Show All

• Boris Drajer 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

• Josh_G MSComctlLib.TreeCtrl.2 Problem

  Working with the treeView Control I ran into an unexpected problem. It appears to be impossible to collapse a node branch programmatically. Collapse is an event, not a method and when I tried to use it as a method I could not get anywhere. I also tried to employ DblClick with the same negative result--the tree does not budge. Aside from Collapse I will need Expand as a method not event, although I am using it as even already. The expansion ...Show All

• TheSoddy [noob questions] Arrays..

  Aaaaaaaaaaaaaaaarrrrgggghhhhhgadsfhasdjhf 1. Is foxpro incapable of returning an array from a function by using the return statement  2. Does foxpro have a function that merges 2 arrays 3. How do you pass an array as an argument to a function in a class when the array is a class variable For example: define class test as Custom     dimension Arr(1)        procedure asdf(tmpArray, tmp ...Show All

• greg derksen huella digital

  como le puedo hacer para integrar un lector de huella digital a mi aplicacion, el lector es digitalpersona(marca), requiero hacer una base de datos de las mismas y poder consultarlas si trae manual, pero solo es la instalacion personal o sea en la misma computadora y requiero de hacer una base de datos con las huellas digitales de todos los empleados. Please keep posts on this site English only . It's in your own interest, because m ...Show All