HYPERLINK LABEL

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
    - Not a character expression (Error 45) Thanks for help. I create a query in visual foxpro 9!The sql is: select a.num,b.doctor; from (select count(id) as num,cl group by cl) a; (select count(id) as doctor,cl where dt="doctor" group by cl); where a.cl=b.cl It can get the correct data from the table,but it could not be readable by the query designer. Whenevery i quit/open the query view there is a messagebox say "Not a character expression (Error 45)" and there is nothing in query designer. I wander how to edit/run the sql without the warning. Or without the designer tool edit the sql in the sql view directly! Thanks anyway! Tag: HYPERLINK LABEL Tag: 222316
  - 2
    - Illegal Immigration, the Non-Issue of the Week........................ Our politicians loved talking about it this week, but they won't do anything about it. Get the details from The Expert: http://www.ExpertHumor.com/ *** Free account sponsored by SecureIX.com *** *** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: HYPERLINK LABEL Tag: 222315
  - 3
    - dataenvironment class code Hello All, I have the following code for an dataenvironment for a report. The last line("this.cursor1.filter...) in the IF statement doesn't work unless I have the variables as PUBLIC. The variables contain valid dates. Could I do this any other way? Thanks Dave DEFINE CLASS dteInspectionHoursReport as dteDataEnvironment initialselectedalias = "vr0002" ADD OBJECT cursor1 as cursor WITH ; alias = "vr0002", ; cursorsource = "vr0002", ; database = "main.dbc" PROCEDURE Init() DODEFAULT() LOCAL loDateRange as Object, ldStartDate as Date, ; ldEndDate as Date LOCAL ARRAY laDate[2] laDate[1] = DATE() - 30 laDate[2] = DATE() loDateRange = CREATEOBJECT("_daterange",@laDate) loDateRange.Show(1) IF TYPE("loDateRange") = "O" AND !ISNULL(loDateRange) ldStartDate = loDateRange.dStartDate ldEndDate = loDateRange.dEndDate this.cursor1.filter = "BETWEEN(dinspectionact,ldStartDate,ldEndDate)" ENDIF ENDPROC ENDDEFINE Tag: HYPERLINK LABEL Tag: 222312
  - 4
    - DropDown List Display Ok maybe I am brain dead right now. I have a dropdown list. It contains 6 fields from a table. It must be a table and NOT an array because there are too many elements (records x fields - about 14,000 records x 6 elements and growing) for an array. The control is bound to column 6 (numeric). The control displays the first 5 columns (text) when it is in dropdown mode. When I select a row from the dropdown, it displays ONLY the data in column 6. I want to display the data in the other 5 columns, not column 6 I have tried to play with the displayvalue but for the life of me, i cannot figure it out. Thanks in advance. Tag: HYPERLINK LABEL Tag: 222309
  - 5
    - Suggestion for INPUTMASK I would like to suggest an enhancement to 'INPUTMASK' and 'DYNAMICINPUTMASK' - to add an option to 'prevent any data entry'. Reason - there are several ways to simulate 'dynamicReadonly' but this option to INPUTMASK would facilitate this easily. Mike Farnesi San Diego Tag: HYPERLINK LABEL Tag: 222306
  - 6
    - Detecting Mouse Clicks in Grid Column Headings Hello, Thanks in advance for the help. How do you detect mouse events in column headings in a grid control? Suppose you wanted to make clicking in a column heading perform a select/deselect all toggle. How would you know that the column heading has been clicked? Thanks, Jeff Tag: HYPERLINK LABEL Tag: 222303
  - 7
    - last record per id view I have an Oracle table with assets, periods and various other fields. Can a create a view to show me the records for the last period per asset? The 2 stage SQL all processed at the client end would be something like SELECT asset, MAX(period) AS maxper ; FROM table ; GROUP BY asset ; INTO CURSOR foo SELECT table.* ; FROM table, foo ; WHERE table.asset=foo.asset ; AND table.period=foo.maxper but I don't want to drag a gazillion records into Fox to do that if I can avoid it by making the server process it before sending. -- TIA Andrew Howell Tag: HYPERLINK LABEL Tag: 222298
  - 8
    - spiradoc record delete Strange happening here. I have an app that continually runs which uses a table "config" that contains 100 paramters in a single record to control it's operation. Every once in a while the program bombs and I find the config table either with an extra blank record or the single record is marked for deletion. There is no code to append or delete that file. The only thing I can come up with is possibly a routine in my program that selects another table and deletes/appends records is failing on the open and because the config table is always open it reverts to that. Any other idea how this could happen? And/or suggestions to prevent? TYIA - Ben Tag: HYPERLINK LABEL Tag: 222296
  - 9
    - blatmailen doesnt work hello,. i trying to send email with blat and smtp thats my configuration: blat -install servername sendername -1 -5022 telnetconnection to the exchangeserver with port 5022 works and here are the syntax blat test.txt -to meineadresse@firma.de Blat v2.5.0 w/GSS encryption (build : Sep 14 2005 22:46:29) Sending test.txt to meineadresse@firma.de Login name is testtd Error: Not a socket. Error: Not a socket. sorry for the bad english ;-) i hope you can help me Tag: HYPERLINK LABEL Tag: 222292
  - 10
    - Strange table behavior I am using VFP 7.0 and have table that I open, zap and then append new datafrom a delimited text file. When I do it manually from the development environment it works ok. When it runs in my program from the IDE or stand alone it has the old data in the table. How can that be from a zapped table? I've put browse windows between the lines and it is empty and them appends old data. I don't know where it is getting it. That file name does not exist anywhere else on my system. Please help! USE rmsmove IN 3 EXCLUSIVE SELECT rmsmove browse && old data ZAP browse && empty table APPEND FROM .\updates\rms.full.txt DELIMITED WITH CHARACTER | browse && old data again??? *REINDEX Cory Tag: HYPERLINK LABEL Tag: 222279
  - 11
    - Inet control StillExecuting not being set to False I have a control that is based on the Inet control it has a httppost method which is below. During development everything works fine but after I build an exe the StillExecting property is not being reset to .F. and the exe is using 95% of my processor. The "After THIS.StillExecuting " test is not being written out to the file. I use this same control on other forms with no problem in development or in an exe. Anyone have any ideas as to what could be causing this. I am using VFP 7 SP1 on XP Pro. The httppost method: STRTOFILE("HTTPControl.Execute"+CR_LF,"c:\temp\auth.txt",1) THIS.Execute(tcURL, "POST", tcSource, lcHeaders) STRTOFILE("After HTTPControl.Execute"+CR_LF,"c:\temp\auth.txt",1) DO WHILE THIS.StillExecuting * Wait for the end of the request DOEVENTS ENDDO STRTOFILE("After THIS.StillExecuting"+CR_LF,"c:\temp\auth.txt",1) Tag: HYPERLINK LABEL Tag: 222277
  - 12
    - Moving from VFP 6 to VFP 9 We currently support Visual AccountMate for a client of ours, which is accounting software written in VFP. We do a lot of reading from and writing to VAM data structures from outside VAM itself. The VAM version our client has been using, LAN 5, was written in VFP 6 and that's what we've used to talk to its data structures and for our own custom development work for this client as well. We are planning to install a newer version of VAM, also LAN (VAM also has a SQL Server-based product but we are not doing that upgrade now although we will in the future, I'm sure) that was written in VFP 9, and would like to know if we should expect changes in data structure significant enough to cause our VFP 6 programs to be unable to read from and write to VFP 9 tables. Obviously we are planning to upgrade our own VFP to 9 but we're trying to figure out if we can get away with doing the VAM upgrade before doing the VFP upgrade for ourselves and for our client. Thanks in advance - detailed replies, e.g, "this will work, but that won't" are most welcomed. -S- Tag: HYPERLINK LABEL Tag: 222268
  - 13
    - VFP 9: Report label orientation and preprocessed totals This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C65308.53710F40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, Some of the features touted for VFP9 report writer were preprocessed = totals and the ability to rotate labels. I've checked documentation and found no references to these two = features. Were they ever implemented? Thanks for the response. John. ------=_NextPart_000_000A_01C65308.53710F40 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.2802" name=3DGENERATOR> <STYLE></STYLE> </HEAD><FONT face=3DArial><FONT size=3D2> <BODY> <DIV>Hello,</DIV> <DIV> </DIV> <DIV>Some of the features touted for VFP9 report writer were = preprocessed totals=20 and the ability to rotate labels.</DIV> <DIV>I've checked documentation and found no references to these two=20 features.  Were they ever implemented?</DIV> <DIV> </DIV> <DIV>Thanks for the response.</DIV> <DIV>John.</DIV></BODY></HTML></FONT></FONT> ------=_NextPart_000_000A_01C65308.53710F40-- Tag: HYPERLINK LABEL Tag: 222265
  - 14
    - OT: Help Desk software recomendation Have received much help here for my VFP app but now I need help keeping the support end organized. Can anyone recommend a good help-desk ticketing software program? Don't want to re-invent the wheel here. Looking for something web-based, Google search returned too many results. I'd like to know if anyone here can make a recommendation. TYIA - Ben Tag: HYPERLINK LABEL Tag: 222263
  - 15
    - decompiling VFP 5.0 I understand there's a program called Refox that will do this, i'm wondering if there is anyone out there who'd be willing to do this for less than the $400 cost of their program? I've lost everything (computers and backups) in a fire, but can get customer .exe files. If anyone can help please let me know,thanks. -- jamesrav ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: HYPERLINK LABEL Tag: 222260
  - 16
    - Network slows down SELECT-SQL I am having a DBF named MJOB.dbf with 20000 records. The table has indexes on the following fields:- JOBNO JOBDATE JOBSERIES I have also indexed on Deleted() as set deleted in on. However, the following select-sql takes around 6-8 seconds when executed from a workstation. ***Code*** Select max(JOBNO) from MJOB ; where SERIES='A' and Between(JOBDATE,mFDate,mTdate) ; into array mARray Return mArray I tried out several things and later the following proved to be more quicker. (It takes less than 1 sec) **Code** Select JOBNO from MJOB ; where MJOB.SERIES='A' and Between(MJOB.JOBDATE,mFDate,mTdate) ; order by 1 ; into cursor c1 Select C1 Go Bottom Return C1.Code Is MAX() function not optimized by RUSHMORE or is there any other mistake in my 1st code. Kindly guide. Rajeev Tag: HYPERLINK LABEL Tag: 222258
  - 17
    - DWG viewer activeX Does someon know where i can download a dwg viewer activeX for foxpro Thanks Tag: HYPERLINK LABEL Tag: 222256
  - 18
    - OLEDragdrop question hi, I've got an application which uses the MS listview activex control. I want to be able to drag an item from that listview control and drop it onto the windows desktop and have it create a textfile with the name of the listview item I just dragged. Does anybody have any code that demonstrates how to do this? Thanks Tristan Tag: HYPERLINK LABEL Tag: 222253
  - 19
    - SQL group by error the following command works fine in VFP 6, but won't work with VFP 9. I get a "1807: SQL: group by clause is missing or invalid". What is wrong with it?! (something silly I've missed I bet) select Creditor.CreditorCd, Creditor.AddrRecID, ; GetDisc(Creditor.PromptTerm) as Discount, ; CredTran.CrTranID, TranDate, PayBy, Reference, CredTran.Amount, ; CredTran.Outstandng, TotAuthAmt, PromptTerm, CredTran.Paid, CredTran.TaxAmount, ; 00000.00 as DisAmount, 000000000.00 as AmtToPay, ; 00000000.00 as Pay, "Chq" as cPayType, ; count(1) as LineCount ; from CredTran inner join Creditor ; on CredTran.AddrRecID = Creditor.AddrRecID ; inner join TranLine ; on TranLine.CrTranID = CredTran.CrTranID ; where PayBy <= pdPayToDate .and. CredTran.Outstandng > 0 ; and TotAuthAmt > 0 and TotAuthAmt <> CredTran.Paid ; and OK2Alloc({}, CredTran.Outstandng, .T., CredTran.TranType, CredTran.Status, .T.) ; group by CredTran.CrTranID ; order by PayBy ; into table (lcFileName) Grant Tag: HYPERLINK LABEL Tag: 222251
  - 20
    - Grid column sorting Hi all, I have a table "A" with a field booknumber that points to booknumber in another table "Books", the relationship is one to many. if I have the table "A" in a grid and point the ControlSource of the booknumber to the bookname in "Books", how can I sort the grid by the bookname and not the booknumber when I click on the column header. this is the code I use in the Click event of the column header oGrd = Thisform.pageframe1.page2.grdtableA oGrd.SetAll("Picture","","Header") SET ORDER to booknumber ascending GO top oGrd.refresh I want to be able to sort the grid using the bookname from the books table. I know I can do that by using a view, but any other ideas? Thanks HME -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com Tag: HYPERLINK LABEL Tag: 222250
  - 21
    - In order to calculate the check number Hello there! I would like to ask for you help. In order to calculate the check number, I have to determine the division of a 21 digits number by 97 and for that I use the MOD () command. The problem is that Fox only uses 15 digits for numeric values, and I would need to get the result more then only 15 digits. The command is mod(2500003842908003100,97) Do you know how I can solve this problem? Thanks in advance, Pedro PS - sorry for the bad English Tag: HYPERLINK LABEL Tag: 222245
  - 22
    - Changing a report after the exe is made Is there a way to make changes to a report in the manner below after the executable is made? I'd like to parse the report according to the user's selections. Thanks ***********code - not mine LOCAL ARRAY laForms[1], laLinesToWipe[1], laSettings[1] LOCAL lnCurForm, lnFormCount, llNeedsCompiling, lcOldDir, lnNamesOnLine, ; lcOldFont, lnNumSettings, lcTargSetting, lnLoop, lcNewExpr *----------------------------- Program Code Begin ------------------------- - #define MAX_LINE_NAMES 4 #define NAME_WIDTH 28 lcOldDir = ALLTRIM(SET("DEFAULT")+ALLTRIM(CURDIR())) IF !EMPTY(tcWhere) AND TYPE("tcWhere") = 'C' set default to (tcWhere) ENDIF CLEAR CLOSE TABLES ALL IF MessageBox("About to clear printer info from all reports in"+CHR(13)+CHR(13)+ ; ALLTRIM(CURDIR())+CHR(13)+CHR(13)+ ; "Go for it?",36,"Mass Report Update!") != 6 WAIT "Aborted." WINDOW TIMEOUT 1 set default to (lcOldDir) RETURN .F. ENDIF lcOldFont = _SCREEN.FontName _SCREEN.FontName = "Courier New" lnNamesOnLine = 0 * * Identify lines in FRX expr field to wipe out: * DIMENSION laLinesToWipe[3] laLinesToWipe[1] = "DRIVER=" laLinesToWipe[2] = "DEVICE=" laLinesToWipe[3] = "OUTPUT=" * * For each FRX file in the current directory: * lnFormCount = ADIR(laForms,"*.FRX") ASORT(laForms,1) FOR lnCurForm = 1 TO lnFormCount llNeedToCompile = .F. * * Open the form as a table: * USE (laForms[lnCurForm,1]) IN 77 SELECT 77 * * The first record has the printer info: * LOCATE IF !EMPTY(tag) OR !EMPTY(tag2) llNeedToCompile = .T. ENDIF * * Clear the tag fields: * REPLACE tag WITH "", ; tag2 WITH "" * * Remove the printer info from the expr field: * lnNumSettings = ALINES(laSettings,expr,.T.) lnLoop = 1 DO WHILE lnLoop <= lnNumSettings lnInc = 1 FOR EACH lcTargSetting IN laLinesToWipe IF lcTargSetting $ laSettings[lnLoop] llNeedToComile = .T. ADEL(laSettings,lnLoop) lnNumSettings = lnNumSettings - 1 lnInc = 0 ENDIF ENDFOR lnLoop = lnLoop + lnInc ENDDO lcNewExpr = "" FOR lnLoop = 1 TO lnNumSettings lcNewExpr = lcNewExpr+ALLTRIM(laSettings[lnLoop])+CHR(13)+CHR(10) ENDFOR REPLACE expr WITH lcNewExpr *MessageBox("Before: "+chr(13)+expr+chr(13)+chr(13)+"After: "+chr(13)+lcNewExpr) IF lnNamesOnLine < MAX_LINE_NAMES ?? PADR(ALLTRIM(laForms[lnCurForm,1])+IIF(llNeedToCompile,'*',''),NAME_WIDTH) ELSE ? PADR(ALLTRIM(laForms[lnCurForm,1])+IIF(llNeedToCompile,'*',''),NAME_WIDTH) lnNamesOnLine = 0 ENDIF lnNamesOnLine = lnNamesOnLine + 1 SELECT 77 USE * * Compile the FRX: * IF llNeedToCompile COMPILE REPORT (laForms[lnCurForm,1]) ENDIF ENDFOR set default to (lcOldDir) Marcel Jalbert seemed to utter in news:22Wi7.289588$v5.29128506@news1.rdc1.ct.home.com: - Hide quoted text - - Show quoted text - > I been working around a problem for years where a FoxPro report form > fails to print to the selected printer or to the Windows default > printer. Anyway to make a long story short, when I compose a report > form for a printer that exists on the Desktop or Server the application > always prints to that printer. I'm use VFP 6.0 sp4 and have seen this > problem on Windows 95 and NT desktops and VFP 5.0. By compose I mean; > Modify the Report, go to "Page Setup" select a printer, click OK and > save the report form. There appears to be some hard coding in the > report form that identifies the printer name the report form was > designed for. If this printer name exists this hard coding seems to > override the destination printer settings your application would > normally print to. There are a couple of ways I get around this > problem. > 1) Temporarily change the name of the printer you want to compose the > report form for, select the printer while editing the report from and > save it. Recompile your code and rename the printer back to it usually > name. You can't rename a printer with Windows NT. > 2) Variations on the same theme that works with Windows NT would be to > temporarily install a printer on the PC that the application will never > printer to. Compose the report form for that printer, save it, > recompile and delete the installed printer. > 3) Have multiple copies of your report forms. Each composed for the > printers you want the reports to go to. (Not a desirable solution) > Has anyone else seen this problem? Is it on a FoxPro bug list? Am I > doing somethink I shouldn't or is there a better work around? > Thanks! > Marcel -- Tag: HYPERLINK LABEL Tag: 222241
  - 23
    - Non-Modal windows problem - VFP 9 I am trying to instantiate several Non-Modal copies of a form in VFP from the currently running form. I have set all of the properties correctly as far as I know but, the forms end up being modal. I can move the top one around and click on objects but cannot access the one created before it without closing the last one it. I have queried the windowtype in the modeless window and it is set to 0. Any thoughts on what I am doing wrong here??? Jim Tag: HYPERLINK LABEL Tag: 222240
  - 24
    - Duplicate records I have imported a textfile to a table. In this file there is now records which has the same information. How is it possible to remove the duplicate records? I have tried with different index ,delete, remove,alter, update and queries but the duplicates is still there. Many thanks in advance Reidar Tag: HYPERLINK LABEL Tag: 222233
  - 25
    - RAID 1 OR RAID 5 - YOUR OPINION Our core processing software is written in Visual FoxPro. We have experienced some performance issues with this software - slow inquiry and slow processing speeds. We have received conflicting information from a couple of different sources regarding the type of RAID used on our server. I am asking for opinions, knowledge, etc. on whether RAID 1 OR RAID 5 works better when running a VF program. Any info would be greatly appreciated. Tag: HYPERLINK LABEL Tag: 222232
