public override void WriteColumnFlags(DBColumnFlags flags, DBClause defaultValue)
        {
            if ((flags & DBColumnFlags.PrimaryKey) > 0)
            {
                this.WriteRawSQLString(" PRIMARY KEY");
            }

            if ((flags & DBColumnFlags.AutoAssign) > 0)
            {
                this.WriteRawSQLString(" AUTOINCREMENT");
            }

            this.WriteSpace();
            if ((flags & DBColumnFlags.Nullable) > 0)
            {
                this.WriteNull();
            }
            else
            {
                this.WriteNotNull();
            }


            if ((flags & DBColumnFlags.HasDefault) > 0)
            {
                this.WriteRawSQLString(" DEFAULT ");
                defaultValue.BuildStatement(this);
            }
        }
Example #2
0
 public override void WriteAssignValue(DBClause receiver, DBClause value)
 {
     if (_isInSelectList)
     {
         if (_hastop)
         {
             if (null == _assignReceivers)
             {
                 _assignReceivers = new List <DBClause>();
             }
             if (null == _assignValues)
             {
                 _assignValues = new List <DBClause>();
             }
             _assignReceivers.Add(receiver);
             _assignValues.Add(value);
             value.BuildStatement(this);
             this.WriteAlias(SELECTTOPFIELDSTEM + _assignValues.Count.ToString());
         }
         else
         {
             value.BuildStatement(this);
             this.WriteIntoOperator();
             receiver.BuildStatement(this);
         }
     }
     else
     {
         base.WriteAssignValue(receiver, value);
     }
 }
        public override void WriteColumnFlags(DBColumnFlags flags, DBClause defaultValue)
        {
            if ((flags & DBColumnFlags.HasDefault) > 0)
            {
                throw new NotSupportedException(Errors.OLEDbDoesNotSupportDefaultValues);
            }

            if ((flags & DBColumnFlags.PrimaryKey) > 0)
            {
                this.WriteRawSQLString(" PRIMARY KEY");
            }

            if ((flags & DBColumnFlags.Nullable) > 0)
            {
                this.WriteRawSQLString(" NULL");
            }
            else
            {
                this.WriteRawSQLString(" NOT NULL");
            }
        }