I am trying to merge 2 database table into a new database. In merging the
two databases I have run into an issue. When I insert data into the new
table from the old table that has a field that is blank I get the following
error. See Below for code, error and table Description. Can you help
Table Description
Table_Of_SearchConditions
SC_lintPID Number
SC_etSearchType, Number
SC_stSearchCondition Text
SC_lintSearchCondition Number "Can be blank"
Code Sample
$stmt = "INSERT INTO Table_Of_SearchConditions (SC_lintPID,
SC_etSearchType, SC_stSearchCondition, SC_lintSearchCondition ) VALUES
('$newAddPID', '$SearchType', '$SearchCond', '$SearchCondCh')";
$rc = $db->Sql($stmt);
die qq(SQL failed "$stmt": ), $db->Error(), qq(\n) if $rc;
Error Message.
Missing SearchCondCh value
New Search Value is
Printing Record for Search Conditions 950 and 2 and 'MAINTENANCE TRAINING
REQUI
REMENTS REVIEW' IS FOUND OR 'MTRR' IS FOUND and
SQL failed "INSERT INTO Table_Of_SearchConditions (SC_lintPID,
SC_etSearchType,
SC_stSearchCondition, SC_lintSearchCondition ) VALUES ('9000', '2',
''MAINTENANC
E TRAINING REQUIREMENTS REVIEW' IS FOUND OR 'MTRR' IS FOUND', '')":
-3100[Micros
oft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query
expr
ession '''MAINTENANCE TRAINING REQUIREMENTS REVIEW' IS FOUND OR 'MTRR' IS
FOUND'
'.10
_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
