October 2005 letter on Visual FoxPro web site

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
    - C0000005 on Windows2003 Hi, The following code (VFP8(SP1), MSXML4(SP2)) works properly on WindowsXP Professional(SP2) and Windows2000 Server(SP4) - parsing error is caught by a handler. The same code doesn't work correctly on Windows2003 EE(SP1) - C0000005 is raised. **************************** Local loException,rdr,hnd try rdr = CreateObject("MSXML2.SAXXMLReader.4.0") hnd = CreateObject("_XMLValidator") rdr.errorHandler = hnd * Valid XML rdr.parse("<catalog><book id='bk101'></book></catalog>") =MessageBox("Valid XML") * Invalid XML rdr.parse("<catalog><book id='bk101'></book></cataloge>") =MessageBox("Invalid XML. This message should never appear.") Catch to loException =MessageBox(; Ltrim(Str(loException.ErrorNo))+; loException.Message+; Iif(IsNull(loException.Details),""," "+loException.Details)) Finally EndTry Define Class _XMLValidator as custom IMPLEMENTS IVBSAXErrorHandler IN {F5078F18-C551-11D3-89B9-0000F81FE221}#4.0 &&"c:\windows\system32\msxml4.dll" **** IVBSAXErrorHandler PROCEDURE IVBSAXErrorHandler_error(; oLocator AS VARIANT, strErrorMessage AS STRING @, nErrorCode AS Number) AS VOID; HELPSTRING "Receive notification of a recoverable error." * add user code here =MessageBox("Error") ENDPROC PROCEDURE IVBSAXErrorHandler_fatalError(; oLocator AS VARIANT, strErrorMessage AS STRING @, nErrorCode AS Number) AS VOID; HELPSTRING "Receive notification of a non-recoverable error." * add user code here =MessageBox("Fatal Error") ENDPROC PROCEDURE IVBSAXErrorHandler_ignorableWarning(; oLocator AS VARIANT, strErrorMessage AS STRING @, nErrorCode AS Number) AS VOID; HELPSTRING "Receive notification of an ignorable warning." * add user code here =MessageBox("Ignorable Warning") ENDPROC ENDDEFINE ****************************** Please, advise Thank you. Tag: October 2005 letter on Visual FoxPro web site Tag: 216761
  - 2
    - Calling a Crystal Rpt file version 11 from VFP I see code for calling other Crystal versions from VFP but I am wondering how to do this for version 11. Thanks in advance. Tag: October 2005 letter on Visual FoxPro web site Tag: 216753
  - 3
    - ODBC for remote views Have always used ODBC to access data remotely in VFP 6. Been told this method is "outdated". The application primarily reads SQL data. Is ODBC still the most reliable and (more importantly) fastest method of accessing remote data in VFP6? - Ben Tag: October 2005 letter on Visual FoxPro web site Tag: 216752
  - 4
    - memo field Hi All, I have a table with memo field created in FoxPro 2.6. We've been using VFP 6.0 and now we want to move the data to SQL 2000, I have tried using the DTS, (comes with SQL 2000), to transfer the data, but some of the contents in the memo field are missing. Does anyone have a better way to transfer table with memo field to SQL 2000 without lossing contents in the memo field. Many Thanks, Nancy Tag: October 2005 letter on Visual FoxPro web site Tag: 216750
  - 5
    - resend: Windows Fax Service i'm able to send out fax using xp fax service. but how can i extract send status from Fax like what we see in fax consol in Foxpro ? Thanks! Tag: October 2005 letter on Visual FoxPro web site Tag: 216746
  - 6
    - VFP9 report data environment display bug I have a report data environment with many tables and many relations (> 20 tables up to 5 levels deep). Works fine in report data environment. However when I save the data environment to a dataenvironment class and reuse it on another report, the layout of the tables in the data environment is lost. They just appear in a straight line across the data environment designer. This in its self is not the problem, just an annoyance. The problem is that at some point, I can not get to the tables on the far right side of the data environment designer. The relation lines go off the right side and no matter what I do, I an not get to the tables to reorganise them. I tried resizing the form every which way, resiizing the screen resolution. Even tried editing the table directly. So, how can I get to these tables to lay them out neatly? Cheers David Tag: October 2005 letter on Visual FoxPro web site Tag: 216743
  - 7
    - Dataenvironment Is there any way to preserve the layout of the data environment once it is saved to a datanevironment class and reused on a report. It seems to lose the entire layout and reverts to a straight line across the dataenvironment designer.. Cheers David Tag: October 2005 letter on Visual FoxPro web site Tag: 216742
  - 8
    - Populate web page fields Hello, I need to populate a form on a web page with data from a single record. How do I map a table field to a web page field and then do the web page population? Make sense? Thanks RH Tag: October 2005 letter on Visual FoxPro web site Tag: 216739
  - 9
    - function syntax hi all, just to make this simple. I want to call a function, pass 3 parameters to the function and I want the function to pass back the total of the 3 parameters and the product (parm1 * parm2 * parm3). I thought the following will do it, but it doesn't. How is it done? Function returnvalues(parm1,parm2,parm3) numadded=parm1+parm2+parm3 nummultip=parm1*parm2*parm3 RETURN (numadded, nummultip) ENDFUNC thanks Hutch -- --------------------------------------------------------------------- "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: October 2005 letter on Visual FoxPro web site Tag: 216731
  - 10
    - Error instantiating Class I can't seem to get rid of this message whenever I open this form. I am asked for the location of the Class, point it to the proper place and then save. My efforts at executing Project->Build, Project->Refresh, Project->Clean Up Project will not make this message disappear. I am Using VFP 9.0 and hope I do not have to completely rebuild this form! Thanks for your help Tag: October 2005 letter on Visual FoxPro web site Tag: 216727
  - 11
    - web service : using FFC\_WS3Client.vcx hi i have a small dll ( VFP 9 - mult subproc ) for consuming a web service i instantiate the dll on My PC with CreateObject and it's all right then, i put the DLL on the server i instantiate it with CreateObjectEX up to this point it's all right ... BUT it can't get the reference to "web service" at the method SetupClient( ) i'm using the FFC\_WS3Client.vcx class any idea ? thanks -- atte, Hernán Tag: October 2005 letter on Visual FoxPro web site Tag: 216719
  - 12
    - OLE Automation and Window handles I am working with automating some barcode label software in VFP 9. One of the OLE functions is used to draw a preview image of the barcode label in an image object. The parameter of the function requires a handle to the control that I want to paint the image in. This can be accomplished in Visual Basic by using the hWnd property of the image control. VFP does not have this functionality that I am aware of for controls. 1.) Is it possible to use this method of painting in an image control in VFP 9? 2.) If not, is it possible to use a form and draw the label preview directly on the form using the form's hWnd propery, maybe by using GDI? Thanks for any help you can give. Tag: October 2005 letter on Visual FoxPro web site Tag: 216715
  - 13
    - update conflict I have code like its CREATE SQL VIEW wfzby REMOTE CONNECTION dbccon AS ; select * from wfzby append blank repl ne with xx &&" 1001" tableUpdate(.t.) refresh() requery() skip -1 skip +1 replace rt with '1' skip -1 * here is error skip +1 what is wrong that is error: conflict update? Adam Rataj Tag: October 2005 letter on Visual FoxPro web site Tag: 216699
  - 14
    - Who Dunnit? Thanks in advance for the help. I have a nightly job which sometimes fails to run because a user stayed in the application and the nightly job can't get exclusive access to the files which need to be updated. I have the following questions: 1. Is there any way for me to get VFP to tell me which user has the file open? 2. Is there a way (that works) to have applications terminate at a specific time? I tried putting a timer on the main form but if the user stays in a sub-form, it never gets back to the main form (or the main form timer fires but can't close the app because a sub-form is open). Do I need a timer on each form? Do I need to write a routine like: FOR EACH OPEN FORM OpenForm.Close() NEXT If that is the way to go can someone tell me the actual code that will do this? Thanks, Jeff Tag: October 2005 letter on Visual FoxPro web site Tag: 216698
  - 15
    - error (108) "File is in use by another user" I have "discovered" that this can prevent a table opening ie if the file is in use with a REPLACE FOR/WHILE then another user cannot open the table. Is this correct or am i missing something?? i know i have set reprocess to 1 but i'm just trying to open the table not edit it Greg Tag: October 2005 letter on Visual FoxPro web site Tag: 216691
  - 16
    - Update syntax problem I try the following syntax in command window. but got errors. Does anyone can help me to correct it ?? Thanks in advance update blcostheader set jobperiod = jobheader.jobperiod from blcostheader ,jobheader where jobheader.jobno = blcostheader.jobno Tag: October 2005 letter on Visual FoxPro web site Tag: 216684
  - 17
    - Network Drive is there a function that can determine this drive is a NETWORK? Tag: October 2005 letter on Visual FoxPro web site Tag: 216683
  - 18
    - Default Directory Hi all, I am not sure why this is working like this. What am I doing wrong? all I want is to allow the user to select a directory and I want to set this selected directory as the default directory. here is the code: CLEAR tempdir = Getdir() && I am selecting the C:\Casino directory ?tempdir Set default To SET DEFAULT TO ("&tempdir") ?"Default Dir= "+SET('default') SET path TO (HOME() + 'ccalps') Additive ?"path =" +SET('path') and here is the output: (Notice how the Default Directory is showing as C: only !!!!!!) c:\casino Default Dir=C: path=C:\Program files\microsoft visual foxpro9\ccalps -- --------------------------------------------------------------------- "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: October 2005 letter on Visual FoxPro web site Tag: 216676
  - 19
    - Running application installed by InstallShield Limited edition for VFP as limited account Hi, I have an application, which I install with InstallShield Limited edition for VFP. It has some ActiveX controls, and also I use several merge modules After installing, application works fine if I run it logged as Admin But if I try to run it logged on a limited account (which is member of users group only), I get an error, Class not registered (when application try to create an ActiveX object instance) I had another problem early, with write access in application root folder (because it is installed in Program Files), but I manage to handle it, by setting Permissions for install folder: I created an entry Users, and give it all rights. I try the same for ActiveX I use in my project (setting full permissions for them individually to Full) but still don't work Can anyone give me a suggestion howe to handle it? Thank you Bogdan Zamfir Tag: October 2005 letter on Visual FoxPro web site Tag: 216670
  - 20
    - working with to records. i have a table, and it has 101 records in it. 2 records for each person. i want to subtract field1 record 1 from field2 record2 of the same person and replace the value of field 1 with the result. is that asking to much without having to create a temp table? Tag: October 2005 letter on Visual FoxPro web site Tag: 216659
  - 21
    - Report Form xx PROMPT vs. Default Printer Hi All, Ever experienced super small 1/4 size printing on a report? In circumstances where you use the PROMPT and NOPAGEEJECT options on the REPORT FORM command so that the user can select the printer desired and so that a subsequent report will be part of the same print job, the subsequent report will always use the default printer driver no matter what printer the user selected. IOW, the PROMPT option of the report command only effects that specific report and not all the reports that are part of the same print job. Example: REPORT FORM A1 TO PRINTER PROMPT NOPAGEEJECT NOCONSOLE REPORT FORM A2 TO PRINTER NOCONSOLE If the user selects any printer other than the default when prompted the two reports above that are both part of the same print job will be printed to the same printer using different printer drivers for the first and second reports. (Keeping them part of the same print job is really handy when printing to a PDF file) . Using the wrong printer driver for a report going to a printer can give you strange results. Is there a way to force multiple reports that are part of the same print job and all going to the same printer to use the printer driver that is related to the PROMPT selection made on the first report? I have resorted to placing a sys(1037) in code just before my report rather than using the PROMPT option on a REPORT FORM command, to change the default printer. It is a kludge and does not present as nice a user interaction as the prompt option but it works. This seems like a minor bug to me... Anyone have a new information or ideas? -- Alec Tag: October 2005 letter on Visual FoxPro web site Tag: 216649
  - 22
    - Wish list : TOTAL... EXCEPT ... How about : TOTAL ON ID_EQUI TO m:\matable.dbf EXCEPT ID_EQUI Fabien Tag: October 2005 letter on Visual FoxPro web site Tag: 216648
  - 23
    - Wish list: update sql How about a: update <TableName> from name <ObjectName> where .... Tag: October 2005 letter on Visual FoxPro web site Tag: 216643
  - 24
    - form.click()? A form with a textbox. Click the textbox. enter a few characters. then the mouse click outside the textbox. what event is fired? Definitely not form.click().... -- .~. Might, Courage, Vision. http://www.linux-sxs.org / v \ /( _ )\ Linux 2.6.13 ^ ^ 21:57:01 up 9 days 43 min load average: 1.02 1.02 1.00 Tag: October 2005 letter on Visual FoxPro web site Tag: 216640
  - 25
    - SourceSafe hangs when multiple users access anything at the same t Does anyone else have the problem when using Visual SourceSafe and two or more developers start up VFP (or one starts up and another wants to modify a form) at the same time. Basically it seems hang when multiple users do anything at the same time, that accesses the VSS database. It hangs until one of the users kills VFP. It seems wired that this would happen when the purpose of SourceSafe is to allow you to develop in a multi-user environment. Has anyone else experienced this or is there something we could try to solve this? Thanks, Jerry Tag: October 2005 letter on Visual FoxPro web site Tag: 216639
