Alpha Video Training
Results 1 to 8 of 8

Thread: trace window

  1. #1
    Member
    Real Name
    Alan Lee
    Join Date
    Jul 2000
    Location
    Olive Branch, MS
    Posts
    198

    Default trace window

    how does the trace window work? how do you tarce an event? i have an import that will not work because of invalid field name. There are close to 100 fields. I am sure the trace window can tell me which one is invalid, I just can't figure out how to trac an event.

    Thanks,
    Alan

  2. #2
    Member
    Real Name
    Dale Shields
    Join Date
    Nov 2002
    Posts
    77

    Default RE: trace window

    I think the message you are getting is bogus. I also need to import a file with more than 100 fields and I get the same error. I suspc the reason is "too many fields", rather than an invalid field name.

    I'm going to try Alpha 6 and see if the same problem happens as I need to get this info imported ASAP.

  3. #3
    Alpha Software Employee AaronBBrown's Avatar
    Real Name
    Aaron Brown
    Join Date
    Feb 2001
    Location
    Waltham, MA
    Posts
    2,836

    Default RE: trace window

    The trace window is accessible from the 'View' menu. It will show you some types of errors that have occurred. If you want to manually write to it, you can use the function trace.writeln().

  4. #4
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,607

    Default RE: trace window

    Alan

    I've normally been able to find problems with imports by opening them in design mode and using the down arrow key to move through row by row of field names.

    It'll stop on a row with a problem.

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

    Default RE: trace window

    Open your database; go to control panel.

    choose View from top menu
    Choose Trace window.
    Check the box that says "Trace events"

    Fieldnames must meet DBF format standards.

    If your source is an EXCEL file, try exporting to a DBF file first. You should be able to Append the new DBF.

    -- t

  6. #6
    Alpha Software Employee Lenny Forziati's Avatar
    Real Name
    Lenny Forziati
    Join Date
    Nov 2001
    Location
    Alpha Software
    Posts
    4,682

    Default RE: trace window

    Dale, the DBF format used by both v5 and v6 allows for 1,023 fields in your table. Unless you have more than that, the error about an invalid field name is probably accurate.

    -Lenny

  7. #7
    Member
    Real Name
    Dale Shields
    Join Date
    Nov 2002
    Posts
    77

    Default RE: trace window

    I've done that - moved through all fields in design mode and I encounter no errors - this is very frustrating as Alpha won't tell which field name is the problem...

  8. #8
    Member
    Real Name
    Dale Shields
    Join Date
    Nov 2002
    Posts
    77

    Default RE: trace window

    The down arrow method didn't work. What did work was setting the "import" option to No and then going through and changing a group of fields at a time to "yes" then testing the import. That enabled me to narrow things down to the one bugger.

    The .csv files I was given came from a system with little to no data integrety rules, unfortunately. I definately need Alpha's operation capabilities to whip the data into shape for final processing. Trying to do this in another DB product leaves me with chills... ;-)

    Thanks for the lead - some of my sanity has been restored...

Similar Threads

  1. Trace Window
    By Bernard Posner in forum Alpha Five Version 5
    Replies: 11
    Last Post: 09-03-2002, 07:40 PM
  2. Need help with Trace window
    By glenschild in forum Alpha Five Version 5
    Replies: 3
    Last Post: 08-09-2002, 07:42 AM
  3. Trace window
    By Richard Froncek in forum Alpha Five Version 4
    Replies: 5
    Last Post: 09-10-2001, 06:32 AM
  4. Trace window
    By Richard Froncek in forum Alpha Five Version 4
    Replies: 8
    Last Post: 09-10-2001, 02:10 AM
  5. Trace Window
    By Rachel Hardy in forum Alpha Five Version 4
    Replies: 9
    Last Post: 06-15-2001, 12:09 PM

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
  •