- Next
  - 1
    - Combo/Incremental Search/Space I have a combobox with style set to Dropdown List and Incremental Search = .t. Incremental searching works fine until I hit the space bar as part of mt search expression. For example, I want to search for "fred smith". I start typing the characters and the incremental search works fine until I get to the space character. Hitting the space drops down the list. How can I force the space character to be part of the searched-for expression and prevent it from driopping down the list? Brian Tag: HYPERLINK LABEL Tag: 222228
  - 2
    - Copy to Xls Command This is a multi-part message in MIME format. ------=_NextPart_000_0039_01C651DC.7517B220 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable From Vfp 9.0 issuing the command copy to excelfile type xls creates an excel file. All fields convert correctly except date column = which becomes "text" type in excel. How can I create an excel file with = the correct date format. ------=_NextPart_000_0039_01C651DC.7517B220 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.2802" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DTahoma size=3D2>From Vfp 9.0 issuing the = command</FONT></DIV> <DIV><FONT face=3DTahoma size=3D2></FONT> </DIV> <DIV><FONT face=3DTahoma size=3D2><STRONG>copy to excelfile type=20 xls</STRONG></FONT></DIV> <DIV><FONT face=3DTahoma size=3D2></FONT> </DIV> <DIV><FONT face=3DTahoma size=3D2>creates an excel file. All fields = convert=20 correctly except date column which becomes "text" type in excel. How can = I=20 create an excel file with the correct date format.</FONT></DIV> <DIV><FONT face=3DTahoma size=3D2></FONT> </DIV> <DIV><FONT face=3DTahoma size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0039_01C651DC.7517B220-- Tag: HYPERLINK LABEL Tag: 222222
  - 3
    - So Weird function execution problem - Trying to get the owner of a file. Functions included. Hi, I have written a program that scans a directory - local or network - and for each file gets the owner name and the domain name and updates a table list. I have noticed that something weird happens during the function execution (function included). The function sometimes does not return the owner and domain. Therefore I set up a mechanism of a couple of retries and maintain a counter of retries. Now the weird things. 1. Sometimes for example for the folder c:\, I may have 200 retries, some other times more than 1000 and some other times 50. 2. Furthermore, because I don't keep trying for ever, some files do not return their owner. When I interactively later request the owner I am able to get it, so there isn't a file specific prolem. 3. The most weird. During the program tests, I had noticed that each time, different files appear in the table list without their owner/domain. What exactly is going on? Is there a timeout problem? Demetrios, Greece -------------------------------- * GetFileOwner - Get the owner of an NTFS file * * VBCode in: http://www.devx.com/vb2themax/Tip/19292 * Runs over Windows NT or 2000, and works only with files in NTFS partitions * * Requires the GetFileOwner_APIs.prg * * Usage: * ------ * GetFileOwner_APIs() * Store "" to Domain, Owner * GetFileOwner(fileName, @Domain, @Owner) * * Example: * -------- * GetFileOwner("C:\Windows\hh.exe", @Domain, @Owner) * ? Domain, Owner LParameters szfilename, Domain, Owner #Define OWNER_SECURITY_INFORMATION 1 Local m.sizeSD, m.pOwner, m.ownerName, m.domain_name, m.name_len Local m.domain_len, m.nLength, m.deUse, m.sdBuf m.sizeSD=0 && Buffer size to store Owner's SID m.pOwner=0 && Pointer to the Owner's SID m.ownerName="" && Name of the file owner m.domain_name="" && Name of the first domain for the owner m.name_len=0 && Required length for the owner name m.domain_len=0 && Required length for the domain name m.nLength=0 && Length of the Windows Directory m.deUse=0 && Pointer to a SID_NAME_USE enumerated type && indicating the type of the account m.sdBuf=" " && Buffer for Security Descriptor bSuccess=GetFileSecurity(m.szfilename, OWNER_SECURITY_INFORMATION, 0, 0, @m.sizeSD) * Create a buffer of the required size and call GetFileSecurity again m.sdBuf=Space(sizeSD) * Fill the buffer with the security descriptor of the object specified by the * filename parameter. The calling process must have the right to view the specified * aspects of the object's security status. bSuccess=GetFileSecurity(m.szfilename, OWNER_SECURITY_INFORMATION, @m.sdBuf, m.sizeSD, @m.sizeSD) * Obtain the owner's SID from the Security Descriptor, exit if error bSuccess=GetSecurityDescriptorOwner(@m.sdBuf, @m.pOwner, 0) * Retrieve the name of the account and the name of the first domain on * which this SID is found. Passes in the Owner's SID obtained previously. * Call LookupAccountSid twice, the * first time to obtain the required size of the owner and domain names. bSuccess=LookupAccountSid(NULL, m.pOwner, @m.ownerName, @m.name_len, @m.domain_name, @m.domain_len, @m.deUse) * Allocate the required space in the name and domain_name string variables. * Allocate 1 byte less to avoid the appended NULL character. if m.name_len>1 ownerName=Space(m.name_len - 1) domain_name=Space(m.domain_len -1 ) * Call LookupAccountSid again to actually fill in the name of the owner * and the first domain. bSuccess=LookupAccountSid(NULL, m.pOwner, @m.ownerName, @m.name_len, @m.domain_name, @m.domain_len, @m.deUse) Endif Domain=m.domain_name Owner=m.ownerName Return Owner * GetFileOwner_APIs * Required from GetFileOwner DECLARE INTEGER GetFileSecurity IN advapi32; STRING lpFileName,; INTEGER RequestedInformation,; STRING @pSecurityDescriptor,; INTEGER nLength,; INTEGER @lpnLengthNeeded DECLARE INTEGER GetSecurityDescriptorOwner IN advapi32; STRING @pSecurityDescriptor,; INTEGER @pOwner,; INTEGER @lpbOwnerDefaulted DECLARE INTEGER LookupAccountSid IN advapi32; STRING @lpSystemName,; INTEGER lpSid,; STRING @lpName,; INTEGER @cchName,; STRING @lpRefdDomain,; INTEGER @cchRefdDomain,; INTEGER @peUse Tag: HYPERLINK LABEL Tag: 222221
  - 4
    - Running FPW 2.6 code in VFP 9 - Buttons are white I have an application written in FPW 2.6 that runs in 2.6 and VFP. I'm used to running it in VFP 7.0. I just set up VFP 9.0 on the machine and I've got the application running but the buttons on the FPW 2.6 screens are colored white. The backgrounds on the screens are grey or blue. Is there a way I can have the buttons the same color as the background? Thanks. Dan Tag: HYPERLINK LABEL Tag: 222210
  - 5
    - any fix to redraw problem yet? I still have this problem (VFP9 SP1, but it's been around for a while), where labels and controls with labels like option buttons and checkboxes, redraw themselves with a tiny < 1 pixel offset, when other controls on a form are refreshed. The net result is that those controls, after a few refreshes, become very icky looking, sort of bold-faced, only uglier. I can get rid of it by setting visible = .t. to those controls, but having to do this hack is getting really annoying. Has this at least been acknowledged to be a problem? Any better workarounds than mine? Tag: HYPERLINK LABEL Tag: 222209
  - 6
    - newbie Change Parent Class Location I have a VFP9.0 that was converted from VFP6.0. One of the parent class was on E:\.......\_base.vcx I need to change it to C:\......\_base.vcx Suggestions? TIA Steve Tag: HYPERLINK LABEL Tag: 222207
  - 7
    - attachments in cdo I copied code: LOCAL loCDOMSG AS CDO.MESSAGE loCDOMSG = NEWOBJECT( 'cdo.message' ) WITH loCDOMSG .Subject = 'Test CDOSYS Message' .TO = 'Joe@somecompany.com' .FROM = 'joe@somecompany.com' .TextBody = 'This is the body' .Configuration.FIELDS.ITEM([http://schemas.microsoft.com/cdo/configuration/s endusing]) = 2 .Configuration.FIELDS.ITEM([http://schemas.microsoft.com/cdo/configuration/s mtpserver]) = [SMTPHOST] .Configuration.FIELDS.ITEM([http://schemas.microsoft.com/cdo/configuration/s mtpserverport]) = 25 .FIELDS([urn:schemas:httpmail:importance]) = 2 .FIELDS([urn:schemas:mailheader:priority]) = 1 .Configuration.FIELDS.UPDATE .FIELDS.UPDATE .SEND ENDWITH loCDOMSG = NULL WAIT WINDOW [Mail Sent.] TIMEOUT 1 ?But how to attach a file thanks Tag: HYPERLINK LABEL Tag: 222206
  - 8
    - File() Function - VP9 If I'm searching for "c:\filepath\myfile.ext" by calling FILE("c:\filepath\myfile.ext") and "myfile.ext" is part of the "Other Files" section in the project, then the FILE() function returns true even though "myfile.ext" does not exist inside of "c:\filepath". This happends ONLY when the program is compiled as an exe. The file function works correctly when run from within the VFP IDE. The VFP Help file states: "If you do not include a path with the file name, Visual FoxPro searches in the default directory for the file. If it cannot find the file in the default directory, Visual FoxPro searches along the Visual FoxPro path, which is established with SET PATH." c:\filepath\ is included when i call the FILE() function and IS NOT part of the PATH set by SET PATH. Thanks! Tag: HYPERLINK LABEL Tag: 222205
  - 9
    - dynamicreadonly I have a grid. Is there a way to simulate the property "DynamicReadOnly" ? Mike Farnesi San Diego Tag: HYPERLINK LABEL Tag: 222201
  - 10
    - Is exclusive open of table faster If you open a table exclusively does that make processing faster? Anybody have any experience or documentation on this?? Tag: HYPERLINK LABEL Tag: 222193
  - 11
    - class not registered.. Hi..guys. I meet a problem in my customer side ..when calling the mscomm32.ocx ..its out a error 'Class not registered' in workstation Window XP SP2. is it the window xp setting problem? I used foxpro 6.0. regards, Orange Tag: HYPERLINK LABEL Tag: 222188
  - 12
    - Report Problem Hi All When I Run report with reportlistener Preview (reportpreview.app) From Button In Window TestForm Created in Top Form MainForm ShowWindow = 1 when report Finish All off properties Of The TestForm and data which I created in load form from sql database and Connections lost This Happen when Run From Exe File Only any Id I use Vfp9 Sp1 Thanks Tag: HYPERLINK LABEL Tag: 222187
  - 13
    - KB/913807 ; KB/913161 ; KB/913571 ; KB/905756 I Can't install this update. I receive this event : Produit : Microsoft Office Professional Edition 2003 - La mise Ã jour 'Security Update for Outlook 2003: Junk E-mail Filter (KB913161): OUTLFLTR' n'a pas pu Ãªtre installÃ©e. Code d'erreur 1603. Windows Installer peut crÃ©er des journaux pour faciliter la rÃ©solution des Ã©ventuelles erreurs d'installation des packages logiciels. Utilisez le lien suivant pour afficher des instructions concernant l'activation des journaux : http://go.microsoft.com/fwlink/?LinkId=23127 0000: 7b 39 30 31 31 30 34 30 {9011040 0008: 43 2d 36 30 30 30 2d 31 C-6000-1 0010: 31 44 33 2d 38 43 46 45 1D3-8CFE 0018: 2d 30 31 35 30 30 34 38 -0150048 0020: 33 38 33 43 39 7d 20 7b 383C9} { 0028: 37 35 33 42 42 33 39 46 753BB39F 0030: 2d 32 41 38 44 2d 34 39 -2A8D-49 0038: 45 41 2d 38 38 31 31 2d EA-8811- 0040: 32 45 33 34 44 41 39 34 2E34DA94 0048: 46 36 39 43 7d 20 31 36 F69C} 16 0050: 30 33 03 Tag: HYPERLINK LABEL Tag: 222185
  - 14
    - White b/g isn't white?! Hi, I'm trying to make the backcolor of my form pure white. But I can't get it to show that. The backcolor of the form and the page is 255,255,255 and the page's color source is 0 (Object's Color Properties). Yet the form is clearly not white. I'm a little color blind so I can't say for sure what the color is but it looks to me as slightly grayish with a bit of pink. The page tabs are white and it's quite obvious that the page itself is not. What am I missing? This is VFP9 Thanks, Frank Tag: HYPERLINK LABEL Tag: 222182
  - 15
    - VFP8 performance on low memory machines I have an app that we have recently upgraded from VFP6 to VFP8. On machines with a lot of memory the performance is very good, but on machines with less memory the performance has degraded significantly. The apps are being run locally. I have had a look at sys(3050) but I am not sure whether it is the right approach to take. Any suggestions? Tag: HYPERLINK LABEL Tag: 222162
  - 16
    - Another query design question... Hi, Using VFP 9.0 to remotely query a SQL database and I'm stuck once again... yeah I know, what else is new? :-) This time I'm trying to make a sort of lookup table(view) from two related tables: Table name: billing_code Fields: sys_id (pk) billing_code_set_ver_sys_id billing_code description create_timestamp modify_timestamp create_user modify_user Table name: billing_code_charge_code Fields: sys_id (pk) billing_code_sys_id chg_codes_code create_timestamp modify_timestamp create_user modify_user These tables are related on the billing_code.sys_id to billing_code_sys_id, for every billing_code record there's many billing_code_charge_code records. What I want is a table that returns chg_codes_code, billing_code and description. Sounds simple doesn't it? Here's the catch... The billing_code table is on the many side of a one to many relationship with another table, billing_code_set_version. This means that there are multiple records in billing_code with the same billing_code and description. So far I haven't figured out how to get my query with just one record for every chg_codes_code, billing_code and billing_code.description. The closest I've gotten is this: select distinct chg_codes_code, billing_code, description from billing_code_charge_code right join billing_code on billing_code.sys_id = billing_code_charge_code.billing_code_sys_id where left(chg_codes_code, 1) in ('D', 'F', 'E') order by chg_codes_code In many cases this returns duplicate chg_codes_code values. The main difference I see in the records is that for one the description is in all upper case and the description for the other record uses normal case. Any suggestions? I've been trying all sorts of combinations but so far no luck. Thanks in advance, Linn Tag: HYPERLINK LABEL Tag: 222156
  - 17
    - Blues on protecting executables After seeing Refox protection is breakable with the new tools, I'm looking a new way to protect an application in VFP7 SP1 Using Molebox my exe file don't work. I don't know what I'm doing wrong. Had someone used this tool.? I'm aware on Derefox, I think this is the name, although I think is a good tool, I consider a problem to have to include more resource files (VFP6). Thanks. Alejandro Fernandez Tag: HYPERLINK LABEL Tag: 222155
  - 18
    - Report Writer VFP 9 BUG Hi, I have a table with 200 records, contains 7 fields, one of them is a memo field. I designed a very simple report with 5 fields on one line in the details band & on the 2nd line in the detail band I putted the memo field with width of the page A4. In the print when of the memo field, I inserted a variable & if this variable is TRUE then the memo field will appear in the report else it won't. When launching the report with the variable set to FALSE, a list of the 200 records appear. When the variable is set to TRUE, the report show a blank page with a number of pages in the TITLE BAR of the report starting from 28500 pages & counting quickly, I waited about 30 seconds & the number is counting with more than 3 millions pages & the VFP is hanging so I closed it from the task manager. I retry the same action, & I obtained the same result. Any Help Tag: HYPERLINK LABEL Tag: 222148
  - 19
    - How to write click event Hi all, In my program, when my program is running, enduser can press a button to create another "command button". And now I have a problem of create a "command button" with coding in that "Click event method" at the same time in the above situation. -- Thanks ! Tag: HYPERLINK LABEL Tag: 222142
  - 20
    - How can I know the class calling the procedure Dear All How can I know the class calling the procedure ? For Example Define class parent_class as session Procedure some_method set proc to procedure_file do call_me() Return Endefine Procedure file.prg : Procedure call_me how do I know the "parent_class" calling me ? <---- Anyone enligthen me ? Return Tag: HYPERLINK LABEL Tag: 222140
  - 21
    - Running a distributed .exe from an installation on a network serve I have a client that is having trouble running my program from an installation on a server from a workstation. I know that it is being used that way on some other sites so I am thinking it is a rights issue. Are there any limitations, such as printing reports from the server, that a client accessing it from a short-cut is going to experience? Cory Bonallo Retail Services Developer Tag: HYPERLINK LABEL Tag: 222136
  - 22
    - Determining SMTP server I want to provide the application option to send email from Fox via SMTP instead of MAPI method. Does anyone know how to retreive the default SMTP server name from Fox or Windows API? ----------------------------------------------------------------- Paul Lee ........ Abri Technologies ........ http://www.abri.com/ 'Recover' - top rated FoxPro file repair utility. ----------------------------------------------------------------- Tag: HYPERLINK LABEL Tag: 222134
  - 23
    - download foxpro 2.6 distrubtion kit here here you can dl Foxpro 2.6 dist... kit tanks alot for all visitors email me for any unfounded link to mbksoft@gmail.com http://vetusware.com/output/id73-FPXPRODK.260.rar Tag: HYPERLINK LABEL Tag: 222131
  - 24
    - Debugging Fox COM object in IIS Hi all! My website uses a FoxPro COM object to perform some database operations. The Fox DLL is single-threaded. At times, the function calls within my website to the Fox COM object will stop responding and the website will hang. The last time this happened, I attached Microsoft's WinDBG to the website process to debug it. What I observed was what appeared to be an infinite loop of first chance access violations. The violation occurrs in "vfp8r.dll" and with symbols, one can see the function in which the crash occurs is "KBCopy2". Apparently some error handler is catching this violation because it never becomes second chance but the function is getting repeatedly called (infinitely it seems) and therefore locking up my COM object. Does anyone have any ideas about how I debug this further and find out exactly what is going on? Thank you! Matthew Tag: HYPERLINK LABEL Tag: 222126
  - 25
    - problem dragging file to explorer I posted in a xp newsgroup, but did not get an answer. I have a Visual Foxpro Application that reads a text file and stores the data in a table. The text file is created using a PDT (Portable Data Terminal). I use the software that came with the PDT to drag the text file from a PDT window (from within the PDT software) to a folder called c:\mobile. It works great on my test computers (both are Windows XP Home Edition....arghhh don't ask why!). Anyway on my client computer, which is a Windows XP Professional, I cannot drag the file. I can only drag it to the Recylce Bin. I think I have checked properly any rights for the c:\mobile folder and they are set to "read, write, etc....all rights are check". However, windows will not allow me to drag the file. What setting am I missing? I opened and saved a wordpad document in the C:\mobile folder so I do have rights. Thanks, John. Tag: HYPERLINK LABEL Tag: 222123

Hi all

I looking For Something Like HyperlinkLabel Not To Used With URL But To Run
Procedure From My Form

Thanks

Re: HYPERLINK LABEL by Carsten

Carsten
Fri Mar 31 07:14:37 CST 2006

Taha,

in VFP 7 (or 8) all controls became 2 new events.
MousEnter and MouseLeave

Its quite easy to imitate a hyperlink-label
Drop a Label on the form, and put something like this in the
MouseEnter-event:

THIS.ForeColor= RGB(0,0,255)
THIS.FontUnderline= .T.
THIS.MousePointer= 15

and this in the MouseLeave-event:

THIS.ForeColor= RGB(0,0,0)
THIS.FontUnderline= .F.
THIS.MousePointer= 0

In the Click-event call your procedure. Thats it.

--
Cheers
Carsten
_______________________________

"Taha" <taha105@hotmail.com> schrieb im Newsbeitrag
news:OlhR$NIVGHA.5592@TK2MSFTNGP09.phx.gbl...
> Hi all
>
> I looking For Something Like HyperlinkLabel Not To Used With URL But To
> Run Procedure From My Form
>
> Thanks
>

Top

Re: HYPERLINK LABEL by Stefan

Stefan
Fri Mar 31 07:27:29 CST 2006

"Taha" <taha105@hotmail.com> schrieb im Newsbeitrag
news:OlhR$NIVGHA.5592@TK2MSFTNGP09.phx.gbl...
> Hi all
>
> I looking For Something Like HyperlinkLabel Not To Used With URL But To Run Procedure
> From My Form

You can make your own label class and modify .ForeColor, .FontUnderline,
.MousePointer, .Click() etc., similar to what the Fox team did in their

MODIFY CLASS _hyperlinklabel of (HOME()+"Ffc\_hyperlink.vcx")

hth
-Stefan

--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------

Top

Re: HYPERLINK LABEL by Taha

Taha
Fri Mar 31 14:12:58 CST 2006

Thanks All
"Taha" <taha105@hotmail.com> wrote in message
news:OlhR$NIVGHA.5592@TK2MSFTNGP09.phx.gbl...
> Hi all
>
> I looking For Something Like HyperlinkLabel Not To Used With URL But To
> Run Procedure From My Form
>
> Thanks
>

Top