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

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

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

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 All I am new to triggers usage and this first time I am in need to write a trigger (I am developing a application in VB.NET 2010 and MS SQL Express 2008 R2). Would really appreciate if some one can help and guide in this. My need: I have two tables Now, I insert a row through user in...

Dear All, I am into trouble while reading .csv file having spaces. I am reading csv file with below code; SAMPLE INPUT FILE: AAAA,43438894322,USA,BASIC BBBB,73738 9393 939,INDIA,BASIC CCCC,00293993020,UK,PREMIUM all is well until i get any file with data having space like 01 0002 020929...

Hello All, I trying a Function to Validate a Field data before passing it to the Process. Validation Details Example; Field1 = Validation [Max 20 Characters Per Line x 1 Line] Field2 = Validation [Max 15 Characters Per Line x 3 Lines] Requirement Details: StringExample : Validation [Max 20...

Dears, myTable ID Name Details 1 XYZ CAT BAT RAT MAT 1 XYZ ANY MANY 2 MNO TEN PEN HEN 3 ABC ONE TWO THREE FOUR 3 ABC MATTER CATTER CHATTER 4 XYZ FAT CAT CHAT 5 XYZ AN PAN CAN 6 NNN CAT ANT PAT If I search with 'like' on...

I need a Stored Procedure that reads a text file and give the text as output; I have one in MS SQL that works well; can anyone help in converting that into MySQL Stored Procedure. I will be passing the Full Path of the File as parameter. /****** Object: StoredProcedure [dbo].[readTextFile]...

Dears, I am using VB6 and MS SQL 2005. I need to generate Unique ID for each records (due to some manipulations required later I cannot use Auto ID's) currently I am using SELECT Max(trID) as maxID FROM trData which works well until other users would Press SAVE at same moment, so what would be...

Dears, I am using MS Access Form - MS Access DB - PDF ActiceX Where I have a table from where I am getting the record values and path of pdf. Then I load this PDF into the PDF Viewer. All works well till now; but then when there is any file physical file missing then I am getting the "File does...

Dears; Greetings I am new to Indexing; I need a help in indexing this table for better search I am using ms sql2005; and this is my table structure; Table Name: trData Column Name Data Type Allow Nulls trID numeric(18, 0) NO trProfileID int NO...

Dears; Greetings I am new to Indexing; I need a help in indexing this table for better search I am using ms sql2005; and this is my table structure; Table Name: trData Column Name Data Type Allow Nulls trID numeric(18, 0) NO trProfileID int NO...

Dears; Greetings I am new to Indexing; I need a help in indexing this table for better search I am using ms sql2005; and this is my table structure; Table Name: trData Column Name Data Type Allow Nulls trID numeric(18, 0) NO trProfileID int NO trCategoryName nvarchar(50) NO...