Search results for query: *

Hi all, Please find my table named 'login' i have somewhere around 150 users active at any given point of time. presently i am using text datatype and storing the user login and password [lgpwd is password field]. 4-5 more people access the database and they are filtering out the password. I...

Hi All, I need some output like lemme explain an employee min work hours are 8 hrs. like that 40 employee. i want the total work hours by multiplying both the fields. Can any one please help me. Regards John PHilip *** Even the Best, did the Bad and Made the Best *** John Philip

Hi, I have the following query , it is consuming more than 6 mts to retieve the result, i want to make it faster retrieval. Query is fetching results from views , which in turn consists fetches only distint records. Due to the non-unique feature of the data, i cannot relate the table with the...

I am using a MSgraph to show soem data in graph. it has two columsn and one row. max value in any of the row is 800, but myu graph is showing 1200 and more. Is there any problem with the graph control. i have printed the data value, it is passed correctly, i dont know where the change is...

HIi all, Please find thee sql stmt: 'Select code,Name from class order by code' In resultset i get dupliacte records only the code is duplicating the name field is different. i want keep only one record of the two; if code '4' has two records then i need only one of them. so the code field is...

Hi all, Please see my SQl stmt ------------------------------------------------- Select contract,company,from_date,pin,feedback, cast(feedback as datetime) as a2, 'Status' = CASE WHEN cast(feedback as datetime)> getdate() THEN 'Active' WHEN cast(feedback as datetime)...

Hi , I have made the Graph for the report . Graph is Displaying fine. Now i want one more addition to the same, i want the values be displayed also Can anyone have some input to this. Regards John Philip *** Even the Best, did the Bad and Made the Best *** John Philip

Hi all, Please take the following query: Select date as Dt1 ,convert(smalldatetime,date,110), count(*) from feedback where TAg='L' Group by Date Order by date ----------------- I am using the convert but it snot converting, field name is 'Date' i am forced to do this, since it is imported from...

Hi all, This is very odd thing happening or happend to me. like i received and email from man@xyz.com and i click reply button and reply. reply mail comes back to me. I dont know how its happening any clue to this. Regards John *** Even the Best, did the Bad and Made the Best *** John Philip

Hi all, I have more than 200 dbf files. I tried DTS but in date field it is failing. so next option available is to make a utility in vb to import all these into sql database. i want code some thing like pick each dbf and insert into sql. Kindly please guide me in these. regards John ***...

Hi all, sorry for posting this here, because less response in sql server forum. ----------------------------------------------------- error at destination for rownumber 1 errors encountered so far in this task: 1. insert error, column 8('ent_date',DBTYPE_DBTIMESTAMP), status 6: Data overflow...

Hi all, i have some where around 273 foxpro tables. Now my company decided to import to sql server. is there any single method to import all the dbf structures to sql server and create the correponding tables in sql server *** Even the Best, did the Bad and Made the Best *** John Philip

Hi all, well i am trying to import foxpro files to SQL server. I can use DTS, fine but only hinderance here is the files extension remain as '.smi', so when i create a DSN with visual foxpro driver, it will not detect these files. I can write a VB application that will consume hours...

Hi all, i have following piece of code, I am trying open a text file and put in a string *************************************************** Dim strMailMessage As String, FSO As FileSystemObject, F Const ForReading = 1, ForWriting = 2, ForAppending = 3 Set FSO = New FileSystemObject...

Hi all, TrnkDt rnktm fld10 fld5 03/01/2004 00:05 2465 24 03/01/2004 00:10 760 26 03/01/2004 00:15 1489 12 03/01/2004 00:20 1158 17 03/01/2004 00:25 592 17 03/01/2004 00:30 1297 10 03/01/2004 00:35 1710 9 03/01/2004 00:40 2211 12 03/01/2004 00:45 546 17 03/01/2004 00:50 275 12 03/01/2004 00:55...

HI all, I have datagrid, it has too many columns so will not fit into a screen. what i have decided is to display the column caption in a label under mouse move event, but then also user have to click on the column then only it is displaying the caption. can u please give me a solution to this...

Hi all, I have DTpicker control, i want to set the minutes interval to 5 minutes, format will be like HH:mm, no seconds is dsiplayed there. can any one please help me in this Best regards JOhn Philip *** Even the Best, did the Bad and Made the Best *** John Philip

Hi all, i have a field 'fld3' it has the following value as '200403010005' in string format; this is used in access database. I want to put th edate to 'dt1' field and time in 'tm1' field, with a single upadte query, can any one please help me. Regards John *** Even the Best, did the Bad...

Hi all, I am using office controls in Vb project . Now it is working fine except that in some times it throws and error like: ' caused and invali dpage fault in module fm20.dll ' and soem binary numbers. can any one help me with a solution to the same. Regards JOhn *** Even the...

Table customer Custid CustName 1 emp #1 2 emp #2 3 emp #3 4 emp #4 5 emp #5 6 emp #6 7 emp #7 Above is the customer table each time the user browes the tabel, a record # is stored in 'Table2' next time when the user starts the browsing the table. it should start at next record. if the...