Thanks a lot. But I am still having issues with this table. It says there is a parse error. Any ideas???
CREATE TABLE tblpartnerdata (
IDPartnership int4 NOT NULL,
FieldPartnershipID int11 NOT NULL,
FieldLinkageActivitiesID int11 NOT NULL,
IDUS int11 NOT NULL,
IDSA int(11) NOT NULL,
USInstName varchar(50),
SAInstName varchar(50),
SourceP1 varchar(40),
SourceP2 varchar(40),
TitleP varchar(135),
Purpose text,
OtherUS1 varchar(50),
OtherUS2 varchar(50),
OtherUS3 varchar(50),
OtherUS4 varchar(50),
OtherSAUniv1 varchar(50),
OtherSAUniv2 varchar(50),
OtherSATech1 varchar(50),
OtherSATech2 varchar(60),
OtherSAInst5 varchar(100),
IntlPartner varchar(90),
SPlan int4 NOT NULL,
SAgree int4 NOT NULL,
SActs int4 NOT NULL,
SFunded int4 NOT NULL,
Begindate varchar(50),
EndDate varchar(50),
TravelSA int11,
TravelUS int11,
Outcomes text,
UsvtAgency1 varchar(60),
UsvtAmount1 decimal(10,2),
UsvtMatch1 decimal(10,2),
UsvtProgram1 varchar(60),
UsvtAgency2 varchar(60),
UsvtAmount2 decimal(10,2),
UsvtMatch2 decimal(10,2),
UsvtProgram2 varchar(60),
SAvtAgency1 varchar(60),
SAvtAmount1 decimal(10,2),
SAvtMatch1 decimal(10,2),
SAvtProgram1 varchar(60),
SavtAgency2 varchar(60) default NULL,
SAvtAmount2 decimal(10,2),
SavtMatch2 decimal(10,2),
SavtProgram2 varchar(60),
Foundation1Name varchar(65),
Foundation1 decimal(10,2),
FoundMatch decimal(10,2),
Foundation2Name varchar(65),
Foundation2 decimal(10,2),
WebsitePUS varchar(125),
WebsitePSA varchar(125),
WebsiteP varchar(125),
WebsiteUSAct1 varchar(125),
WebsiteUSAct2 varchar(125),
WebsiteSAIntl varchar(125),
WebsiteSALink1 varchar(125),
WebsiteSALink2 varchar(125),
WebCheck varchar(10),
MatchSAAmount decimal(10,2),
DocumentP text,
EntryDate date,
DateChange date,
Notes text,
FOther varchar(50),
AOther varchar(50),
PRIMARY KEY (IDPartnership)
);
