HiIf I run - Describe TableName - in Interactive SQL it returns the column name, type, nullable and Primary Key - but when running the same from a .NET app it throws the above error. The full text of the error is below. Any ideas?ThanksSap.Data.SQLAn...
This query...BEGIN
DECLARE DocumentDate Date;
DECLARE AssessmentsNormal INTEGER;
SET DocumentDate = '2025-01-01';
SET AssessmentsNormal = (SELECT Dues_Nominal FROM Annual);
SELECT IsNull(Position, 0) AS 'Position',
IsNull(Nom_Code, 0) as 'NomCode',...
If I use this statementSELECT SUM(Debit) - SUM(Credit) FROM A_Purchase_Ledger WHERE Supplier_ID = 16It returns 0 as the sum of debit is 250 and the sum of credit is 250. However, in this...SELECT A_Purchase_Ledger.Supplier_ID AS 'SupplierID',
A_Purc...
As an update - SELECT c.column_name AS 'Name', c.base_type_str AS 'Type', c.nulls AS 'Nulls', c.`default` AS 'Default' FROM systabcol c KEY JOIN systab t ON t.table_name = 'MyTable' does the same thing. Any idea, though, how to determine if as defaul...
Sometimes after you have stared at something for hours nothing pops up until you ask for help(SELECT SUM(A_Purchase_Ledger.Credit)- SUM(A_Purchase_Ledger.Debit)FROM A_Purchase_Ledger WHERE A_Purchase_Ledger.Supplier_ID = SupplierID) as 'TotalBalance'...