dbf encrypting data

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
    - 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 encrypting data Tag: 197629
  - 2
    - 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 encrypting data Tag: 197628
  - 3
    - 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 encrypting data Tag: 197627
  - 4
    - 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 encrypting data Tag: 197626
  - 5
    - 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 encrypting data Tag: 197625
  - 6
    - cannot using "GROUP BY" clause hi why i can't include GROUP BY clause in my SQL-string ? thank Tag: dbf encrypting data Tag: 197616
  - 7
    - 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 encrypting data Tag: 197610
  - 8
    - 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 encrypting data Tag: 197606
  - 9
    - 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 encrypting data Tag: 197592
  - 10
    - 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 encrypting data Tag: 197591
  - 11
    - 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 encrypting data Tag: 197585
  - 12
    - 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 encrypting data Tag: 197576
  - 13
    - 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 encrypting data Tag: 197575
  - 14
    - 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 encrypting data Tag: 197573
  - 15
    - 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 encrypting data Tag: 197572
  - 16
    - 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 encrypting data Tag: 197567
  - 17
    - VFP 9 threads??? I don't see very many threads on Fox9. Is there a special beta newsgroup somewhere???? Thanks Tag: dbf encrypting data Tag: 197566
  - 18
    - 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 encrypting data Tag: 197565
  - 19
    - 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 encrypting data Tag: 197562
  - 20
    - 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 encrypting data Tag: 197557
  - 21
    - 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 encrypting data Tag: 197552
  - 22
    - 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 encrypting data Tag: 197550
  - 23
    - 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 encrypting data Tag: 197544
  - 24
    - 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 encrypting data Tag: 197541
  - 25
    - 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 encrypting data Tag: 197540
- Next
  - 1
    - 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 encrypting data Tag: 197516
  - 2
    - 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 encrypting data Tag: 197512
  - 3
    - 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 encrypting data Tag: 197509
  - 4
    - 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 encrypting data Tag: 197502
  - 5
    - 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 encrypting data Tag: 197500
  - 6
    - 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 encrypting data Tag: 197489
  - 7
    - 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 encrypting data Tag: 197488
  - 8
    - 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 encrypting data Tag: 197474
  - 9
    - 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 encrypting data Tag: 197473
  - 10
    - 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 encrypting data Tag: 197469
  - 11
    - 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 encrypting data Tag: 197466
  - 12
    - 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 encrypting data Tag: 197460
  - 13
    - 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 encrypting data Tag: 197459
  - 14
    - 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 encrypting data Tag: 197443
  - 15
    - 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 encrypting data Tag: 197437
  - 16
    - 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 encrypting data Tag: 197434
  - 17
    - 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 encrypting data Tag: 197429
  - 18
    - 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 encrypting data Tag: 197427
  - 19
    - 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 encrypting data Tag: 197423
  - 20
    - [VFP9]: Cannot add macro substitution in local view! Hi all, Up to VFP8, I used to be able to do this CREATE SQL VIEW lv_test AS ; SELECT fields1, fields2 ; FROM some_tables ; WHERE &lcWhereClause *!* Obviously, I did RELEASE lcWhereClause I cannot do this in VFP9. Does anybody got a clue about this? TIA, Willianto Tag: dbf encrypting data Tag: 197409
  - 21
    - Running VFP on vmware workstation. Hi all, I am wondering; has anybody manage to run VFP under VMWare? I always have a GPF in *all* version of VFP I tried to run (after installing -obvioulsy). Looking forward to hearing from you! Willianto P.S: I use VMWare 4 under WinXPSP1. The host OS on VMWare is WinME. Tag: dbf encrypting data Tag: 197408
  - 22
    - more article & resources ? hi beside wiki, UT ,where i can find any free article & resources on web to help somebody like me to learn Vfox ? christ Tag: dbf encrypting data Tag: 197404
  - 23
    - WINWORD8 OLE PROBLEM I have a problem at one of my clients running my vfp6 app on xp home and calling winword8 (office 2000) They were win 2000 running with no problems - their tech just did an upgrade. The document is a mail merge document and I provide a button that allows them to view & edit the document (code snippet below) word opens and then crashes after about 5 seconds with fatal error message If I try again - winword doesn't even open & I get the fatal error message followed by a vfp error 1426 I can close my application & open the documents in word with no problems Where should I start to look for a solution to this problem ************** if file(cDocument) oW = createobject("word.application") oDoc = oW.documents.open(cDocument) else return endif if type("oDoc") # 'O' ow.quit(.f.) release oW return endif ow.visible = .t. ** wait for word to be closed by users do while type("ow.visible") = 'L' if isnull(ow) exit endif enddo release oDoc release oW ****** Tag: dbf encrypting data Tag: 197387
  - 24
    - Ordering a recursive table Ordering a recursive table We have a number of Visual FoxPro databases and programs that need to be converted to SQL Server. One of the tables is recursive and I have a little program that populates an index field so the table can be placed in the hierarchy order. Example: Top assembly Level 1 subassembly Level 2 Component part Level 2 Component part Level 1 subassembly Level 2 subassembly Level 3 Component part The recursive table had a parent, child and index fields. The program that sets the order does it in this way: 1. SQL out all the top assemblies. Order this table by the index field. (All children that do not have a parent) 2. With the record pointer on the first record. SQL out all the children that have the current record as a parent. 3. Set the index of the children to the sequence of the child records 1 thru n plus the record number of the parent. This means that when the children are appended to the table containing the top assembles they will appear under their parent. 4. Now move the record pointer to the next record. Which will be the first child. 5. SQL out all the children that have the current record as a parent. 6. This process continues stepping through each record until the end of the file is reached. The result is a properly ordered hierarchy of the recursive table. In SQL Server there are no record numbers. Nor can you open a table and order it as u do in Visual FoxPro. So the above described technique can not be used. I have looked at using a SQL Server cursor but that does not look like will allow this technique either. How can I accomplish the same thing in SQL Server that I easily did in VFP? I really appreciate the HELP. Tag: dbf encrypting data Tag: 197386
  - 25
    - Problem preparing installshield setup Hi all, I am having trouble accessing the data when making shortcuts in the Program Menu and on desktop. The program does run when I clik either shortcut but gives me an error about locating the table. My tables are included in the setup program My INSTALLDIR IS: [ProgramFilesFolder]MyProg DATABASEDIR is: [ProgramFilesFolder]MyProg\Data Shortcut in Programs Menu: [INSTALLDIR]MyExe.exe Desktop : [INSTALLDIR]MyExe.exe Installshield express is the limited edition (3.5 ver4) included with VFP8.0 sp1. Another question: When preparing the setup disk, instead of hardcoding the data directory, is it possible to allow user to change the data directory with this limited edition? Or is it available only in the full edition? Thanks for the help in advance. -- jw Tag: dbf encrypting data Tag: 197384

