Search results for query: *

Hi try this INSERT INTO Destination(f1, f2, f3, f4) SELECT s.f1, s.f2, s.f3, s.f4 FROM Source s LEFT JOIN Destination d ON s.f1 = d.f1 and s.f2 = d.f2 WHERE d.f1 IS NULL HTH

Hi for the first question try this DECLARE @usercount INT SELECT @usercount = COUNT(*) FROM Activity IF @usercount > 0 BEGIN -- your script ELSE --- notify user END

Hi it should be @variable = field not field = variable HTH

Hi An easy way to do this is to use the hWndDisplay property of the control. set this to a hWnd of a form in you app bofore playing the movie. MMControl1.hWndDisplay = form2.hWnd Now the movie will be displayed in form2. now you should be able to resize the form HTH Chamindu

Hi Can you post the code where you insert a record.

Hi If i get what you are trying to say ..... if you dont give an alias to the field then you can access it using oRS(0).Value or you can alias the field SELECT MAX(nroconsulta) AS nroconsulta

But you dont need a database here. If you use a database every time you create a HTML file you have to add a record to the DB. But if you use a FSO approach you can just create the HTML file drop it in the specified folder and thats all. HTH

Hi You can use the FileSystemObject to enumarate all the files in a folder and also you can use it to open and read your HTML files.After that creating the link will be very easy HTH

Hi you only have to create a single recordset using a group by query. Here is an example you can run on a SQL server it uses the pubs sample database select j.job_desc , count(e.emp_id) AS NoOfEmployees from employee e inner join jobs j on e.job_id=j.job_id group by j.job_desc this query will...