Posts by debasisdas

You cam also use FileSystemObject.

lock the server to restrict what ?

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 this , may help you.

This may be helpful to you.

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

add this to change event or lost focus of the text box.

if vaL(txtr.text) > 32767 then
msgbox( "out of range")
end if;

You need to use GROUP BY clause in your query.

Lets see the code that you are working on.

which user you are talking about ?

is it application login user ,database user or windows user ?

try this way

select distinct f1,f2,f3 from
(select distinct f1,f2,f3 from table1
union
select distinct f1,f2,f3 from table2
)

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

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

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

if the images are in net what is in database ?

try this

select EmpID,EmpName from Emp order by EmpName

Hi Lyandor,

Welcome to Daniweb.

Hope you have a nice time learning new things here.

Use distinct.

where the images are stored in what format ?

Please check here and here.

database does not fetch it only stores.

This is useful to you.

how are you generating those random numbers.

Hi,

Welcome to Daniweb.

Lets see the query that you are working on.

i think you said you want to find the highest block_id

then why using max(unique_id)

you need to update the records.

Please read more here and here.
Also check this.

Read this.

How you populate the grid ? is it not from recordset ?

dtATG.Rows.Add(i)

in the above line you need to add column values not the for loop counter.

have you opened the record set ?

I think that should be available under property pallet of the toolbar control.

I think that exceeds the max value allowed.

Rediscovering the wheel sounds great but actually is not a good idea.

Donate $5 to daniweb and you will know all the secrets of this universe that is not visible to mere mortals. :)

please check this.

if that doe snot work you need to use some 3rd party control.

This may help.

that can be done using a view also.

If you have Hugh records, the insert into temp table will take a lot of time.

if you are simply selecting from other tables , why need to store the result set.

What is the connection string that you are using.

why not use a view instead.

I dont understand the code. No where in the code mentioned to insert the image

SavePicture()---does that for you.

as i said this only a sample and is not fully customized to cater to your exact requirement.

first insert a record into database without he document and then modify the code in the link.

your procedure contains only the SQL , and nothing else ?

have you tried for those file formats ?

What worries you masters you.

So what are you doing after that SQL query ?

Please read this and this.

these are sample codes only.

can you access your centralized server from all the 5 branches ?

internet is not required, you can work on a centralized DB with your intranet.