Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. yakata

    select the last modified line for each item

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

    Trigger... or not trigger ?...

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

    A script that runs when SQL Server is started...

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

    A script that runs when SQL Server is started...

    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 :)
  5. yakata

    Insert and Delete Triggers from only one transaction

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

    Insert and Delete Triggers from only one transaction

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

    newbie... Server has not yet been opened... SQL

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

    Printing Multiple Page report through web.. .net

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

    Aaargh ! Objects disappear from webform...!!

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

    Aaargh ! Objects disappear from webform...!!

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

    Mixing sound channels idea ?

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

    Mixing sound channels idea ?

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

    Preventing multiple login with the same roaming profile ?

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

    Shared tables dramatically slow !!

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

    Reference in a project for "Folder" type ?

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

    Reference in a project for "Folder" type ?

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

    Passing GUID from Sql server 2000 to VB?

    Hello, Chip, You deserve a nice day !-) Done what you suggest, works fine, great help ! Thanks Yak
  18. yakata

    Passing GUID from Sql server 2000 to VB?

    Hi, Chip, And thanks for the idea :-) But well, do an insert followed by a select to have the last Guid inserted is what i tries not to do... But if there is no other way, well .-( By the way, what do you mean in an 'out' parameter ? TIA for a reply Yak
  19. yakata

    Passing GUID from Sql server 2000 to VB?

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

    Uploading files to a Web Server using FTP

    Sounds great !)) I'm interested too ! I've tried to do the same, dealing with return messages, ftp block size variation, but not a success at this time...( Please, send me a copy ;-) TIA my email : lthunissen@rtl.be yak

Part and Inventory Search

Back
Top