foxpro tables on PocketPc

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
    - New MSGraph FoxPro user group, Can we -fox developers- reditribute the new version of MSGraph? Thanks in advance... Bastian V. Tag: foxpro tables on PocketPc Tag: 180910
  - 2
    - Divid by Zero Error hi; I'm working in foxpro. Program, but whenever i tried to print it gives me zero error. so i will be grateful, by find a solution for this errore from from any one. Tag: foxpro tables on PocketPc Tag: 180904
  - 3
    - Is Nothing $ Nothing? Check the following: STORE "" TO nada STORE "" TO zilch ? nada $ zilch && Returns .F. STORE SPACE(10) TO nada STORE "" TO zilch ? LEN(nada) && Returns 10 ? zilch $ nada && Returns .F. Is this appropriate behavior? Okay, so it sort of makes sense that if something doesn't contain anything, then it can't even contain nothing. But it sure kabolixes things up when you want to do a "contains" comparision where an empty string or an empty character field are just as valid values for comparison as any other. My particular case is a system where "jobs" are set up by one department and "invoices" are assembled from those jobs by another department. An invoice can contain many jobs, done over a period of time. The idea is to automatically pull all jobs being billed to the same organization into one invoice. Since the same organization can be represented by different strings (ie., "Lourdes Hospital", "Our Lady of Lourdes Hospital", "Our Lady of Lourdes", or just "Lourdes"), I need to start with some job (preferably the shortest name), and look for all other jobs that contain the organization name from the current job. IE, temporgan = "Lourdes" SELECT..... ; WHERE UPPER(ALLTRIM(temporgan)) $ UPPER(ALLTRIM(organ))... My workaround is to create two separate WHERE clauses--one to use if "temporgan" turns up empty and one if it doesn't. Not difficult, but this did bite me when, after the system had been in use for several months, it finally stumbled on a billing contact with no organization name. It seems to me that $ would be even more useful if it would return .T. when it compares two variables that, in the end, both evaluate to EMPTY(). Thanks for your thoughts. Ken Dibble Southern Tier Independence Center, Inc. Tag: foxpro tables on PocketPc Tag: 180892
  - 4
    - Using a Dll With an Event in a VFP Form. I have a client that is adding a barcode card reader to a turn style access gate. The reader vendor provided a dll with examples for VB. I have used 3rd party dll's before but never to respond to an event initiated by the dll. I can connect to the reader and send data. When I use there connection string I connect and can send data but return .Null. as the return value instead of the 0 or 1 nRetval = 0 nGateNumber = 1 nIp = 10.10.1.2 nMyRetval = oreader.SendConnection(nGateNumber, nIp, nRetVal) It requires the 3rd parameter but always returns .Null. (I have played with various values of nRetVal although this is actually the retval. and the value of nRetVal is always the value that I set it to after I call the method.) My other issue is I am not sure how to respond to the DataFromGate event generated when a user scans there card. I need to take the card number and look it up to see if they are paid up and open or close the gate. This will be called from form open on the front desk used to see details if the account is past due or to manually open the gate. But for 98% of the people the form will function without any user input other than the scan of the card triggering the DataFromGate Event which sends the form the card number. I believe i need to create a wrapper for the DataFromGate method but and not sure how to do that or add it to my existing form. Thanks for your help. Larry Oliver All the documentation I have is included below. dll Reference Methods CloseConnection () Description: Closes the connection with the card reader or IPC. SendData (short validEntry, short sound, short light, variant textLine1,variant textLine2, variant textLine3, short time) Description: Controls the connected gate. Can be used to open the gate, keep it closed and display messages. Parameters: validEntry - The action to be taken by the gate. 0 Keep the gate closed, 1 open the gate. sound - The type of sound to be made by the gate. 0 sound off, 1 valid, 2 not valid, 3 error light - type of flashing for the light. 0 light off, 1 solid on, 2-13 various flashing speeds. textLine1 - First line of text to be displayed on card reader. textLine2 - Second line of text to be displayed on card reader. textLine3 - Third line of text to be displayed on card reader if available. time - Length of time in seconds for the gate to flash or display a message before being reset. SetConnection (long gateNumber, variant IPAddress, long returnValue) Description: Connects to an IPC or individual card reader. Must be called first in order to receive gate events and send data. Parameters: gateNumber - The number of the card reader, either 1 or 2, used for compatibility with systems using an IPC. IPAddress - A string containing the IP address of the individual card reader or IPC. returnValue - The result of the connection attempt. 1 successful, 0 failed. Events DataFromGate (String cardNumber) Description: Called when the gate has received a card number scanned by a member. Parameters: cardNumber - The number on the card scanned by the card reader. Tag: foxpro tables on PocketPc Tag: 180885
  - 5
    - Dragging classes on to form... There is probably a very simple answer, but how do I drag an object in the class browser onto a form? Or how do I place the object such as a command button onto a form? Tag: foxpro tables on PocketPc Tag: 180881
  - 6
    - Communications Hello all, The application I am working in copies files into a PC from a remote server via pcAnywhere. The problem I have is that a dialog asking the user for permission is presented. The dialog refers to the pcAnywhere's .CHF file that the app uses to establish the connection. This occurs in Windows XP boxes. I noted that if the Software Restriction Directives branch of the machine's Local Security is empty the dialog is not launched. How can I Eliminate the contents of this branch (I mean all the content)? Any help is a great help. TIA Carlos Jones Tag: foxpro tables on PocketPc Tag: 180873
  - 7
    - Subclassing Foxpro Class Libraries Hi everybody, I am looking for Tool (PRG, APP, EXE) which enables me to subclass a Class Library such that it retains all the Properties and Class hierarchy of the Parent Class. I will be very thankfull to anybody who could help me find such tool. -- Tanveer H. Malik LAHORE. (Pakistan) Cell: +92 333 4227099 Tag: foxpro tables on PocketPc Tag: 180841
  - 8
    - font changed How can I fix the font of the VFP compiled exe file ? It is because the font changes according to the system font of the OS that the exe file runs, the labels become mess up. Matthew Tag: foxpro tables on PocketPc Tag: 180837
  - 9
    - How to find out how many instances running. Hi all I use an addon for Outlook that is creating multiple instances of Outlook to run invisibly. I can see them all using Task Manager. Is there a way in FoxPro or API to count how many instances of any application are active? This might be useful in other circumstances where a bug in my automation code leaves multiple copies of Word running. Malcolm Tag: foxpro tables on PocketPc Tag: 180834
  - 10
    - how to link with COM port hello, i would like to know the coding to link the program with COM port.. i'll will appreciate it.. Tag: foxpro tables on PocketPc Tag: 180828
  - 11
    - 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: foxpro tables on PocketPc Tag: 180819
  - 12
    - 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: foxpro tables on PocketPc Tag: 180812
  - 13
    - Open file dialog I want to add an "Open file dialog" to my VFP 7 form. Where do I find it? Thanks, Scott Tag: foxpro tables on PocketPc Tag: 180811
  - 14
    - 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: foxpro tables on PocketPc Tag: 180807
  - 15
    - File size hi all how can i know the size of thefile ? size('test.doc') tankes Tag: foxpro tables on PocketPc Tag: 180794
  - 16
    - claint-server example Hi all where can i find example for clint-server program i men com programes tankes Tag: foxpro tables on PocketPc Tag: 180790
  - 17
    - Disk Free Space Hi Freinds, VFP6.0 How can I get available free disk space ? Thanks, Pat Tag: foxpro tables on PocketPc Tag: 180789
  - 18
    - 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: foxpro tables on PocketPc Tag: 180787
  - 19
    - 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: foxpro tables on PocketPc Tag: 180780
  - 20
    - 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: foxpro tables on PocketPc Tag: 180776
  - 21
    - 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: foxpro tables on PocketPc Tag: 180771
  - 22
    - 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: foxpro tables on PocketPc Tag: 180770
  - 23
    - 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: foxpro tables on PocketPc Tag: 180753
  - 24
    - 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: foxpro tables on PocketPc Tag: 180750
  - 25
    - 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: foxpro tables on PocketPc Tag: 180747
