dbf and php

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
    - Tables with buffering VFP 80 Sp1 XP My form allows the user to add a record. (In this case to the zip code table). I control my "Save" and "Undo" according to certain rules. If the user enters a zip code that is already in the table, I want to prevent the "Save" from enabling. However, on the LostFocus of the textbox for the zip code, I will automatically save the record when I seek that code. How do I determine if that zip code codes not already exist? I could open the table twice, but that seems a waste. TIA Tag: dbf and php Tag: 197651
  - 2
    - _Screen.Image When an Image object is added to the _screen to show some picture or graphic and a user later runs a report in Preview mode, periodically the image object on the _screen, continues to show the report preview image even after the report preview has been released. It is as if the graphic image from the report preview window, overlays, changes or corrupts the PICTURE of the IMAGE object on the _screen. Has anyone else seen this behavior/bug, and if so, any ideas what causes it or how to fix it short of destroying the _screen.image object and re-adding it to _screen? Thx Alec Tag: dbf and php Tag: 197648
  - 3
    - Sql Server Question Assuming I have a table stored in SQL server. What is the best technique advised as to searching for a particular record since the Seek command can not be used. The two options that comes to my mind is the Locate and the set filter command. If the particular field I am searching for has been defined in SQL server as being an index key, how can one perform a search that would not be considered sequestial and move the record pointer to the record desired as in the seek command. Many thanks in advance. Shahriar Tag: dbf and php Tag: 197647
  - 4
    - displaying records through a preview window Hi, what and how would be the easiest way to display records in a pre-formatted preview window in vfp6.0? before with 2.6, i redirect the formatted report to a text file, viewing the result through 'modi comm (text output file)' and terminating the preview report throught the ESC button. With 6.0, i've heard of so many ways to implement it, i dont know now what to use as my standard program procedure? I'm thinking of using a 'Microsoft Word Document Viewer'. will this simplify my class creation and maintenance? Thank you very much and more power! Long live Foxpro! Tag: dbf and php Tag: 197646
  - 5
    - Cryptor IV fll file I can't seem to get a response from Xitech on the issue but they advertise the Cryptor IV is compatible with VFP 8 but there is not an fll for VFP8 included in my copy. Is there an fll for VFP8? And if so does anybody have it and can I get a copy. This should not be a problem as I can't use the fll without a legit copy of he rest and I have that and all. But it makes it a little hard to use the product in VFP8 without the fll since you have to have the proper version of the dll for each version of VFP that is supported. I have tried emailing Xitech on the issue several times and have not gotten any response from them at all. Tag: dbf and php Tag: 197644
  - 6
    - dbf encrypting data Is there an easy and efficient way of encrypting data in dbf's? Looking for something simple.. thanks Tag: dbf and php Tag: 197636
  - 7
    - Adding events VFP80 SP1 on XP I have a basegrid in MyClass. I have added it to a form. When I run the form, I programmatically want to add a column and a Click() event to that column. I do not understand the Help screens on this issue. Anyone have a simple example. TIA Tag: dbf and php Tag: 197629
  - 8
    - set confirm and end of input ContainerA .textbox ContainerB 1. With SET CONFIRM OFF, how could I make a particular textbox on a form NOT to fire its valid()/lostfocus() event unless the user hit <enter>? 2. and when the user did hit <ENTER>, containerB will be made visible while containerA would be made invisible via containerA.textbox.lostfocus(). Any neat way to prevent containerA.textbox.valid() from being fired again when containerB was made visible? -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.26 ^ ^ 12:24am up 16:25 0 users 1.72 1.89 Tag: dbf and php Tag: 197628
  - 9
    - textbox focus (VFP6 unpatched) In one form, after going through a few events, a textbox.setfocus() was called, with textbox.format="K". Though the textbox got focus, the text inside was not selected (note the textbox.format) and sometimes, even the cursor is not inside the textbox, going somewhere. sometimes, the textbox, while in focus, didn't echo the text I inputted, though beneath the "surface", it's taking the input. The behaviour returned to normal after textbox.valid() fired once. -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.26 ^ ^ 12:16am up 16:17 0 users 2.11 2.06 Tag: dbf and php Tag: 197627
  - 10
    - simulate PRINT-SCREEN I use VFP 8.0 I would like to simulate the print-screen (stamp) button Any ideas ???? thanks KEYBOARD '{ xxx }' Tag: dbf and php Tag: 197626
  - 11
    - Datagrid control for VFP 8? Does anyone have a recommendation on a grid control for foxpro outside of the Datagrid control that is shipped with VFP 8. Many thanks Shahriar Tag: dbf and php Tag: 197625
  - 12
    - cannot using "GROUP BY" clause hi why i can't include GROUP BY clause in my SQL-string ? thank Tag: dbf and php Tag: 197616
  - 13
    - Menu Creation I have created menu using menu command Everthing works fine through command window i.e. do program name. But, when i generate the EXE it does not work, Programme exits directly. Tag: dbf and php Tag: 197610
  - 14
    - Complicated form with many search options Hello, I'm creating a form to manage serialized goods. The form shows data from 9 different tables. I also need to allow the user to search on a combination different parameters: Serial number Description GL Accounts Payment Due date Retail price Received Date AP Invoice # Categories They can search on as many or as few as they want. When faced with a form of this complexity, is it best to go with a CURSOR and update the records by hand, or is it best to use a view. The downside of the cursor is that it requires more work to commit the changes to the back end table. The advantage is that I have a lot more flexibility with my query statement. The downside of using a view is that I have to include all parameters in every search whether the user search on it or not. The advantage is that I can bind a view to the form itself and TABLEUPDATE() will handle the changes for me. Another problem is that a couple of my search fields are variable list matches that I make with a sub query against a temporary cursor and this might be difficult with a view (a variable table name parameter?) Does anybody have any tips on ways to go about this? Sincerely, Caleb Land Tag: dbf and php Tag: 197606
  - 15
    - NTFS system I need to know if our program is running on NTFS. I figure I could do this with OS(11). I am just checking if this is right. We only have NTFS stations so I can't see what a Win 98 will return with that function. I am guessing it will return a 0. Is this right? Tag: dbf and php Tag: 197592
  - 16
    - What am I missing in outer join query I am having problem with outer join in query. I am sure I am missing something and I am sure someone will point me the right direction. I have 2 tables AreaOffice Purchases I want all the records from Areaoffice and related purchases from Purchases table. AreaOffice: AOId AOName 1 AreaI 2 AreaII 3 AreaIII Purchases: AOId Date Amount 1 7/1/04 100 1 7/2/04 200 3 7/1/04 300 What I want is AOId AOName Date Amount 1 AreaI 7/1/04 100 1 AreaI 7/2/04 200 2 AreaII 3 AreaIII 7/1/04 300 But I dont get AreaII record on final result. Here is my query: SELECT AreaOffice.AoId, AreaOffice.AOName, Purchases.Date, Purchases.Amount ; from Areaoffice LEFT OUTER JOIN purchases on purchases.aoid = areaoffice.aoid ; order by ao_id Why am I not getting expected records? Thanks. Tag: dbf and php Tag: 197591
  - 17
    - FormHandler only allows 1 form I have taken the following code from "Advanced Object Oriented Programming with Visual FoxPro 6.0" and if I'm not mistaken it only allows 1 form to be open at a time. Is this a bug? It should be easy enough to correct but I am just a little surprised. Function LaunchForm(tcClassName) *-- Check if we have to redimension the array If Alen(This.ApplicationForms,1)=1 AND NOT ; Vartype(This.ApplicationForms(1))="O" Dimension This.ApplicationForms(Alen(This.ApplicationForms,1)+1) EndIf *-- Create the form and show it This.ApplicationForms(Alen(This.ApplicationForms,1))=CreateObject(tcClassNam e) *-- Check form has been created If Vartype(This.ApplicationForms(Alen(This.ApplicationForms,1)))="O" *-- Form has been created *-- Show it This.ApplicationForms(Alen(This.ApplicationForms,1)).Show() *-- Return a reference to the new form Return This.ApplicationForms(Alen(This.ApplicationForms,1)) Else *-- Form was not created *-- Delete the reference from the array If Alen(This.ApplicationForms,1) = 1 *-- The array only had the one item so we can't shrink it *-- We can however clear the object reference This.ApplicationForms(1) = .NULL. Else *-- Shrink the array Dimension This.ApplicationForms(Alen(This.ApplicationForms,1)-1) EndIf Return .NULL. EndIf EndFunc -- Regards Darren Woodford - MCP, MCSE Woodford Computer Systems Ltd http://www.woodfordcomputers.co.uk http://www.pegasus-opera-ii.co.uk Tag: dbf and php Tag: 197585
  - 18
    - callAll? I was wondering if anything like callAll for objects is being thought about for VFP 9. I havent found anything about it and after having setAll it seems to be the logical next step. CallAll should call the same method for all objects.. very similar to setAll just with methods.. I would like to get a suggestions about that to the developers of VFP.. I wonder if this is potentially the right place.. Tag: dbf and php Tag: 197576
  - 19
    - SetFocus to a form (class) VFP8 How do I set the focus to a form after I instantiate it and display using Visible = .T. ? Eg. loForm = CreateObject("TForm") loForm.Visible = .T. *-- Form does not have focus however loForm.Show() does give the form focus but I would like to know how to do this 'manually' -- Regards Darren Woodford - MCP, MCSE Woodford Computer Systems Ltd http://www.woodfordcomputers.co.uk http://www.pegasus-opera-ii.co.uk Tag: dbf and php Tag: 197575
  - 20
    - Local View modification on a remote database I have a local view stored in a database which needs to be modified. Unfortunately the database is in a remote location and I have no access to it. My first thought was to write some code and let it run on the remote location to modify the view. Unfortunately I cannot find anything how to change a view with code, I even do not know how to access it or where it is stored. Download the data, modify the view and upload againg is not possible. The database is quite big for such a task. Any suggestion would be appreciated Wolfgang Tag: dbf and php Tag: 197573
  - 21
    - Custom sized reports Hello; I have a situation where a client has started the process of upgrading workstations from Windows 98 to XP. Currently they are about 50% complete. The problem we are having is that custom sized report forms (ie cheques), do not print correctly from the XP stations (their alignment is off slightly, ie off millimeter for every page). The project is compiled under Windows 98. I see a few potential solutions. 1) recompile under XP - I am concerned that the 98 stations will have issues than, and currently, they are the critical stations. 2) do all special form printing from the 98 stations until the upgrade is complete and than recompile uner XP and adjust the forms as required. I do not like either of these options. I was wondering if anyone has seen this and knows of a work around. The version of Foxpro I am running is 5.0b. Any ideas are welcome. Tag: dbf and php Tag: 197572
  - 22
    - Filemaker Pro data to VFP I have been tasked to determine the feasability of importing data from a Filemaker Pro database to a VFP database. I will just require raw data as opposed to rules, etc. Is there anyone out there who has gone down that path? TIA --E. Myron -- To reply, change "invalid" to "net" Tag: dbf and php Tag: 197567
  - 23
    - VFP 9 threads??? I don't see very many threads on Fox9. Is there a special beta newsgroup somewhere???? Thanks Tag: dbf and php Tag: 197566
  - 24
    - Valid Event Message Hi Experts, Does anyone know how to change message "Invalid Input" to our own message, thanks in advance for all advices Hidayat Tag: dbf and php Tag: 197565
  - 25
    - Referncing a table not in the current datasession Using VFP 8 --- Is there anyway to reference (or view in the VFP debugger) a table or object in a specific data session - without changing the datasession? The same table can be open in multiple datasessions, so we are trying to find a way -in code- to view information about a table, or an object, that is specific to one datasession. It would make debugging much easier. Yes, you can use the DataSesson window (or the SET command) to flip back and forth between datasessions, but we are looking for a way -in code- to reference a table or object that is not in the current data session. Any ideas would be greatly appreciated. --Thanks Mike C. Tag: dbf and php Tag: 197562
