Which unit is needed to use ALTER TABLE?

[marieannie]

Hello everybody!
Does anyone know which unit I have to add to my project
in order to use the ALTER TABLE command??

Thanks for the information

 

[buho]

If I'm getting your meaning right, ALTER TABLE is an SQL command, and not related to any Delphi specific unit.

It is all about the db engine being able to handle it and the encapsulating objects being able to send it to the engine.

What engine are you using? What behavior are you having now? Any error message?

buho (A).

 

[marieannie]

I saw code example in which is no necessary the use of an object.. and I wondered if I can do it that way...
I guess it isn't posible. Thank you! I have a pretty good idea how to use the objects for SQL.

 

[whosrdaddy]

offcourse this is possible! (everything is possible in Delphi )

you can create a TADOCommand object in code and use the CommandText property to issue the ALTER TABLE command
Read the help file for more details. I don't have time to create a small code sample (maybe later) at the moment.

Cheers,
Dadddy

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[buho]

Without using any object (ie: pure objectless PASCAL)? May be diving into the deeps of the VCL, to see how it connects with the underlaying engine. A (probably very) difficult task, not worth the work IMO.

On the other hand, if your meanining is "not dropping a component in a form/module", see Daddy above.

buho (A).