Description:
Created an application in VB6 which truncates a 360,000 row table and reloads it using a stored procedure. While the code is running I'm developing other stored procedures in NaviCat 5.1.1. and ocassionally checking on the running process by selecting all records from the table.
During the Other Stored Procedure Creations or the selecting all records from the table being loaded, the running procedure will start inserting all Null fields, every field in every record will be null. Connection to the database is still there and no errors returned from the database.
If I let it run it will enter thousands of Null filled records.
I using a DSNLess connection and MySQL ODBC 2.50.39
Here is the stored procedure:
CREATE PROCEDURE CCHInsertDetail (IN strGeocode char(10), IN strInOutCity char(1), IN strInOutLocal char(1),
IN decTaxRate decimal(8,2), IN strLocation char(8), IN strTaxBase char(5), IN decMaxTax decimal(8,2), IN decExcessRate decimal(8,2),
IN strEffDate char(8), IN strTaxAuth char(1), IN strTaxType char(2), IN strTaxCat char(2), IN strDescr char(30), IN decUseTaxRate decimal(8,2),
IN decUExcesRate decimal(8,2), IN decFee decimal(10, 2), IN strUnitType char(2), IN decMaxUnits decimal(8,2), IN strMaxType char(2),
IN strPassFlag char(1), IN strPassType char(2), IN strBaseType char(2), IN decUnitBase decimal(15,2), IN decExcessFee decimal(10,2),
IN strThreshType char(1), IN strUnitAOTtax char(1))
LANGUAGE SQL SQL SECURITY DEFINER COMMENT 'Inserts CCH Detail.txt Data Into dpcDetail Table'
INSERT INTO dpcdetail (geocode, inoutcity, inoutlocal, taxrate, location, taxbase, maxtax, excessrate, effdate, taxauth,
taxtype, taxcat, descr, usetaxrate, uexcesrate, fee, unittype, maxunits, maxtype, passflag,
passtype, basetype, unitbase, excessfee, threshtype, unitaotax)
VALUES
(strGeocode, strInOutCity, strInOutLocal,
decTaxRate, strLocation, strTaxBase, decMaxTax, decExcessRate,
strEffDate, strTaxAuth, strTaxType, strTaxCat, strDescr, decUseTaxRate,
decUExcesRate, decFee, strUnitType, decMaxUnits, strMaxType,
strPassFlag, strPassType, strBaseType, decUnitBase, decExcessFee,
strThreshType, strUnitAOTtax)
Mike
How to repeat:
Start inserting data using the stored procedure and then perform other actions in the database.
Suggested fix:
Don't Know
