Page 1 of 1
alter table
Posted: Thu 03 Feb 2011 17:08
by m_alvanchi
hi
alter table test add name text(10) default null
when i used alter table in uniquery dispaly error.
how i used alter table with default value .
when i used alter table with out default value this code is true.
please help me
tanks
Posted: Fri 04 Feb 2011 08:01
by AlexP
Hello,
Please specify the following information so that I am able to help you:
- the exact version of UniDAC;
- the name and the version of your IDE;
- the name of your database;
- the script to create and alter the table.
alter table
Posted: Sat 05 Feb 2011 05:38
by m_alvanchi
hi
The version of UniDAC is :3.50.0.14 for RAD studio 2010
the name and the version of your IDE is :Embarcadero® RAD Studio 2010 Version 14.0.3615.26342 (Delphi 2010)
The name of my database is :sql server2010 and Microsoft Access
The script of alter table is:
UniQuery1.SQL.Text:='ALTER TABLE DP_Tab '+
' ADD nCas_num int default 0';
UniQuery1.Execute;
Posted: Mon 07 Feb 2011 11:10
by AndreyZ
You can use this code when you are working with SQL Server. To make this code work with MS Access, you should enable support for extended SQL for MS Access by setting the UniConnection.SpecificOptions.ExtendedAnsiSQL option to 1.