|
AFAIK you need a SQL server installed.
If you need to deploy a SQL Server, take a look at the Express Edition which IIRC is free to use.
|
|
|
|
|
the error is _CrtIsValidHeapPointer function returning FALSE.
for example:
<pre>ResultSet *rs = stmt->executeQuery();
int nCol = 0;
{
vector<MetaData> vMetaData = rs->getColumnListMetaData();
nCol = (int) vMetaData.size();
} //now deconstructing vMetaData, the error is like this:</pre>
Debug Assertion Failed!
Program: ...
File: dbgheap.c
Ling: 1132
Expression: _CrtIsValidHeapPointer(pUserData)
windwosXP sp3 vs.net 2003
Oracle11g OCCI
|
|
|
|
|
Try in the C/C++ forum.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
thanks
but it is no use in my code:
ResultSet *rs = stmt->executeQuery();
int nCol = 0;
try
{
vector<MetaData> vMetaData = rs->getColumnListMetaData();
nCol = (int) vMetaData.size();
}
catch (...)
{
}
the errors are the same as before!
|
|
|
|
|
I have a SQL result coming as
ID Created Status
================================================
1 2008-05-10 Active
4 2008-05-11 Active
3 2008-05-12 Inactive
2 2008-05-13 Inactive
I want the same to come as (Order by ID)
ID Created Status
================================================
Con1 2008-05-10 Active
Con2 2008-05-13 Inactive
Con3 2008-05-12 Inactive
Con4 2008-05-11 Active
How do i do this using SQL
|
|
|
|
|
Are you wanting this for display purposes only or for saving to a DB?
If you are inserting you should be able to do something like INSERT INTO tbl_WHATEVER "CON" & ID
I think you could do something similar for display purposes:
SELECT ("Con" & ID, Created, Status)
FROM tbl_WHATEVER
SORT ASC
I haven't tried it though.
|
|
|
|
|
Try this:
Select 'Con' + convert(varchar(20),ID), *
From TableName
Order by ID (desc)
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
select 'Con'+cast(ID as varchar),Created,Status from myTable order by ID asc
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
Hi all,
I have a simple mysql query which returns user data stored in some table, e.g:
SELECT *
FROM cpa_candidate c
WHERE c.firstname like 'john' AND
c.lastname like 'smith'
The above query runs with no problems and returns data as expected.
Now I want to use variables in the query for the values in the criteria:
set @fname = 'john';
set @lname = 'smith';
SELECT *
FROM cpa_candidate c
WHERE c.firstname like @fname AND
c.lastname like @lname
When I execute the query above, an empty recordset is returned. What could be causing this? I tried casting the variables to varchar - no help, I even tried enclosing them in quotes - no help! Someone please help me
Thank you in advance!
|
|
|
|
|
declare @fname as varchar(255)<br />
decare @lname as varchar(255)<br />
set @fname = 'john';<br />
set @lname = 'smith';<br />
<br />
SELECT * FROM <br />
cpa_candidate c <br />
WHERE c.firstname like '%' + @fname + '%' AND <br />
c.lastname like '%' + @lname '%'
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
Thanks for the response man, but I have tried this and it did not work...
|
|
|
|
|
This is a reserved word that is documented nowhere in the known universe.
Semicolons: The number one seller of ostomy bags world wide. - dan neely
|
|
|
|
|
Well, the 2005 documentation points me towards it being used in VisualFox exception handling.
It is also possible it is just reserved for the sake of future implementation, or because they thought it would be used in future implementations.
Can't find much information about it either though.
|
|
|
|
|
What documentation? SQL Server BOL states in one or two places only that it is a reserved word. I'm sure other systems have their own uses of reserved words like lineno, but I was asking what it means in T-SQL.
Semicolons: The number one seller of ostomy bags world wide. - dan neely
|
|
|
|
|
I have a join on two tables, for document header and line data:
select * from DocumentHeader dx inner join DocumentLine ix on ix.DocID = dx.DocID
I need to get sequential numbering for all DocumentLine records, as below, where all <H> lines are from table DocumentHeader and all <L> lines from DocumentLine. Note how the numbering does not restart for each new document header.
"X","@<H>","","R","2342",2008.02.29,2008.05.18,"",5016,"ZAR" "X","@<L>",1,290002,2508 "X","@<L>",2,290002,2508, "X","@<H>","","R","2342",2008.02.29,2008.05.18,"",2508,"ZAR" "X","@<L>",3,290002,2508
Any ideas of how I could achieve that in a query? BTW, I'm not asking for my work to be done, I am also hard at work trying to find a solution to this.
Semicolons: The number one seller of ostomy bags world wide. - dan neely
|
|
|
|
|
Solved! I create a temp table called #LineNumber with an identity column, LineNumber for each DocItemID in DocumentLine and just join to the temp table in my main query.
Semicolons: The number one seller of ostomy bags world wide. - dan neely
|
|
|
|
|
If you are using SS2005 then look at the row_number (also rank and partition) function. It will allow you to do this without the temp table.
Also look at a table variable, you can have the same identity field without having to create the table in the temp DB.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thanks! row_number() looks perfect.
Semicolons: The number one seller of ostomy bags world wide. - dan neely
|
|
|
|
|
hi
i have a job that scheduled to perform a specific transaction
so i want to change the command of this job by programming
but when i set the value of a cmd(SqlCommand object) and call cmd.ExecuteNoneQuery(); nothing happens but when i run that query by query analyzer that do corrctly.
how can i do this action programmatically???
nobody help you...
you have to help you yourself
and this is success way.
|
|
|
|
|
Hi all,
I'm using OleDbCommandBuilder to build commands for an OleDbDataAdapter automatically
The problem is when using OleDbDataAdapter to retrieve data from a "View" in a SQL Express database
Ex: OleDbDataAdapter("select * from ViewName", ConnectionString);
The generated CommandText for generated commands is invalid, it looks like this:
InsertCommand ex:
INSERT INTO D:\\FOLDER_NAME\\DATABASE_FILE_NAME.MDF.dbo.TableName
DeleteCommand ex:
DELETE FROM D:\\FOLDER_NAME\\DATABASE_FILE_NAME.MDF.dbo.TableName
UpdateCommand ex:
UPDATE D:\\FOLDER_NAME\\DATABASE_FILE_NAME.MDF.dbo.TableName
Where TableName is the source table of the "View" !!!
Ofcource executing command causes an error of "Incorrect syntax near 'D:'"
Notice that, this problem doesn't occur with tables, only with views !!
Also problem doesn't occur with SqlCommandBuilder, but I need to use OleDbCommandBuilder because I'm dealing with multiple database providers
Please help
modified on Sunday, May 18, 2008 6:45 AM
|
|
|
|
|
|
Flight_ID Passenger_ID Seat_Number Seat_Cost Seat_Class
1 3 j15 $112.00 Business
2 5 K16 $38.00 Economy
3 4 A12 $85.00 Economy
4 2 B05 $40.00 Economy
5 1 C08 $85.00 Economy
6 5 B12 $85.00 Economy
8 7 K17 $42.00 Economy
9 6 L25 $125.00 Business
I need to be able to allow duplicated in the Flight_ID which is the primary key so i can allow more passengers to be able to "fly" on that flight
iD
|
|
|
|
|
You can't have duplicate primary keys, it kind of defeats the entire purpose of having it as a primary key. A primary key needs to be unique.
What you can do instead is make a combined primary key consisting of multiple columns or revisit whether you need/want that column as a primary key to begin with.
Considering the snippet of your table you have posted, I would think that a combined key of Flight_ID and Passenger_ID (A specific passenger on a specific flight should all things equal be unique.) would be the best way to go.
|
|
|
|
|
To allow adding multiple passagers on one flight then make combination of primary key with Flight_id and Passager_ID
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
Your table design sucks - big time.
You should have the following tables to get this data
Flight - FlightNo
Passenger - PassengerID
Seat - SeatNo
Cost - CostID
Transaction
TranID
FlightNo
PassengerID
SeatNo
CostID
Your primary key Flight_ID is NOT the primary key for the transaction table as you are attempting to make it!
Recommendation you REALLY need to get a book on data structuring before adventuring into this area, you will save yourself months of heartache. Even if you get this working for flight 1 (it is possible for 1 flight) as soon as you add another flight or another plane design or want to change the cost of a class of seats you are in trouble. GET A DESIGN BOOK - READ IT.
Never underestimate the power of human stupidity
RAH
|
|
|
|