Recent content by yakata

Hi there, So stupid I think, I just have a table with a list of devices and the date of their last check. I need to list only one line per device which is the last check date. Help me, i'm stuck, tryin to use max but I can't figure out how to deal with the distinct and group by clauses... TIA...

Hi there :) I'm using a trigger to detect changes into a value in a table, let's say 'Status'. My trigger gives 'if updated(Status)...' The crazy (not mine:)) application that is changing the Status is sending first of all a value of '0' then a status of '1', sometimes a hundred of times, and...

Cool, ClaireHsu :) Exactly what I nedd, have a great day !) Thanks

Hi there, I'm just looking for a way to 'auto' execute a stored proc when a sql server is started on my server... Actually, I need that this sp is executed BEFORE any other command or transaction is commited to the server... SQL 2000 Any Idea ? TIA for a reply :)

Thanks SamGarland ! Appreciate your explanation, it helps me to understand that the insert trigger on the table can't never give me infos on the deleted table... But it doesn't help me to solve the issue immedialtely... Let me be more precise... First of all, my triggers are sending message...

Hi there :) Just working on a tool that will capture some events in the DB(sql server 2000) of one of our supplier to launch some process (restore of files, for ex.) in one of our internally developped tool... The case is this one : i've a trigger for insert on a table, a trigger for update and...

Hi there !) Using CR8.5 in VB 6.0 connecting to a SQL SERVER 2000... Just a little report taking data from a view. I use the CR8.5 standalone designer to design : execute without any problem. In VB, I insert a CR component using 'existing report'... works... from time to time... I try to pass...

Hi there, I'm using .net and wish to print a Crystal Report with multiple pages. Have designed the report but when I launch a print, i have a preview page which is showing only the first page... How can i go through this ? TIA for any idea !)) Luc

Thank you for the input... I've investigated, the Zone Alarm problem exists on one machine and I'll try to disable it. But other one doesn't have ZA, I try to type the next adress but it depends on the data from the loggin then impossible to do so, the machine gives you the loggin form back...

Hi there, really strange behaviour ! I've made an application with webforms : first, a login form, then a webform with some datas related to people that have logged.. On some machine (IE 6), the login form is displayed correctly, then when login is validated, a blank (without any object)...

Thanks, I tried your suggestion, johnnyv , but no settings possible through their tool :(

Hi there, Searching for a way of driving the left and right channels of a sound card to let them play in mono but with a level control of each in the mix... In other words, have a file with different sounds in the left (sound effects) and right channel (comments) and need to mix them in a way...

Preventing multiple login with the same roaming profile ? Hi there, we do have implemented in our company the roaming profiles (nt 4 server, win2k wks). From time to time, we do have problem with users who don't log off and connect themselves with their profil from another machine... Of...

Hi there ,!) Got a problem with a shared table : this one is seen by one application that show the content of the table into a browse window (child of another screen) and is also used by another application which used the table to populate arrays. When the 1st application is down, the 2nd one...

Oups, found it ... by myself, sorry for disturb..) It's shell objects and automation (shell32.dll) Keep nose in the blue !)