|
I have a datagrid bound to a sqlserver table. It has 2 columns. how can i write a statement that will evaluate when i change data in a cell of column 1 and trigger the data in column 2 to change base off of the column 1 change?
|
|
|
|
|
hello,
i am in need of ODBC(C++) code that performs join (natural or inner) between 2 tables based on some condition.But i dont know where to look for. Can someone please give me some pointers or source.
(this is not my assignment!! i need to it for someother purpose and unfortunately i dont have time to learn ODBC c++ interfaces).
thanks a lot
-Ganesh.M.Ramaswamy
|
|
|
|
|
I'm not sure the ODBC library has this feature. Normally you join tables using SQL, in the statement that you pass to SQLExecDirect or SQLPrepare , or within a stored procedure (which you call using a suitable {call=procname} syntax with either of the above functions).
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
Hi
Someone knows if it's possible replicate data from a SQL Server 7 to a SQL Server 2k. I try but it's no possible. There is not a third part software to make this??.
Thanks
----
hxxbin
|
|
|
|
|
you are sorta trying to make water run uphill, why not upgrade the SQL7 server to 2K?
Power corrupts and PowerPoint corrupts absolutely. - Vint Cerf
|
|
|
|
|
Er, maybe because of the horrendous pricing model of SQL Server 2000? Most companies that use 2000 (like mine) have a mixture, and that won't change any time soon.
Regards,
Jeff Varszegi
|
|
|
|
|
Hey
I couldn't find out the exact procedure to use sql server ce in embedded visual c++. If u have any tutorials or weblink, Plz help me.
Thanks
JP
ALL THINGS ARE POSSIBLE UNTIL THEY ARE PROVED IMPOSSIBLE-AND EVEN THE IMPOSSIBLE MAY ONLY BE SO,AS OF NOW
|
|
|
|
|
Hi, gurus
I have a web method, getting DataSet with locale property set to "en-GB". My local settings are different. DataSet has columns of datetime type and I was suprised that when I get data using
DataSet myDS = goToWebMethod(...);
and
Inserting data into local DB from myDS as is
I've got permanent 6 hr difference in time !
Any ideas?
JackDotNet
|
|
|
|
|
Your server time is different from your local time?
Mazy
"Man is different from animals in that he speculates, a high risk activity." - Edward Hoagland
|
|
|
|
|
Yes, the server is remote one and client application that requests data is local one with 6 hr time difference and different locale too
JDotNet
|
|
|
|
|
So web method return time in server local. Thats all.
Mazy
"Man is different from animals in that he speculates, a high risk activity." - Edward Hoagland
|
|
|
|
|
That's nice, but it modifies the data!!!
This action is taken without asking, on the background. And what if I don't care about this fantastic feature? I just want to get what was sent to me, as is.
This looks ridiculous, don't you agree?
|
|
|
|
|
Hello all.. i need your help again.
I'm use CDatabase and CRecordSet to access to my access database.
forexample myTable have two rows, row1 and row2. row1 contains texts, row2 contain numbers
as shown below.
r1 | r2
___________
a | 1
a | 1
b | 2
c | 1
a | 1
c | 5
d | 5
d | 9
a | 3
I want only a,b,c,d from row1 not entire column, so I wrote the following code to get select the data that I want. but it still giving me entire column instead of only a,b,c,d
could you please point me out that what am i doing wrong?
<br />
CDatabase db;<br />
MyCRecordSet rs(&db);<br />
db.open.....<br />
rs.open...<br />
<br />
CString qstr = "SELECT DISTINCTROW r1 FROM myTable";<br />
rs.m_pDatabase->ExecuteSQL(qstr);<br />
if(rs.ReQuery())<br />
{<br />
while(!rs.isEOF())<br />
{<br />
MessageBox(rs.rOneData);<br />
}<br />
}<br />
<br />
thank you
|
|
|
|
|
pnpfriend wrote:
CString qstr = "SELECT DISTINCTROW r1 FROM myTable";
should be "SELECT DISTINCT r1 FROM myTable";
pnpfriend wrote:
myTable have two rows, row1 and row2
I think you meant myTable have two Columns, r1 and r2
and you want one row for each unique value in column r1
"select distinct" will do that. select distinctrow retuns all the rows that are not duplicates (all column vaues equal).
Power corrupts and PowerPoint corrupts absolutely. - Vint Cerf
|
|
|
|
|
yes.. i meant myTable have two columns, r1 and r2
i think i have to use distinctrow, since you said that
distinctrow returns all the rows that are not duplicates meaning
if i use distinctrow i will get a,b,c,d from r1 as I wanted.
anyway i tried both and it is not giving me the answer i wanted.
<br />
CString qstr = "select distinctrow r1 from myTable";<br />
rs.m_pDatabase->ExecuteSQL(qstr);<br />
if(rs.ReQuery())<br />
{ <br />
while(!rs.IsEOF())<br />
{<br />
MessageBox(rs.r1Data);<br />
rs.MoveNext();<br />
}<br />
}<br />
<br />
keeping giving me entire r1 column data.
is it because of rs.IsEOF() while loop??
is is CRecordSet will have the record of whatever record set of sql query statement executed and return??
|
|
|
|
|
The DISTINCTROW only eliminates duplicate records from the query result; it does nothing to qualify the selection. You need to include a WHERE clause in the query to define what records you want returned. Adding the clause WHERE r1 >= 'a' AND r1 <= 'd' (or whatever is syntactically correct for Access) will filter the resulting recordset so that it contains only records that meet the specified criteria. Also, specifying r1 as the only value returned is probably not what you intend - try SELECTing * to return entire records.
Will Build Nuclear Missile For Food - No Target Too Small
|
|
|
|
|
ExecuteSQL lets you send SQL-Commands to the Database directly, but it doesn't change the recordset (you can prove by examining the m_strSQL member)
to use aggregate functions and the like (sum, count, distinct, ...) you have to modify the DopFieldExchange-function:
void
CDPDCount::DoFieldExchange(CFieldExchange* pFX)
{
pFX->SetFieldType(CFieldExchange::outputColumn);
RFX_Long(pFX, _T("COUNT(*)"), m_lCount);
}
hope it helps
dirk
|
|
|
|
|
Hello,
I am encountering deadlock issues when trying updating data from a dataset to a database using an adapter.
Can anyone tell me how to catch the error 1205 exception from my C# ADO.NET code so I can rerun the transaction?
Thanks!
Best regards,
Alexandru Savescu
P.S. Interested in art? Visit this!
|
|
|
|
|
Hello
How can a sql paramter in a sql command be mapped to a coputed column in a data table?
Thanks In Advance
|
|
|
|
|
First up, you can't set a computed column's value (unless, I think, you write an INSTEAD OF trigger).
If you want to set an output parameter, you need to set it in the body of your statement. I normally do this from a stored procedure - I'm not sure that you can use output parameters with a literal SQL statement.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
Hi
Thanks for ur reply..BUT..i am talking in the context of ADO.NET not SQL Server.
I am trying to map sql command parameters of a sql command object to columns of a data table to update the table back to the DB.
It seems that ADO.NET does not allow such a mapping to COMPUTED columns (data columns with thier EXPRESSION property filled)
is there a work around?
|
|
|
|
|
hello ...
I have a big problem with an application.
with this application i have to open an access file on a server somewhere in the net.
the clients use my app to open this access-file.
i used ODBC, i use DAO ... but always there must be something installed on the clients that i can open the access-file (mdac, jet,...)
but i need a solution where i can start the app-exe on a naked client (no installation of jet before). it is ok, if dll's are in the app-directory ...
how can i do this ??????????????????????????????????
P.S. the database must be a file ... no server ...
|
|
|
|
|
You are out of luck, IMO. you will have to install at least MDAC & Jet on the client.
Power corrupts and PowerPoint corrupts absolutely. - Vint Cerf
|
|
|
|
|
des hätsch dir auch so sagen können (und ich glaub des hab ich auch schon
|
|
|
|
|
HI Friends,
I have installed two instances of SQL server on my machine.First one is default installaion and second instance is going to be Named Instance.I want to access the named instance of the SQL server through access workflow 2000.Is it possble ? If not how?
VikramS
|
|
|
|