- Next
  - 1
    - Foxpro to Excel cell formatting questions I am currently using Foxpro to write out an excel spreadsheet. I am using the following line to write a cell: for eline to 10 oExcel.Cells(eline, 2).Value = database.p_price endfor It is working but I want to have the following format on the cell: $###,###,###.## What do I need to add to do this? Also, what would I need to do if I wanted to format with the following: ###,###.##% One more question, if I wanted to spread a cell over 2 (or more cells), what would I need to do. Thanks. LVIII Tag: dbf and php Tag: 197557
  - 2
    - Visual Foxpro Scctext.prg I am attempting to re-create the .frt & .frx files of a Foxpro report using scctext.prg. (VFP 8.0) I have been successful in re-creating the binary files for forms and classes, but whenever a report is being processed, there is an error in the following method "HexStr2BinStr". I have been able to determine that when the ascii file (.fra) is written, any binary objects are stored using Sys(2007) (creating a Checksum), which is then passed to HexStr2BinStr prefixed with "CHECKSUM=". HexStr2BinStr uses Strtran() to convert some characters with a result of <H><KSUM=99999, etc, but the method fails before actually getting to the numeric portion of the string. Function HexStr2BinStr .*--where m.cHexStr = "CHECKSUM=55992"--* . . m.cHexStr = strtran(m.cHexStr, 'A', chr(asc('9') + 1)) m.cHexStr = strtran(m.cHexStr, 'B', chr(asc('9') + 2)) m.cHexStr = strtran(m.cHexStr, 'C', chr(asc('9') + 3)) m.cHexStr = strtran(m.cHexStr, 'D', chr(asc('9') + 4)) m.cHexStr = strtran(m.cHexStr, 'E', chr(asc('9') + 5)) m.cHexStr = strtran(m.cHexStr, 'F', chr(asc('9') + 6)) for m.i = 1 to len(m.cHexStr) step 2 m.cBinStr = m.cBinStr + ; chr((asc(substr(m.cHexStr, m.i, 1)) - 48) * 16 + ; asc(substr(m.cHexStr, m.i + 1, 1)) - 48) endfor . I have looked at the latest version included with VFP 9.0, but there are no changes that I can see. Has anyone found a work-around for this, or am I doing something totally incorrectly? Tag: dbf and php Tag: 197552
  - 3
    - Right click event of grid Hi experts.. Why does not grid's right click event work ? How to make it work ? any help are appreciated Tag: dbf and php Tag: 197550
  - 4
    - Inkey()??? Hello, I have inheritted some code. This program is written in Visual FoxPro 6.0. The function inkey() is used in several areas of the program and I still have not been able to figure out it's purpose. I would postpone to investigate this had it not been for one particular one causes errors every no and then. Got to love those inconsistent ones where debuggin takes 4 times as long and in my case still not solved. I checked FoxHelp and all it has is: Returns a number corresponding to the first mouse click or key press in the type-ahead buffer. It doesn't explain why anyone would want to use it. If there is anyone who can tell me what the inkey() function's purpose is, and what possibly could cause the following error message for the following code segment code: =inkey(1) error: Function argument, value, type or count is invalid. Please keep in mind that this error message does not pop up all the time. Thank you for your help in advance. Tag: dbf and php Tag: 197544
  - 5
    - Help distributing and app (VFP8) Hi, I'm having a difficult time sending a small vfp8 application (EXE) to a friend. See the thread: What files to distribute? for background info. I created a SETUP.EXE using InstallShield Express (ISE) and sent it to my friend. He ran it and got the same error as when I tried sending him the individual files. The message is: "A required DLL file, MSVCR70.DLL was not found." I had previously sent him this file outside of ISE. What I'm not sure of is if the necessary support files were actually included in the ISE Setup.exe file or not. I didn't see any place to explicitly include these files so I had to assume ISE took care of that for me. The only file I included was the EXE that VFP built for me. Anyway, since the setup didn't work, I'm back to square one. I'd just as soon send the individual files and skip ISE altogether as it seems more complicated and with more black magic when using it. Can someone help with this? At this point I'm totally confused. I don't know which way to turn. Why do I get the above message even when MSVCR70.DLL is present? Thanks for your help, Frank Tag: dbf and php Tag: 197541
  - 6
    - mapi mail xp-win2k domain - woes Hello All, I wasn't sure where to list this so please excuse if I picked the wrong category. I'm trying to get mapi mail inside my fox app to work at my customer's location. It works find on my development machine.....here's the details. I've tried several things and listed them all so please be patient....... The situation: xp pro client win2k server domain the client pc has two logon's possible. One is the administrator belonging to the local machine name and the other is the username belonging to the domain. My first attempt was to run fox.reg looged in as a domain user. This fails because no admin rights to local machine (or so it tells me - could it have meant domain rights here?). I'm hoping the registry modification(fox.reg) if made as administrator will work also for the user so I give this a try. I installed it (fox.reg) on local machine logging in as the adminstrator. I log back in as the user and mapaimail is not working - no messages it simply acts like either mapi is not talking from vfp or the mail program outlook express or eudora is not listening. So I dig deeper and try more. When I look at the control panel I see the user does in fact have admin rights on the local machine but when I look at the user on the win2k box (domain) they do not have admin rights. Still not working. I read somewhere that rights need to be the same on both the xp and win2k systems, So I change the domain to also give them admin rights by adding them to that group. I log back in as the user and the mapimail mods I've made still don't work. I'm suspecting it's the supervisor / user / domain security issues. I think I should try to install fox.reg again as the user now that I've changed the domain to recognize the user a an administrator. - nope it states something similar to "already in use". So I'm unsure of what to do here any ideas? I'm stuck. thanks for any help.... Tag: dbf and php Tag: 197540
  - 7
    - XMLAdapter - ApplyDiffGram Question Have a situation where some diffgram records are applied and some not. Are there any known issues with ApplyDiffgram that would prevent records from updating? Thanks - Base table seems OK - All diffgram records seem OK - No database validation rules violated - So far, records not updating don't show any pattern or deviation from the records that do update Here's the code: FUNCTION LoadDiffGram() && XML Parsing (Diffgrams) LOCAL oMyAdapter,lToAFile,lElementBased, ; lIncludeBefore,lChangesOnly SET MULTILOCKS ON lcFileName = <name of the diff gram file> lcViewName = <view to apply the diffgram to> SELECT 0 OPEN DATABASE cw2k USE &lcViewName CURSORSETPROP("Buffering",5,lcViewName) oXMLAdapter=CREATEOBJECT("xmladapter") oXMLAdapter.LoadXML(lcFileName,.t.) oXMLAdapter.Tables(1).ApplyDiffgram(lcViewName,,.T.,0) *-- Force any changes to the table to be applied lnReturnValue = TABLEUPDATE(1,.t.,lcViewName) USE IN (lcViewName) RETURN Tag: dbf and php Tag: 197516
  - 8
    - idispatch exception code 0 from CDO.Message.1 Hey; When I use this CDO object with objMail =Createobject("CDO.Message") set the vars and give it a objMail.Send() it runs just fine at the command line or in a class running a exe. But when I compile it as a multithreaded dll in VFP8 it breaks on the objMail.Send() line.. I get the idispatch exception error?? Any Ideas?? tks Linwood Tag: dbf and php Tag: 197512
  - 9
    - importing fixed field asci data I have a bunch of files from the post office that are all in fixed field length asci (no seperates). I have created a database with the correct length fields for each of the data fields to go into but cannot see what type of table I should say I am appending from. I previously used MS Access and this had a direct import function that would import the flat file with the relevant field breaks at the right spacing. Can any one please tell me how I need to do this. We are on MACs! the file name is ORG.CO1. Tag: dbf and php Tag: 197509
  - 10
    - Datasession on programmaticChange Event I have 2 forms with Private Data session. In first Form is Text control with programmaticChange Event. Second form method change the Text control value in first form . Shuld I use at begining in ProgrammaticChange code ThisForm.DataSessionID=xxx to change First form datasession to his datasession or not ? Thank you Tag: dbf and php Tag: 197502
  - 11
    - cursor adapter UPDATE/INSERT problem Hi experts.. Im having trouble with CA.i really need your help here 1. I create a table (MySQL), and one of My Customer field was set for NOT ACCEPTING NULL VALUE (NOT NULL). when issuing APPEND BLANK in the VFP cursor (create by CA) and then use Tableupdate(.T.) It always return True, whereas My Backend Data was not change or updated at all. So I Wrap it with Transaction, and issuing SQLCOMMIT() to commit the Null Data in the backend... weird!!! it still return 1 (which mean updating the backend was success) here's my code: ** assumming a connection has been build using sqlstringconnect() select caCustomer Append blank ln = CURSORGETPROP("ConnectHandle") = SQLSETPROP(ln,"Transactions",2) IF TABLEUPDATE(.T.) WAIT WINDOW 'update Success' WAIT WINDOW SQLCOMMIT(ln) ELSE WAIT WINDOW 'O..Oh.. problem with Updating!' WAIT WINDOW SQLROLLBACK(ln) ENDIF the question is: HOW I trap this error, for data was not phisically update to the BackEnd?? 2. which one is better, Using Automatic Update or using *CMD to manually manipulate the data in the backend. a little example will be appreciate PS: VFP 8 SP1, backend MySQL, WINXP pro any idea are appreciate... Please help best regards, Lee Tag: dbf and php Tag: 197500
  - 12
    - How do I run this click button programatically I have a click button created several times over and I need to run following command based on what I have in variable "thisform.addfoldername". w=thisform.addfoldername thisform.my_ctnlistbar1.listbar1.+(&w)+.folderheader.click() the above command doesn't seem to work, it gives errors. For example if w=csfld then the above command should represent: thisform.my_ctnlistbar1.listbar1.csfld.folderheader.click() however, I need a way to keep my code flexible and I was trying to use macro substitution, but it's not working. Any suggestions? thanks Nick Tag: dbf and php Tag: 197489
  - 13
    - How do I run this click button programatically I have a click button created several times over and I need to run following command based on what I have in variable "thisform.addfoldername". w=thisform.addfoldername thisform.my_ctnlistbar1.listbar1.+(&w)+.folderheader.click() the above command doesn't seem to work, it gives errors. For example if w=csfld then the above command should represent: thisform.my_ctnlistbar1.listbar1.csfld.folderheader.click() however, I need a way to keep my code flexible and I was trying to use macro substitution, but it's not working. any ideas. thanks Nick Tag: dbf and php Tag: 197488
  - 14
    - using KEBOARD into a EditBox with InputMask I'm trying to enhance my TouchScreen Entry form by allowing an InputMask on the data entered. Basically, my customer would like to be able to do simple input masking (like A9A-9A9 for Canada Postal Codes) in order to make it a little more difficult for the entry operators to screw up. That is a trivial operation when entering with a keyboard, but when entering data with my TouchScreen Entry form is where I'm running into difficulties. Basically, I have a Form with a button for each letter (laid out like a QWERTY keyboard) that enters the 'keys' touched into a TextBox. I thought that it would be a simple matter of Setting Focus to the TextBox (with an InputMask), then passing the keystroke with a "KEYBOARD cKeyPassedIn" command. Unfortunately, the cursor is always on the first position, so it 'inserts' the newly-entered character in the first position. I tried to manually attempt to keep track of where the last character is and force the cursor to that position with a "TextBox.SelStart = nLastCursorPosition" command. I managed to get most of it working, but when attempting to backspace to correct an incorrect entry, I ran into the problem of keeping an accurate nLastCursorPosition, because a cKeyPassedIn could be quietly rejected because it isn't a valid InputMask data-type. I tried to sense this by capturing the BeforeValue+cKeyPassedIn to the TextBox.ControlSource variable. During the general Method that does this 'simple' KEYBOARD operation, I haven't been able to get an accurate TextBox.Value or value of the TextBox.ControlSource. They both seem to be either empty, or what was there BEFORE the current operation. Is there a better way to do this? More specifically, is there a way that will work? Thanks for reading this far, Andy. Tag: dbf and php Tag: 197474
  - 15
    - SQL field limit 255 I upsized a Foxpro table with exactly 255 fields to a SQL server DB. Eventhough, I received a warning, It was successful. Then I manually wrote a script to upsize the 255 fields from the same table to another SQL server database and that was OK also. The problem is this. When I create a local database and set a remote to both databases, the one that was upsized by Foxpro is fine. The one that I upsized manually gets an error stating that I have more than 255 fields. I view both tables in the SQL server and they seem to be Identical. I even matched the SQL script generated from foxpro to the one I created manually and that seems to match. Is there some hidden field(s) somewhere? Many thanks in advance. Shahriar Tag: dbf and php Tag: 197473
  - 16
    - FPD2.6A Can't Tell Time :) I have a strange and frustrating (really, really frustrating) problem. I have a point of sale app that stores the date and time of sales as they occur. Many of our clients operate their POS terminals until about 2AM --- Here's the bug that has been happening... Sometimes FPD gets the wrong date! Ok, so I'm thinking maybe in the microsecond between when it pulls down the date and pulls down the time maybe the date changed. So if it is within 5 seconds of midnight, it actually just goes to sleep and waits for the new day. But still it sometimes gets the wrong date! I have a transaction right now I'm looking at that happened 9 seconds after midnight, but it reported the day as being from the day before --- can it take 9 seconds for the date to catch up with the seconds???? So I wrote code to store away what it's seeing as the date and time... (I'm using sys(2) to get the seconds, and date() for the date) 7/26/04 00:00:01 7/26/04 00:00:02 7/27/04 00:00:03 7/27/04 00:00:04 Sometimes it's 2 seconds, sometimes as much as 10 seconds!! What is going on??? Has anyone else seen this? I'm thinking of testing it with VFP, but it's probably an irrelevant problem because I'd use datetime() instead... Anyone have any ideas of a workaround here? I can't freeze the terminals for more than a couple of seconds (my retailers have midnight sales, so it would kind of kill the point if they had to stand at the registers waiting) Tag: dbf and php Tag: 197469
  - 17
    - What is foxr.exe used for? Hi Again, Can someone tell me what the program file foxr.exe is used for. I have a couple of batch files that reference this file with a -t switch, followed by a call to another file. Thanks, GaryB Tag: dbf and php Tag: 197466
  - 18
    - TRY..CATCH and insert trigger * location.dbf - parent table * cardhdr.dbf - child table with the field LOCATION_KEY as a foreign key * the referential integrity between 2 tables is setup as Restricted * with generated insert trgger * The INSERT command works fine INSERT INTO cardhdr ( pk_field, location_key) ; VALUES (10, NULL) * The INSERT failed when called from TRY...CATCH block * Reason: * procedure PROCEDURE __RI_INSERT_cardhdr * gives 'Data type mismatch' error at the line llRetVal=SEEK(lcChildID,lcParentWkArea) Without TRY...CATCH the error is trapped by ON ERROR command that just log the error and allow to continue ( llRetVal is .T. ) WITH TRY ...CATCH the control returns to the calling program leaving the transaction open and never executing RIEND procedure Is the only option is to put every trigger procedure inside its own TRY..CATCH ? Tag: dbf and php Tag: 197460
  - 19
    - Terminal Server Issues I'm hoping someone can shed some light on some problems I'm encountering on one specific client site running Terminal Server. We have other TS production environments running our app successfully without a hitch. At this one site, however, the user receives an "Invalid path or file name" program error when trying to launch the app. Our installation hasn't changed in quite some time and, as previously stated, works successfully everywhere else. Could someone please throw out some ideas of what I need to look at in troubleshooting their installation? It looks like all the VFP runtime classes have been successfully registered and all the necessary files that are loaded upfront (i.e. help file, Foxtools) exist in the EXE's directory. Kinda stumped! Tag: dbf and php Tag: 197459
  - 20
    - IMPLEMENTS How is implements different from ordinary inheritance. I can't see the point in it? Is it a means to multiple inheritance? -- Regards Darren Woodford - MCP, MCSE Woodford Computer Systems Ltd http://www.woodfordcomputers.co.uk http://www.pegasus-opera-ii.co.uk Tag: dbf and php Tag: 197443
  - 21
    - Working with DataSessions ? I want to read certain data from a table open in another Data Session - DataSessionID is not known in advance - but the name of the table is known . How can I ? Tag: dbf and php Tag: 197437
  - 22
    - How to import chinese data from Foxpro database to SQL database Hi all, I have tried to use the DTS Import/Export Wizard to import data from Foxpro database to SQL database. It is successful, but there is some problems. All chinese import cannot be seen in SQL database. Please help. Thanks a lot, Ray Tag: dbf and php Tag: 197434
  - 23
    - How To Trap Ctrl Key I want to trap Ctrl Key and if Ctrl Key is pressed than I want to show some help messages. Foxpro gives keypress event but it is only fired when i press some other key with Ctrl like Ctrl+A etc. Key press event is not fired when I press only Ctrl Key. Any Help? TIA Tag: dbf and php Tag: 197429
  - 24
    - set print driver while printing in Acrobat My application was working fine printing in Acrobat and printing multiple reports after a few changes to accommodate someones personal machine (although it worked for everyone else, I broke it). Putting it back doesn't work. I'm able to send a report to Acrobat print driver, but any further reports give me an "Error accessing printer spooler" error. I have to shut down the application and start it again in order to get another report. I have tried to hack the frx's to make sure the printer name is no longer in the file. It still doesn't work. Any ideas? Tag: dbf and php Tag: 197427
  - 25
    - Sql upsize I have a foxpro table that I am upsizing to SQL server. I have a field name called user (which is a reserved keyword in SQL server) and thus the field name is converted to user_ during the upsizing process. In the Sql server, I can rename the field back to USER and then it is enclosed in brackets as in [USER]. From Foxpro I am able to access that field name just fine. Now here is my question. I am manually upsizing my foxpro tables and I want to keep the field name USER, thus the following line of code in the SQL script will cause an error: Create table sample (user char(25)) Does anyone have a suggestion as to how I can indeed create the field name USER? Many thanks in advance. Shahriar Tag: dbf and php Tag: 197423

there is an example to open with mysql and php a foxpro database?

RE: dbf and php by Leemi

Leemi
Mon Aug 02 09:11:38 CDT 2004

Hi isabel:

> there is an example to open with mysql and php a foxpro database?

Take a look at this link from FoxWiki:

http://fox.wikis.com/wc.dll?Wiki~VFP/PHP/SQL

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 Public Beta Now Available!! --*
Download the VFP9 beta here: http://msdn.microsoft.com/vfoxpro/

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

Top