G
Guest
I need help.. I have a table with data, the column that I want to alter is
completely empty and originally set to text(255)
COL1 COL2 COL3
10 YELLOW
11 RED
12 BLUE
when I try the following SQL command in VB:
DoCmd.RunSQL "ALTER TABLE UNDEF_FLAT ALTER COLUMN COL2 INTEGER;"
Automagically, a modal pop-up Message Box with the window title being the
name of the database, the Qustion (?) Icon, NO MESSAGE what-so-ever, and the
only two buttons that show up are "OK" and "CANCEL". The column IS altered
correctly to an INTEGER
while debuging.. if I hit OK... code continues normally and the table is
altered correctly to a LONG INTEGER/Number data type..
My problem is that the empty message box pops-up.. how can I avoid the
pop-up message box? what does it mean?? I'm lost.. again I ask assistance to
the experts and gurus and thak you all in advance..
completely empty and originally set to text(255)
COL1 COL2 COL3
10 YELLOW
11 RED
12 BLUE
when I try the following SQL command in VB:
DoCmd.RunSQL "ALTER TABLE UNDEF_FLAT ALTER COLUMN COL2 INTEGER;"
Automagically, a modal pop-up Message Box with the window title being the
name of the database, the Qustion (?) Icon, NO MESSAGE what-so-ever, and the
only two buttons that show up are "OK" and "CANCEL". The column IS altered
correctly to an INTEGER
while debuging.. if I hit OK... code continues normally and the table is
altered correctly to a LONG INTEGER/Number data type..
My problem is that the empty message box pops-up.. how can I avoid the
pop-up message box? what does it mean?? I'm lost.. again I ask assistance to
the experts and gurus and thak you all in advance..