By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,208 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

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

P: n/a
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_long", 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ährung Currency NULL,
test11_währ_euro Currency NULL,
test12_memo Memo NULL,
test13_dat_standard Date NULL,
test14_dat_zeit Date NULL,
test15_dat_dat Date NULL,
test16_auto_long Long NULL,
test17_bool_j_n Bit NULL,
test18_bool_true_false Bit NULL,
test19_bool_on_off Bit NULL,
test20_ole_objekt Binary NULL,
test21_hyperlink 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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Thank you.
But I've got another question like this.

test21_hyperlink Memo NULL <-- should be a hyperlink (datatype?)
test7_dezimal Double NULL <-- should be a decimal (datatype?)
"Terry Kreft" <te*********@mps.co.uk> wrote in message news:<bj**********@newsreaderm1.core.theplanet.net >...
...
test16_auto_long COUNTER NULL,
...
test20_ole_objekt LONGBINARY NULL,
...

Terry

"KePaS" <ke***@o2online.de> wrote in message
news:e8**************************@posting.google.c om...
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_long", 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ährung Currency NULL,
test11_währ_euro Currency NULL,
test12_memo Memo NULL,
test13_dat_standard Date NULL,
test14_dat_zeit Date NULL,
test15_dat_dat Date NULL,
test16_auto_long Long NULL,
test17_bool_j_n Bit NULL,
test18_bool_true_false Bit NULL,
test19_bool_on_off Bit NULL,
test20_ole_objekt Binary NULL,
test21_hyperlink 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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.