Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rnathan

    Problem creating Data Definition (TTX) File

    Hi, I was checking the http://support.businessobjects.com/communitycs/technicalpapers/scr8_ttxado.pdf file to see how I can create a TTX file. The scr8_ttxado.pdf says in the Database Explorer window, I should click on More Data Sources, click on Active Data and then click on Active Data...
  2. rnathan

    How to print the record layout

    This would work. Thanks so much. Rita
  3. rnathan

    How to print the record layout

    I tried to run the wizard. I am getting a msg asking me for MS 2000 Professional CD because it is not installed on my WS. Knowing our Helpdesk people, I'm pretty sure they would have misplaceed it some where. Is there anyother way? Thanks again. Rita
  4. rnathan

    How to print the record layout

    Hi I am a new user of Access. I have Access 2000 (9.0). I need to print the record layout of the database. Just don't know how. Thanks in advance. Rita
  5. rnathan

    Trigger Failed database error

    Rick, Yes, I'm using the latest version of VFP ODBC driver. Regarding VFPOLEDB, I was under the impression that you have to have VFP 8.0. Thanks for the info. Once the error occured, the application did not save any of the info entered for that particular quote. It exited. Because the trigger...
  6. rnathan

    Trigger Failed database error

    Hi all I have a major database problem in my hands and I just don't know how to resolve it. My application has been created using VB 6.0 connecting to VFP6.0 database using MS VFP ODBC driver. I have 3 major tables in the database. 1. CustomerInfo (Parent table/CustId as prime key) 2...
  7. rnathan

    Why 'Zap' works with 'Delete' set to 'Restrict' in RI?

    Thanks Mike. I wasn't aware of this fact.
  8. rnathan

    Why 'Zap' works with 'Delete' set to 'Restrict' in RI?

    Thanks Ramani.. that sure answered my question..
  9. rnathan

    Why 'Zap' works with 'Delete' set to 'Restrict' in RI?

    Hi I have a DB container (VFP 6.0) in which I have set up the Delete trigger to 'Restricted' for two tables in the Referential Integrity Builder. These two tables have parent-child relationship. What I noticed was I was able to zap the parent table (shocking...) but when I tried to delete a...
  10. rnathan

    Having trouble generating a .htm file

    I've included genhtml.prg. The error occurs only when I run the executable. Rita
  11. rnathan

    Having trouble generating a .htm file

    Yes, I've included genhtml.dbf and genhtml.fpt in the project and I tried both "Do genhtml with" and "DO _genhtml With". Either way, I'm still getting the 'File does not exist' error. I tried Brian's suggestion as per FAQ. I get "Function argument value, type, or count...
  12. rnathan

    Having trouble generating a .htm file

    I took a look at the code at FAQ. Is there a way we can create an htm file with one line of code like 'DO (_genhtml) with lcOutFile, lcSourceFile' without getting an error msg? Thanks. Rita
  13. rnathan

    Having trouble generating a .htm file

    ...with lcOutFile, lcSourceFile'. I have added genhtml.prg in the code segment of Project Manager. I am not sure if I have to add any other dlls. ** Sample code lcSourceFile = "D:\CommStat\CommStatus.dbf" lcOutFile = "D:\Commstat\StateNY.HTM" ** This is where the error...
  14. rnathan

    How to password protect a VFP 6.0 database

    Sorry, I wasn't being specific. I want to prevent users from accessing data in tables referenced in the DBC. My application is password protected. But any knowledgeable person can open a .dbf file in Access or Excel and manipulate the data. I would like to avoid that. Mike Lewis's comments are...
  15. rnathan

    How to password protect a VFP 6.0 database

    Hi I have a DB (.dbc) in VFP 6.0 that needs to be password protected. Can someone help me on this? Thanks Rita
  16. rnathan

    E-FAIL Error

    I checked the environment variables and they have been set. Any other suggestions?
  17. rnathan

    E-FAIL Error

    Hi I am trying to find a solution to the following problem. The error is 'Data Provider or other service returned an E-FAIL error. Number- 2147467259'. This happens when I add a new record to this table. Everything works fine when I have a small set of records. Currently I have about 24,000...
  18. rnathan

    How to update records in DBF file from VB 6.0?

    Set the date value to null if you really don't have any dates in the date field. And also in FoxPro, open the database, go to Tools->Options->Regional tab, for Date and Time, you may want to set Seconds check box to off. Rita
  19. rnathan

    How to update records in DBF file from VB 6.0?

    ...gDBConnection.CursorLocation = adUseClient gDBConnection.Open rsCustomer.Open "Select * from Customer where CustId = 1", gDBConnection, adOpenKeyset, adLockOptimistic, adCmdText rsCustomer!LastName = tstLastName.txt rsCustomer.Update rsCustomer.Requery ' If you want to refresh a...

Part and Inventory Search

Back
Top