Alpha Video Training
Results 1 to 2 of 2

Thread: initialize from table

  1. #1
    BRIAN GRAY
    Guest

    Default initialize from table

    Good Morning,

    Again I find myself having a problem with placing a filter in a dialog I'm trying to display filtered records in a dialog And i cannot for the life of me figure out how or why this is not working:

    table_name = a5.Get_Path()+chr(92)+ "job description.dbf"
    dim rec[1000] as p
    rec.initialize_from_table("job description","Customer_id=Var->vid","Job")

    dim i as n
    i = 1

    So what am I missing???????

    Thanks for the help
    Brian

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: initialize from table

    table_name = a5.Get_Path()+chr(92)+ "job description.dbf" - why do this?

    and then

    rec.initialize_from_table("job gescription","Customer_id=Var->vid","Job")

    instead of

    rec.initialize_from_table(table_name,"Customer_id=Var->vid","Job")

    also

    "Customer_id=Var->vid" means

    Customer_id = "var->vid"
    or
    customer_id = "the characters 'var->vid'"

    if you want to "drop in" the value of the variable vid try

    "Customer_id=' "+Var->vid+" ' "

    if vid is a character value.

Similar Threads

  1. cannot initialize printer database
    By Juanita in forum Alpha Four Versions 7 and 8
    Replies: 6
    Last Post: 01-01-2015, 08:23 PM
  2. Array doesn't initialize, any ideas?
    By Jerry Gray in forum Alpha Five Version 6
    Replies: 1
    Last Post: 06-27-2005, 01:04 PM
  3. Initialize a structure
    By Marcel Kollenaar in forum Alpha Five Version 6
    Replies: 2
    Last Post: 08-08-2004, 01:22 AM
  4. Initialize from table
    By BRIAN GRAY in forum Alpha Five Version 5
    Replies: 0
    Last Post: 01-26-2004, 07:12 AM
  5. Initialize PDF driver
    By Andrew Osyany in forum Alpha Four Versions 7 and 8
    Replies: 8
    Last Post: 04-16-2003, 01:40 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
  •