Fri, 30 May 2003 11:25:37 GMT

About General SQL error while using MSSQL 7 with BDE

Hi.
I use TQuery with "select * from Hist_endShiftRecord2000" to get data
successfully, but couldn't use SQL builder to create this sql
statement(display an error information).
And I want that the reason of the "General SQL error" is too wide table and
the diffrence of sql6.5/sql7.0.

cms
2000-12-11

Quote
cms <xqlmzlh...@sina.com.cn> wrote in message

news:90q0as$6h51@bornews.inprise.com...
Quote
> Dear Sir:
> I use MSSQL7 and BDE native driver in D5 for read a table, but if I active
> the TTable, the system display a error information "General SQL error" and
> display all of fileds name in the TDBGrid.
> And I use  SQL Explorer, when I open the Data sheet, this phenomenon is
> displayed too. Why ? And how can I do ?
> The table structure is:
> CREATE TABLE dbo.Hist_EndShiftRecord2000 (
>   fldRecordID char(51) DEFAULT '
> ',
>   fldLoginDate char(10) DEFAULT '          ',
>   fldLoginTime char(8) DEFAULT '        ',
>   fldLogoutDate char(10) DEFAULT '          ',
>   fldLogoutTime char(8) DEFAULT '        ',
>   fldStaAddress char(19) DEFAULT '                   ',
>   fldLaneDirect varchar(5) DEFAULT '     ',
>   fldOperatorID varchar(6) DEFAULT '          ',
>   fldGroupName smallint DEFAULT 6,
>   fldShiftNo smallint DEFAULT (-1),
>   fldNormalCards int DEFAULT 0,
>   fldBadCards int DEFAULT 0,
>   fldReceptNum int DEFAULT 0,
>   fldTotalNoneCardVehicles int DEFAULT 0,
>   fldTotalFeeVehicles int DEFAULT 0,
>   fldVehicleType01FeeVehicles int DEFAULT 0,
>   fldVehicleType02FeeVehicles int DEFAULT 0,
>   fldVehicleType03FeeVehicles int DEFAULT 0,
>   fldVehicleType04FeeVehicles int DEFAULT 0,
>   fldVehicleType05FeeVehicles int DEFAULT 0,
>   fldVehicleType06FeeVehicles int DEFAULT 0,
>   fldVehicleType07FeeVehicles int DEFAULT 0,
>   fldVehicleType08FeeVehicles int DEFAULT 0,
>   fldVehicleType09FeeVehicles int DEFAULT 0,
>   fldTotalOfficialVehicles int DEFAULT 0,
>   fldVehicleType01OfficialVehicles int DEFAULT 0,
>   fldVehicleType02OfficialVehicles int DEFAULT 0,
>   fldVehicleType03OfficialVehicles int DEFAULT 0,
>   fldVehicleType04OfficialVehicles int DEFAULT 0,
>   fldVehicleType05OfficialVehicles int DEFAULT 0,
>   fldVehicleType06OfficialVehicles int DEFAULT 0,
>   fldVehicleType07OfficialVehicles int DEFAULT 0,
>   fldVehicleType08OfficialVehicles int DEFAULT 0,
>   fldVehicleType09OfficialVehicles int DEFAULT 0,
>   fldTotalMilitarylVehicles int DEFAULT 0,
>   fldVehicleType01MilitaryVehicles int DEFAULT 0,
>   fldVehicleType02MilitaryVehicles int DEFAULT 0,
>   fldVehicleType03MilitaryVehicles int DEFAULT 0,
>   fldVehicleType04MilitaryVehicles int DEFAULT 0,
>   fldVehicleType05MilitaryVehicles int DEFAULT 0,
>   fldVehicleType06MilitaryVehicles int DEFAULT 0,
>   fldVehicleType07MilitaryVehicles int DEFAULT 0,
>   fldVehicleType08MilitaryVehicles int DEFAULT 0,
>   fldVehicleType09MilitaryVehicles int DEFAULT 0,
>   fldTotalEmergencyVehicles int DEFAULT 0,
>   fldVehicleType01EmergencyVehicles int DEFAULT 0,
>   fldVehicleType02EmergencyVehicles int DEFAULT 0,
>   fldVehicleType03EmergencyVehicles int DEFAULT 0,
>   fldVehicleType04EmergencyVehicles int DEFAULT 0,
>   fldVehicleType05EmergencyVehicles int DEFAULT 0,
>   fldVehicleType06EmergencyVehicles int DEFAULT 0,
>   fldVehicleType07EmergencyVehicles int DEFAULT 0,
>   fldVehicleType08EmergencyVehicles int DEFAULT 0,
>   fldVehicleType09EmergencyVehicles int DEFAULT 0,
>   fldTotalTrailerVehicles int DEFAULT 0,
>   fldVehicleType01TrailerVehicles int DEFAULT 0,
>   fldVehicleType02TrailerVehicles int DEFAULT 0,
>   fldVehicleType03TrailerVehicles int DEFAULT 0,
>   fldVehicleType04TrailerVehicles int DEFAULT 0,
>   fldVehicleType05TrailerVehicles int DEFAULT 0,
>   fldVehicleType06TrailerVehicles int DEFAULT 0,
>   fldVehicleType07TrailerVehicles int DEFAULT 0,
>   fldVehicleType08TrailerVehicles int DEFAULT 0,
>   fldVehicleType09TrailerVehicles int DEFAULT 0,
>   fldTotalMotorcadeVehicles int DEFAULT 0,
>   fldTotalViolationVehicles int DEFAULT 0,
>   fldFreeNum int DEFAULT 0,
>   fldTotalFreeFee int DEFAULT 0,
>   fldVehicleType01FreeFee int DEFAULT 0,
>   fldVehicleType02FreeFee int DEFAULT 0,
>   fldVehicleType03FreeFee int DEFAULT 0,
>   fldVehicleType04FreeFee int DEFAULT 0,
>   fldVehicleType05FreeFee int DEFAULT 0,
>   fldVehicleType06FreeFee int DEFAULT 0,
>   fldVehicleType07FreeFee int DEFAULT 0,
>   fldVehicleType08FreeFee int DEFAULT 0,
>   fldVehicleType09FreeFee int DEFAULT 0,
>   fldTotalCashFeeHanded int DEFAULT 0,
>   fldTotalCashNum int DEFAULT 0,
>   fldVehicleType01CashFeeHanded int DEFAULT 0,
>   fldVehicleType02CashFeeHanded int DEFAULT 0,
>   fldVehicleType03CashFeeHanded int DEFAULT 0,
>   fldVehicleType04CashFeeHanded int DEFAULT 0,
>   fldVehicleType05CashFeeHanded int DEFAULT 0,
>   fldVehicleType06CashFeeHanded int DEFAULT 0,
>   fldVehicleType07CashFeeHanded int DEFAULT 0,
>   fldVehicleType08CashFeeHanded int DEFAULT 0,
>   fldVehicleType09CashFeeHanded int DEFAULT 0,
>   fldTotalSVCFeeHanded int DEFAULT 0,
>   fldTotalSVCNum int DEFAULT 0,
>   fldVehicleType01SVCFeeHanded int DEFAULT 0,
>   fldVehicleType02SVCFeeHanded int DEFAULT 0,
>   fldVehicleType03SVCFeeHanded int DEFAULT 0,
>   fldVehicleType04SVCFeeHanded int DEFAULT 0,
>   fldVehicleType05SVCFeeHanded int DEFAULT 0,
>   fldVehicleType06SVCFeeHanded int DEFAULT 0,
>   fldVehicleType07SVCFeeHanded int DEFAULT 0,
>   fldVehicleType08SVCFeeHanded int DEFAULT 0,
>   fldVehicleType09SVCFeeHanded int DEFAULT 0,
>   fldTotalCreditFeeHanded int DEFAULT 0,
>   fldTotalCreditNum int DEFAULT 0,
>   fldVehicleType01CreditFeeHanded int DEFAULT 0,
>   fldVehicleType02CreditFeeHanded int DEFAULT 0,
>   fldVehicleType03CreditFeeHanded int DEFAULT 0,
>   fldVehicleType04CreditFeeHanded int DEFAULT 0,
>   fldVehicleType05CreditFeeHanded int DEFAULT 0,
>   fldVehicleType06CreditFeeHanded int DEFAULT 0,
>   fldVehicleType07CreditFeeHanded int DEFAULT 0,
>   fldVehicleType08CreditFeeHanded int DEFAULT 0,
>   fldVehicleType09CreditFeeHanded int DEFAULT 0,
>   fldTotalLoan int DEFAULT 0,
>   fldTotalLoanCashHanded int DEFAULT 0,
>   fldTotalLoanSVCHanded int DEFAULT 0,
>   fldTotalLoanCreditHanded int DEFAULT 0,
>   fldTotalLoanNum int DEFAULT 0,
>   fldTotalForefeit int DEFAULT 0,
>   fldTotalForefeitCashHanded int DEFAULT 0,
>   fldTotalForefeitSVCHanded int DEFAULT 0,
>   fldTotalForefeitCreditHanded int DEFAULT 0,
>   fldTotalForefeitNum int DEFAULT 0,
>   fldTotalArrearage int DEFAULT 0,
>   fldTotalArrearageNum int DEFAULT 0,
>   fldSent smallint DEFAULT 0
> )

> Very thanks
> cms
> 2000-12-8