|
With ODBC, I can't write :
'CREATE TABLE table1(field1,field2);CREATE TABLE table2(field1,field2);'
because ODBC doesn't accept the ';'. So I have to execute the first statement and then the second.
Therefore, I'd want to know if there is a possibility to execute a multi-statement line command with ODBC : Is there another separator ?
In fact, I write program that can communicate with several database servers.
I've got a file with all queries I need:
[MySQL]
QUERY1:SELECT * FROM table1
QUERY2:INSERT INTO table1( ....)
.....
[MSSQL]
QUERY1: .....
QUERY2: .....
.....
[ORACLE]
QUERY1: .....
QUERY2: .....
.....
The problem is that I can create a table with 'auto-increment' field with only one SQL statement on MySQL and SqlServer but on Oracle, it needs 3 statements to do it ... and I want to have only one line of SQL code.
If you've got a solution to my problem, please help me !
jpeg
|
|
|
|
|
Yes, you can do that for DBMS's that support query batches. MSSQL does query batches, just leave out the semicolon.
onwards and upwards...
|
|
|
|
|
I read the article Code Project/C# Programming - ADO Data Access through COM Interop in .NET by Kannan Kalyanaraman and it is great.
The only thing that I have not got is the open method of the connection object when I use the Interop Component in C#. What I am coding is:
cnnCustomer.Open(strConn, "", "", (int)ConnectModeEnum.adModeUnknown);
What is wierd is that in VB.Net it works fine. I am missing something here?
|
|
|
|
|
Okay..heres what my goal is. I have 2 tables with a parent-child relationship in an Oracle DB. I want the XML file to look like this. (I want to use XSLT to format the data).
<parents>
<parent>
<col1>
<col2>
<children>
<child1>
<att1>AAA
<child1>
<att1>BBB
...
Is there a way to create this type of XML easily using the DataSet. Here's what I tried. I tried adding both tables to a dataset, and then adding the relationship. Then I called the WriteToXml method of the dataset but it did not keep that format. I also have a XSD file for my dataset that I created with that format but no luck.
Any ideas??
|
|
|
|
|
i use ADO in MFC to access my database using SQL
my problem is that i can't add a variable using INSERT INTO
like,
---------
char mon[50]
pRs->Open("INSERT INTO moshtarayat1(elsanf) VALUES(mon)",m_pConn.GetInterfacePt(),adOpenForwardOnly,adLockOptimistic,adCmdText);
-------------
the problem here is that the INSERT INTO statment inserting the varibale name not it contents !
is there anyway to solve this problem ?
|
|
|
|
|
SomeOne_SurVive wrote:
Open("INSERT INTO moshtarayat1(elsanf) VALUES(mon)",m_pConn.GetInterfacePt
Are you using a stored procedure to add this value?
Or, are you using a form field within an ASP.NET, or ASP page?
How are you getting the value of this variable?
If using a stored proc, the variable should be declared as @mon.
Please post more details !!!!
HTH
Tony
|
|
|
|
|
after alot of tries, i got an clue as below :
CString mon;
lCommand.Format("INSERT INTO moshtarayat1(dates) VALUES('%s')",(CString)mon);
pRs.CreateInstance(__uuidof(Recordset));
pRs->Open((variant_t)lCommand,m_pConn.GetInterfacePtr(),adOpenForwardOnly,adLockOptimistic,adCmdText);
pRs->Update();
----------------------------------
i didn't try ur way yet, but i'll.
thanks for response.
|
|
|
|
|
Sure it will...
If I read this C++ code right, you're sending the following string to the DB:
INSERT INTO moshtarayat1(elsanf) VALUES(mon)
Aren't you trying to send the contents of the mon variable into the DB?
Copy the value of mon into the SQL string, so that it would look like:
INSERT INTO moshtarayat1(elsanf) VALUES(value_of_mon)
where value_of_mon represents the value of
mon<code>.<br />
<br />
(I'm not sure how you combine strings in C++, so no actual sample code...)
|
|
|
|
|
yea, thats right if i'm adding the contents from the code by myself.
but what about if the user is the one who gonna enters it ?
like i copy the contents from and editbox or somthin.
thanks for response
|
|
|
|
|
Hi All!!
I m making a generalized class which can handle all type of databases
like Access , SQLServer etc.
So i m using static interaces to declare DataConnection and DataAdapter.
Problem is that i can't get the PrimarKey of DataTable.
PrimaryKey.Length always returns '0'.
any suggestions....
Thanx in advance
sorry for my bad English.
|
|
|
|
|
Hi!
I'm writing an app in VC++ 6 that uses ADO through the #import directive.
There are an unknown number of predefined queries in the database (access)
witch I need to execute and I wonder if there's a way of retrieving the
names of those queries using ADO.
I'm using a Connection Object and a RecordSet Object to obtain the results
of the queries but how can I obtain the queries?
thanks
/Anders
|
|
|
|
|
See the replies in the VC forum
<marquee scrollamount="3" scrolldelay="80" direction="right" width="40%" style="border: 2px inset silver;background-color:yellow;color:green;font-family:Verdana,Arial;font-size:8pt;font-style:italic">onwards and upwards...
|
|
|
|
|
I have a table that's being populated by a stored procedure. Once the table is populated I need to know the distinct values in some of its columns. I can use foreach loops, but this seems like it would be slow. Is there any way to query a table in a dataset and place the results into another table or an array?
>>>-----> MikeO
|
|
|
|
|
|
Hello All,
I am stuck with sql server my friends. The situation is i am installing sql server 7.0 desktop edition on windows 98 on laptop.i installing the sql server it hanged in between the process.After that i am not able to register my server.
Please any body can help me in this situation.
Thanx & Regards,
Shalender Gandhi.
|
|
|
|
|
We're running mixed mode authentication on our sql server. The SQL server grants access to everyone on the domain. What I'd like to do is restrict table drop access on all accounts except sa. Is there a way to do this? If not, is there a way to restrict table drop access on certain tables to so that no one can ever drop these tables?
|
|
|
|
|
USE DATABASENAME<br />
<br />
GRANT SELECT, UPDATE ON TABLENAME<br />
<br />
TO [DOMAINNAME\useraccount]<br />
<br />
GO<br />
<br />
USE DATABASENAME<br />
<br />
DENY DROP TABLE ON TABLENAME<br />
<br />
TO [DOMAINNAME\useraccount]<br />
<br />
GO
Tony
|
|
|
|
|
I tried the 2nd statement, but get the following error:
Privilege DROP <object> may not be granted or revoked.
I then tried the following command to allow create access which should implicitly deny drop access, however I can't seem to modify the views/tables in design mode because it doesn't have the privledges:
USE DATABASENAME
GRANT CREATE FUNCTION, CREATE PROCEDURE, CREATE VIEW
TO [DOMAINNAME\useraccount]
GO
Anyone have any other ideas/workarounds to deny drop table access for all users except sa (but still allow modify and create access)
|
|
|
|
|
T,
I would then look into the ALTER TABLE T-SQL statement.
I have used this many times on permissions and views and it has saved my a.. more than once.
Sorry couldn't be more helpful !
Tony
|
|
|
|
|
Hi, all:
After I made the update to the database with ONLY the RowState = Deleted rows, I 'd like to AcceptChanges to those deleted row in my datatable. I used the following code to do that. Obviously, this code HAS problem, it changes the Collection while iterating through the collection. Does anyone know a way to AcceptChanges ONLY for rows with Deleted RowState?
**************
foreach( DataRow dr in dsMain1.Tables["LMCables"].Rows )
{
if ( dr.RowState.ToString() == "Deleted" )
{
dr.AcceptChanges();
}
}
****************
|
|
|
|
|
The quick answer is to use the DataAdaptor as follows:
myDataAdaptor.Update(myDataSet.myTable.Select(null, null, DataViewRowState.Deleted));
DataViewRowState.Deleted can of course also be changed for other rowstate based selections such as added/modified.
If you end up using these in a sequence and have related tables then note that you should also do the updates in a specific order between parent and child tables: delete child rows, add parent rows, modify parent rows, add child rows, modify child row etc.
It gets more fun if you have a whole hiearchy of tables....
Hope this helps.
|
|
|
|
|
Hi,
I want to store in database (ms-access), and display some non-English content in the web site (Arabic). The database stores the english and arabic contents in it. It will pick the respective contents on the user's selection policy.
I made changes at the ASP to make language charset as follows...
ARABIC -
ENGLISH -
And the fonts looks fine when it is seen from MS access. But when I show that in the web-site, it JUST shows as ?????.
What can be the 'missing factor' to make the arabic text look on the site.
Any tag to be added at the asp page to make the site show good with the arabic fonts from the ms-access?
Thanks in advance!
I was born intelligent
Education ruined me!.
|
|
|
|
|
I am tring to develope a source code storage app and I can't
figure out how to design the db so that code belongs to a category
of a category. Nested I guess is the word I am looking for.
If I add a category on a tree view and then add a subcategory
how do I create the db and also adding and updating.
This is my first try
one table named sourcecodeinfo and second table named sourcecode
sourcecodeinfo columns
id
category
created
updated
sourcecode columns
id
code
notes
type
the category column has one to many relation like dataaccesscode
then a bunch of code snippets that relate to dataaccess.
But what if I have a category named DataAccess and subcategory
named updates or whatever?
How is this done?
I don't want someone to do the work for me I would like to learn how
myself. I hate it when someone says provide code and thats all they
want and then someone does and then they say I need it in VB or C#.
They want people to do the work for them.
Thank You
Bo Hunter
|
|
|
|
|
You can create another table that describes categories, for example:
id - category id
parent_id - the parent category
name - the name of the category
Your sourcecodeinfo table would then reference a category ID.
- Mike
|
|
|
|
|
Well Mike I feal dummer than dumb. That is too easy.
Thank You very much.
I have done alot of sql and none of oledb
even though they are somewhat the same there
are some differences. Not that has anything
to do with this.
Bo Hunter
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
