I'm running SQLBase 7.5 and attempting to create a table from SQLTalk. When I do so, it tells me "Error: Time out (transaction rolled back)". Where should I be looking to isolate/correct the problem?
The following is the command that I would really like to execute (though I've tried several variations including the simplest CREATE TABLE possible):
CREATE TABLE RESOURCE_AVAIL
( RESOURCE_ID VARCHAR (25) NOT NULL
,SCHED_DATE DATE NOT NULL
,HRS_REM_SHIFT_1 DECIMAL(10,4)
,HRS_REM_SHIFT_2 DECIMAL(10,4)
,HRS_REM_SHIFT_3 DECIMAL(10,4)
)
IN DATABASE VMFGTEST;
Thanks in advance for your help!
Andy
The following is the command that I would really like to execute (though I've tried several variations including the simplest CREATE TABLE possible):
CREATE TABLE RESOURCE_AVAIL
( RESOURCE_ID VARCHAR (25) NOT NULL
,SCHED_DATE DATE NOT NULL
,HRS_REM_SHIFT_1 DECIMAL(10,4)
,HRS_REM_SHIFT_2 DECIMAL(10,4)
,HRS_REM_SHIFT_3 DECIMAL(10,4)
)
IN DATABASE VMFGTEST;
Thanks in advance for your help!
Andy