how to link with COM port

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
    - VFP Remote Access Issues Hello - I have a few questions about remote access with VFP. First - does anyone have any idea as to the future speeds of the internet? We have of course basic dial up, DSL, T1, etc. In general most have either dial up or DSL or cable with top speeds of 500kbs or so. This is too slow if one wants to map a drive through the intenet. What is wrong with VFP? What in the world is it sending to the workstations on a LAN? Seems like a lot of junk data or something. Certainly a lot more than raw data is being passed. I'm wondering if instead of a file server application I wrote a front end/back end application using VFP as both the front end and back end and using a socket control with TCP/IP if it would be a lot faster over a dial up. Or, if that even makes any sense given that some of the hotels already have a high speed connection. Or perhaps another soluition such as VFP on the web? I'm not sure but does anyone have ideas for remote access improvements with VFP? Or will technology bail us out with faster connections? If so - how long before we see some real speed improvements at a reasonable cost? My understanding is right now they are just way too expensive. Seems like even a T1 is not fast enough when mapping a drive using VFP and with a lot of users something like Terminal or Citrix server (which only does screen transfers) is too expensive. Just exploring ideas, Thanks. Mike Tag: how to link with COM port Tag: 180819
  - 2
    - CURSORGETPROP / tablerevert Hello, Im attaching a part of my code that seems to function abnormally. I initiated cursorsetprop on my POSDetail table (optimistic table buffering). I have to add the first record BUT before i issue a TABLEREVERT or TABLEUPDATE, I have get some records from another table. Those records need to get checked if there's an actual onstock. If one of those records did not have enough stock, it will actually TABLEREVERT all the records added, so it will return to original form as if nothing was added. For some reason, it didnt wanna revert all the records. Records that were already added stayed in the table as if i had initiated a tableupdate which i did not. If i issue a CURSORGETPROP(), will that function hold true for as long as i didnt issue a tablerevert or tableupdate? or if i move from one table to another and do some select statements in between the CURSORGETPROP and TABLEUPDATE/TABLEREVERT, will it lose its state? please help me out. thanks. select posdetail =CURSORSETPROP("Buffering",5,"posdetail") APPEND BLANK replace detailno with lnNewId replace transactno with lcTransactno replace productid with lcProductID replace quantity with thisform.txtqty.value replace discount WITH thisform.txtdiscount.value replace itemsales with thisform.txtsales.value REPLACE itemcost WITH lcCost replace nettotal with lcNetCost replace grosstotal with lcGrossCost bChkStock = .T. IF thisform.bokits.Value THEN SELECT bo_kitsku,bo_sku,bo_qty,bo_display FROM bokits ; WHERE bo_kitsku = thisform.txtskucode.Value ; INTO CURSOR botemp SELECT botemp GO TOP nId = lnNewid SCAN WHILE NOT EOF() IF SEEK(botemp.bo_sku,"product","skucode") IF product.onstock < 1 or THEN =MESSAGEBOX(ALLTRIM(product.productname)+" does not have enough stock!",0+16) lbChkstock = .F. EXIT ELSE lcProductid = product.productid nId = nId + 1 INSERT INTO posdetail(detailno,transactno, productid, quantity,; mod_user,mod_date,locationid) ; VALUES (nId,lcTransactno, lcProductID, botemp.bo_qty*thisform.txtqty.value, ; goprogram.cusername, DATE(), VAL(goprogram.cregion_code)) ENDIF ENDIF SELECT botemp ENDSCAN USE IN botemp ENDIF SELECT posdetail IF bChkStock THEN =TABLEUPDATE(.T.,.T.) ELSE =TABLEREVERT(.T.,"posdetail") ENDIF Tag: how to link with COM port Tag: 180812
  - 3
    - Open file dialog I want to add an "Open file dialog" to my VFP 7 form. Where do I find it? Thanks, Scott Tag: how to link with COM port Tag: 180811
  - 4
    - define popup I am trying to get a popup to show up under a command button when it is clicked but I am having problems on getting it located without trial and error and a static number. Any suggestions????? -- Altman VFP7 SP1 "No matter how foolproof you make a system, 'fools' can be remarkably ingenious." Tag: how to link with COM port Tag: 180807
  - 5
    - File size hi all how can i know the size of thefile ? size('test.doc') tankes Tag: how to link with COM port Tag: 180794
  - 6
    - claint-server example Hi all where can i find example for clint-server program i men com programes tankes Tag: how to link with COM port Tag: 180790
  - 7
    - Disk Free Space Hi Freinds, VFP6.0 How can I get available free disk space ? Thanks, Pat Tag: how to link with COM port Tag: 180789
  - 8
    - Copying Files Hi Everyone! I am trying to copy a shortcut file from a directory on my network to the desktop of a users computer. The problem I am having is that under Windows 2000 a users desktop directory is under the directory Documents and Settings. When I try to get FoxPro to copy to c:\documents and settings\kevin\desktop\ I keep getting invalid directory or path errors. Anyone have any ideas on how to copy to this directory? Also I can't string a path name together. Example : k = kevin path = 'c:\documents and settings\'+'k'+'\desktop\ copy file k:\test\sbtest.lnk to path - This will not work eithier Thanks Tag: how to link with COM port Tag: 180787
  - 9
    - macro substitution I have the followig code in a routine, which i neeed it to refresh data in different forms, having objFormName= to the form name. &objFormName..GridSignOff.RecordSource='rv_view_singOffList VirtualSql' &objFormName..GridSignOff.Refresh() Everithing works well, but when I compile the application, I get a message stating the the form name contained in the variable objFormName is not an object. What i am doing wrong here? Can anybody help before i perform a "MACRO SUBSTITUTION" to my monitor?! Tag: how to link with COM port Tag: 180780
  - 10
    - UNC problem I have an application that is located on a server LIVE in a directory MYAPP. All of the users will login and map the S: drive to \\LIVE\MYAPP. All of the application files and subdirectories are under this main directory. The application DOES NOT use any UNC paths to find files. The application will always look under the S: drive for files and directories. I wanted to create a test login for this application. I copied the entire application along with the data files to another share (TESTAPP) on the LIVE server. The test login will map the S: drive to \\LIVE\TESTAPP. When the test login is initializing variables, it looks for a "Variable save" (.mem) file to load the variables and values. This .mem file DOES not exist on the test environment, but does exists on the live application. So stepping through the application on the test login, the application set a variable equal to the mem file name. gf_memfile = "S:\MEMFILE\AMEMFILE.MEM". The application then tries to verify the file exists with the FILE() command. It returns .t. even though the file does not exist! The value of gf_memfile remains equal to "S:\MEMFILE\AMEMFILE.MEM". The next statement is a RESTORE FROM command that executes without an error. The gf_memfile variable gets changed to \\LIVE\MYAPP\MEMFILE\AMEMFILE.MEM!!!! Why is that? Where does it get the UNC from? I don't believe this is a Foxpro problem, but rather an OS problem, but I can't be sure. Any ideas? <snip> ..... gf_adrive = 'S:\' gf_memfile = gf_adrive+ "MEMFILE\AMEMFILE.MEM" IF FILE(gf_memfile) && does not exist, but this returns true RESTORE FROM (gf_memfile) && this statement changes the gf_memfile && to a UNC pointing to the live application! ENDIF ..... </snip> HELP!!! Tag: how to link with COM port Tag: 180776
  - 11
    - VFP to VB6 Hi I'd a software written in Visual Foxpro 6 and now in the process of converting the source codes into VB 6. I made use of lots of subclassed controls in my software, like embedding a Checkbox, Command Button, Image or Combo Box into some columns of a Data Grid. Is there a way to realize these functions in VB 6 without buying other 3rd-party OCX controls ? Thanks a lot in advance. Tag: how to link with COM port Tag: 180771
  - 12
    - Data Navigation Hi I have been a Visual Foxpro programmer for a few years and now looking for a way to convert those VFP written system into VB6. I have some degree of knowledge in ADO as I did write some Web-based database applications in ASP using ADO as a data access interface. I faced some difficulties in designing a Data Navigation Interface in VB6 coz I can't directly retrieve and bind a million of records into data-bound controls. In VFP 6, I simply used the following syntax to open a table and then directly set the RECORDSOURCE of control to the STUDENT will do, need not bother too much about the criteria in the retrieval of records. A simple Data Navigation Interface with searching features is then easily created in VFP. USE STUDENT IN 0 INDEX STUDENT SHARED In VB6, I need to think of lots of data retrieval criteria. If I used the following ADO syntax to retrieve the STUDENT data will take me 10 minutes for the whole process and might cause system hanging as well. SET rsA = cnA.Execute "SELECT * FROM STUDENT" In such scenario, the data is then broken down into smaller parts by putting a WHERE clause as below. SET rsA = cnA.Execute "SELECT * FROM STUDENT WHERE YEAR_ENROL = 2000" The Data Navigation Interface will only have the recordset of those students enrolled in the year of 2000. What if I want to search for a student by name "LESLIE WILSON" who actually enrolled in 2001? Of course, the rsA.Find syntax is not applicable in locating this student. In this case, I shall use rsA.open "SELECT * FROM PATIENT WHERE NAME = 'LESLIE WILSON'" However, by using this syntax, the Data Navigation Interface will then only have this student record. I found this is not a nice method. In VFP 6, I don't need to bother so much by using SEEK. What's the proper way of handling this issue in VB using ADO ? Thanks a lot. Tag: how to link with COM port Tag: 180770
  - 13
    - cursor shape in vfp6 Hi! I am using vfp6.0 in windows 2000 os. Whenever I starts vfp6.0, I finds my cursor shape to be vertically thin. Sometimes, I even can't identify its position on screen. I want to change cursor shape. i.e. It should be solid shaped, and in different color like red,green etc.Would you like to give any help regarding the above problem. Thanks Pushpak. . Tag: how to link with COM port Tag: 180753
  - 14
    - Error 1104 on zipfile, pls kindly help Hi, My application just only unzip some file and post them to my database file. However, it might after a day, will give error of 1104, Error reading file when going to unzip the zip file. Normally, before unzipping the file, I will tried to test whether the zip file is still posting half way by my client by fopen it to ensure that is is okay to open it exclusive first. After that, I use Dynazip to test it integrity before unzipping the file, but error 1104 still happen to my application. I am using VPF5a with Dynazip v4 running on Win98/95 with my zip file on my NT server share folder. Any possible cause of why this problem is happening ? I am at a loss. Tag: how to link with COM port Tag: 180750
  - 15
    - Reports produce different results every time I have a client with a very large database. Some of the tables has about half a million or more records in them. When I run a report using any of tables, I get different results on every workstation. It is also different on the same workstation if I run it multiple times. If I run it on the server, it is fine. Write caching has been turned off on all workstations. The server runs Windows NT 2000 and all the workstations have different versions of windows on them. Is there any other type of caching that needs to be turned off or has anyone else experienced this problem ? TIA Sujata Tag: how to link with COM port Tag: 180747
  - 16
    - XML to single or multiple cursor(s) I have a project where I have to link our application to QuickBooks for updating records in either application or inserting transactions in to QB. US version of QB SDK had a foundation class and XML options and I used FC, which had simplified my task but Australian version only supports XML. I need to be able to create single and/or multiple cursors depending on the XML dataset so that I can manipulate data easily in my application. I experimented with the response xml file and find out if I only have 1 level of tags XMLTOCURSOR nicely creates a cursor that corresponds to the xml structure except the variable types (eg. a datetime field was created as a character field). Eg. A response xml file from QB <?xml version="1.0" ?> <QBXML> <QBXMLMsgsRs> <TaxCodeQueryRs requestID="1" statusCode="0" statusSeverity="Info" statusMessage="Status OK"> <TaxCodeRet> <ListID>20000-1046324474</ListID> <TimeCreated>2003-02-27T16:41:14+10:00</TimeCreated> <TimeModified>2003-02-27T16:44:08+10:00</TimeModified> <EditSequence>1046324648</EditSequence> <Name>CAF</Name> <IsActive>true</IsActive> <Desc>Cap. Acq. - GST Free</Desc> <Tax1Rate>0.00000</Tax1Rate> <Tax2Rate>0.00000</Tax2Rate> <IsTax1Exempt>false</IsTax1Exempt> <IsTax2Exempt>false</IsTax2Exempt> <IsPiggybackRate>false</IsPiggybackRate> <IsECVatCode>false</IsECVatCode> <TaxType>5</TaxType> </TaxCodeRet> <TaxCodeRet> <ListID>D0000-1046324474</ListID> <TimeCreated>2003-02-27T16:41:14+10:00</TimeCreated> <TimeModified>2003-02-27T16:44:08+10:00</TimeModified> <EditSequence>1046324648</EditSequence> <Name>NCI</Name> <IsActive>true</IsActive> <Desc>Non-Cap. Acq. - for making Input Taxed Supplies</Desc> <Tax1Rate>0.00000</Tax1Rate> <Tax2Rate>0.00000</Tax2Rate> <IsTax1Exempt>false</IsTax1Exempt> <IsTax2Exempt>false</IsTax2Exempt> <IsPiggybackRate>false</IsPiggybackRate> <IsECVatCode>false</IsECVatCode> <TaxType>3</TaxType> </TaxCodeRet> </TaxCodeQueryRs> </QBXMLMsgsRs> </QBXML If I use XMLTOCURSOR function without any modification I will get either one field or as many as the number of requests in the returned XML file (I can send multiple queries to QB in one XML message and therefore get a multiple response in one XML returned message) with everything squashed in with out their tags. Now if I remove <QBXMLMsgsRs> and <TaxCodeQueryRs .....> lines and also corresponding end tag lines then use XMLTOCURSOR function it will give me a cursor with field names and properties as ListID (char 16), TimeCreated (char 25), }these two is datetime field in the original XML response file TimeModified (char 25), } EditSequence (num 10), Name (char 3), IsActive (logical), Desc (char 47), Tax1Rate (num 8), Tax2Rate (num 7), IsTax1Exempt (logical), IsTax2Exempt (logical), IsPiggybackRate (logical), IsECVatCode (logical), TaxType (num 1) I can then work with this table to get what I want. This is fine if I only deal with one request/response, but majority of response(s) have more complex structure. Is there a better way to deal with response XML files? I saw in VFP8 new features that there is XMLAdaptor class that can accept internal or external schemas and create single or multiple cursors but we have some stability issues running our application in VFP 8 and therefore not ready yet to go up to VFP8. I need to find a solution within VFP7 capabilities. Cheers Mehmet Tag: how to link with COM port Tag: 180736
  - 17
    - VFP 7 How to change command button text color How do you change the text color of a command button programatically? I've tried to change the forecolor property, but that doesn't work. Thanks, Cliff Tag: how to link with COM port Tag: 180733
  - 18
    - send me spam plz zaitsev@mail15.com zaitsev@mail15.com zaitsev@mail15.com zaitsev@mail15.com zaitsev@mail15.com zaitsev@mail15.com Tag: how to link with COM port Tag: 180730
  - 19
    - _screen function Hi guys, I have create an object to display it as my background using the _screen.createobject command line. I had went through the help file but nothing in there tell me how to create the screen such that it will maximise to fill up all the white space. I can drag the size to fill the screen size but my concern is that if this were to implment to many customer, this might not look good since chances are they does have the same screen setting as mine. Mine is 1024 X 768 pixel Thanks a lot Best Regards Edwin Chua Tag: how to link with COM port Tag: 180729
  - 20
    - resizable frames within a form Hi, I need to create 3 or 4 frames(windows/sections/divisions) within a form that the user can adjust in an easy way. think about the 2 or three frames we usually have in Outlook or Outlook Express... the user just drag the frame borders with the mouse and the other frames ar also automatically adjusted right now the only way I have found to solve this is using one Formset with several forms and puting some code in the resize event of the forms to adjust the others, however there is a problem: the only visual container of the forms is _screen, it seems there is no way to put the forms inside a single form object that contains them so I can instantiate the same form with it´s internal adjustable frames and allow the user to look at them as many software allows: Mosaic or Cascade I know this should be possible becaus e I have seen an application developed this way (I guess in Microsoft C++), but I am not sure what controls are they using I would appreciate any advice or if somebody knows where can I download a similar sample from the net Thanks and Best regards Tag: how to link with COM port Tag: 180722
  - 21
    - SQL server connection Hello everyone.... how will i know if my sql connection which i made from the start of the program is still active. i need this to avoid errors that the said connection isn't active anymore. tnx a lot. Tag: how to link with COM port Tag: 180692
  - 22
    - Are there any drawbacks if I use a lot of connection to SQL Server (and not sharing them)? Hi all, Most of the connections I used in my apps are occupied by one SQL query (VFP's remote view). However, in a case where I need atomic transaction, I would share a connection and perform table insertion/update inside SQL's BEGIN TRANSACTION and SQLCOMMIT pair. Question: Are there any drawbacks if I use a lot of connection to SQL Server (and not sharing them)? Overriding the connection handle in VFP's remote views require coding in the form's Init event. If the drawbacks are acceptable, I'd rather bind the RVs in the DE than open it programmatically one by one. Please note that what I mean a lot is about 10 to 25 connection (remote view) in each form. TIA, Willianto Tag: how to link with COM port Tag: 180689
  - 23
    - General Question about hWnd Hello - is it possible to pass the hWnd to an activeX control for standard VFP objects? I can't seem to do it. In other words...... thisform.cmdButton.hWnd or thisform.lblBase1.hWnd Thanks. Mike Tag: how to link with COM port Tag: 180684
  - 24
    - launch explore from command line Hello again all I am converting reports to HTML and I know I can launch internet explorer from an icon on a screen but is there a way to launch it from the command line after the report has been created? Hope this makes since. Glen Tag: how to link with COM port Tag: 180672
  - 25
    - SQL error: GROUP clause missing or invalid This SQL statement which works fine in VFP7 generates a SQL error: GROUP clause missing or invalid when run in VFP8 SELECT Astu.status, Acls.classlink, amst.sectionid, ; count(*), amst.meetperiod ; FROM astu INNER JOIN acls ON Astu.stulink = Acls.stulink; INNER JOIN amst ON Acls.classlink = Amst.classlink; WHERE astu.status=' ' ; GROUP BY amst.sectionid ; INTO TABLE temp (Note: This is just a subset of the full SQL statement. Neither the full one, nor this one, work in VFP8) What do I need to change to make it work in VFP8? Thanks. Tag: how to link with COM port Tag: 180659
- Next
  - 1
    - VFP6 data type mismatch on selecting table an VFP6 application that has been running for a number of years, quite happily, which I am now doing further development on has suddenly started to come up with the error "data type mismatch" when I try to select a cursor that I am scanning through - either within the scan or at the endscan stage. I suspend the program then immediately click resume and it selects the cursor and carries on quite happily - right through to the end of the scan. I can't see any fields that could be suspect, they are all character and just a simple select with no function calls. It happily starts the scan. This is totally doing my head in. I had a sircam.worm infection a couple of weeks ago which I sorted out with Norton's help and the problems seem to have been going on since soon after that. Anybody come across/sorted out this problem? Tag: how to link with COM port Tag: 180651
  - 2
    - Creating User-Defined functions in Crystal Reports 8.5 or 9 via VFP 7 Automation Server I have Craig Bernston's book CrysDev and have downloaded several PDF's from Crystal Decisions and must be missing something. This appears to be a pretty simple process as described by both sources. However, I have built by VFP automation server, registered it, verified naming conventions and that Crystal has my DLL in use when in the designer, but my functions simply are appearing in the Crystal additional functions list. The behavior is the same for both Crystal versions 8.5 and 9 using VFP version 7. Any tips or suggestions would be appreciated. Thanks, Rory Sawtelle Tag: how to link with COM port Tag: 180645
  - 3
    - Softwarekey, Protection Plus, FPW2.6 I need to supply an old FPW2.6 application but add software protection. I have got Protection Plus from Software Key, and am having difficulty getting it to work using the KEYFOXW.FLL. I know it's old stuff but is there anybody who can guide me through the process of providing a 30-day demo which can then be unlocked to full version? Many thanks Stephen Ibbs Tag: how to link with COM port Tag: 180639
  - 4
    - VFP7 Multi-user View problems We are using some views in our system for combining files for using in a grid. When 2 users are inputting data on these forms, each user cannot see the other user's added records until they exit the screen and come back in. Is there a way of forcing the view to refresh from the server data? I don't really want to close it and reopen it as this may slow things down. Bernie Tag: how to link with COM port Tag: 180638
  - 5
    - Active SQL Connection Hi. Is there a way to determine if a connection to an SQL server is still active? Im using VFP 8.0 and MS SQL Server 7.0. Tnx!!! Tag: how to link with COM port Tag: 180636
  - 6
    - Slow down on XP SP1 Help i just install my application built by vfp7.0&vfp8.0 without any modification on win xp sp1, it runs extremely slow on connecting mysql database remotely or locally use odbc, but the program works fine on 98se, me, w2k, w2k server, xp without sp1, so i try to reinstall the win xp sp1 again without norton anti-virus software, and upgrade any service pack for xp, but still happen, i am using remote-view to connect mysql database, i discover, when the program is connecting database, the program will hang up for a long time, and occupy 100% CPU Usage, i have no idea about this problem. thks Tag: how to link with COM port Tag: 180627
  - 7
    - Background for report Is it possible to place a bitmap as a background for a report ? TIA Sujata Tag: how to link with COM port Tag: 180594
  - 8
    - Setup Wizard for exe files. I have been using the setup wizard in VFP6 to make up the installation CD to install applications. I see there is a better one out and wonder if I need to upgrade the VFP6 or can I obtain this newer wizard to make up the setup files?? I sure do like the ease at which VFP6 lets me make them up but is there something out there that I can use that is better? Tony Tag: how to link with COM port Tag: 180593
  - 9
    - Create Table - SQL This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C372FB.7C8059D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable VFP8/XP: I am creating a Binary Memo field in a table/DBF. When using "Create Table ..." SQL statement, there is no option to = distinguish a "Memo" field and a "Memo-Binary" field. Is VFP going to treat the momo field (which I create with the field type = "M") as "Memo-Binary" type based on the information I am going to store = in that field or what?! sp ------=_NextPart_000_0008_01C372FB.7C8059D0 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.2800.1226" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>VFP8/XP:</FONT></DIV> <DIV><FONT face=3DArial size=3D2>I am creating a Binary Memo = field in a=20 table/DBF.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>When using "Create Table ..." SQL = statement, there=20 is no option to distinguish a "Memo" field and a "Memo-Binary"=20 field.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Is VFP going to treat the momo field = (which I=20 create with the field type "M") as "Memo-Binary" type based on the = information I=20 am going to store in that field or what?!</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>sp</FONT></DIV></BODY></HTML> ------=_NextPart_000_0008_01C372FB.7C8059D0-- Tag: how to link with COM port Tag: 180574
  - 10
    - Using a UDF in Menu's skip for Is there any way to reference the menu level, prompt, or command values in the skip for section of the menu designer? I want to create a database containing a record for each menu option, and the user ID's that have the authority to run each option. I could then place a used-defined function that queries this database to determine if the option is available. Tag: how to link with COM port Tag: 180567
  - 11
    - Overlaying a .wmf or other graphic over a .frx report Does any know how I can overlay a graphic file over a .frx report? This is what I want to do: I have a number of 81/2 X 11 forms (for example, export documents) that I want to generate from my Foxpro program. I have done this in Delphi by overlaying a .wmf on a report file and printing them both. This method generates a very professional looking form and is very useful in placing and aligning the data fields. However, because of the way VFP reports are generated (Header/Body/Footer/)inserting a full page graphic and overlaying the data fields seems impossible. If anyone knows how I can do this or something similar I would be forever in your debt. Thanks Pat Tag: how to link with COM port Tag: 180558
  - 12
    - Recording Table Changes I routinely receive updates to an existing table. I want to compare the old table to the new and record (in another table or view) only updated, added or delted records. I can write a program that will compare each record field by field, but can't help but think there might be an easier way. Any thoughts? Thanks Tag: how to link with COM port Tag: 180554
  - 13
    - Odd VFP6 behavior in XP Just noticed this oddity developing in VFP6 SP5 in XP Pro. Could be a video driver issue, but it only happens in VFP6, not in VFP8... Open a form for editing. Double click a control that has a resonably long chunk of method code in it. Select that method - the scroll bar in the edit window must be displayed. Click and drag the scroll bar a bit and DON'T RELEASE THE MOUSE. Keep the mouse button down, but keep the mouse still. In my system, after about 6 seconds, all of the windows in the VFP IDE go blank and stay blank until the mouse button is released. Thankfully the same thing does not happen in a VFP app at runtime. Still weird though! -- TRW _______________________________________ My e-mail: t r w 7 @ i x . n e t c o m . c o m _______________________________________ Tag: how to link with COM port Tag: 180553
  - 14
    - PRTINFO() How can I make a form print in landscape, thru a .prg file. I have tried PRTINFO(1) to no avail. Thank you Tag: how to link with COM port Tag: 180544
  - 15
    - win32api GetTempPath() on win98 Hi, I have been using the win32 api call GetTempPath() which has been working correctly on my development machine (Windows XP). How ever when tested on a Windows 98 machine the function returns an empty string, I know the winapi function works on win98 because I have used it in the past with various other languages. Please help! Thanks Chris Tag: how to link with COM port Tag: 180531
  - 16
    - Passing array to DLL Hi, I have a litte problem with passing and getting back values of an array passed to a dll (everything is VFP code). Here is my sample, and what happened. My DLL (a project compile as dll) Define Class ArrayToDll as Custom OlePublic Function GoArray lparameter pTableau Dimension pTableau(3) pTableau(1)="One" pTableau(2)="Two" pTableau(3)="Three" Return pTableau EndFunc Procedure ProcessArray lparameter pTableau Dimension pTableau(3) pTableau(1)="One" pTableau(2)="Two" pTableau(3)="Three" EndProc EndDefine and the code that uses the DLL ... i want to get back an updated array (dimension and values) Procedure ClientArray Local oObjetDLL,lTableau oObjetDLL=CreateObject("ArrayToDll.ArrayToDll") Dimension lTableau(1) lTableau(1)="Zero" lTableau=oObjetDLL.GoArray(lTableau) Dimension lTableau(1) lTableau(1)="Zero" oObjetDLL.ProcessArray(@lTableau) Release oObjetDLL EndProc I tried two methods, getting my updated array by value or by reference. In both case, i only get back an array with one element but with updated values. In fact, i get back the number of elements i passed, not an array with an updated number of elements. I got a solution with putting my array in an object and passing the object ... i just wanted to know if someone had to deal with such a case and how you solved it ... a solution with just passing array seemed to me more to read and understand ... Bests regards. Tag: how to link with COM port Tag: 180523
  - 17
    - Put a "date" date into a string and print in the report! Hi All, I have created a grid window and the data have been stored in a cursor. Also, two text fields (datatype: Date, Name of Text Fields: Text1,Text2) have been added in order to list the selected area only in the grid window. I'm now having a little troubles of how to print the selected data in the report. I want to list a sentence with "Text1" and "Text2" data ("date" datatype) in two text fields to the report like: filter_print='The date from'+allt(thisform.text1.value)+' to '+allt(thisform.text2.value) *!* This command is written in "Print" and "Preview" button. After I compile and execute the program, an error message jumps out and said "Operator and Operand do not match!" (It may not exactly the message like this!) The reason is because "date" data cannot be inserted into the string. So what's the correct statement should be looked like? Please help. Sam. Tag: how to link with COM port Tag: 180519
  - 18
    - Microsoft Windows Image Acquisition (WIA) Automation Layer Does anyone have any experience with Microsoft Windows Image Acquisition (WIA) Automation Layer - I would like to be able to scan & save images from my vfp6 app Thanks John Tag: how to link with COM port Tag: 180510
  - 19
    - WORD - CustomDocumentProperies I am looking for de VFP code to set the CustomDocumentProperties in a Word document. TIA Martin Lans Tag: how to link with COM port Tag: 180497
  - 20
    - SQL download I'd appreciate if someone can help me out on my dilemma: I would like to know what are the steps/commands to use to download data queried from SQL table, create output DBF that I can process in my Foxpro. Thanks for your help. Deo Tag: how to link with COM port Tag: 180490
  - 21
    - Catching error c05 when opening corrupted indexes Catching error c05 when opening corrupted indexes The problem is that I need to catch the error when I execute an USE command that opens a table with a corrupted index file. Normally Fox just gives me C0005 and exits. Any sugestion for any Visual FoxPro version from 6 to 8. Regards, Bastian Tag: how to link with COM port Tag: 180488
  - 22
    - Double Ampersand in Pull Down VFP8 I have a drop down control that is being populated by a field from a table. In one of the records the field being displayed has an ampersand in the text. When you pull down the list it displays two ampersands and not just the one that is in the field. e.g. The field text is: Barnes & Noble The pull down list displays: Barnes && Noble. What is going on and how can I stop this. Versions prior to VFP8 did not do this. Thanks Tim Cairns Tag: how to link with COM port Tag: 180484
  - 23
    - Eltron Programming Language/Foxpro 8.0 I'm interested in printing bar codes on Zebra LP2844 barcode printer. Can I access the Eltron Programming Language (EPL2) via Foxpro 8.0? Do I still need to buy a barcode font package or is this included? Thanks in advance. John. Tag: how to link with COM port Tag: 180478
  - 24
    - #DEFINES in VFP 8.0 - Bug? Hello, today I discoverd a stupid behavior in VFP 8.0. Could anyone confirm the following problem? > VFP 7.0 SP 1 ---------8<-------------- #DEFINE TEST "Hi" ? "TEST" && TEST ? [TEST] && TEST --------->8-------------- > VFP 8.0 ---------8<-------------- #DEFINE TEST "Hi" ? "TEST" && TEST ? [TEST] && HI --------->8-------------- Thanks Marco Tag: how to link with COM port Tag: 180462
  - 25
    - How to start Mobile Device Programming using VFP 7 Tag: how to link with COM port Tag: 180454

hello, i would like to know the coding to link the
program with COM port.. i'll will appreciate it..

Re: how to link with COM port by Eric

Eric
Tue Sep 09 02:25:51 CDT 2003

Hello, azrul!
You wrote on Tue, 9 Sep 2003 00:00:43 -0700:

a> hello, i would like to know the coding to link the
a> program with COM port.. i'll will appreciate it..

You can use the MSCOMM32.OCX active x control library. Go here for more
info:

HOWTO: Receive from the Serial Port by Using MScomm32.ocx.
http://support.microsoft.com/default.aspx?scid=140525
Also useful may be
HOWTO: Send to the Serial Port by Using Mscomm32.ocx.
http://support.microsoft.com/default.aspx?scid=139526
And of course,
HOWTO: Transmit and Receive Binary Data using MSCOMM32.
http://support.microsoft.com/default.aspx?scid=154741
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

Top