>>>Create table CATMaster (CATID int identity(1,1), Category char(2), diff char(1), ALC varchar(5), Keyword varchar(25),
>>> Keyword2 Varchar(25), keyopt char(1), script varchar(500), stem varchar(500), respa varchar(115),
>>> respb varchar(115),respc varchar(115), respd varchar(115), scripttime varchar(2), testtype char(1),
>>> EntBy Char(3), EntDate date, RevBy char(3), RevDate date, Completed char(1))
>>>
>>
>>All seems OK except the ScriptTime can also be char(2). BTW, how is time is char(2)?
>>
>>Diff may be a bit problematic field's name.
>>
>>Also, I just tried it and I didn't get any errors.
>>
>>What is the compatibility level of your database and result
>>
>>of SELECT @@VERSION?
>Ok, I may have bigger issues
>
>Major Error 0x80040E14, Minor Error 25623
>> Select @@Version
>The global variable name is not valid. [ Global variable Name = @@Version ]
>
>According to the window, it's SQL Server Compact Edition.
I see, SQL Server Compact has many limitations and may need a special syntax. Let me see if I can access Compact version and try it now.
If it's not broken, fix it until it is.
My Blog