Advertisement

05.22.2006 at 02:16PM PDT, ID: 21859804
[x]
Attachment Details

DDL Queries - What are these binary data types

Asked by Rick_Rickards in Microsoft Access Database

Tags: ddl, queries

I've been trying to hazard a guess at the correct syntax for a DDL query that will create a OLE Object field.  While I did discover how to this I stumbled across this data type named "Binary" by accident.  It appears that the Binary Data type cannot be created via the GUI but can via DDL queries and DAO.  Syntax for these DDL queries are provided below.

Question:  What is the significance of the various types of Binary fields that these queries create, (ie: why would I want one, when and where might I prefer one of these data types over any other).

CurrentDb.Execute "ALTER TABLE tblCustomer ADD COLUMN MyBinary BINARY"                    'Binary (Defaults to Length of 255)
CurrentDb.Execute "ALTER TABLE tblCustomer ADD COLUMN MyBinary1 BINARY(1)"              'Binary (Length of 1)
CurrentDb.Execute "ALTER TABLE tblCustomer ADD COLUMN MyBinary15 BINARY(15)"           'Binary (Length of 15)
CurrentDb.Execute "ALTER TABLE tblCustomer ADD COLUMN MyVarBinary VARBINARY"         'Binary (Defaults to length of 255 characters - is this different than the first query listed above)
Start Free Trial
 
Keywords: DDL Queries - What are these binary …
Title
1 RTHDCPL.EXE  error
2 How can i print the DDL for "create ta…
3 Adding text field with DDL
4 DDL
5 Junction table - PK - unique index
6 ddl bind
 
Loading Advertisement...
 
[+][-]05.22.2006 at 02:40PM PDT, ID: 16738118

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2006 at 03:01PM PDT, ID: 16738278

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.22.2006 at 03:27PM PDT, ID: 16738436

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.21.2006 at 02:06AM PDT, ID: 16949595

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.22.2006 at 09:30PM PDT, ID: 16966172

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]06.22.2006 at 09:44PM PDT, ID: 16966240

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.27.2006 at 10:13PM PDT, ID: 16998653

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Access Database
Tags: ddl, queries
Sign Up Now!
Solution Provided By: RomMod
Participating Experts: 2
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32