Need help with some datatypes in an Access2k-SQL-Statement

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • KePaS

    #1

    Need help with some datatypes in an Access2k-SQL-Statement

    I,ve got the following Script to Use on MS Access. So far it works
    just fine, but I want to set "Auto-Increment" to the field
    "test16_auto_lo ng", but I don't know the expression Access wants to
    have.
    The same problem I have with the datatype "OLE-Object".

    So here my question: how are these two datatypes called in Access-SQL?
    Hope it's possible.


    CREATE TABLE tblTest
    (
    test1_short_int Short not NULL,
    test2_norm_int Integer NULL,
    test3_long_int Long NULL,
    test4_single Single NULL,
    test5_double Double NULL,
    test6_rep_ID GUID NULL,
    test7_dezimal Double NULL,
    test8_text_255 Text (255) NULL,
    test9_währ_allg _zahl Currency NULL,
    test10_währ_wäh rung Currency NULL,
    test11_währ_eur o Currency NULL,
    test12_memo Memo NULL,
    test13_dat_stan dard Date NULL,
    test14_dat_zeit Date NULL,
    test15_dat_dat Date NULL,
    test16_auto_lon g Long NULL,
    test17_bool_j_n Bit NULL,
    test18_bool_tru e_false Bit NULL,
    test19_bool_on_ off Bit NULL,
    test20_ole_obje kt Binary NULL,
    test21_hyperlin k Memo NULL
    );

    =============== =============== =============== =============
    =============== =============== =============== =============

    Ok, and I have just an other question. The above SQL-statement is
    created out of VB. I analyze the structure of existing tables and out
    of this information this SQL-string is created. But I didn't manage to
    get the Primary Key out of a table via VB. How can I get this?

    thx in advance.
  • KePaS

    #2
    Re: Need help with some datatypes in an Access2k-SQL-Statement

    Thank you.
    But I've got another question like this.

    test21_hyperlin k Memo NULL <-- should be a hyperlink (datatype?)
    test7_dezimal Double NULL <-- should be a decimal (datatype?)


    "Terry Kreft" <terry.kreft@mp s.co.uk> wrote in message news:<bj7gki$h4 d$1@newsreaderm 1.core.theplane t.net>...[color=blue]
    > ...
    > test16_auto_lon g COUNTER NULL,
    > ...
    > test20_ole_obje kt LONGBINARY NULL,
    > ...
    >
    > Terry
    >
    > "KePaS" <kepas@o2online .de> wrote in message
    > news:e8531081.0 309040543.3f4eb eea@posting.goo gle.com...[color=green]
    > > I,ve got the following Script to Use on MS Access. So far it works
    > > just fine, but I want to set "Auto-Increment" to the field
    > > "test16_auto_lo ng", but I don't know the expression Access wants to
    > > have.
    > > The same problem I have with the datatype "OLE-Object".
    > >
    > > So here my question: how are these two datatypes called in Access-SQL?
    > > Hope it's possible.
    > >
    > >
    > > CREATE TABLE tblTest
    > > (
    > > test1_short_int Short not NULL,
    > > test2_norm_int Integer NULL,
    > > test3_long_int Long NULL,
    > > test4_single Single NULL,
    > > test5_double Double NULL,
    > > test6_rep_ID GUID NULL,
    > > test7_dezimal Double NULL,
    > > test8_text_255 Text (255) NULL,
    > > test9_währ_allg _zahl Currency NULL,
    > > test10_währ_wäh rung Currency NULL,
    > > test11_währ_eur o Currency NULL,
    > > test12_memo Memo NULL,
    > > test13_dat_stan dard Date NULL,
    > > test14_dat_zeit Date NULL,
    > > test15_dat_dat Date NULL,
    > > test16_auto_lon g Long NULL,
    > > test17_bool_j_n Bit NULL,
    > > test18_bool_tru e_false Bit NULL,
    > > test19_bool_on_ off Bit NULL,
    > > test20_ole_obje kt Binary NULL,
    > > test21_hyperlin k Memo NULL
    > > );
    > >
    > > =============== =============== =============== =============
    > > =============== =============== =============== =============
    > >
    > > Ok, and I have just an other question. The above SQL-statement is
    > > created out of VB. I analyze the structure of existing tables and out
    > > of this information this SQL-string is created. But I didn't manage to
    > > get the Primary Key out of a table via VB. How can I get this?
    > >
    > > thx in advance.[/color][/color]

    Comment

    Working...