Alpha Video Training
Results 1 to 14 of 14

Thread: Violated.ddd

  1. #1
    Edward F. Schulz
    Guest

    Default Violated.ddd

    Hi Phorum,

    Suddenly my append from floppy does not work. It gives the error
    message that "Cannot find c:|program files|a5v4|violated.ddd.

    The database in it's entirety is in C:|program files|a5v4|frog. I
    searched the hard drive (in windows "find") for violated.ddd without
    success. Where is it supposed to be?

    Thanks for your time to examine this problem,
    efs

  2. #2
    Edward F. Schulz
    Guest

    Default RE: Violated.ddd

    BTW, even though it gives the message cannot find C:|program files|a5v4
    |violated.ddd it does append the records.
    efs

  3. #3
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,314

    Default RE: Violated.ddd

    Ed,

    The 'violated' table is where Alpha stores information on records which could not be appended. When Alpha creates it the first time it creates the related dictionary files, too (ddd, ddm, ddx and possibly the fpt). On my system these appear in the EXE folder for Alpha Five, with the Violated.DBF file. Can't explain why your's is missing. Suggest you manually delete all the Violated.* files from your EXE folder and do another append. I think Alpha Five will recreate them for you.

    Check user's guide, pp 165, 190 and 242 for add'l info.

    -- tom

  4. #4
    Edward F. Schulz
    Guest

    Default RE: Violated.ddd

    Hi Tom,
    Thank you for the response, I'll get chance to look into that later
    today.
    Many thanks,
    efs

  5. #5
    Edward F. Schulz
    Guest

    Default RE: Violated.ddd

    Hi Tom,

    I deleted the violated.dbf and dbt files from c:|program files|a5v4 and
    then ran the append operation again. It recreated the violated.dbf but
    did not recreate the violated.dbt nor ddd. Any other sugestions?
    efs

  6. #6
    Edward F. Schulz
    Guest

    Default RE: Violated.ddd

    Tom,
    BTW, the violated.dbf file that was just created in
    c:|program files|a54v does not contain any data.
    efs

  7. #7
    Edward F. Schulz
    Guest

    Default RE: Violated.ddd

    Hi,
    Now it is really weird, after recreating violated.dbf and then
    compacting the database the append operation gives the error message
    cannot find c:|program files|a5v4|frog|jobs.dbG. I have very carefully
    checked for typos in the append design and do not find a one.
    Incidently, I do not get the can't find
    c:|program files|a5v4|violated.ddd message now.

  8. #8
    Edward F. Schulz
    Guest

    Default RE: Violated.ddd

    Another BTW !

    What the heck is a DBG file, or is there a virus going around that
    changes F in an extension to a G ?
    efs

  9. #9
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,314

    Default RE: Violated.ddd

    Ed, 99 out of 100 problems I've ever had with appends were due to faulty source table data. If it were me I would not be trying to debug or fix anything anywhere until I first each and every record in the source data file.

    -- tom

  10. #10
    Edward F. Schulz
    Guest

    Default RE: Violated.ddd

    Hi Tom,

    This is peculiar. First of all I have 2 buttons on a menu that is based
    on a dummy table. 1 button will append data to jobs.dbf and the other
    will zap jobs.dbf. The zap button works great. The append floppy button
    gives an error after a few seconds and presents an error message that
    it can't find c:|program files|a5v4|frog|jobs.db"G" (without the quotes
    and uppercase they are just there to emphasize their presence). The
    really peculiar thing is that it does the append properly, I checked
    every record. But, the "G" thingy led me to search the HD for *.dbg,
    lo and behold I found 4 of them, 2 each in 2 different DBs. (not
    tables, different apps and these 2 DBs work perfectly). Go figure.
    Many thanks for your time,
    efs

  11. #11
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,314

    Default RE: Violated.ddd

    Ed, I searched this forum for message threads containing:

    dbg

    Found several hits that may be useful to you:

    Thread 07-05-2000
    Msg Id 23571


    Thread 02-17-2000
    Msg Id 2552


    Thread 07-28-1999
    Msg Id 9543


    -- tom

  12. #12
    Edward F. Schulz
    Guest

    Default RE: Violated.ddd

    Hi Tom,

    I am amazed, now I know why you are such a diligent contributor to this
    phorum. As often as I use the search on here when I need help, it never
    occured to me to search for this problem, I was convinced that I made a
    typo somewhere and it migrated to other apps. As soon as I finish this
    response I'll do a search.

    Thanks again,
    efs

  13. #13
    "Certified" Alphaholic
    Real Name
    Ohlen Cartmell
    Join Date
    Apr 2000
    Posts
    1,599

    Default RE: Violated.ddd

    It is apparent to all that Tom has no job and requires no sleep. How else can he spend so much time helping others.

  14. #14
    Edward F. Schulz
    Guest

    Default RE: Violated.ddd

    We have to believe you are right. How does he do it?
    efs

Similar Threads

  1. importing, edit rules & violated.dbf
    By Hasan Muhammad in forum Alpha Five Version 5
    Replies: 1
    Last Post: 03-21-2003, 09:10 AM
  2. export violated.dbf to excel not includes remarks
    By Hasan Muhammad in forum Alpha Five Version 5
    Replies: 1
    Last Post: 02-05-2003, 03:39 AM
  3. bug? copy_records_to() not filling violated.dbf
    By Hasan Muhammad in forum Alpha Five Version 5
    Replies: 0
    Last Post: 02-04-2003, 08:55 AM
  4. Violated Table
    By Phil Rolf in forum Alpha Five Version 4
    Replies: 4
    Last Post: 04-13-2001, 08:09 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •