Invalid Row Count
Mar 19, 2004
Hi,
I am building a shopping cart program, complete with an admin back end.
I am using ASP.NET, VB. NET and a SQL SERVER 2000 database.
The cart is working well... items can be added, updated and removed. However when trying to access the orders stored in the database from the admin section of the application, I am getting an "invalid record count" error.
I have no idea what this means. I've tried looking it up online, but so far no luck.
The orders are being stored in two tables connected via a foreign key.
I have no problem writing to the tables, it's just a problem reading the tables. I have dropped the two tables twice and rebuilt them, but I get the same error each time.
Any thoughts on what is causing this error?
Thanks,
-Michael
View 2 Replies
ADVERTISEMENT
Apr 21, 2008
Hello,
I've got the following query:
SELECT zA."ID" AS fA_A
, zA."TEXT" AS fA_B
, (
SELECT COUNT(zC."ID")
FROM Test."Booking" AS zC
) AS fA_E
FROM Test."Stack" AS zA
WHERE zA."ID" = ?
With this query I call:
- SQLPrepare -> SQL_SUCCESS=0
- SQLNumParams -> SQL_SUCCESS=0, pcpar = 1
- SQLDescribeParam( 1 ) -> SQL_ERROR=-1, [Microsoft][ODBC SQL Server Driver]Invalid parameter number", "[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index"
Is there a problem with this calling sequence or this query? Or is this a problem of SQL Server?
Regards
Markus
View 7 Replies
View Related
Aug 6, 2006
With the function below, I receive this error:Error:Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0.Function:Public Shared Function DeleteMesssages(ByVal UserID As String, ByVal MessageIDs As List(Of String)) As Boolean Dim bSuccess As Boolean Dim MyConnection As SqlConnection = GetConnection() Dim cmd As New SqlCommand("", MyConnection) Dim i As Integer Dim fBeginTransCalled As Boolean = False
'messagetype 1 =internal messages Try ' ' Start transaction ' MyConnection.Open() cmd.CommandText = "BEGIN TRANSACTION" cmd.ExecuteNonQuery() fBeginTransCalled = True Dim obj As Object For i = 0 To MessageIDs.Count - 1 bSuccess = False 'delete userid-message reference cmd.CommandText = "DELETE FROM tblUsersAndMessages WHERE MessageID=@MessageID AND UserID=@UserID" cmd.Parameters.Add(New SqlParameter("@UserID", UserID)) cmd.Parameters.Add(New SqlParameter("@MessageID", MessageIDs(i).ToString)) cmd.ExecuteNonQuery() 'then delete the message itself if no other user has a reference cmd.CommandText = "SELECT COUNT(*) FROM tblUsersAndMessages WHERE MessageID=@MessageID1" cmd.Parameters.Add(New SqlParameter("@MessageID1", MessageIDs(i).ToString)) obj = cmd.ExecuteScalar If ((Not (obj) Is Nothing) _ AndAlso ((TypeOf (obj) Is Integer) _ AndAlso (CType(obj, Integer) > 0))) Then 'more references exist so do not delete message Else 'this is the only reference to the message so delete it permanently cmd.CommandText = "DELETE FROM tblMessages WHERE MessageID=@MessageID2" cmd.Parameters.Add(New SqlParameter("@MessageID2", MessageIDs(i).ToString)) cmd.ExecuteNonQuery() End If Next i
' ' End transaction ' cmd.CommandText = "COMMIT TRANSACTION" cmd.ExecuteNonQuery() bSuccess = True fBeginTransCalled = False Catch ex As Exception 'LOG ERROR GlobalFunctions.ReportError("MessageDAL:DeleteMessages", ex.Message) Finally If fBeginTransCalled Then Try cmd = New SqlCommand("ROLLBACK TRANSACTION", MyConnection) cmd.ExecuteNonQuery() Catch e As System.Exception End Try End If MyConnection.Close() End Try Return bSuccess End Function
View 5 Replies
View Related
May 25, 2015
below data,
Countery
parentid
CustomerSkId
sales
A
29097
29097
10
A
29465
29465
30
A
30492
30492
40
[code]....
Â
Output
Countery
parentCount
A
8
B
3
c
3
in my count function,my code look like,
 set buyerset as exists(dimcustomer.leval02.allmembers,custoertypeisRetailers,"Sales")
set saleset(buyerset)
set custdimensionfilter as {custdimensionmemb1,custdimensionmemb2,custdimensionmemb3,custdimensionmemb4}
set finalset as exists(salest,custdimensionfilter,"Sales")
Set ProdIP as dimproduct.dimproduct.prod1
set Othersset as (cyears,ProdIP)
(exists(([FINALSET],Othersset,dimension2.dimension2.item3),[DimCustomerBuyer].[ParentPostalCode].currentmember, "factsales")).count
it will take 12 to 15 min to execute.
View 3 Replies
View Related
Jul 3, 2013
I am trying to get count on a varchar field, but it is not giving me distinct count. How can I do that? This is what I have....
Select Distinct
sum(isnull(cast([Total Count] as float),0))
from T_Status_Report
where Type = 'LastMonth' and OrderVal = '1'
View 9 Replies
View Related
Nov 26, 2007
I use SQL 2000
I have a Column named Bool , the value in this Column is 0�0�1�1�1
I no I can use Count() to count this column ,the result would be "5"
but what I need is "2" and "3" and then I will show "2" and "3" in my DataGrid
as the True is 2 and False is 3
the Query will have some limited by a Where Query.. but first i need to know .. how to have 2 result count
could it be done by Count()? please help.
thank you very much
View 5 Replies
View Related
Jul 23, 2005
SQL 2000I have a table with 5,100,000 rows.The table has three indices.The PK is a clustered index and has 5,000,000 rows - no otherconstraints.The second index has a unique constraint and has 4,950,000 rows.The third index has no constraints and has 4,950,000 rows.Why the row count difference ?Thanks,Me.
View 5 Replies
View Related
Aug 21, 2007
The following query returns a value of 0 for the unit percent when I do a count/subquery count. Is there a way to get the percent count using a subquery? Another section of the query using the sum() works.
Here is a test code snippet:
--Test Count/Count subquery
declare @Date datetime
set @date = '8/15/2007'
select
-- count returns unit data
Count(substring(m.PTNumber,3,3)) as PTCnt,
-- count returns total for all units
(select Count(substring(m1.PTNumber,3,3))
from tblVGD1_Master m1
left join tblVGD1_ClassIII v1 on m1.SlotNum_ID = v1.SlotNum_ID
Where left(m1.PTNumber,2) = 'PT' and m1.Denom_ID <> 9
and v1.Act = 1 and m1.Active = 1 and v1.MnyPlyd <> 0
and not (v1.MnyPlyd = v1.MnyWon and v1.ActWin = 0)
and v1.[Date] between DateAdd(dd,-90,@Date) and @Date) as TotalCnt,
-- attempting to calculate the percent by PTCnt/TotalCnt returns 0
(Count(substring(m.PTNumber,3,3)) /
(select Count(substring(m1.PTNumber,3,3))
from tblVGD1_Master m1
left join tblVGD1_ClassIII v1 on m1.SlotNum_ID = v1.SlotNum_ID
Where left(m1.PTNumber,2) = 'PT' and m1.Denom_ID <> 9
and v1.Act = 1 and m1.Active = 1 and v1.MnyPlyd <> 0
and not (v1.MnyPlyd = v1.MnyWon and v1.ActWin = 0)
and v1.[Date] between DateAdd(dd,-90,@Date) and @Date)) as AUPct
-- main select
from tblVGD1_Master m
left join tblVGD1_ClassIII v on m.SlotNum_ID = v.SlotNum_ID
Where left(m.PTNumber,2) = 'PT' and m.Denom_ID <> 9
and v.Act = 1 and m.Active = 1 and v.MnyPlyd <> 0
and not (v.MnyPlyd = v.MnyWon and v.ActWin = 0)
and v.[Date] between DateAdd(dd,-90,@Date) and @Date
group by substring(m.PTNumber, 3,3)
order by AUPct Desc
Thanks. Dan
View 1 Replies
View Related
Jun 25, 2007
Hi all
i using lookup error output to insert rows into table
Rows count rows has been inserted on the table 59,123,019 mill
table rows count 6,878,110 mill ............................
any ideas
View 6 Replies
View Related
Aug 28, 2007
Is there a difference in performance when using count(*) or count(columnname)?
View 10 Replies
View Related
Nov 8, 2006
HI,
We upgraded to SQL Server 2005 Standard Edition for our ASP.NET 2.0 website. We were using SQL Server Express 2005. That worked fine. Now we are unable to connect to the database. I have googled, but I just cann't figure out what is going on. Any help is appreciated. Here is the error.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
In our firewall sqlbrowser.exe and sqlservr.exe are allowed.
Thanks Matt
View 11 Replies
View Related
Sep 27, 2007
Ok I'm trying to connect to my easycgi.com MSSQL database.I can connect OK.My ID is in the db_owner group.I can create and edit tables and data.I can open a table and see the data.I can view the SQL statement behind the open table (select * from Table) and execute it successfully.But if I open a new query window and type "select * from [table]" (or any other query), no matter which table it is, I get an error:Msg 208, Level 16, State 1, Line 1Invalid object name '[table name]'.I've searched the web and found this error plenty of times, usually associated with security or the schema. But all my objects are under dbo and I'm in db_owner... ???
View 6 Replies
View Related
Jun 19, 2008
When trying to connect to a remote SQL 2005 Express Server, I get this error message: [DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection.
I can remotely connect to the server with the same username and password using osql in command and I can also connect to the server remotely with SQL Server Management Studio installed on this machine.
Here is my connection string:
Provider=SQLOLEDB.1;Password=password;Persist Security Info=True;User ID=uid;Initial Catalog=EBM;Data Source=xxx.xxx.xxx.xxxSQLEXPRESS;Use Encryption for Data=False
The same connection string works if connecting locally, via changing the ip address to the machine name:
Provider=SQLOLEDB.1;Password=password;Persist Security Info=True;User ID=uid;Initial Catalog=EBM;Data Source=machinenameSQLEXPRESS;Use Encryption for Data=False
Any help would be appreciated.
View 2 Replies
View Related
Mar 19, 2004
I get a Invalid Column Name ' '. with this procedure. Can anyone see what migh be wrong?
Thanks,
SELECT A.CompanyName,C.FirstName,C.LastName,C.Client_ID,
CASE WHEN A.[CompanyName] IS NULL OR A.[CompanyName] = '' THEN C.[FirstName] +" "+ C.[LastName] ELSE A.[CompanyName] END AS DRName, C.Client_ID
FROM tblClients C INNER JOIN tblClientAddresses A ON C.Client_ID = A.Client_ID
WHERE (C.Client_ID = 15057) AND (A.MailTo=1) AND Convert(varchar(5), GETDATE(), 10) BETWEEN Convert(varchar(5), A.Startdate, 10) AND Convert(varchar(5), A.Enddate, 10) OR (A.Startdate Is Null) AND (A.EndDate Is Null)
GO
View 3 Replies
View Related
Aug 19, 2004
Hi the following SP that causes an error.
CREATE PROCEDURE GetInfo
(
@MinPriceint=0,
@MaxPriceint=9999999999,
@TypeHomenvarchar(50)=NULL,
@Locationnvarchar(100)=NULL
)
AS
Declare @strSql nvarchar(255)
Set @strSql="Select * from table WHERE "
Set @strSql=@strSql + 'Price BETWEEN ' + CONVERT(nvarchar(20),@MinPrice) + ' and ' + CONVERT(nvarchar(20),@MaxPrice )
If @TypeHome != "No Preference"
Set @strSql=@strSql + ' and Type = ''' + @TypeHome+ ''''
If @Location != "No Preference"
Set @strSql=@strSql + ' and City = ''' + @Location+ ''''
Set @strSql=@strSql + ' and IDX = ''Y'' ORDER BY Price'
Exec(@strSql)
GO
The Error I get is:
"Error 207: Invalide Column Name 'Select * from table WHERE'
Invalid Column Name 'No Preference'
Invalid Column Name 'No Preference'
I have checked the table and the columns do exist, spelled correctly and caps are all the same. Also, this same SP in another table works just fine.
What is causing this error?
Thanks in advance!
View 1 Replies
View Related
Mar 30, 2005
Hey everyone, hope you all can help me with this problem.
We have a remotely hosted website, but we have a SQL server in our company (powers our instore portal). I have set up our router so that i can connect to remote desktop and sql server. I can connect to the remote desktop and i can connect to the sql server with query analyzer. On our local site i can set up a connection to look at sqlserver.underpargolfutah.org and it works fine, everything goes well.
Now here is the problem. On the hosted site i have set up the following
web.config >
<appSettings>
<add key="sql_dsn" value="server=************.underpargolfutah.org;database=online;uid=sa;pwd=*******" />
</appSettings>
default.aspx >
Public Class shopDB 'publicly declare typical stuff for connections Public conn As SqlConnection Public cmd As SqlCommand Public reader As SqlDataReader Public dsn As String = ConfigurationSettings.AppSettings("sql_dsn").ToString Public Function getBaseSelectionsByType(ByVal type) 'declare the connection conn = New SqlConnection(dsn) 'declare command cmd = New SqlCommand("SELECT * FROM category", conn) 'open the connection conn.Open() 'grab data reader = cmd.ExecuteReader(CommandBehavior.CloseConnection) Return reader End Function
End Class
This should all work but i get the following error
[SqlException: Invalid connection.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 v3.shopDB.shopDB.getBaseSelectionsByType(Object type) in shopDB.vb:21 v3.shop_default.Page_Load(Object sender, EventArgs e) in default.aspx.vb:32 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +742Any ideas? i am stumped.
Thanks in advance-Darren
View 1 Replies
View Related
Feb 16, 2001
Can anyone tell me why I get the above message using the following stored procedure and passing in a value of 120:
CREATE Procedure qryAnalysisCountMain
(@WizardGroup1Question int)
As
EXEC("SELECT QuestionDescription FROM Questions WHERE QuestionCode = " + @WizardGroup1Question)
120 just happens to be the asci value of 'x' and whatever number I pass in gets converted into it's character equivalent and the sp tells me it can't find that column name. QuestionCode is an int field so there is no problem there
The procedure works OK with:
SELECT QuestionDescription FROM Questions WHERE QuestionCode = @WizardGroup1Question
However I need the SQL in an EXEC as the sp will eventually be dynamic so that i can pass in the name of the table to select from.
Thanks
Martin
View 1 Replies
View Related
Mar 30, 2004
Hi
I have a dynamic select statement which is showed below.
declare @query varchar(100)
set @query = 'select * from undergraduate where Gender =' + @Gender
exec (@query)
//
When I execute the @query, I get an error message like "Invalid Column Name Male".
I think I need to put a single quotation around the dynamic variable, so that I have
select * from undergraduate where Gender ='Male'. But I am not sure how to do that.
Thank you for your help!!
View 3 Replies
View Related
Jan 21, 2006
Dear guys
when am executing a stored procedure from asp page it will shows an err like this
"
Microsoft OLE DB Provider for SQL Server error '80040e30'
Type name is invalid
"
but the script and the database is perfectly working in local computer ..
what will be the reason.
regards jini
View 2 Replies
View Related
Jul 31, 2002
When running 'select * from <table> everyone gets 'invalid object' error. When they run 'select * from <database>.<objectowner>.<table> it works fine. This would lead one to believe that they're either not in their default database or that they don't own the objects. However this is not the case.
Why do they need to qualify everything if they're running from their own databaase, they own the object and they're logged in as the objectowner?
This was working fine one day but not the next. They connect using a DSN that's on a web server and they pass their login and password but not their database. I don't have this problem and can't duplicate anyone else's, but I'm not on the web server, I'm going directly to teh SQL server using Query Analyzer.
Any ideas??
View 1 Replies
View Related
Jul 12, 2005
I'm connecting to an SQL Server database through a Perl script (using Win32::ODBC). The connection seems to go through fine, as in, I get no errors. But even simple statements like "Select * from AccountTable" dont work. I get the error Invalid Object Name 'AccountTable'. The table exists and I even gave myself explicit permission for "SELECT" statements for that table.
Are there any other permissions that need to be set? The DSN defaults to the database that I need.
Any help would be most appreciated. I'm going mad here.
Thanks.
-Amrita
View 1 Replies
View Related
Feb 2, 2007
as i run my code (windows application) i get this error
Invalid object name 'dbo_TASk'.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1.
/****** Object: Stored Procedure dbo.stp_per_task_by_system_sel Script Date: DATE ******/
IF EXISTS (SELECT *
FROM dbo.sysobjects
WHERE id = OBJECT_ID(N'[dbo].[stp_per_task_by_system_sel]')
AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[stp_per_task_by_system_sel]
GO
CREATE PROCEDURE dbo.stp_per_task_by_system_sel
(
@sys_id int
)
AS
--------------------------------------------------------------------------------
-- Created by : Jacco B
-- Date created : 1-febrauri-2007
--------------------------------------------------------------------------------
-- Description : deze stp haalt de specefieke taken van een geselecteerd systeem uit de database
--------------------------------------------------------------------------------
-- Test string : stp_per_task_by_system_sel 'var'
--------------------------------------------------------------------------------
-- Change Log : Date By Description
-- -------- ------ ------------------------------------
--
--------------------------------------------------------------------------------
BEGIN
SET NOCOUNT ON
--declaratie locale variabelen
DECLARE @error integer,
@object_name varchar(30)
--begin transactie
SELECT @object_name = object_name(@@procid)
BEGIN TRAN @object_name
--begin procedure
SELECT SYSTEM_STANDARD_TASK.*, TASk.*
FROM SYSTEM_STANDARD_TASK INNER JOIN dbo_TASk ON SYSTEM_STANDARD_TASK.tas_id = TASk.tas_id
WHERE SYSTEM_STANDARD_TASK.sys_id = @sys_id
--Errorafhandeling
SELECT @error = @@error
IF @error <> 0
BEGIN
ROLLBACK TRAN @object_name
RETURN @error
END
--commit transactie
COMMIT TRAN @object_name
RETURN 0
END
GO
--grant exec to sql group
GRANT EXECUTE ON [dbo].[stp_per_task_by_system_sel] TO [PERIODIEK_USER]
GO
View 2 Replies
View Related
Feb 4, 2005
When i enter http://akor.alternatifim.com/
i get the error below
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tblSARKICIM'.
The SQL statement is so simple like
Select * from tblSARKICIM
However when i change the SQL statement Select * from lyric.tblSARKICIM
lyric is username and owner of the tables.
Problem is solved. I transfer the My SQL Server and then this problem occurs and i don't want change all my SQL statements.
What can i do?
View 6 Replies
View Related
Jul 9, 2006
Hi All,
We have got a new HP server and SQL is preinstalled, But when we are trying to start SQL, it gives an error "The handle is invalid".
We tried to reinstall the SQL, but , being a server t doesn't allow to do so
Please assist.
regards,
Jatin
View 1 Replies
View Related
Jul 16, 2007
Hi,
My application uses VB6 and Sql-Server 2000.
I can’t understand why the error
INVALID OBJECT NAME Run-time error '-2147217865 (80040e37)'
appears only sometimes and not always. For example, a select instruction is executed inside a loop without any problem 1 thousand times, then when I try to execute it 1 thousand times and one, it fails.
Have you got any suggestions?
I’ve read a lot of posts on Internet Forums, without finding any solutions.
In the mail I attach, you can see that the application stops at 79%, after having executed many times the select instruction without any problem!
Thank you very much for your help!
Bye,
Emanuela
View 7 Replies
View Related
Dec 29, 2003
I am getting the "Invalid use of Null" message when I execute the following code under the following conditions.
fields in SQL Server table
db_date varchar(30) --> "December 29"
db_subject varchar(200) --> "Test Subject"
db_thought text --> "This is a test to see if this works"
I execute the following code from VB6
strText = "select * from db_table where db_date = 'December 29'"
ors.open strText, dbConnect
if not ors.eof then
if not isnull(ors("db_thought")) then
txtBox1 = ors("db_thought")
end if
end if
Here is my problem. Since there is a value in db_thought the code if not isnull(ors("db_thought")) evaluates to true -- this is what I expect. However when I try to assign the ors("db_thought") to the txBox1 field I get an Invalid use of Null. What am I missing?
Thanks
View 2 Replies
View Related
Feb 9, 2004
I restored all Databases in other server.
First I restored the master database and after the others databases. But when I connect by Query Analyser with a user that is a DBO and I execute a select the system return : "Invalid object name 'XXXX'"
My MS-SQL is the version 7.0.
View 1 Replies
View Related
Mar 3, 2004
This is what I have. It works fine until I get to the select statement, then it tells me that I have an invalid object name. What am I missing? Thanks!
DECLARE @SvrName varchar(100)
if @@SERVERNAME='pubs' begin
set @SvrName=’pubs.books.isbn’
print @SvrName
end
if @@SERVERNAME='MGMFILENET' begin
set @SvrName=’store.books.isbn’
print@SvrName
end
print @@SERVERNAME
PRINT @SvrName
SELECT * FROM "@SvrName"
View 7 Replies
View Related
Apr 2, 2004
I am getting an error 'Invalid Object Name' when I try and insert a row yet I can query the same table and get results????
Please Help!
View 7 Replies
View Related
May 6, 2008
Hello All,
I m facing problem in one query. What I did is
SELECT
PRODUCT_ID,
PRODUCT_END_DATE,
CASE
WHEN PRODUCT_ID = 1 THEN DATEADD(YY,-5,PRODUCT_END_DATE)
WHEN PRODUCT_ID = 2 THEN DATEADD(YY,-10,PRODUCT_END_DATE)
WHEN PRODUCT_ID = 3 THEN DATEADD(YY,-15,PRODUCT_END_DATE)
END AS MODIFIED_END_DATE
FROM PRODUCTS
WHERE MODIFIED_END_DATE BETWEEN '2008-04-01' AND '2008-04-30'
when I execute this query returns an error as
Invalid column name MODIFIED_END_DATE
So how can I write this query? any idea.
Thanks in advance.
--kneel
View 3 Replies
View Related
Jun 16, 2008
I have my column names right but its telling me they are invalid. It must be something to do with how I have my subquery formatted but I don't see it. I was wondering if anyone else can see it? It tells me payer_id is not right and I know its coming from the bolded section. I just added that line to do some additional grouping. I know that the query above aliased as D was working before I put the bolded line in. Am I setting this up wrong?
select distinct c.description,tmp.person_id,tmp.person_nbr,tmp.first_name,
tmp.last_name,tmp.date_of_birth,d.payer_name,b.create_timestamp
from PersonMIA tmp
join person a on a.person_id = tmp.person_id
join patient_encounter b on a.person_id = b.person_id
join provider_mstr c on b.rendering_provider_id = c.provider_id
cross apply(select top 1 payer_name
from person_payer
where person_id = tmp.person_id
order by payer_id) d
join payer_mstr e on d.payer_id = e.payer_id
join mstr_lists f on e.financial_class = f.mstr_list_item_id
where c.description = 'Leon MD, Enrique'
group by c.description,tmp.person_id,tmp.person_nbr,tmp.first_name,tmp.last_name,
tmp.date_of_birth,d.payer_name,b.create_timestamp
)tmp2
where year(create_timestamp) IN (2005,2006)
group by person_nbr,payer_name,first_name,last_name,description,create_timestamp
Thanks in Advance!
Sherri
View 2 Replies
View Related
Oct 15, 2005
Hi
Please help how to solve the invalid use of Null value in numeric field
1. Query name : Genled
----------------------
SELECT PARTY.PARTYNAME AS PARTYNAME, GEN.GLNAME AS GLNAME,
GEN.AMOUNT AS OAMOUNT, CASH.CASHNAME AS CASHNAME, TXN.CBCODE AS CBCODE,
GEN.CB AS CB, TXN.GLCODE AS GLCODE, TXN.VOUCHER AS VOUCHER,
TXN.DOCDATE AS DOCDATE, TXN.AMOUNT AS TAMOUNT, TXN.VTYPE AS VTYPE,
TXN.NARR AS NARR, TXN.CHEQUE AS CHEQUE, TXN.CHEQDATE AS CHEQDATE,
TXN.BANK AS BANK, TXN.BILLNO AS BILLNO, TXN.BILLDT AS BILLDT
FROM PARTY RIGHT JOIN (GEN LEFT JOIN (TXN LEFT JOIN CASH ON TXN.CBCODE
= CASH.CBCODE) ON GEN.GLCODE = TXN.GLCODE) ON PARTY.PARTYCODE =
TXN.PARTYCODE WHERE (((GEN.GLCODE) Not In (SELECT CASHCODE FROM CASH)));
2. From query 1 i have to create temporary table ogenled & generalled
3. From table ogenled i have pass this query -
select glname, oamount, sum(tamount) as tamt,
(oamount+sum(tamount))as opbal from ogenled group by glname,
oamount order by glname
4. from query 3 i have update generalled table for opbal
but the problem is this if only oamount is <>0 and tamt is empty
then error message show "INVALID USE OF NULL"
5. gen table contain the glname, oamount , txn table contains the detail
transaction. It is quite possible that only opening amt is exit.
by query it nothing transaction is done than tamount field show " "
6. Please help how to show the default value 0 insted of " "
Thanks
ASM
View 7 Replies
View Related
Mar 26, 2006
I am building a query and thought I had completed it but I get 'Invalid Column Name "A1" when I run it?
SELECT
Groups.GroupID,
Sum(Stages_On_Route.Distance) AS Miles_Covered,
Groups.Group_Name
FROM Groups
INNER JOIN ((Route INNER JOIN Departure ON (Route.GroupID=Departure.GroupID)
AND (Route.RouteID=Departure.RouteID))
INNER JOIN Stages_On_Route ON Route.RouteID=Stages_On_Route.RouteID)
ON Groups.GroupID=Departure.GroupID
GROUP BY Groups.GroupID,
Groups.Group_Name
HAVING (((Groups.GroupID)="A1"));
View 6 Replies
View Related