Optional Parameter

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
    - string to integer? Is there anyway to convert a field saved in a db as a text field into an integer? i have a field thats padded by 0's on the left so you have numbers like 0000345, but the way they are stored in our db is just by the number 3-45 (with a dash) i have the dash removed in the select statement, but i need to remove the padding zeros from the other one to compare them... normally you can do that with integer conversion... but foxpro doesn't seem to like converting string numbers to integers? any help would be nice.. thanks! Tag: Optional Parameter Tag: 187702
  - 2
    - removeing char from string If i had a string like "3465-564576-3456-6" and i wanted all the dashes removed, how would you do that in foxpro? Tag: Optional Parameter Tag: 187700
  - 3
    - VFPOLEDB returning "Cannot update the cursor" Hi all, (And sorry for the double post for any .NET group readers) I'm trying to write to a VFP table from a .NET program using OLE DB. It returns 'Cannot update the cursor "cursor", since it is read-only.' The table is not open by any other source at the time and it wasn't flagged as read-only in the OS. I'm pretty ignorant when getting into OLE DB. Is there a setting in the driver that could be causing it? If so, direction as to where to address it would be great! TIA, John Tag: Optional Parameter Tag: 187694
  - 4
    - Tab Delim files with header import? If a file you are trying to import into a cursor is tab delimited and has a header column... how would you ignore the header column? im C++ we'd just read the next record, but since this is foxpro and things are diffrent, and im using APPEND FROM (fileName) DELIMITED WITH TAB as my statement... any suggestions? thanks Tag: Optional Parameter Tag: 187689
  - 5
    - Is it possible to change HeaderHeight property in a grid if View property is 1? If View property is 1 (Change), the header is viewed vertically. I want to change the width of the header. Is it possible? TIA. Tag: Optional Parameter Tag: 187687
  - 6
    - Visual foxpro executed file (.exe) if the executed file (.exe) was created in visual foxpro 7.0, is it possible to run it in visual foxpro 8.0? Tag: Optional Parameter Tag: 187684
  - 7
    - compare two fox tables Dear All, I wanted to findout whether user made any changes in a fox table. Is there any function to do this ? Thanks in advance Jijo David Tag: Optional Parameter Tag: 187680
  - 8
    - Install Problem with FPW26a Application I've got a real problem with a FPW2.6a program and I could use some big help on it! This is long but I don't know how to shorten it, sorry. Here's the problem: I have a program that has existed for many years and is downloaded over the internet. There have been a number of upgrades made and is currently on version 4.1. The program has been installed by hundreds of different people and more times than that by me personally with no problems. Yesterday I got a message from a new user using WinXP. He said he could not install the program and got the following error message during install: "An error has occurred in your application / If you choose Ignore you should save your work in a new file / If you choose close, your application will terminate." The error window within the FPW install window is titled "DSHELL". What I've done: I tried to install the program and I too got an error. On a Win98SE machine the error read similar indicating a problem with DSHELL. The "ignore" button does nothing. After using the "Close" button, the machine exhibits a "not enough memory" error if I try installing again without resetting the computer. I tried to install an older version of the same program and now get the same error (when I had installed from the same install files many times before). I re-setup the program within FPW26a and then tried another install. Got the same failure. As of now, I can not install any version of the program. I did a complete virus check on the machine and there is no virus. I know that the install program's setup.lst file shows, under [Params] section, that DrvModName = DSHELL but I do not know the significance of it. It seems to me that maybe one of the dlls that get installed by the FPW26a installer is bad and for some reason (?) replaced the one I had on my machine. This would have to be one of the old FPW era dlls since common ones would be dated much later and should not get replaced. I tried removing some some of these old dlls and replaced them with ones that came with FPW26a. Now I get a different error that "Bind time error. 'SPAWN' not found in specified library" before I can get to the original error. Any help would be greatly appreciated! Ray Tag: Optional Parameter Tag: 187679
  - 9
    - how can I get the loginname of user? Dear All, I want to ask that how can I get the login name on the viusal foxpro? since I need to use GETOBJECT() function get the user's detail information from the domain. Thank you!! Happy new year! Nic Tag: Optional Parameter Tag: 187665
  - 10
    - Newbie - Report Hi all, I would like to print this in report:- item Description of Goods Quantity 1 Apple 10 2 Banana 20 3 Orange 30 I just don't know how to print out the ITEM column, by writing up SQL statement properly. Many thanks. Regards, Wandy Tag: Optional Parameter Tag: 187661
  - 11
    - CDX structure Hi All! I am looking for CDX structure with terms explanation. There are many CDX and IDX docs but I dont understand their terms like "exterior node" etc. They say CDX is "similar" to IDC but I cant find this similarity ! Tag: Optional Parameter Tag: 187660
  - 12
    - Screen Font Easiest question of the day (I hope). When I do a "dir" or "list stru" from my VFP 8 command box, the font is too large. I have looked high and low and cannot find where to change it. Can someone tell me how to fix this nuisance? Thanks, Scott Tag: Optional Parameter Tag: 187657
  - 13
    - creating check boxes programmatically Hi all, I've recently started working on a project using microsoft visual foxpro 8.0. Unfortunately i met with some problems creating checkboxes wif values retrieved from a database table. Any help is appreciated. Thanks Tag: Optional Parameter Tag: 187656
  - 14
    - FoxPro Interop Okay, A foxpro programmer I am not, however...I wrote a class in vfp6. In this class I wrote a procedure that accepts three parameters. I compiled the dll. I wrote another app in VB6 that uses this class. Almost everything works. My only problem is with my parameters. I am trying to pass them by reference but I can't get it to work (and not sure that it will at all), does anyone have any thoughts on this? Could someone give me a template of how I would pass parameters by ref? I have seen the @ sign used, but I can't seem to get that to work...may be it's because I'm using vfp6... Thanks in advance. Tag: Optional Parameter Tag: 187655
  - 15
    - Fox 5&6 page frame instabilities I am writing a program for a company that has a truly computer phobic CEO. Because of that, I used a page framew with 9 pages to make it appear as simple as possible. The menu bar was to be accessed only by a computer literate staffer. When most of the program was done, it started exhibiting instablities that I couldn't get rid of. I tried manually controlling data and control issues. When that didn't work, I tried using as many automatic program building wizards as possible. That didn't work either. I tried using a floating window above the page frame with a menu bar inside it, and that had limited sucess. I can find nothing on the limitations of the number of pages and controls allowed in a page frame. I don't know if Fox 8 will work, and I'm reluctant to buy it and go to all the work involved in upgrading the program and then not have it work. If anyone has knowledge of a possible work-around, or knows whether version 8 would allow that many pages and controls, please let me know. Jack Hunt Creative Systems Tag: Optional Parameter Tag: 187654
  - 16
    - ADO and performance I'm working with an ADO connection via ODBC into a 1.3GB VFP table, and I'm finding it to be excruciatingly slow (don't ask why I'm doing it this way...). The recordset has about 5000 records in it. Doing a MoveFirst takes over 2 minutes. A query that retreives about 4700 records takes about 2 1/2 minutes. I'm wondering at this point if working via ADO is normally slow, and this is "normal" performance? Tag: Optional Parameter Tag: 187645
  - 17
    - Create a report file for email Happy Holiday To You All, I need to be able to print my report in a format (may be .PDF format?)so I'll be able to email them to my customers. Can you please help me. Thanks a million in advance, Nancy Tag: Optional Parameter Tag: 187634
  - 18
    - strange behavior in IDE for foxpro... Does anyone know what might be causeing this? Every time I go into a project and try to use the builder it says it cant be found... so i have to go reset the path to the builder each time the project loads... but it's not just the builder it doesn't remember the path to... there are a few others that get lost also... but when i make a brand new project, it knows where the builder is! only older projects from foxpro 6 are doing this.. (this is foxpro 7 right now) also, every time i run a form to test it, the controls toolbar (which i docked onto the toolbar spot on the top) gets undocked and moved back to a certin location (same place every time)... and the form window gets resized to smaller then maximized like i had it (the form designer window) it's getting kind of annoying and set as default in properties isn't helping much either... it just forgets the settings every time... any idea how to fix this? thanks -- ================================ Brian Henry The Reschini Group HTTP://www.reschini.com Tag: Optional Parameter Tag: 187632
  - 19
    - Error 1705 File Acces Denied I have a problem that someone out there may be able to help me with. We have a network with a server running Windows 2000 Server. There are several workstations on the network running different operating systems namely Windows 98 and Windows XP. The server primarily stays on continuously. Workstations are generally shut down each evening. On each of these systems there are two distinct programs accessing the same database's tables and indexes. One program is complied with Visual FoxPro 6.0 and the other is compiled with Visual FoxPro 7.0. For the most part this seems okay but we occasionally get an error message "1705 File access denied". We get this message at time when only one user is on the system with only one of the programs open after other users have been into and out of these programs. We suspect having the programs compiled under two different versions of FoxPro may be at the root of this. To get both programs compiled under the same version of FoxPro in this instance sounds easier than it will actually be. We're willing to do this if we had some good indication that this would solve the problem and it isn't something else say operation system related or say accessing the files with other programs namely Excel. Thank you in advance Tag: Optional Parameter Tag: 187631
  - 20
    - 3rd party VFP grid replacement Hello, I wonder if anybody uses 3rd party replacements for the VFP grid? I'm looking for a commercial OCX or native VFP Grid class that is able to do sorting, filtering, grouping, incremental searching, editing local and remote (MS SQL) data, printing/exporting grid content. Do you have any experience with the products below and VFP ?: ComponentOne True DBGrid (http://www.componentone.com/products.aspx?ProductCode=1&ProductID=67) DBI-Tech Grid Tools 2.0 (http://www.dbi-tech.com/show_products.asp?id_prod=8) or maybe you could recommend any other Grid classes or VFP frameworks with advanced Grid capabilities?. Regards, Marek Hryceniak Tag: Optional Parameter Tag: 187626
  - 21
    - Newbie - Report Hi all, I would like to do this, a statement SELECT ... INTO ARRAY aryRecord will load in the sales record in my report, I would like to do this 1) check if aryRecord is created (length of array > 0) 2) if is created, print the content of the array can I all do that in programming in report? Regards, Wandy Tag: Optional Parameter Tag: 187623
  - 22
    - C0000094 on Terminal Server I run vfp app on Terminal Server and change the registy on 2k sbs server ref. by article 299603: http://support.microsoft.com/default.aspx?scid=kb;en- us;299603 HKEY_LOCAL_MACHINE\System\CCS\Services\Mrxsmb\Parameters OpLocksDisabled : 0x1 HKEY_LOCAL_MACHINE\System\CCS\Services\LanmanServer\Paramet ers CachedOpenLimit : 0x0 HKEY_LOCAL_MACHINE\System\CCS\Services\LanmanWorkstation\Pa rameters UtilizeNTCaching : 0x0 It occur the following error message while running app : Fatal error : Expection Code=C0000094 and then close the app. client connect to Terminal Server O/S : Windows 2000 sbs server (Service Pack 4) app store on Data Server O/S : Windows 2000 Server (Service Pack 4) foxpro version of app : vfp8.0 sp1 What steps of configuration is missing? Thanks Ray Tag: Optional Parameter Tag: 187622
  - 23
    - Object Excel Properties Hi Expert, I look at the VFP 7 ...\SAMPLES\SOLUTION\OLE\OLEXL.SCX, inside the 'Examples 1' button event stated the following line: tmpsheet = GetObject('','excel.sheet') XLApp = tmpsheet.application XLApp.Visible = .t. XLApp.WorkBooks.Add() XLSheet = XLApp.ActiveSheet XLSheet.Cells(1,1).Value = PRODUCT_LOC XLSheet.Cells(1,2).Value = SALESJAN_LOC XLSheet.Cells(1,3).Value = SALESFEB_LOC XLSheet.Cells(1,4).Value = SALESMAR_LOC XLSheet.Cells(1,5).Value = TREND_LOC I want to know all property/method related to EXCEL object like 'Cells()', 'ActiveSheet', 'Add()','Save()','Copy ()', 'Move()' etc. Do you know from where I can get the those information. Thansk for advices Hidayat Tag: Optional Parameter Tag: 187621
  - 24
    - Newbie - Report Hi all, Is it true that you cannot edit a label field again? A real headache that everytime you want to edit a label field you need to remove that label field and recreate and refill the label again. Many thanks. Regards, Wandy Tag: Optional Parameter Tag: 187618
  - 25
    - wrong report page footer printing O/S 2000 sp4 vfp7 sp1 SYMPTOMS 1.data group is set, new page when group change 2.when fields on group footer band is overflow to next page, fields of page footer band is incorrect. WORKAROUND create table table1 (f1 c(10),f2 m) insert into table1 (f1,f2) value ('1','') insert into table1 (f1,f2) value ('2',repl('X'+ chr (13),200) && overflow to next page insert into table1 (f1,f2) value ('3','') create new report named 'report1' add data grouping "f1" : set "Reset page number to 1 for each group" add report variables "vf1" : value to store : f1 on page header band : add a field "f1" on detail band : add a field "f1" on "group footer : f1" band : add a field "f2" ,set "Stretch with overflow". on page footer band : add two field ,"f1" and "vf1" do a command : report form report1 preview result : on page footer band when f1 group is 2 : field "f1" : 3 && wrong field "vf1" : 2 && correct on page footer band when f1 group is 3 : field "f1" : 3 && correct field "vf1" : 2 && wrong Tag: Optional Parameter Tag: 187610
- Next
  - 1
    - VFP8: running SQL scripts Hello. What is the best way to run a series of SQL scripts from *.sql files (for MS SQL Server) - for example for creating a database on client machine. Our application runs on CA classes, ADO. And 2nd question - any thoughts on integrating MSDE installation into InstallShield project - so far no success. M.Kujawa Tag: Optional Parameter Tag: 187607
  - 2
    - Running VFoxPro application on network I have an application developed in VFoxPro. Recently, I should run this application on network where 30 different users are working and manipulating data simultaneously. I wonder if it's possible to do it in Visual FoxPro as in other technologies like MS-SQL. Thank in advance. Tag: Optional Parameter Tag: 187602
  - 3
    - Walkthrough files in a project Hi all, I need to 'walkthrough' scxs, vcxs, prgs, and fxps contained in a specific project (say, test.pjx). Can anybody show me how to do that? TIA, Willianto Tag: Optional Parameter Tag: 187591
  - 4
    - OT: Looking for Help in Central New Jersey If anyone lives or is going to be around the North Branch, New Jersey area, please send me an e-mail directly if you can and are willing to help. As a favor to my wife, I would like to ask if someone can go to the Girl Scout store in North Branch and get some patches and mail them to me. I have the store address and phone number that I will reply back to you with. We will pay you for the patches and mailing. Thanks! Mark McCasland mmccasla AT airmail DOT net Tag: Optional Parameter Tag: 187588
  - 5
    - Foxpro nubie: Migrate 2.6 Unix to Windows? Hello all, I have a client that has been running an SCO Unix FoxPro 2.6 database and I would like to migrate it to Windows. Is it as easy as buying a Windows version of FoxPro and moving the actual database tables and forms? I'm prepared to do some work as necessary, but would like to understand the "got-ya's" before I quote the conversion. What would be the best version of FoxPro to convert into: Visual, etc.?? I have a good database background, but am unfamiliar with FoxPro. Any guidance or links to an FAQ would be much appreciated Thanks in Advance Ed O'Reilly oreilly@nospambasici.com (remove the nospam) Tag: Optional Parameter Tag: 187579
  - 6
    - OCR IN VFOX PRO Hi! M.XMAS! Please help me with this... i need to use some OCR library in order to recognize some images text, where can i find libraryes to add the ocr funtionality ot my programs? does anyone has some idea or advice about how can i recognize text images into text? (the images are not files, area areas in my monitor... i need to recognize some images shown in my browser) thankz beforehand JOSE Tag: Optional Parameter Tag: 187574
  - 7
    - Network printing We are changing our network environment from Novell to Windows Server 2003 and we have several FPD2.6 legacy programs that utilize network printing. With Novell I was able to capture the port and print directly to the printer. However, I have not been able to print to the network printers under our new Windows Server network. I have used the the following command with no success: SET PRINTER TO \\<Network Name>\<Printer Name> = LPT1: What am I doing wrong? The printer is connected to the network via a HP Jet Direct print server with TCP\IP addressing and it is identified through the server as a shared printer. How can I reach this printer from my FPD2.6 programs? Any and all help would be greatly appreciated. Thanks, Ted Tag: Optional Parameter Tag: 187573
  - 8
    - How to print in basic codes ? Hello all ! What's epson printer's code if I want to make my output font in 8 point size ? I use basic printing codes like : set alternate to myname.txt set alternate on ? ?? chr(27)+(m)+chr(18) && if i want to make font size in 10pci ? 'body text' set alternate off set alternate to *====================== Thank's alot for your kind information and help... Tag: Optional Parameter Tag: 187561
  - 9
    - Any idea how to implement internet billing software Hi everyone, A client of mine just opened an internet cafe in our town. He asked me whether I can embed automatic billing application into my-already-run-POS apps. He got 25 computers in his cafe. All connected with 100 Mbps Ethernet connections. He got a wireless connection to the internet, and most of his customers are using the computer to play ragnarok (online games). He charge his customer on time basis, and he wanted the system to automatically record computer usage time (and bill) whenever the customer login on one of the computer and stop the timer (and print the bill) when the customer logout. A friend of mine suggested that this will involve winsock programming. Honestly, I never touch winsock, so I think I just asked here first. Anybody here got any idea how to implement such application? Is VFP capable of doing real-time transaction (I mean, transaction that heavily depends on time). TIA, Willianto Tag: Optional Parameter Tag: 187559
  - 10
    - Problem with printing on continuos form paper Hi there, merry X’mast!!! , Why when I printing my report using continuous form formated paper (4 pages or mores..) the position of contents different, start from page 3 if I compared it with page 1 ? (My codes: REPORT FORM myreport to printer noconsole nopageeject ) My printer is : LQ 1170 (custom size: W=22 x H=14 cm) Thank’s a lot for your help….. Tag: Optional Parameter Tag: 187557
  - 11
    - Any idea how to access task in outlook? I would like to update tasks in outlook, any tips? Tag: Optional Parameter Tag: 187555
  - 12
    - [OT]: Merry Christmas to all Foxers in the world! Hello everybody, It's 11:00 pm here in Indonesia. I just came home from my parents' home and had a wonderful Christmas day with all of my family. I wish you all the happiest Christmas ever. Merry Christmas to you! Merry Christmas to our Fox! Regards, Willianto P.S: I hope that I can have my next Christmas (2004) in New York! Tag: Optional Parameter Tag: 187551
  - 13
    - Visual Fox with SQL Server 2000 I want to Know as to save and to select in Visual Fox images(*.BMP) from SQL Server??? Which is the code or tool to save from Visual Fox to SQL server??? If I can save image in SQL server 2000??? Thanks.... Tag: Optional Parameter Tag: 187544
  - 14
    - OLE DB Support on remote server Hi all, We'll be deploying on a web server that we don't directly control but the owner is usually open to configuring as we wish. We've starting doing some new ASP.NET development using VFP's OLE DB Provider. My question is how does one install the OLE DB Provider? The help file indicates registry entries that result from an installation, but I can't seem to find the steps to set up in the first place. TIA, John Tag: Optional Parameter Tag: 187542
  - 15
    - Foxpro 2.6 I have an old version of foxpro 2.6 on 7 floppy discs. Disc 7 does not work, and burning a copy from the computer that has foxpro on it doesnt work either. Can anyone help. I will pay for disc 7 if necessary. Thank you. Dave Tag: Optional Parameter Tag: 187535
  - 16
    - corrupted data VFP6.0 i have a table that it says <<not a table>> any GOOD utilities that fix data? or any ways to fix this ? Thanks -- George Malekkos --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 18/6/2003 -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: Optional Parameter Tag: 187532
  - 17
    - set NULL values! Hi All, This time I have an easy question that may drive to your attention. I have a database table like this: Table Name: products col1 col2 col3 col4 AAA 432 57 BBB 10 CCC 493 20 29 DDD 293 28 I want to printout 3 records only as col2 and col3 are not NULL. What the command should be? I had tried the following commands, but it doesn't work. repo form products for isNull(col2)=.F. and isNull (col3)=.F. prev Please correct the mistakes as I mentioned above, many thanks. Sam. Tag: Optional Parameter Tag: 187517
  - 18
    - Create Image Hello: I have Visual FoxPro 8.0 clients that connect to SQL Server 2000. I need to display a *.bmp image in Visual Fox that stays on the Server end. What is the code or tool that I can use in FoxPro to create this? It is important that the image is recorded on the server end. Thank you. Tag: Optional Parameter Tag: 187514
  - 19
    - Project building VFP8/XPP When I build a project, I do not want the image files to be included in the final executable file. Even if I modify the project to specifically remove those image files in the project, after building the executable, I found the images are back inside the project and inside the executable file as well, resulting in a jumbo size executable file. What do I have to do to prevent the images being built inside the executable file? sp Tag: Optional Parameter Tag: 187509
  - 20
    - Resize buttonimages by code - VFP7SP1 Hi all! Q1 How can I by code resize an app´s buttonpictures (bmp and ico) to be of the same proportional size independenly of the user´s screenresolution? Q2 How do I keep the buttonpictures backcolor? White becomes gray. Merry Christmas Christina Tag: Optional Parameter Tag: 187508
  - 21
    - Multi-tier with VFP - how? Question - how would you go about building a multi tier solution with VFP. I have an architecture that calls for a VFP front end and a middle tier running on a server providing the business processes. How do you interface the front end to this middle layer? There are likely to be 50 clients running this app. Tag: Optional Parameter Tag: 187504
  - 22
    - Next Grid Problem, Please Help, Thanks in Advance I have a grid on a form with a private datasession. AR has a 1 - 1 relationship with CHECKS on the field CHK_NUM The init code to open the tables is: USE AR IN 0 USE CHECKS IN 0 ORDER CHK_NUM SELECT AR SET RELATION TO CHK_NUM INTO CHECKS The Grid's RecordSource is AR The Problem I'm having is with Dynamic Fore and Back Colors. For one of the columns I have: DynamicForeColor set to iif(not empty(checks.rd),rgb(255,255,255),rgb(0,0,0)) DynamicBackColor set to iif(not empty(checks.rd),rgb(0,0,0),rgb(255,255,255)) This should have the effect of having that column displayed as white on black instead of black on white when the RD field in Checks is not empty. The effect I'm observing is that when you move the cursor to a row in which CHECKS.RD is not empty the entire column turns white on black. Once you move the cursor to a row where CHECKS.RD is empty then the entire column reverts to normal. I am looking to have only those rows where CHECKS.RD is not empty display as white on black. What am I doing wrong? Many thanks. Jeff Tag: Optional Parameter Tag: 187499
  - 23
    - How to deal when ODBC throw up 'Connection is busy with results for another hstmt'? Hi all, I insert 183 rows to a specific table in SQL Server (say, T035). The method I used was I created a remote view rv_location with (CREATE SQL VIEW rv_location REMOTE CONNECTION "Conn" AS SELECT T035.* FROM dbo.T035 T035), and do the insertion to the remote view. After the insertion, I couldn't run all forms that have remote views related to T035. Whenever I run the form, ODBC sent "Connection is busy with results for another hstmt" error. It's really confusing because: 1. The database is on my local machine, and I am not connected to any network. This means nobody use the server except vfp. 2. Although I cannot open the rv from my form's DE (Data Environment), when I use the remote view from VFP IDE, the cursor filled with appropriate value. No error from ODBC. I searched SQL Server Online Books, and I found out that the cause either SQL Server doesn't support SELECT * FROM... (???) or SQL Server treat it as bulk copy. It is said that "the solution is to call bcp_done" --- and I don't know how to call bcp_done (tried it with SQLEXEC) I'm really confused here. I tried to exit and re-run vfp with no luck. I tried to reboot my computer --- still with no luck. I even (stupidly --- it's funny how we suddenly do something that obviously has nothing to do with the error when unknown error happened!---) tried to delete the view from my form's DE, pack the .scx, and attached the view back again; of course with no luck! Can anybody help me what to do with this error? I hate to admit that the only solution I got is restore the database from the backup :-( TIA, Willianto Tag: Optional Parameter Tag: 187483
  - 24
    - Grid Problem, Please Help This example is simpilfied for brevity but accurate: I have two tables AR and CHECKS. They both have the field CHK_NUM and there is a 1-1 relationship between AR and CHECKS. I have a grid on a form with a private data session an AR is the RecordSouce In the init method of the form when I'm opening the tables I have: USE CHECKS ORDER CHK_NUM USE AR SET RELATION TO CHK_NUM INTO CHECKS I have some text boxes on the form to show me some of the values from the CHECKS table. They are always empty and this is the problem. If instead I don't use SET RELATION but instead put the following code in the in the AfterRolColChange method of the grid: SELECT CHECKS SEEK AR.CHK_NUM SELECT AR then I see the values from the CHECKS table. The problem is that this method doesn't allow me to make use of Dynamic Fore and Back Colors. Does anyone know why seeking for the records in the AfterRolColChange method works and SET RELATION doesn't? Thanks in advance. Jeff -- Jeff Grippe Hilldun Corporation Phone 646-312-8130 Fax 212-594-8162 Tag: Optional Parameter Tag: 187477
  - 25
    - IExplorer DOM Please i need the DOM (Document Object Model) of Internet Explorer I htink the "DHTML Object Model" and the "Internet Explorer Object Model" arent the same... i need to know methods like: .busy; .ReadyState; where can i get a reference of this methods Tag: Optional Parameter Tag: 187473

Hi,
Can anyone tell me how to setup optional parameters in a method?

Re: Optional Parameter by Rush

Rush
Tue Dec 30 14:41:33 CST 2003

in FoxPro, all parameters are optional - for example, MyForm.DoStuff(a, b, ,
d) would execute DoStuff with only the first, second, and fourth parameter
supplied.

Of course, you'll have to resolve the parameters within your method - any
missing parameters will be initialized as a logical .F., regardless of
'expected' data type.

- Rush

"Roger Cantillo" <rogerc@axiomsw.com> wrote in message
news:OPPM5OxzDHA.1576@TK2MSFTNGP11.phx.gbl...
> Hi,
> Can anyone tell me how to setup optional parameters in a method?
>
>
>
>

Re: Optional Parameter by Trey

Trey
Tue Dec 30 14:52:56 CST 2003

Inside VFP, all parameters are optional.

If you are using a VFP7+ COM dll, you can specify optional parameters with
_COMATTRIB - 5th element
e.g.

Define Class myTestClass As custom OLEPublic

Dimension myMethod_COMATTRIB(5)
myMethod_COMMATTRIB[5]=2 && makes only the first 2 params required

Procedure myMethod (param1 as integer, param2 as string, param3 as
string)
** proc code
EndProc

EndDefine

"Roger Cantillo" <rogerc@axiomsw.com> wrote in message
news:OPPM5OxzDHA.1576@TK2MSFTNGP11.phx.gbl...
> Hi,
> Can anyone tell me how to setup optional parameters in a method?
>
>
>
>

Re: Optional Parameter by David

David
Mon Jan 05 18:28:35 CST 2004

Roger,

To add to the other replies, You can use the pcount() function inside the
method to determine how many parameters were passed.

df

"Roger Cantillo" <rogerc@axiomsw.com> wrote in message
news:OPPM5OxzDHA.1576@TK2MSFTNGP11.phx.gbl...

> Can anyone tell me how to setup optional parameters in a method?