Is there an easy and efficient way of encrypting data in dbf's?
Looking for something simple..

thanks

Re: dbf encrypting data by Alex

Alex
Sat Jul 31 19:29:02 CDT 2004

On Sat, 31 Jul 2004 17:04:29 -0700, "foxman" <S-CPEREZ@MSN.COM> wrote:

>Is there an easy and efficient way of encrypting data in dbf's?
>Looking for something simple..

Depends on what version of VFP, and what are you looking for.

See:
http://www.feldstein.net/CodeCryptoArticle.htm
http://www.hallogram.com/cryptor/

Alex Feldstein
________________________________
Microsoft Visual FoxPro MVP
Please respond in the public groups so that everybody
can benefit from the exchange.
Favor de responder en los foros públicos asi todos se benefician.
(Address scrambled with ROT-13)

Top

Re: dbf encrypting data by sp

sp
Sat Jul 31 20:49:16 CDT 2004

Look for cipher50.fll

sp

"foxman" <S-CPEREZ@MSN.COM> wrote in message
news:uC2cvn1dEHA.2864@TK2MSFTNGP12.phx.gbl...
> Is there an easy and efficient way of encrypting data in dbf's?
> Looking for something simple..
>
> thanks
>
>

Top

Re: dbf encrypting data by Josh

Josh
Sun Aug 01 09:14:15 CDT 2004

What version of foxpro? fpd, fpu, vfp?

Since you x-posted to a vfp groups -- we can assume you are using at least vfp.

there's the FFC class for encrypting data; there's cryptor, there's NetLib,
there's Cipher, there's Windows encryption, there's a lot of examples on
www.universalthread.com in the download section.

On Sat, 31 Jul 2004 17:04:29 -0700, "foxman" <S-CPEREZ@MSN.COM> wrote:

>Is there an easy and efficient way of encrypting data in dbf's?
>Looking for something simple..
>
>thanks
>

---
Remove x's to send.

Top