PC Plus SuperCD (UK) 1995 June/PC_PLUS.BIN/vbdb/demoapp.vbd

Text File | 1995-03-22 | 6.8 KB | 448 lines

VBDB Demonstration
.
demoapp.vbd
BIBLIO.MDB
 5
Begin table Authors
     3        -1             4             0
        Au_ID
        "Au_ID"
        -1
         4
         4



        Author
        "Author"
        -1
         255
         10



        Date
        "Date"
        -1
         8
         8




 0
 0
 7
    First
     0
     0
     0
     0
    Last
     0
     0
     0
     0
    Next
     0
     0
     0
     0
    Previous
     0
     0
     0
     0
    Sort
     0
     0
     0
     0
    Refresh
     0
     0
     0
     0
    Close
     0
     0
     0
     0
         1 ,  0 ,  0 , -1 ,  1 ,  6000 ,  4000 , -1 , -1 ,  0 ,  0
    2 ,  7170 ,  2370 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0
End table
Begin table Publisher Comments
     3        -1             4             0
        PubID
        "PubID"
        -1
         4
         4



        Publisher
        "Publisher"
        -1
         25
         10



        Comments
        "Comments"
        -1
         0
         12




 0
 0
 0
         1 ,  0 ,  0 , -1 ,  1 ,  8500 ,  8500 , -1 , -1 ,  0 ,  2
    1 ,  285 ,  645 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0
End table
Begin table Publishers
     9        -1             0             0
        PubID
        "PubID"
        -1
         4
         4



        Name
        "Name"
        -1
         50
         10



        Company Name
        "Company Name"
        -1
         255
         10



        Address
        "Address"
        -1
         50
         10



        City
        "City"
        -1
         20
         10



        State
        "State"
        -1
         10
         10



        Zip
        "Zip"
        -1
         15
         10



        Telephone
        "Telephone"
        -1
         15
         10



        Fax
        "Fax"
        -1
         15
         10




 0
 0
 11
    Add
     0
     0
     0
     0
    Delete
     0
     0
     0
     0
    First
     0
     0
     0
     0
    Last
     0
     0
     0
     0
    Next
     0
     0
     0
     0
    Previous
     0
     0
     0
     0
    Update
     0
     0
     0
     0
    Sort
     0
     0
     0
     0
    Refresh
     0
     0
     0
     0
    Close
     0
     0
     0
     0
    Edit
     0
     0
     0
     0
         1 ,  0 ,  0 , -1 ,  2 ,  8500 ,  6000 ,  0 ,  0 ,  0 ,  1
    2 ,  2655 ,  945 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0
End table
Begin table Titles
     5        -1             4             0
        Title
        "Title"
        -1
         255
         10



        Year Published
        "Year Published"
        -1
         2
         3



        Au_ID
        "Au_ID"
        -1
         4
         4



        ISBN
        "ISBN"
        -1
         20
         10



        PubID
        "PubID"
        -1
         4
         4




 0
 0
 8
    First
     0
     0
     0
     0
    Last
     0
     0
     0
     0
    Next
     0
     0
     0
     0
    Previous
     0
     0
     0
     0
    Filter
     0
     0
     0
     0
    Sort
     0
     0
     0
     0
    Refresh
     0
     0
     0
     0
    Close
     0
     0
     0
     0
         2 ,  0 ,  0 , -1 ,  1 ,  6000 ,  5000 , -1 , -1 ,  0 ,  2
    1 ,  5055 ,  1920 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0
End table
Begin table By State
     5         0             4             1
        Titles.Title
        "Titles.Title"
         0
         255
         10



        Titles.[Year Published]
        "Titles.[Year Published]"
         0
         2
         3



        Authors.Author
        "Authors.Author"
         0
         255
         10



        Publisher
        "Publisher"
         0
         50
         10



        Location
        "Location"
         0
         120
         10




 0
 0
 0
         2 ,  0 ,  0 , -1 ,  1 ,  8500 ,  3500 , -1 , -1 ,  0 ,  2
    1 ,  570 ,  2640 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 ,  0
End table
 0             0             0             0
 2             2             0             0
 7
 0
Publishers
PubID
Titles
PubID
"select [Publishers].[PubID], [Publishers].[Name], [Publishers].[Company Name], [Publishers].[Address], [Publishers].[City], [Publishers].[State], [Publishers].[Zip], [Publishers].[Telephone], [Publishers].[Fax] from [Publishers] "
"select [Titles].[Title], [Titles].[Year Published], [Titles].[Au_ID], [Titles].[ISBN], [Titles].[PubID] from [Titles] where [Titles].[ISBN] = NULL"
 2
Publishers
PubID
Publisher Comments
PubID
"This is a 'Table' object, no SQL."
"select[Publisher Comments].[PubID], [Publisher Comments].[Publisher], [Publisher Comments].[Comments] from [Publisher Comments] where [Publisher Comments].[PubID] = [Publishers].[PubID]"
 0
Publishers
State
By State
[Enter state]
"select [Publishers].[PubID], [Publishers].[Name], [Publishers].[Company Name], [Publishers].[Address], [Publishers].[City], [Publishers].[State], [Publishers].[Zip], [Publishers].[Telephone], [Publishers].[Fax] from [Publishers] "
"select [By State].[Titles.Title], [By State].[Titles.[Year Published]], [By State].[Authors.Author], [By State].[Publisher], [By State].[Location] from [By State] where [By State].[[Enter state]] = NULL"
 0
Titles
Au_ID
Authors
Au_ID
"select [Titles].[Title], [Titles].[Year Published], [Titles].[Au_ID], [Titles].[ISBN], [Titles].[PubID] from [Titles] "
"select [Authors].[Au_ID], [Authors].[Author], [Authors].[Date] from [Authors] where [Authors].[Au_ID] = NULL"
 3
Authors
Au_ID
Titles
Au_ID
""
""
 3
Publishers
PubID
Publisher Comments
PubID
""
""
 3
Publishers
PubID
Titles
PubID
""
""
 0
 0
 0
 0
 1
        [Enter state]
        "[Enter state]"
         0
         0
         0

        State

 0
End