- Next
  - 1
    - 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: foxpro tables on PocketPc Tag: 180736
  - 2
    - 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: foxpro tables on PocketPc Tag: 180733
  - 3
    - send me spam plz zaitsev@mail15.com zaitsev@mail15.com zaitsev@mail15.com zaitsev@mail15.com zaitsev@mail15.com zaitsev@mail15.com Tag: foxpro tables on PocketPc Tag: 180730
  - 4
    - _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: foxpro tables on PocketPc Tag: 180729
  - 5
    - 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: foxpro tables on PocketPc Tag: 180722
  - 6
    - 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: foxpro tables on PocketPc Tag: 180692
  - 7
    - 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: foxpro tables on PocketPc Tag: 180689
  - 8
    - 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: foxpro tables on PocketPc Tag: 180684
  - 9
    - 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: foxpro tables on PocketPc Tag: 180672
  - 10
    - 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: foxpro tables on PocketPc Tag: 180659
  - 11
    - 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: foxpro tables on PocketPc Tag: 180651
  - 12
    - 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: foxpro tables on PocketPc Tag: 180645
  - 13
    - 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: foxpro tables on PocketPc Tag: 180639
  - 14
    - 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: foxpro tables on PocketPc Tag: 180638
  - 15
    - 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: foxpro tables on PocketPc Tag: 180636
  - 16
    - 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: foxpro tables on PocketPc Tag: 180627
  - 17
    - Background for report Is it possible to place a bitmap as a background for a report ? TIA Sujata Tag: foxpro tables on PocketPc Tag: 180594
  - 18
    - 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: foxpro tables on PocketPc Tag: 180593
  - 19
    - 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: foxpro tables on PocketPc Tag: 180574
  - 20
    - 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: foxpro tables on PocketPc Tag: 180567
  - 21
    - 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: foxpro tables on PocketPc Tag: 180558
  - 22
    - 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: foxpro tables on PocketPc Tag: 180554
  - 23
    - 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: foxpro tables on PocketPc Tag: 180553
  - 24
    - 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: foxpro tables on PocketPc Tag: 180544
  - 25
    - 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: foxpro tables on PocketPc Tag: 180531

