When I try to open the linked table I get the following message recorded in the Event Log and it happens no matter what I try to do with the table:
ControlPanel.OnActivate : Cancel selected()
addin.variables().a5_error_show(Error loading c:\documents and settings\administrator\my documents\linkeddata\code.dbf: Error executing SQL SELECT statement opening link table code.
Statement is: SELECT
StockCode,
AltCode,
Mfr,
Model,
Descr,
Category,
SubCat,
Location,
Cost,
LastCost,
List,
Price,
Discount1,
Discount2,
Discount3,
Discount4,
Discount5,
Taxable,
GST,
OnHand,
Minimum,
TargetQty,
Serialized,
Container,
NoDeplete,
Shipping,
Weight,
OnOrder,
Allocated,
OnRMA,
InPreBuilt,
Unit,
OrderUnit,
UnitsToOrd,
NonStock,
Discontinued,
Notes,
AutoRound,
AutoPrice,
ListMthd,
ListPct,
SaleMthd,
SalePct,
Disc1Mthd,
Disc2Mthd,
Disc3Mthd,
Disc4Mthd,
Disc5Mthd,
Disc1Desc,
Disc2Desc,
Disc3Desc,
Disc4Desc,
Disc5Desc,
Disc1Pct,
Disc2Pct,
Disc3Pct,
Disc4Pct,
Disc5Pct,
QtyPricing,
Disc1Qty,
Disc2Qty,
Disc3Qty,
Disc4Qty,
Disc5Qty,
PrefVendor,
UPSInd,
PriceCat,
HasImage,
HasRelated,
PostToWeb,
LastModDt,
LastMo) : Internal error (exception caught) in function _rpc_resolve in C:\Dev\a5v9\src\engine\GENERIC\AU_PARSE.cpp on line 187Please contact Alpha Software with a reproducible case of this error.
addin.variables().a5_error_show(Error loading c:\documents and settings\administrator\my documents\linkeddata\code.dbf: Error executing SQL SELECT statement opening link table code.
Statement is: SELECT
StockCode,
AltCode,
Mfr,
Model,
Descr,
Category,
SubCat,
Location,
Cost,
LastCost,
List,
Price,
Discount1,
Discount2,
Discount3,
Discount4,
Discount5,
Taxable,
GST,
OnHand,
Minimum,
TargetQty,
Serialized,
Container,
NoDeplete,
Shipping,
Weight,
OnOrder,
Allocated,
OnRMA,
InPreBuilt,
Unit,
OrderUnit,
UnitsToOrd,
NonStock,
Discontinued,
Notes,
AutoRound,
AutoPrice,
ListMthd,
ListPct,
SaleMthd,
SalePct,
Disc1Mthd,
Disc2Mthd,
Disc3Mthd,
Disc4Mthd,
Disc5Mthd,
Disc1Desc,
Disc2Desc,
Disc3Desc,
Disc4Desc,
Disc5Desc,
Disc1Pct,
Disc2Pct,
Disc3Pct,
Disc4Pct,
Disc5Pct,
QtyPricing,
Disc1Qty,
Disc2Qty,
Disc3Qty,
Disc4Qty,
Disc5Qty,
PrefVendor,
UPSInd,
PriceCat,
HasImage,
HasRelated,
PostToWeb,
LastModDt,
LastMo) : Internal error (exception caught) in function _rpc_resolve in C:\Dev\a5v9\src\engine\GENERIC\AU_PARSE.cpp on line 187Please contact Alpha Software with a reproducible case of this error.
ControlPanel.DeActivate : Cancel selected()
Browse.Activate : Cancel selected()
Browse.DeActivate : Cancel selected()
ControlPanel.OnActivate : Cancel selected()
ControlPanel.DeActivate : Cancel selected()
Browse.Activate : Cancel selected()
Browse.DeActivate : Cancel selected()
ControlPanel.OnActivate : Cancel selected()
ControlPanel.DeActivate : Cancel selected()
Browse.Activate : Cancel selected()
Browse.DeActivate : Cancel selected()
ControlPanel.OnActivate : Cancel selected()
ControlPanel.DeActivate : Cancel selected()
Browse.Activate : Cancel selected()
Browse.DeActivate : Cancel selected()
ControlPanel.OnActivate : Cancel selected()
addin.variables().a5_error_show(Error loading c:\documents and settings\administrator\my documents\linkeddata\codesale.dbf: Error executing SQL SELECT statement opening link table codesale.
Statement is: SELECT
RecID,
StockCode,
BegDate,
EndDate,
List,
Price,
Discount1,
Discount2,
Discount3,
Discount4,
Discount5,
Promo,
NoDiscounts FROM codesale
Database API specific error
Your database has returned the following error code and description to Alpha Five.
Consult your database documentation for further information.
700 - '[Elevate Software][ElevateDB] ElevateDB Error #700 An error was found in the statement at line 1 and column 48 (Expected ( but instead found ,)
SQL State is: 42000') : Property not found
*INTERMEDIATE_0000003d.a5_error_show method not found.
ControlPanel.DeActivate : Cancel selected()
ControlPanel.OnActivate : Cancel selected()
addin.variables().a5_error_show(Error loading c:\documents and settings\administrator\my documents\linkeddata\code.dbf: Error executing SQL SELECT statement opening link table code.
Statement is: SELECT
StockCode,
AltCode,
Mfr,
Model,
Descr,
Category,
SubCat,
Location,
Cost,
LastCost,
List,
Price,
Discount1,
Discount2,
Discount3,
Discount4,
Discount5,
Taxable,
GST,
OnHand,
Minimum,
TargetQty,
Serialized,
Container,
NoDeplete,
Shipping,
Weight,
OnOrder,
Allocated,
OnRMA,
InPreBuilt,
Unit,
OrderUnit,
UnitsToOrd,
NonStock,
Discontinued,
Notes,
AutoRound,
AutoPrice,
ListMthd,
ListPct,
SaleMthd,
SalePct,
Disc1Mthd,
Disc2Mthd,
Disc3Mthd,
Disc4Mthd,
Disc5Mthd,
Disc1Desc,
Disc2Desc,
Disc3Desc,
Disc4Desc,
Disc5Desc,
Disc1Pct,
Disc2Pct,
Disc3Pct,
Disc4Pct,
Disc5Pct,
QtyPricing,
Disc1Qty,
Disc2Qty,
Disc3Qty,
Disc4Qty,
Disc5Qty,
PrefVendor,
UPSInd,
PriceCat,
HasImage,
HasRelated,
PostToWeb,
LastModDt,
LastMo) : Internal error (exception caught) in function _rpc_resolve in C:\Dev\a5v9\src\engine\GENERIC\AU_PARSE.cpp on line 187Please contact Alpha Software with a reproducible case of this error.
ControlPanel.DeActivate : Cancel selected()
ControlPanel.OnActivate : Cancel selected()
addin.variables().a5_error_show(Error loading c:\documents and settings\administrator\my documents\linkeddata\code.dbf: Error executing SQL SELECT statement opening link table code.
Statement is: SELECT
StockCode,
AltCode,
Mfr,
Model,
Descr,
Category,
SubCat,
Location,
Cost,
LastCost,
List,
Price,
Discount1,
Discount2,
Discount3,
Discount4,
Discount5,
Taxable,
GST,
OnHand,
Minimum,
TargetQty,
Serialized,
Container,
NoDeplete,
Shipping,
Weight,
OnOrder,
Allocated,
OnRMA,
InPreBuilt,
Unit,
OrderUnit,
UnitsToOrd,
NonStock,
Discontinued,
Notes,
AutoRound,
AutoPrice,
ListMthd,
ListPct,
SaleMthd,
SalePct,
Disc1Mthd,
Disc2Mthd,
Disc3Mthd,
Disc4Mthd,
Disc5Mthd,
Disc1Desc,
Disc2Desc,
Disc3Desc,
Disc4Desc,
Disc5Desc,
Disc1Pct,
Disc2Pct,
Disc3Pct,
Disc4Pct,
Disc5Pct,
QtyPricing,
Disc1Qty,
Disc2Qty,
Disc3Qty,
Disc4Qty,
Disc5Qty,
PrefVendor,
UPSInd,
PriceCat,
HasImage,
HasRelated,
PostToWeb,
LastModDt,
LastMo) : Internal error (exception caught) in function _rpc_resolve in C:\Dev\a5v9\src\engine\GENERIC\AU_PARSE.cpp on line 187Please contact Alpha Software with a reproducible case of this error.
addin.variables().a5_error_show(Error loading c:\documents and settings\administrator\my documents\linkeddata\code.dbf: Error executing SQL SELECT statement opening link table code.
Statement is: SELECT
StockCode,
AltCode,
Mfr,
Model,
Descr,
Category,
SubCat,
Location,
Cost,
LastCost,
List,
Price,
Discount1,
Discount2,
Discount3,
Discount4,
Discount5,
Taxable,
GST,
OnHand,
Minimum,
TargetQty,
Serialized,
Container,
NoDeplete,
Shipping,
Weight,
OnOrder,
Allocated,
OnRMA,
InPreBuilt,
Unit,
OrderUnit,
UnitsToOrd,
NonStock,
Discontinued,
Notes,
AutoRound,
AutoPrice,
ListMthd,
ListPct,
SaleMthd,
SalePct,
Disc1Mthd,
Disc2Mthd,
Disc3Mthd,
Disc4Mthd,
Disc5Mthd,
Disc1Desc,
Disc2Desc,
Disc3Desc,
Disc4Desc,
Disc5Desc,
Disc1Pct,
Disc2Pct,
Disc3Pct,
Disc4Pct,
Disc5Pct,
QtyPricing,
Disc1Qty,
Disc2Qty,
Disc3Qty,
Disc4Qty,
Disc5Qty,
PrefVendor,
UPSInd,
PriceCat,
HasImage,
HasRelated,
PostToWeb,
LastModDt,
LastMo) : Internal error (exception caught) in function _rpc_resolve in C:\Dev\a5v9\src\engine\GENERIC\AU_PARSE.cpp on line 187Please contact Alpha Software with a reproducible case of this error.
ControlPanel.DeActivate : Cancel selected()
Browse.Activate : Cancel selected()
Browse.DeActivate : Cancel selected()
ControlPanel.OnActivate : Cancel selected()
ControlPanel.DeActivate : Cancel selected()
Browse.Activate : Cancel selected()
Browse.DeActivate : Cancel selected()
ControlPanel.OnActivate : Cancel selected()
ControlPanel.DeActivate : Cancel selected()
Browse.Activate : Cancel selected()
Browse.DeActivate : Cancel selected()
ControlPanel.OnActivate : Cancel selected()
ControlPanel.DeActivate : Cancel selected()
Browse.Activate : Cancel selected()
Browse.DeActivate : Cancel selected()
ControlPanel.OnActivate : Cancel selected()
addin.variables().a5_error_show(Error loading c:\documents and settings\administrator\my documents\linkeddata\codesale.dbf: Error executing SQL SELECT statement opening link table codesale.
Statement is: SELECT
RecID,
StockCode,
BegDate,
EndDate,
List,
Price,
Discount1,
Discount2,
Discount3,
Discount4,
Discount5,
Promo,
NoDiscounts FROM codesale
Database API specific error
Your database has returned the following error code and description to Alpha Five.
Consult your database documentation for further information.
700 - '[Elevate Software][ElevateDB] ElevateDB Error #700 An error was found in the statement at line 1 and column 48 (Expected ( but instead found ,)
SQL State is: 42000') : Property not found
*INTERMEDIATE_0000003d.a5_error_show method not found.
ControlPanel.DeActivate : Cancel selected()
ControlPanel.OnActivate : Cancel selected()
addin.variables().a5_error_show(Error loading c:\documents and settings\administrator\my documents\linkeddata\code.dbf: Error executing SQL SELECT statement opening link table code.
Statement is: SELECT
StockCode,
AltCode,
Mfr,
Model,
Descr,
Category,
SubCat,
Location,
Cost,
LastCost,
List,
Price,
Discount1,
Discount2,
Discount3,
Discount4,
Discount5,
Taxable,
GST,
OnHand,
Minimum,
TargetQty,
Serialized,
Container,
NoDeplete,
Shipping,
Weight,
OnOrder,
Allocated,
OnRMA,
InPreBuilt,
Unit,
OrderUnit,
UnitsToOrd,
NonStock,
Discontinued,
Notes,
AutoRound,
AutoPrice,
ListMthd,
ListPct,
SaleMthd,
SalePct,
Disc1Mthd,
Disc2Mthd,
Disc3Mthd,
Disc4Mthd,
Disc5Mthd,
Disc1Desc,
Disc2Desc,
Disc3Desc,
Disc4Desc,
Disc5Desc,
Disc1Pct,
Disc2Pct,
Disc3Pct,
Disc4Pct,
Disc5Pct,
QtyPricing,
Disc1Qty,
Disc2Qty,
Disc3Qty,
Disc4Qty,
Disc5Qty,
PrefVendor,
UPSInd,
PriceCat,
HasImage,
HasRelated,
PostToWeb,
LastModDt,
LastMo) : Internal error (exception caught) in function _rpc_resolve in C:\Dev\a5v9\src\engine\GENERIC\AU_PARSE.cpp on line 187Please contact Alpha Software with a reproducible case of this error.
ControlPanel.DeActivate : Cancel selected()
Comment