alter command in sql

[bharadwaja]

hi,

could you please tell me is there any command in cvi like

ALTER TABLE table_name{ADD|DROP|MODIFY} column_name {data_ype};

i am getting error like undeclared identifier ALTER.

Thanks & Regards

[SteveD123]

Look at the SQL toolkit help. You can assemble your command in a string and use the appropriate SQL toolkit function, e.g.

sprintf(sqlstatement,"SELECT * FROM `TESTDATA`.`RESULTS` WHERE ID = '%s' ORDER BY ReadingNo;", UID);
local_report_handle = DBActivateSQL (hdbc,sqlstatement );

Also Search this forum for SQL topics. e.g.http://forums.ni.com/t5/LabWindows-CVI/CVI-database/m-p/2285016#M60668