- Next
  - 1
    - call32.dll questions I've been using Rick Strahl's call32.dll from FPW with fairly high success on Win95 and ntvdm under 2K and XP. It can be a bit painful at times (eg just trying to Declare32 a non existant function name will throw a GPF instead of something friendlier.) There's also an annoyance when trying to RegFN() - if you pass the whole path to the dll then the second and subsequent attempts to register a function claim there is no function of that name within the dll. Relative paths seem OK but since I can't be sure of current directory I found the easiest thing to do was change default to dll directory, register the functions and then change default back. Anyway, sometimes after a few function calls, a GPF will be thrown just trying to call any function in call32. It is always the same GPF and it persists between FPW sessions. I have found that if I kill off the ntvdm process using task manager then it starts working again (or, of course, reboot. Merely exiting all 16bit applications doesn't stop wowexec and ntvdm, they are left running for a quicker startup if you run another 16bit application.) Does anyone have any idea why it seems to go a bit screwy after a while? It's a little annoying because I thought I'd got it working stably but now I've put it into production the flakiness has been exposed. All the examples I've seen for calling functions in external dlls don't do anything to tidy up afterwards and I wonder if this is the problem? The next thing I'm going to try is the latest version of call32.dll, it was originally written for VB and Rick took the source and added a few other functions that may be useful to Foxpro programmers. The latest version has been updated a couple of times since Rick's build and there is an extra function to free libraries used. Anyone else have any experience with this module? -- TIA Andrew Howell Tag: October 2005 letter on Visual FoxPro web site Tag: 216634
  - 2
    - discrepancy between keyboard an mouse I have an textbox with an input mask of "999,999.99" The value is "0.00" Then the user used the mouse and hit the space on the left of the leftmost "0" in "0.00" and typed "1" The field now displayed like "1 0.00". If I used the mouse to exit the field (by hitting somewhere else in the from, the value become "10.00" If I hit <ENTER> key, the value becomes "1.00", which was what the user expected. Now, how could I make the mouse hit to behave as keyboard? -- .~. Might, Courage, Vision. http://www.linux-sxs.org / v \ /( _ )\ Linux 2.6.13 ^ ^ 19:42:01 up 8 days 22:28 load average: 1.00 1.02 1.00 Tag: October 2005 letter on Visual FoxPro web site Tag: 216633
  - 3
    - Screensaver Question I'm trying to deactivate the screen saver programatically using SystemParametersInfo DECLARE INTEGER SystemParametersInfo IN user32; INTEGER uiAction, INTEGER uiParam,; INTEGER @pvParam, INTEGER fWinIni when I use SystemParametersInfo(SPI_GETSCREENSAVEACTIVE, 0, @lnTemp, 0) or SystemParametersInfo(SPI_GETSCREENSAVERRUNNING, 0, @lnTemp, 0) I can detect whether the screen saver is running / active etc but neither SystemParametersInfo(SPI_SETSCREENSAVEACTIVE, .T., @lnTemp, 0) or SystemParametersInfo(SPI_SETSCREENSAVERRUNNING, .F., @lnTemp, 0) will turn it off, I've tried using .T. or .F. but it doesn't make any difference. Does anybody use these successfully? What am I doing wrong? Thanks LH Tag: October 2005 letter on Visual FoxPro web site Tag: 216629
  - 4
    - Autosize Problem I have a generic form with a label that is passed a variable size caption. I set the caption in the Init method. Autosize is set to .T.. I then resize the form in the Activate method in relation to the change in the size of the label. This works fine in VFP 8.0, but it doesn't work in 9.0. In 8.0, the change in size is recognized at the time of the Activate method, but this is not the case in 9.0. I can create a breakpoint in the Activate method and step through the critical lines of code and it will recognize the autosize change. Any suggestions? Rick Tag: October 2005 letter on Visual FoxPro web site Tag: 216628
  - 5
    - Select from an Array Can you do this? I have a single dimension array containing a list of different widgets. I would like to count the quantity of each widget in the array. Can I use a select statement for this? tia Tag: October 2005 letter on Visual FoxPro web site Tag: 216616
  - 6
    - Adding a picture to a general field VFP9. I want to programmatically add a picture (e.g. a .gif file) to a general type field for use in a report. I couldn't find how to do this in the doc. I tried the APPEND GENERAL command and looked at the sample, but my results only put the file name in the field and no picture showed on the report. I can do it interactively in the report designer, but I want the user to select the file for his/her own logo. Thanks for any help. Steve Meyerson Tag: October 2005 letter on Visual FoxPro web site Tag: 216615
  - 7
    - Object class is invalid for this container When I try to copy an OLE control from one class library into another, I get the error message "Object class is invalid for this container". Obviously that's a mistake, because the class already exists in a class library. Any suggestions? Tag: October 2005 letter on Visual FoxPro web site Tag: 216611
  - 8
    - Wish list: append from name <ObjectName> Any support for this? -Lew Tag: October 2005 letter on Visual FoxPro web site Tag: 216606
  - 9
    - Difference between fdate(,1) and ftime() Can anyone explain this, please? -Lew Tag: October 2005 letter on Visual FoxPro web site Tag: 216605
  - 10
    - MS Word Problem Lee: Thanks for the suggestion, but that caused no difference. It should also be noted that MS Word starts and opens the original document, but then displays an error "This cannot be completed because of a dialog or database engines failure. Please try again." Thanks. BR I can't reply to the earlier question. I get an error with an Infortion icon and 3 choices, but no words.? Tag: October 2005 letter on Visual FoxPro web site Tag: 216603
  - 11
    - MS Word Merge problems using VFP 9.0 I am having a lot of problems getting a MS Word Merge to work from VFP 9.0. I swear it used to work in 6.0. I am getting the error message "OLE IDispatch exception code 0 from Microsoft Word: Word was unable to open the data source..." Below is a majority of the code. The last line is what generates to error. TIA for taking a look. Thisform.Wordmailmerge1.cSQL = "" Thisform.Wordmailmerge1.cDataPath = SYS(5) + CURDIR() Thisform.Wordmailmerge1.cDataSource = "OUTPUTER" Thisform.Wordmailmerge1.cFormLetter = ALLTRIM(THISFORM.PrimaryDOC.VALUE) Thisform.Wordmailmerge1.lSave = .T. Thisform.Wordmailmerge1.cSaveAsFolder = FOLDERNAMEIS Thisform.Wordmailmerge1.cSaveAsName = FILENAMEIS Thisform.Wordmailmerge1.Merge Local oWord, lcFileName, lcConnectionString, oFormLetter If Empty(This.cSQL) Then This.cSQL = "SELECT * FROM " + This.cDataSource Endif lcFilename = addbs(This.cDataPath) + This.cDataSource + ".DBF" If !Directory(This.cDataPath) Then Messagebox("Invalid Datapath specified : " + This.cDatapath, 0, "Error") Return Endif If !File(Addbs(This.cDatapath) + This.cDataSource + ".DBF") Then Messagebox("Datasource " + addbs(This.cDatapath) + This.cDataSource + ".DBF does not exist", 0, "Error") Return Endif If !File(This.cFormLetter) Then Messagebox("Form Letter " + This.cFormLetter + " does not exist", 0, "Error") Return Endif lcConnectionString = "DSN=FoxPro Files - Word;UID=;PWD=;SourceDB=" + This.cDataPath + ";SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=MACHINE;Null=Yes;D eleted=Yes;" On Error Do MSMergeError oWord = GetObject(,"Word") *ON ERROR DO errhandler WITH ERROR( ), MESSAGE( ), MESSAGE(1), PROGRAM( ), LINENO( ) ON ERROR If Type("oWord") != "O" Then oWord = CreateObject("Word.Application") If Type("oWord") !="O" Then MessageBox("Unable to start MS Word", 0, "Error") Return Endif Endif With oWord .visible=.t. EndWith lnSelectArea=select() oWord.Documents.Open(This.cFormLetter, .F., .F., .F., "", "", .F., "", "", 0) oFormLetter = oWord.ActiveDocument oWord.ActiveDocument.MailMerge.OpenDataSource(lcFilename, 0, .F., .F., .T., .F., "", "", .F., "", "", lcConnectionString, This.cSQL, "") BR Tag: October 2005 letter on Visual FoxPro web site Tag: 216592
  - 12
    - How do you read postdata in a webbrowser control? I'm working on a VFP project for engineers designed to help them collect descriptions, links and images from manufactures sites to simplify creating design documents. Part of the time saving aspect of this project is to reduce the dozens of times each day they have to logon to each manufacture site and search/navigate to the pages they need for their projects. To accomplish this for non-programmers I need a way to capture POSTDATA from the beforenavigate2 event. I believe the datatype is a safearray. I've found code that is for VB that uses lenb and midb functions. It looks like this: Private Sub ctrlWB_BeforeNavigate2(ByVal pDisp As Object, URL As Variant, Flags As Variant, TargetFrameName As Variant, PostData As Variant, Headers As Variant, Cancel As Boolean) If pDisp Is ctrlWB.object Then Dim lCount As Long Dim lLen As Long Dim strPostData As String lLen = LenB(PostData) ' Use LenB to get the byte count If lLen > 0 Then ' If it's a post form, lLen will be > 0 For lCount = 1 To lLen strPostData = strPostData & Chr(AscB(MidB(PostData, lCount, 1))) ' Use MidB to get 1 byte at a time Next MsgBox strPostData End If End If End Sub But I can't seem to figure out what I need to do in VFP to capture and use this data. Many thanks in advance! Tag: October 2005 letter on Visual FoxPro web site Tag: 216591
  - 13
    - VFP 6.0 and Network Access Storage (NAS) Our Win2K server was recently migrated to Oa new NAS (Network Attached Storage) device. Since this time, some of our application have been receiving 'Cannot Update Cursor' errors. I've narrowed it down to when a 'PACK' command is issued. The application utilizes a control file that stores folder names in it associated with the server on the Q:\ drive (i.e. Q:\TEST). The application has been running for years and hasn't had updates in the past 9 months. Since the NAS migration, these errors have been experienced. Any thoughts on how to get around this? It is my understanding that this NAS device uses a Linux OS - so my guess is there are compatibility issues. Tag: October 2005 letter on Visual FoxPro web site Tag: 216590
  - 14
    - Advice for first time "contractor" I've been programming (in FoxPro) for around 10 years and working at it (W2) for 8 or so. I've had quite a few jobs. I am sometimes asked if I want to work as a contractor or as an employee and I have always said "employee" mainly because I've always done that. I figured I could probably easily take those jobs on a contract basis and figured that someday I'd have to (or even want to) but that day hasn't come until today. A recruiter got my resume off an employment recruitment site and has been lining me up for a position at one of their client companies and yesterday I was told that the decision has been made that I get the job (starting Monday). I am to be paid on an hourly basis as a contractor. They emailed me papers to sign yesterday. Generally, when I sign preemployment papers I scan them and sign, have a general idea what it's about, the legalese notwithstanding. Since I was at home this time, at my "leisure," I took the time to read this stuff carefully. Most of it looks pretty OK, although I'm rather inexperienced at this, obviously. There's a nondisclosure agreement, a W9 form - pretty standard stuff. Then there's the 5 page contract with an "Exhibit A" tacked onto that, being a purchase order for my services. That's a bit weird from my perspective, but probably standard, I figure. It states my hourly rate, basically, with a sentence or two with yet another guarantee by me that I won't make any agreements with the 3rd party for a year after the completion of my assignment, things of that nature. In the contract they want me to guarantee that if I do start working directly with their client, I will fork over 20% of my salary. I guess I'm OK with signing on that. However when I got to paragraph 12 in the contract, I did a double take: 12. INSURANCE. Contractor will obtain for itself and its personnel before providing services, at its own expense, comprehensive General Liability insurance coverage for projects covered by this Agreement, for limits of liability not less than $500,000 and will name <insert name of recruiter here> as an Additional Insured, provide a copy of the binder and policy to <insert name of recruiter here>, and hold <insert name of recruiter here> harmless for any damages or expenses, including attorney's fees, incurred as a result of misconduct of Contractor or its personnel involving <insert name of recruiter here>, the TPU (third party unit), or any customer of client of the TPU. Now, that's something I wasn't prepared for and I figure I'll be calling them first thing in the morning - their office won't be opening for at least 3 hours. You people with experience, can you tell me what this is about? Are they going to waive this for me? I can't believe that they recruited me with the assumption that I already have an insurance policy of this nature and didn't ask me up front. I'm a computer programmer, and they were careful to check out my references before making me the offer. In the past, the trust inherent in that type relationship has floated my boat. Please, in addition to answering that specific question, can I get some tips and hints to give me a more solid footing in embarking on my first gig as a contractor? I've had quite a few contractor-like assignments, but never actually been on a contract basis. I always figured it was going to be principally a matter of filling out some different or extra IRS forms, but I guess there's more to it. For one thing, it looks like I'm going to have to manage my own withholding of federal and state taxes and SS. Do I do that at tax time or do I have to manage that during the work year? This job is 6 months+ (I'm told it's funded for a year, possibly with extensions) but I will be on a trial basis, especially at the start. The TPU is contractually entitled to send me home for any reason at any time. The contract seems to carefully stipulate that I'm entitled to zero benefits, just my hourly rate with no possibility of extra compensation for overtime, no possibility of being compensated for training of any kind, etc. I am in California. Thanks for any help. Tag: October 2005 letter on Visual FoxPro web site Tag: 216589
  - 15
    - Can anyone recommend .. Know might not be the propper forum to ask but here I go and ask you guy that 'can anyone recommend me a VFP Magzine for subscription' ? It will be better if an on-line+Print edition are both available? Tag: October 2005 letter on Visual FoxPro web site Tag: 216586
  - 16
    - Remote View ODBC error (VFP6) I keep getting this error and have no clue why. Error: 1526 Connectivity Error: Unable to retrieve specific error information. Driver is probably out of resources I'm using a remote view which refreshes every 10 seconds. Runs fine about 100 times then this OR same error with a SQL deadlock. Any ideas? Thanks in advance for any help. - Ben Tag: October 2005 letter on Visual FoxPro web site Tag: 216582
  - 17
    - SQL Stump I am having problems coming up with an sql statement to get the data that I want. I would like to get the data in one SQL statement if possible and I cannot get my brain to work this morning. I have 3 tables, user, locations, and user_locations. The user to locations is a many to many hence the user_locations. The user_locations table basically just says what locations a user has access to example user table User1 User2 Location Table loc1 loc2 loc3 loc4 If I want user 1 to have access to location 1 and location 4 I would put these records in the user_locations table User_locations Table user1 loc1 user1 loc4 Anyway the query I want is a listing of all of the locations and a true or a false whether the user has access filtered of course by user select (need something here) where user = user1 would return loc1 yes loc2 no loc3 no loc4 yes Anyway I am stumped right now on getting the right SQL statement to give me my data. -- TIA Altman VFP9 Tag: October 2005 letter on Visual FoxPro web site Tag: 216562
  - 18
    - Alog problem , please help. I got two invoice table, InvHeader(company,invno) InvDetail.(ChargeItem, unitprice,invno) select Invheader.company,InvDetail.chargeitem,InvDetail.unitprice from InvHeader,InvDetail where InvHeader.invno = InvDetail.innvo into cursor pTempTable Scan select "InvInfo" append blank in "InvInfo" replace InvInfo.company with pTempTable.company Do case case InvInfo.chargeitem = "PEN" replace invinfo.pen with pTempTable.unitprice case InvInfo.chargeitem = "TOY" replace invinfo.toy with pTempTable.unitprice casel........ endcase endscan Now, the problem is , invinfo got over 10 different types. (pen, toy-car,toy-doll,toy-xxxx). I need to check each types and give one file tables to my client. If my invoice tables got over 10000 records, the above process need over 1 hrs to process. Any faster method to process it ??? thanks a lot. Thanks a lot Tag: October 2005 letter on Visual FoxPro web site Tag: 216560
  - 19
    - How to Block an active windows for being Hide! Hi , I'd like to know how can I get the same effect of the Modal property of a form en VFP but in Foxpro 2.6 for windows in order to avoid that a User by mistake hide a current active window an put another active window in front and seem like the program has block! I try the wintop() funtion but anything happens. Thanks. Oscar. Tag: October 2005 letter on Visual FoxPro web site Tag: 216556
  - 20
    - Pagesetupdlg Hi Can anyone tell me how to create an object to give me the same dialogue box as I get with Pagesetupdlg() as produced by the Comdlg32 dll, I am looking for an OCX that I can feed into visual foxpro. Kind Regards Andrew Bowles -- I am using the free version of SPAMfighter for private users. It has removed 1127 spam emails to date. Paying users do not have this message in their emails. Try www.SPAMfighter.com for free now! Tag: October 2005 letter on Visual FoxPro web site Tag: 216552
  - 21
    - Table Limits I have a table that is going to start growing real fast and I need to know about how many records the limit will be. I realize that the table size limit is 2GB. Therefore I'm guessing I can take the record length that is listed in foxpro and divide this number by 2GB. Is this correct. For instance my record length is 301 therefore if I take 2,147,483,648 / 301 I get 7,134,497 records. Is this the correct way to figure it, or are there more figures involved that I am not aware of. -- TIA Altman VFP9 Tag: October 2005 letter on Visual FoxPro web site Tag: 216550
  - 22
    - set procedure vs close all... My coding may be a bit rusty, but should a close all command also clear my set classlib/set procedure values? I thought set procedure to and set classlib to were necessary for this. -Lew Tag: October 2005 letter on Visual FoxPro web site Tag: 216544
  - 23
    - PagesetupDlg using VFP 8.0 Hi I am trying to initialize the Page Setup Dialogue box (PAGESETUPDLG(@lcBuffer)) with a buffer string already saved to file, the Pagesetupdlg allows me to pass the buffer string into and out of the function and works a treat whilst I remain within the foxpro environment, however should I exit foxpro then upon my return to the program the Pagesetup dialogue box gets reintialized with my default printer even though I am telling it to use the buffer string previously saved to file. Can anyone give me any pointers ? Kind regards Andrew Bowles Tag: October 2005 letter on Visual FoxPro web site Tag: 216541
  - 24
    - MAPI32 problem ? i'm able to automate mail sending from outlook using mapi32.. but why is receipient in TO and CC is being switch ? the receipient type i set is : To = 1 Cc = 2 Bcc= 3 if only one receipient is sent, these setting is correct. but will have problem if more than 1 recipients. e.g To recipient will sent as Cc, Cc recipient will sent as To. is this a know problem ? any work around this ? thanks! Tag: October 2005 letter on Visual FoxPro web site Tag: 216539
  - 25
    - Report footer problem I have a 2 inch report footer with each field having Remove lines if blank set. However, even if no footer info prints, the footer still takes up 2 inches. How can I get it to take up no space at all if nothing print in the footer. Alternately, is there a way to suppress the whole footer if a condition is evaluated? I am trying to create an invoice layout with the totals on the bottom. Because there are multiple invoices in a row, I am putting the totals in the footer but I want to only print the footer on the last page of each invoice. I achieve this by use of a Print When expression. Perhaps there is a better way to achieve this. Cheers David Tag: October 2005 letter on Visual FoxPro web site Tag: 216530

October letter at http://msdn.microsoft.com/vfoxpro/letters/. This month's
letter contains information about new content online about Visual FoxPro
9.0, news about the SP1 for Visual FoxPro 9.0 beta download, more in-depth
information about Microsoft's roadmap for Visual FoxPro, plus recent content
and community news. There is a new one hour audio podcast (MP3) interview
on the FoxShow, FoxShow #24: Interview with Ken Levy with mentions of
various members of the VFP team, Sedna, transparency, VFP roadmap, etc.

Ken Levy
VS Data Product Manager
Microsoft
http://blogs.msdn.com/klevy
http://msdn.microsoft.com/vfoxpro

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden

Top