debasisdas

Lets see the query you are working on, to solve your assignment.

try this [CODE]SELECT * FROM block WHERE name LIKE '%q test''yes%' ORDER BY id DESC[/CODE]

Outer join should work for you.

I don't see any relation between 456 and 4:56. I you wan to separate, can simply split using a delimeter.

Then you need to hire a developer who will do all that for you, as that seems to be a paid job. As we do not write code for others home works / assignments, you need to show some effort to get any sort of help here.

First of all why you need an additional textbox control on the form when you already have the Dt Picker in place.

Do you know how to take BackUp of SQL Server database using script ?

I think that exceeds the max value allowed.

If you have and understand the source code then go for it. But i am not sure if VB 6 supports all that implemented in the C++ class.

What about reading the file list from 1st directory and storing somewhere (may be in an array), and later read from second directory and check the same in the array. If it exists store in another array and proceed.

They are different ORDBMS from different vendors.

I think you do not need the HAVING part of the SQL.

Simply you can try to ping the system using its IP or system name over LAN.

You have to do it yourself.

Let me understand first what exactly you mean by [B]last record[/B]. Last as per what ?

Why not do all the calculations are database level.

Try this [CODE]Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load My.Computer.Registry.LocalMachine.OpenSubKey("SOFTWARE\Microsoft\Windows\CurrentVersion\Run", True).SetValueApplication.ProductName, Application.ExecutablePath) End Sub[/CODE]

You can store either way 1. Convert the file into a binary stream and store the same in DB as BLOB. 2. Store the physical path of the file as a string in the DB. Both as its own pros and cons.

Hi Heather, Welcome to Daniweb.

Database must be installed on the machine before deploying any application that is using the DB.

What is the logic for Eat and Don't Eat ?

You need to read [URL="http://www.amazon.com/Programming-Microsoft-Visual-Basic-6-0/dp/0735605580"]books[/URL] for all that.

You need to run the [B]EXP[/B] utility from the user account.

As [B]smantscheff[/B] mentioned you need to pull the records from DB by using joins between your dependent tables. Better to use some external tool to populate the tree.

what exactly you are trying to do ?

You need to write a validation function for that and call the same in the lost focus of the control.

simply, by writing some code that works for you.

Hi Alex, Welcome to Daniweb.

in VB 6 or in .NET ?

Select the MAKE EXE option from file menu in VB 6 IDE.

Try using CommonDialogControl.

Hi, Welcome to Daniweb.

[QUOTE=blocker;1602784]where did quickbooks get the grid? did they create it themselves or just buy it from a commercial publisher?[/QUOTE] That quickbooks only can tell. [QUOTE=blocker;1602784] Are there also any commercial or type of combo box like quickbooks that has multiple columns? [/QUOTE] You need to use some 3rd party controls …

What you need to use is proper key words for search, will will always hit what you are looking for.

You cam also use [B]FileSystemObject[/B].

Lets see your code that you are working on.

[URL="http://www.codeguru.com/forum/showthread.php?t=367911"]This[/URL] my be helpful to you.

lock the server to restrict what ?

which user you are talking about ? is it application login user ,database user or windows user ?

You need to use GROUP BY clause in your query.

1. clear the control. 2. refresh the recordset from database. 3. populate the control.

Let me understand for which date you want to fetch the data.

That can also be done in a simple for loop.

Displaying all the files of a directory at one place does not make any sense to me. Try using DriveListBox, DirListBox and FileListBox Control. Check [URL="http://basicprograming.blogspot.com/2009/10/using-drivelistbox-dirlistbox-and.html"]this[/URL] , may help you.

how i will know what data is in the .csv file

try this [CODE]select EmpID,EmpName from Emp order by EmpName[/CODE]

how are you generating those random numbers.

Let see your code, how you have done all that.

database does not fetch it only stores.

Please check [URL="http://www.lvr.com/serport.htm"]here[/URL] and [URL="http://www.dreamincode.net/forums/topic/37361-serial-port-communication-in-vbnet/"]here[/URL].