- Nov 7, 2007
- 3,809
- 115
- 300
Right Click CHERODB > All Tasks > Import Data
Click Next.
From drop down list, select Microsoft Access
Browse to CT.mdb
Click Next
Make sure CHERODB is selected.
Select Copy Tables
Click Select All.
You have to click the browse button all tables and do the following settings.
Create destination Table
Drop and re create destination table
Make sure you do this for all tables.
Then keep clicking next until it saves.
Once done, right click Tables and Refresh.
ID Fix:
Right Click Stditems.dbo > Design Table
Untick Allow Nulls for IDx and Name.
Right Click IDx and Set Primary Key
Save.
Human_Info_Add Fix:
Go to CHERODB > Stored Procedures.
Locate Human_Info_Add and double click to open it.
Select everything inside and replace with this.
Click Next.
From drop down list, select Microsoft Access
Browse to CT.mdb
Click Next
Make sure CHERODB is selected.
Select Copy Tables
Click Select All.
You have to click the browse button all tables and do the following settings.
Create destination Table
Drop and re create destination table
Make sure you do this for all tables.
Then keep clicking next until it saves.
Once done, right click Tables and Refresh.
ID Fix:
Right Click Stditems.dbo > Design Table
Untick Allow Nulls for IDx and Name.
Right Click IDx and Set Primary Key
Save.
Human_Info_Add Fix:
Go to CHERODB > Stored Procedures.
Locate Human_Info_Add and double click to open it.
Select everything inside and replace with this.
Code:
CREATE PROCEDURE HUM_INFO_ADD
@ACCOUNT varchar(15) ,
@NAME varchar(15) ,
@Hair tinyint ,
@Sex tinyint ,
@Job tinyint ,
@YSMaster varchar(15)
AS
DECLARE @BinaryData binary(1647)
IF EXISTS(SELECT ACCOUNT FROM D_HUM_INFO WHERE NAME=@NAME)
RETURN(2)
ELSE
BEGIN
if @YSMaster='' and (SELECT Count(*) FROM D_HUM_INFO WHERE (ACCOUNT=@ACCOUNT)and (YSMaster='') and(boDelete=0) )>=3
RETURN(3)
INSERT INTO D_HUM_INFO
(ACCOUNT,
NAME,
YsMaster,
Hair ,
Sex ,
Job ,
BinaryData,
boDelete,
boSelect,
UpDateTime
)
VALUES (
@ACCOUNT,
@NAME,
@YsMaster,
@Hair ,
@Sex ,
@Job,
@BinaryData,
0,
0,
GetDate()
)
RETURN(1)
END
GO