Search results for query: *

Dear Experts, I am using VB.NET 2010 (Visual Basic), MS SQL Server. Polaroid P5500S ID Card Printer will be used to print this ID Cards. I am struck at point in my application where I need to design and print ID Cards (where ID Card information is coming from MS SQL Database). I am doing all...

Dear Experts; I have a table for the data storing of treeview. Now, the challenge is I need to get the full path of a node without using treeview; how to achieve this I am bit confused, any help will be highly appreciated. So, lets say I pass a node name and function returns me entire path...

Thanks ingresman for detailed reply, but the question they have asked is for a Desktop Client Application. And it's data passed on network. Best Regards, Sam

Sure thanks a lot George, That's why I am taking sometime to understand what and how its doing before I put on live. Best Regards, Sam

Thanks George for all the efforts, will need some time to think over it and understand :) Surely get back to you .. thanks again Regards, Sam

Thanks George for your kind review, Currently there is only one button that allows to change this status for jobMaster table; also jobID is unique id so only one record will be updated in master. And I am only changing two field values where one value is just keeping the last value track from...

Final got it working :) May Help Some1 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER [dbo].[jobMasterDetails_trg_Upd] ON [dbo].[jobMasterDetails] AFTER UPDATE AS Declare @updatedjobID int = (SELECT jobID FROM inserted); Declare @totalTaskCount int Declare...

CAME UP WITH THIS TRIGGER NOW TESTING .. CREATE TRIGGER jobMasterDetails_trg_Upd ON jobMasterDetails AFTER UPDATE AS Declare @updatedjobID int = (SELECT jobID FROM inserted); Declare @totalTaskCount int Declare @completedTaskCount int BEGIN SET @totalTaskCount =...

Dears, I have one two tables jobMaster - [jobID] - [jobStatus] jobMasterDetails - [jobID] - [jobTaskID] - [jobTaskStatus] jobMasterDetails contains multiple task against jobID present in jobMaster. Once every Task Completes the [jobTaskStatus] is changed to '10' or '11' for Cancelled. Now...

thanks philhege :) that looks like it may come helpful in some dire situation .. :)

Ok, thanks notadba. We were also thinking on the same line, and felt that it can only be judged after application development is done. They are just trying to harass by asking such baseless questions before even developing the application .. anywayz thanks again, Best Regards, Sam

Dears All, I am in fix one of client has asked for what size of data bandwidth usage application eat up. Can some one help me in this? its a just simple transactions like a search a db and display simple row of data. but some time it may need to return multiple rows of data but each row will...

Any 1????

nobody .... [neutral]

Dears All, I am in fix one of client has asked for what size of data bandwidth usage application eat up. Can some one help me in this? its a just simple transactions like a search a db and display simple row of data. but some time it may need to return multiple rows of data but each row will...

Dear George... Please accept my heartiest thanks.. [bigsmile] Its working as i wanted it to ... can't thank you enough for the kind support .. Thank a Lot .. Wish U All the Success..!!! Best Regards, Sam

YES, it will keep adding no deletions .. now the table will have 15 records. 10 AGAINST D & 5 AGAINST C. So, the serial may be repeated again .. may be same serial 11..12..13..14..15 ...(doesn't matter).

Something like this Best Regards, Sam

Appreciate your kind help; Sorry George, I feel I missed one point here see there may be Repetition of numbers as their is a Prefix so its not always a serial to start form and end. So I just need to add a serial no between the Master Start and Master End Serial No Input. SO something like if...

Thanks George for spending sometime on this. Will not be allowing to update, they will have to delete the old Master Entry Yes, the old entries will have to be deleted. I plan to delete this entries with simple delete query, if the Master entries are deleted. Actually this range may vary...