|
we have 2 databases with phpmyadmin v5.5.31 and we want to convert data from the one to the other, so we are in need of a converter that will fix the difference of tables
is there any one who could give a hand to that?
thanks
|
|
|
|
|
Red-Gate SQL Compare works with SQL Server not sure what your DB is but it may be compatible.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello..can anyone help me on this.
I want to insert data based on the dropdownlist value. This is my database sql.
SELECT TOP (200) Actuators.id, Actuators.ActuatorInfo, Actuators.Fan, Actuators.Date, Actuators.DeviceId, Actuators.House, Actuators.DateView
FROM Actuators INNER JOIN TDevice ON Actuators.DeviceId = TDevice.id INNER JOIN TMushroomHouse ON TDevice.MushroomHouseId = TMushroomHouse.id
If I want to insert data DateView into table Actuators, based on the dropdownlist for mushroom house name, how I can inner join with table TDevice and TMushroomHouse.
For example:"Insert into Actuators(DateView) Values (@DateView) INNER JOIN ..."
|
|
|
|
|
There is no "join" clause on the insert-statement. You'd insert the values you need, so I doubt you need to join any lookup-table in there.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hi,
I don't understand what exactly you want to do, but there are two ways to insert data:
1. Insert values.
INSERT INTO Table1 (Column1, Column2)
VALUES (@Value1, @Value2);
2. Insert from table/tables.
INSERT INTO Table1 (Column1, Column2)
SELECT Column1, Column2 FROM Table2
WHERE Column1 = @Parameter;
or something like
INSERT INTO Table1 (Column1, Column2)
SELECT t2.Column1, t3.Column2 FROM Table2 AS t2
INNER JOIN Table3 AS t3 ON t2.ColumnID = t3.ColumnID
WHERE t2.Column1 = @Parameter;
Best regards,
Andrius Leonavicius
|
|
|
|
|
Hello..i want to ask question.
In my database there is a column for Date such as below:
2014-03-26
2014-03-25
2014-03-24
Does anyone know how I want to retrieve data value from a previous row with select statement.If I want the latest data, so the sql is like this ORDER BY Actuators.Date DESC";and the answer I get is 2014-03-26. But if I want to show the previous data value from previous row what can I do?The result will show date 2014-03-25. Tq
|
|
|
|
|
Which database system? SQL Server 2012?
You want to get the second highest? Or both the highest and second-highest in one row?
You'll never get very far if all you do is follow instructions.
modified 23-Apr-14 13:12pm.
|
|
|
|
|
Database system is SQL Server 2012. I just want to get the second highest in a column Date.
|
|
|
|
|
You could use ROW_NUMBER and select the one with a value of 2.
Or something like:
SELECT TOP(1) * FROM (
SELECT TOP(2) StartTime FROM dbo.RunSummary ORDER BY StartTime DESC
) T ORDER BY StartTime
Neither seems very elegant.
You'll never get very far if all you do is follow instructions.
|
|
|
|
|
Tqvm 
|
|
|
|
|
Syafiqah Zahirah wrote: what can I do?
..SELECT TOP 2
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
yes..it working! 
|
|
|
|
|
You try to do this by the following code:
select max(Actuators.Date)
from table1
where Actuators.Date<(select max(Actuaors.Date) from t1);
i hope it can help you.
|
|
|
|
|
I'm not sure if this is even possible. I'm trying to create a auto increment column for FID in this database file.
I was going to use SQL Server Express, but decided to just stick with the same format of the original program Account Mate for DOS, running low on quoted time for the project.
Any insight would be appreciated!
Dim m_path As String = Nothing
Dim dwXCode As Integer = registry_shared.read_HKCU_dataPath(m_path)
Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & m_path & "; Extended Properties=dBASE IV"
Dim queryString As String = _
"CREATE TABLE ARCEMJN " & _
"(" & _
" FID AUTOINCREMENT " & _
" , FINVNO VARCHAR(10) " & _
" , FCUSTNO VARCHAR(10) " & _
" , FTRANSDATE DATE " & _
" , FCONTACT1 VARCHAR(80) " & _
" , FEMAIL1 VARCHAR(254) " & _
" , FSTATUS BIT " & _
" , FERRCODE VARCHAR(10) " & _
" , FERRMESS VARCHAR(80) " & _
" , FPDFPATH VARCHAR(254) " & _
") "
|
|
|
|
|
Some info[^] on how to use AutoInc fields in dBase.
Sorry, forget that, wrong version.
modified 23-Apr-14 1:45am.
|
|
|
|
|
Did those exist in DBase IV?
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Oh bugger. I forgot to check the version.
|
|
|
|
|
I am developing a windows form application using c#. I want to connect to sql server 2008 which is in the server using windows authentication. Can anyone please provide me the connection string?
Note:
1. domain is created in my server.
2. Remote access is enabled for the sql server
3. TCP/IP port is also enabled.
Please help me. I am struggling for this since 3 days.
|
|
|
|
|
|
Hi,
I am currently using DevExpress Reports. I just wanted to know if anyone used RDLC?
Would you recommend it?
Thanks,
Technology News @ www.JassimRahma.com
|
|
|
|
|
RDLC is the embedded version of SSRS. We have used these extensively in winforms and asp environment. There is no Silverlight RDLC viewer (well there is on but it is bloody expensive). We use the server version for our enterprise reporting needs.
SSRS is one of the premier reporting platforms, but then so is DevExpress!
Just don't get involved with crystal reports spit
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
who's using crystal reports now! 
so let me ask you if you had to choose between DevExpress reports and RDLC, which one you'll choose and why?
Also let me tell you about my scenario..
I am using MySQL backend with WinForm and from application, I want to allow the user to design their own reports or change existing reports using report designer.
Thanks,
Jassim
Technology News @ www.JassimRahma.com
|
|
|
|
|
I would choose RDLC but only because of familiarity. Possibly the support and examples may be more widespread.
While I have deployed the report designer (many years ago) in 2 organisations they were NEVER used, the users always came back to the developer (me) to build the reports. The closest I ever got to user design was where they would dump a set of data to excel, fiddle with it and then get me to build the report.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Great..
Thanks Mycroft 
Technology News @ www.JassimRahma.com
|
|
|
|
|
I've never worked on these old dbase/clipper database files for Account Mate DOS, and I'm having trouble with multiple joins. Says I'm missing a arithmetic operator in the statement. I can't find a reference to study to get an idea of how it should be written. I really don't want to make 2 calls, because it really slows down the load time.
This is the error message
Syntax error (missing operator) in query expression '(c.FCUSTNO = a.FCUSTNO) LEFT JOIN ARCEM01.dbf e ON (c.FCUSTNO = e.FCUSTNO)'.
"SELECT c.FINVNO, c.FCUSTNO, c.FCOMPANY, c.FSALESPN, c.FSHIPVIA, c.FORDDATE, c.FSHIPDATE, c.FNTAXAMT, a.FADDR1 " & _
"FROM ARINV01.dbf c " & _
"LEFT JOIN ARCUS01.dbf a ON (c.FCUSTNO = a.FCUSTNO) " & _
"LEFT JOIN ARCEM01.dbf e ON (c.FCUSTNO = e.FCUSTNO) " & _
"WHERE c.FORDDATE=@startDate"
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
Hangover? Last 3 days're holidays.