Dono anymore who was looking for something similar
(it was more appdev) but this can be a start
Foxpro with index compatible
tables on a pocketPc !
I didn't try it (later maybe)
but maybe others now something more about it

http://www.pylin.com/docs/doc_xbase.asp

christophe
belgium

Top

Re: foxpro tables on PocketPc by christophe

christophe
Fri Sep 12 01:58:47 CDT 2003

yes, indeed I installed it and at the moment it is very
limmitted. I've send them (author) a mail for other
possibilities and they will come out early next year
with simple definable forms with little programmability.
it's a start ...

christophe
belgium

--
¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º°`°º¤ø,¸¸,ø¤º°`°º

"EFGroup" <wsanders.bob@bob.advmed.com> schreef in bericht
news:ONNk046dDHA.2148@TK2MSFTNGP12.phx.gbl...
> Christophe - about bloody time :P but - just browse windows ???? don't
see
> any code samples for easy stuff like order taking and invoice generation..
> please let me know your thoughts?
> mondo regards [Bill]
> --
> William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
> email.
> FREE LONG DISTANCE -> mailto:excel-info@efgroup.net
> mySql / VFP / MS-SQL
> "christophe" <irs.znospamforme@skynet.be> wrote in message
> news:eh2ITc6dDHA.1632@TK2MSFTNGP12.phx.gbl...
> > Dono anymore who was looking for something similar
> > (it was more appdev) but this can be a start
> > Foxpro with index compatible
> > tables on a pocketPc !
> > I didn't try it (later maybe)
> > but maybe others now something more about it
> >
> > http://www.pylin.com/docs/doc_xbase.asp
> >
> >
> > christophe
> > belgium
> >
> >
> >
>
>

Top