A web-based shop that sells Foxpro books in Hong Kong

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Foxpro 10???? I've been developing in Foxpro for about 10 years now. With the news from Microsoft that development has now ceased and it's exclusion from the Visual Studio framework I've been considering moving away to something with more longjevity? Does anyone see a future for VFP? What's the chances of VFP being developed further - if not by Microsoft then by others? Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241696
  - 2
    - Field Limitation of Entry Q. Say I want a data entry field to hold minutes. How do I limit the user from not being able to key more than 60 as their entry? Would I put this code in the valid or is there somewhere else that would work better? Cheers, Jonathan Morningstar Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241693
  - 3
    - how to use sql server udf I have created function on sql server 2000 which I would like to use in FoxPro code but SQLEXEC function returns -1. Is there any restriction for SQL UDF? My SQL Function is AS follow: Function GetClientName (@ClientId Char(10)) Returns char(20) AS BEGIN DECLARE @ClientName as varchar(20) set @ClientName = (Select LastName from Clients where ClientId = @ClientId) RETURN @ClientName END In FoxPro I use: lnRetVal = SQLEXEC(pnHandle,"SELECT dbo.GetClientName('0000000101') AS ClientName", "sqlClientName") - which returns -1 when I use SELECT dbo.GetClientName('0000000101') AS ClientName in query analyser it returns last name of the client! Am I missing anything? Thanks for looking it. Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241684
  - 4
    - excel format version I've saved a spreadsheet via copy to xxx type xl5 and I'm trying to do an automation task to update the version to match my current copy of excel. I thought I could just issue: oExcel.ActiveWorkbook.FileFormat = <something??> and then save/close, but .ActiveWorkbook assignments produce an error. How do I go about doing this? Thanks. PS what's the value of <something> I should use? Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241680
  - 5
    - NUM2WORD Prg Q. Is there a Number to word program that spells out numbers? I don't need the spelling out in dollars format. What I need... 1 = One 2 = Two 3 = Three...etc What I don't need.... 1 = One and zero cents Respectfully, Jonathan Morningstar Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241676
  - 6
    - translation question Group, How does this: (ofso.execute, var1 var2 var3) translate to vfp? the comma after execute doesn't compute in my feeble brain. Wade Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241672
  - 7
    - Inner classes Hi all, Is it possible to use inner classes in VFP like in Java? I've been trying to do so, but i haven't got it working yet. Let's say I have this code: DEFINE CLASS MyOuter as Custom InnerObject = NULL PROCEDURE Init THIS.InnerObject = NEWOBJECT("MyInner") ENDPROC DEFINE CLASS MyInner as Custom ... ... ENDDEFINE ENDDEFINE When I run this, I get the message "Class definition MyInner is not found". What am I doing wrong??? Thanks! Regards, Bami Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241660
  - 8
    - ArcGIS Engine Developer Kit License --____YKFPKMSHPVMKUCJHOJLU____ Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I would like to develop applications in FoxPro that make use of ArcObjects = controls. This would be used to run on our in-office computers that have = ArcView installed. When I try to add an ArcObjects control to a FoxPro form, I get an error = message saying I need an ArcGIS Engine Developer Kit license. Do I need = to pay for a license to use ArcObjects on machines that are already = licensed to run ArcView? Or do I just need to activate some license I = already have? --____YKFPKMSHPVMKUCJHOJLU____ Content-Type: multipart/related; boundary="____OFZDOEOMHYGEWLUYCWOQ____" --____OFZDOEOMHYGEWLUYCWOQ____ Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1"= > <META content=3D"MSHTML 6.00.2900.3199" name=3DGENERATOR></HEAD> <BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma"> <DIV>I would like to develop applications in FoxPro that make use = of ArcObjects controls.  This would be used to run on our = in-office computers that have ArcView installed.</DIV> <DIV> </DIV> <DIV>When I try to add an ArcObjects control to a FoxPro form, I get an = error message saying I need an ArcGIS Engine Developer Kit license.  = Do I need to pay for a license to use ArcObjects on machines that are = already licensed to run ArcView?  Or do I just need to activate some = license I already have?</DIV></BODY></HTML> --____OFZDOEOMHYGEWLUYCWOQ____-- --____YKFPKMSHPVMKUCJHOJLU____-- Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241648
  - 9
    - PDF Form Filler ActiveX controls Does anyone have any really good ActiveX form filler controls they can recommend where a user can fill out a PDF form and then the viewer will save the changes in PDF format? Thanks, Mike Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241647
  - 10
    - Do they have Outlook Q. How can you tell, via Foxpro code, if a workstation has Outlook on it? Is there a way to tell? Respectfully, Jonathan Morningstar PS. If I haven't said this lately - pardon me... This is the best newsgroup ever. I appreciate the community and your willingness to share so openly. Thank you. Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241646
  - 11
    - copy classes (vfp9sp1) I am trying again on the issue of copying classes. I have two applications that use a common set of classes. I need to make a change that only impacts one application in one of the common classes. This reflects a pretty fundamental change to the application, even though it actually involves changing only one line in the common classes. At a later time, the same changes will be made to the other app, but at the moment just the one. Based on the last time I asked about this, I made a copy of the vcx in the home directory of the app to be changed. I then removed the original class from the project, added the relocated class, and rebuilt the project. As I am sure most of you know, the components that use the class in question still point to the original. Is there a straightforward way to accomplish what I want, or must I add code to the class to detect the calling app? Thanks Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241635
  - 12
    - Network Workstation Q. Can anyone tell me me how to return the Network and Workstation name off the computer I am sitting at? Is there a SYS() command that will return that? Cheers, J Morningstar Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241624
  - 13
    - delete directory Group, How can you delete a directory in code if it has files in it? (vfp6) Wade Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241613
  - 14
    - duplicate records Hi .. i am trying to update a table in foxpro 6.0 where if field contents any duplictaed entries than one of the field should be updated with random number which is unique so i can make all entries unique i searched a lot but couldn't find any solution which i could understand easily . is it very difficult in sql to update duplicate entries with new unique random values? table example : id is primary key ---------------------- id | name | age ---------------------- 1 a 24 2 b 24 3 c 28 4 d 12 5 e 12 in the above table id is unique but the age is same for a , b and d,e . what i am trying to do is that in a single query i can update table set age=age+random unique number where duplicate age exists . that mean b will become 24+some random number and e will be 12+some random number hope someone reply's soon thanks Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241611
  - 15
    - Other Discussion Groups, Newsgroups other than MSDN No offense here, but MSDN Newsgroup here for Microsoft Visual FoxPro is a little weak...and understandable now that Microsoft has pulled the plug on it. Does anyone know of any other Microsoft Visual FoxPro Discussion Groups, Newsgroups out on the Internet other than MSDN??? Thanks in advance for your help. PSULionRP Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241600
  - 16
    - SQL Server and Microsoft Visual FoxPro I am really struggling with the Microsoft Visual FoxPro syntax to SQL Server. I actually have to CREATE a SQL Server Table. I seem to be doing that ok. It's the INSERT to this table from Microsoft Visual FoxPro that I am struggling with. Does anyone know of some good training sites for SQL Server interface with Microsoft Visual FoxPro or some where I can find syntax??? I have scoured Google and can't seem to find anything. Thanks in advance for your help. PSULionRP Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241599
  - 17
    - Trapping events in BROWSE window I come from FPW 2.6 moving to VFP9 and I have enhanced my BROWSE command adding NAME so that I can set colours for headers, columns, rows, gridlines, etc. Is it possible to trap under this schema for events like double clicking a column, clicking on a column header, etc. ? Please remember that I don't use forms. Walter Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241597
  - 18
    - Declare DLL String limit This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C8E42B.8897B730 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am using the declare dll command in VFP 6.0 and 9.0. The DLL decides = if there are errors and if so outputs an errors.txt file. The code is = below. If I do it in 6.0 it works fine. In 9.0 the errors.txt file = gets truncated at about 4k. Is there a way around this. DECLARE INTEGER MYDLL IN MYDLL; STRING @, ; STRING @, ; INTEGER @ InFile =3D "InData.txt"=20 OutFile =3D 'ERRORS.TXT' ErrCount =3D 0 ErrLevel =3D MYDLL(InFile, OutFile, ErrCount) if ERRLEVEL =3D 4 WAIT WINDOW 'Warnings in output. See ERRORS.TXT file for details.' !NOTEPAD 'ERRORS.TXT' ENDIF TIA. BR ------=_NextPart_000_0008_01C8E42B.8897B730 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.3354" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff background=3D""><FONT face=3DArial = size=3D2></FONT> <DIV><FONT face=3DArial size=3D2>I am using the declare dll command in = VFP 6.0 and=20 9.0.  The DLL decides if there are errors and if so outputs an = errors.txt=20 file.  The code is below.  If I do it in 6.0 it works = fine.  In=20 9.0 the errors.txt file gets truncated at about 4k.  Is there a way = around=20 this.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>DECLARE INTEGER MYDLL IN=20 MYDLL;<BR>          &nb= sp;           &nbs= p;           &nbsp= ;=20 STRING @,=20 ;<BR>           &n= bsp;           &nb= sp;           =20 STRING @,=20 ;<BR>           &n= bsp;           &nb= sp;         =20   INTEGER @<BR></DIV></FONT><FONT face=3DArial size=3D2></FONT> <DIV><FONT face=3DArial size=3D2>InFile =3D "InData.txt" <BR>OutFile =3D = 'ERRORS.TXT'</FONT></DIV> <DIV><FONT face=3DArial size=3D2>ErrCount =3D 0<BR>ErrLevel =3D = MYDLL(InFile, OutFile,=20 ErrCount)<BR></FONT></DIV> <DIV><FONT face=3DArial size=3D2>if ERRLEVEL =3D 4<BR> WAIT WINDOW = 'Warnings in=20 output. See ERRORS.TXT file for details.'<BR> !NOTEPAD=20 'ERRORS.TXT'</FONT></DIV> <DIV><FONT face=3DArial size=3D2>ENDIF</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV> <DIV><FONT face=3DArial size=3D2>TIA.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>BR</FONT></DIV></DIV></BODY></HTML> ------=_NextPart_000_0008_01C8E42B.8897B730-- Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241595
  - 19
    - Using a SQL Cursor to INSERT into another Table I have a SQL SELECT into a Cursor. Can I use the cursor results as a host variable and INSERT this data into another table??? SELECT column1, column2, column3 FROM Table1 SQLEXEC(dataconn,lcSQL,"cursor") SELECT cursor GO TOP DO WHILE NOT EOF() lcinsertsql = [ INSERT INTO Table2 ] +; [ (columna, ] +; [ columnb, ] +; [ columnc ] +; [ VALUES ] +; [ (ALLTRIM(STR(cursor.column1)), ] +; [ ALLTRIM(STR(cursor.column2)), ] +; [ ALLTRIM(STR(cursor.column3))) ] Does this look right??? Any suggestions??? Thanks in advance for your review and help. PSULionRP Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241583
  - 20
    - Confuse behaviour calling a DLL I´m using a DLL with several readonly tables inside. Sometimes trying to open one of these tables I got the error "File MyDBF does not exist". On displaying memory and status to files I couldn´t find changes at all. No database is open. These are free tables. What other environment changes can I compare? Thanks. Alejandro Fernandez Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241577
  - 21
    - excel automation datatype I'm pushing a table into an excel work sheet by iterating through the table, doing a scatter .... <to array> and .Cell[row,col].Value = array[col] etc... Using this method, however, vfp date types seem to be converted to characters like "mm/dd/yy" instead of an excel date type (if there is one). How do I make sure excel winds up with one of its internal date types? Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241567
  - 22
    - Declaring Variables How come sometimes I see LOCAL variables being explicitly defined and then other times I don't...they seem like they're being defined on the fly. Is this bad coding discipline??? Arrrrrrgggggggghhhhhhhhh PSULionRP Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241563
  - 23
    - vfp 9 printer setup overrides printer driver i am trying to print lables. in doing this, i need to print them portrait 180. i set this up in the printer driver this way, but in foxpro it shows and prints portrait. is there a patch for this? thannks, Marty Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241559
  - 24
    - Confusing performance difference VFP8 SP1 on XP Pro SP2 I have some code that was running a bit slowly: SELECT DISTINCT colToFix ; INTO ARRAY colArray ; FROM myTbl SELECT myTbl FOR EACH curVal IN colArray lcNewVal = ThisForm.Standardize(curVal) REPLACE colToFix WITH lcNewVal FOR colToFix = curVal ENDFOR There is an index on the ColToFix column. myTbl is a free table. Standardize is a method that makes sure the passed in value follows certain formatting rules. On a table with 50K records, this was taking almost 2 minutes. There are about 10 distinct values in the column in question. All of the execution time was happening in the 10 calls to REPLACE - some of them taking over 20 seconds! With such a small table and indexed on the column in question, I would think each REPLACE would take no more than a second. I've tested on many, many tables of the same size with the same result, so it's not a corruption issue. Playing around with it, I changed it to the following: SELECT myTbl SCAN REPLACE colToFix WITH ThisForm.Standardize(colToFix) ENDSCAN Amazingly, this was 5 times faster! How could performing 50K replacements and 50K calls to the standardize method take *less* time than doing 10 calls to each?!? This was also 5 times faster: SELECT myTbl REPLACE colToFix WITH ThisForm.Standardize(colToFix) ALL I rarely have performance problems in VFP, so this one's a bit of a head scratcher. Any ideas on why this difference and how to possibly make this run even faster? -- TRW _______________________________________ t i m . w i t o r t _______________________________________ Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241557
  - 25
    - VFP column type using SQL I have a situation where I am doing a SQL query within a FoxPro .prg. The program is assuming the data attributes from SQL and I'm specifically going after an INT column type. And I have to pass back a <blank> in this field rather than the value. If I set up a global or local variable, can I move the SQL result column to this global/local character field and then pass the <blank> that way??? I also thought about doing a CAST or CONVERT in my SQL statement, but I'm not sure how to pass back a <blank> that way either. The problem here is that is one big UNION Select and I only want to do this in the one UNION condition. I am sort of new to Visual FoxPro. How does FoxPro discern whether a working storage global or local variable is character or numeric??? Can anyone help me out here??? Thanks in advance. PSULionRP Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241549
- Next
  - 1
    - Error only reports "click" I have an application with an error handler that saves information on errors. For some errors, though, instead of reporting the form and/or function that caused the error, Exception.Procedure only returns "click". This makes it very difficult to track the error. Am I doing something wrong? Is there any way to track the procedure that causes this error? Is there a known situation for which Exception.Procedure returns only "click"? Regards, Kevin Clark Seton Home Study School Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241547
  - 2
    - VFP 9.0 report template returns printer to default I have a third party application that uses vfp9.0. When i try to save a printer to the report template, it goes back to the default printer. i am unable to save the non default printer. we use this application to print labels using a datamax printer. we need to be able to save the datamax printer because it uses labels different then 81/2 X11. in trying to resolve this, i contacted teh third party, and they responded that this was a vfp 9.0 bug and not their bug. they had a vfp application that was supposed to solve this, but it didn't. i went to vfp 9 and created a sample report. i then tried to save a non default printer, and it did the same thing. after closing and opening the report, the default printer was selected again. is there any patches to fix this? any help would be appreciated. thanks Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241538
  - 3
    - Little black box in .dbf Please excuse my newness to Microsoft Visual FoxPro. There is a little column in a database file and it is sometimes black and sometimes not. Is this like an active flag or something for data rows?? Black meaning it is not active??? Thanks in advance. PSULionRP Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241531
  - 4
    - FPW 2.6 and SHOW WINDOW oddness Hello group, hope all are well.. I stumbled across an unusual behaviour this morning, trying to refresh a browse window called "Reorder" closes the window. Does anyone know why? I don't think "REORDER" is a keyword, have I stumbled across something magic? Incidentally, is there somewhere (in the help maybe?) I can see a list of keywords for FPW2.6? *--------------------------------------- code... * type a new value in the field and press enter - * this causes a SHOW WINDOW ... REFRESH to be executed * and it has the magic effect of closing the window * the problem is apparently calling the window 'Reorder' * issuing SHOW WINDOW ALL REFRESH will refresh it correctly * but any way of referencing the single window (eg 'Reorder' * or WONTOP etc.) seems to cause this behaviour CREATE CURSOR test (test C(30)) INSERT INTO test (test) VALUES ('change me and press enter') BROWSE TITLE 'Reorder' ; FIELDS test :v=refwind() ****************** FUNCTION refwind ****************** * refresh browse window SHOW WINDOW (WONTOP()) REFRESH *--------------------------------------- end code.. -- best regards Andrew Howell Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241525
  - 5
    - Using default font under Vista (or XP) Out of curiousity, does anyone know how to get Foxpro to use the standard Windows font for form labels, textboxes etc without having to manually set the font as such? ie. If the app is running under XP, then form objects will display using Tahoma (for example) or if running under Vista then Segoe UI. If that is not possible.... Setting the font to default for a form object seems to set it to Arial. Is there some way of changing this default font setting for VFP such that all forms pick this up? Alas, many of our forms don't use label/textbox classes so doing it in a class is not an option. Thanks, Andrew Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241520
  - 6
    - tooltips in grid headers not showing I cannot get the tooltips in grid headers to show up. Is this a bug or am I doing something wrong. (VFP9SP2) If I cannot fit enough text in the header I would like to use the tooltips to show additional information. Max Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241515
  - 7
    - Is an .exe running - revisited I asked a question earlier where I would like to check if an external app (non-foxpro) is running as was given the code below to place in a function. It works great and detects if an app is running however, when I close the other app, and do a test to see if it still running, calling the funton still indicates the other windows app is still runing but it's not. I tried issuing clear dlls but it doesn't help. If I leave FoxPro and come back in, it resets the function and it now works but once the other app is run, it again indicates the the other app is running after I close it. Is there anyway I could fix this issue. It seems to only work until the first instance of the external app is run. TIA Mike. PARAMETERS pMutex && pMutex=Program name #DEFINE ERROR_ALREADY_EXISTS 183 DECLARE INTEGER CreateMutex IN WIN32API INTEGER, INTEGER, STRING @ DECLARE INTEGER CloseHandle IN WIN32API INTEGER DECLARE INTEGER GetLastError IN WIN32API nExeHwnd=CreateMutex(0, 1, @pMutex) IF GetLastError()=ERROR_ALREADY_EXISTS CloseHandle(nExeHwnd) =MESSAGEBOX(pmutex+" Is Already Running",64,registname) RETURN .F. ELSE RETURN .T. ENDIF Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241512
  - 8
    - Shortcut or Popup menus on top level forms VFP8 SP1 on XP Pro SP2 I have a form with ShowWindow=2 (As top level form). I am using the MenuLib class in the Utility.vcx library to dynamically create and show a popup menu when a certain control is Right-clicked on. This worked fine when ShowWindow was set to 0 (in screen), but with the form as a top level form, the popup no longer appears. I suspect it is being displayed *behind* the top level form or in the SCREEN (??!). This makes the popup unusable, needless to say. The MenuLib class uses DEFINE POPUP to build the popup menu then SHOW POPUP to display it. I don't see anything in the help file about this not working on a top level form, but there is obviously something amiss here. Any idea how to make this work? -- TRW _______________________________________ t i m . w i t o r t _______________________________________ Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241511
  - 9
    - FoxPro Automation Q. I have started passing data back and forth from Foxpro and Outlook's Contacts. The only problem is that I do not know all the names of the fields in Outlook's Contact section. ie. the attached picture file, the notes field... Where can you get a listing of all the objects in outlook? Has anyone ever plowed this ground already and willing to share some code? Your knowledge is greatly appreciated. Jonathan Morningstar Edisto Island, South Carolina, USA Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241509
  - 10
    - Active Source Control Provider not recognizing VSS is installed Hi, My machine crashed, so I'm setting up a new machine with my dev environment. I've never had a problem with VFP finding my VSS installation before, but I do now. I have VSS installed, I can see it in the registry, it's hooked up the project and I can use the VSS environment just fine. But when I go to VFP's Options for the project, and drop down the Active Source Control Provider box, it's empty. I checked and I am running VSS from a local installation, not off a server. How do I tell VFP where to find VSS? I assumed it would find it in the registry. Thanks Cathy Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241502
  - 11
    - SQL - lates date entry I have a table for different engine parts were the date of the last overhaul of a particular part is entered Something like: 1. engine1; unit1; some details...; date1 2. engine1; unit1; some details...; date2 3. engine1; unit1; some details...; date3 4. engine12; unit7; some details...; date1 5. engine12; unit7; some details...; date2 6. engine12; unit7; some details...; date3 ect... On a form an engine and a unit can be selected and in a grid with a view the history of the maintained parts will be visible. My problem is, I cannot figure out how to get only the last date entry of each engine and unit, in above sample it would be line 3 and 6 only. Any help would be appreciated Thanks Max Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241495
  - 12
    - Tables become corrupted in Terminal Server Session My scenario: application's exe (vfp9) running from a file server, on 30 computers and there are also 10 sessions of terminal server who run on another server (not the file server). The users of the 10 sessions are 3 miles away from both file server and the terminal server. Connection is over a 2 MB point to point line, with a good ping of about 30 ms. Surprisingly, from time to time some tables on the file server become corrupted, and I can see that these tables had been in use by the "remote" people in terminal server mode. (These are the only people that can update the corrupted tables. The "local" people just open the tables with NOUPDATE). For example today, one of the tables that became corrupted, indicated with Foxfix5 a wrong record count. The table is small, about 15000 records, with a record length of 50, that means 750 kB. Is there a chance to get a corrupted table because of a micro cut in the connection to the remote office? I could understand this if it were a true client-server application, but it runs on a LAN and on terminal server, this means only video is updated. What else can be happening ? Walter Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241494
  - 13
    - animated gif Hi I have a form(form A)(vfp8) the only thing on this form is an animated gif. In the activate event I call another form(formB) at that point the gif is no longer active. How can I keep the gif moving while the other form is loading? Also..what code and where do I put it to close form A.(it stays running under form B.(it is also moving again.) Thanks Sherry Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241492
  - 14
    - Outlook Contacts Automation Q. Greetings, How can you create an additional address book inside the Outlook contacts folder via VFP code? I know how to add contacts from VFP into Outlook but I need them to go into a new folder in the Outlook contacts. Respectfully, Jonathan Morningstar Greenville, South Carolina USA Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241484
  - 15
    - limitation on string of 255 bytes??? hi i can't create a string of more than 255 bytes.... what is happening...? this don't occurred before... bye, thanks ks Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241480
  - 16
    - Project hook There are a couple of prgs that I have to remember to run before creating the exe - e.g. initialising some tables that are stored R/O within the exe. I have never done anything with project hooks before, but believe that this is the way I should do this. Can somebody point me to a helpful article or explain simply how I set this up? Many thanks Stephen Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241471
  - 17
    - Problems running code created by GENDBC When the app begins the function MakeRI to write store procedures, the statement CLOSE DATABASE USE "MYDBC.DBC" I got the error "File is in use" Does knows somebody this behaviour? Thanks. Alejandro Fernandez Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241468
  - 18
    - What about Sybase iAnywhere's Advantage Database Server ? I am trying to attend South West Fox conference in Arizona in October, and one of the sponsors is Sybase. Does anybody have got an experience with their Advantage Database Server? Does it replace SQL Server? Pros? Cons? Walter Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241464
  - 19
    - Software Development Services, Software Outsourcing Services In India Software Development services in India suggest IT Solutions for Software outsourcing services, Software Design, affordable software technology and Programming Development by frequent Software Testing. More information for visit our site http://www.itoutsourcingservices.com/software_development.htm Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241452
  - 20
    - Quit To ... There used to be a DOS-days (Foxbase?) command QUIT TO <Some other app> where <Some other app> would start automatically after exiting Fox. I could probably replicate this by creating a batch file (using some commands I have forgotten) to start the initial app, but I have a feeling there's a way to do it inside VFP9SP2 - or maybe with a dll? Any suggestions? Steve Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241445
  - 21
    - ActiveX Control No Visible After Form INIT Hi I have an ActiveX form on my form and despite my best attempts I cannot get the thing to display when I launch my form. The only way to 'fudge' the situation is to make it tab order 1 and force a 'TAB' character into the keyboard buffer. That's fine whilst it's the first control on the form but that's not always the case. I've seen this behaviour before with other ActiveX controls so it's not just confined to this one. I've tried: _VFP.AutoYield = .f. (program startup & form init) DOEVENTS ThisForm.Paint ThisForm.Refresh Have also tried the refresh(), redraw() events of the control but nothing works unless UNTIL the control gets the focus. Just wondered if anyone else had seen similar behaviour? Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241439
  - 22
    - Http post Group, We need to use Http Post to send a file (I have Zero experience with it) from vfp 6 to an electronic medical claims site for processing. They sent me the 'parameters', etc. but after googling for info, I found no examples of how to do it. Can anyone point me in the right direction? I don't know Http post from a fence post. TIA, Wade Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241435
  - 23
    - empty memo field in an sql query Hi and thanks in advance for the help... When doing an SQL query I've often used things like... space(2) as State or 000000.00 as Amount is there a construct that I can use in a query to create a memo field in the resulting table? Thanks, Jeff Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241425
  - 24
    - rename and rename table How can I rename tables in a dbc so that the disk name and the dbcname are updated and the backlink unbroken? Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241417
  - 25
    - Slider control... Does anyone know of a good 'slider' type control (other than the one in the "solutions" example) that I can use to change the size of my form? ________________________ | | | | | | | | | | | B | | | | | A | ____________| | | | | | | | | C | | | | | | | |__________ | ____________| The form is split in to three sections as shown above and I would like the user to be able to resize each by using the horizontal / vertical lines that separate the three panels A,B & C. Thanks in advance. Tag: A web-based shop that sells Foxpro books in Hong Kong Tag: 241415

http://www.bookworld.com.hk/book/srchlist.asp?qsrch=foxpro&FINISH=Go

--
@~@ Might, Courage, Vision, SINCERITY.
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Xubuntu 8.04) Linux 2.6.26
^ ^ 16:21:01 up 2 days 19:47 2 users load average: 1.00 1.00 1.00
? ? (CSSA):
http://www.swd.gov.hk/tc/index/site_pubsvc/page_socsecu/sub_addressesa/

Top