Search results for query: *

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...

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 :)

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

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)...

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...

Hi there, I use a Folder data type in a project, but each time in try it , I receive a 'User defined data type not defined', typically a reference missing in the project... but which one ?... Or am I wrong ? TIA for any help !) Yak

Hi to all, I'm using a stored proc to insert recs into table in SQL 2000. One column of the table is Uniqueidentifier and rowguide. When i insert, it creates a GUID value in that field. Now I want to have this Guid available to insert it in a new line in another table. I use @@identity in...

Hi there !) I try to explain, clear and short.. I intend to use an app which open a file when you click on an icon of the file. But... My app knows the last path to the file (stored in a db).. and from time to time, another app is moving the files, from one server to another (logging his moves...

Hi there, Got a problem ;-( I need to seek a directory to find out new subdirectories as soon as they are created. I use a list box to diplay on screen the content of the 'master' directory and make a "do while" loop, waitin for new directories. When a new one is created, it is not...

Hi to all, Is it possible to download a file from a server in Binary mode with INET ? And if it's so, what's the command to switch from Ascii to Binary FTP mode ? Thanks alot, I've tried everything (see my previous post), and I'm certainly missing something...(( Regards, Luc

Hi there, I've got a problem with INET. I have to get file in FTP from a Unix server. The files are named "std", "ft" and "header" without extension. I need to get them in Binary mode... I've tried this Private Sub cmdGET_Click() Dim b() As Byte Dim strURL...

Hi there, Let me explain : I'm working with Foxpro for years, now I use 2.6a patched (using a PIII). All works fine in W98 and i upgrade to win2k. Everything runs smoothly for a few weeks. One day, I tried to launch Foxpro, sign on screen came, white window appeared half of a second... and all...