i have developed a single user application in foxpro 2.6.How can i use it as multiuser application on a local network.What commands should i use so that each workstation can acess data stored in d drive of server.
Answer Question | July 17, 2009 12:47 PM
FoxPro, FoxPro 2.6
How I secure my data
Answer Question | August 25, 2009 10:41 AM
Database administration, Database management, RDBMS
i have a directory containing 1000s of photos which i have to upload into oracle 9i db. i need to use only sql plus for this. i want a simple material to upload all those photos..
Answer Question | July 17, 2009 10:40 AM
Image databases, Oracle image storage, SQL, SQLPlus
Hi, I have an sql query which takes 8 seconds in the first run. The next run there after takes 0.5 seconds and all consecutive runs take 0.5 seconds. Is the plan getting cached? How do i make this query run in 0.5 second in the first run itself? Please find the query below. select [...]
Answer Question | July 24, 2009 10:15 AM
SQL queries, SQL query optimization, SQL Server 2005
how can i get ExecuteXmlReader() in OLEDB? i used sql server databse in my project. but now i want to change it to OLEDB. but ExecuteXmlReader() is not in OLEDB. what can i do to solve this? pls reply.
Answer Question | July 17, 2009 5:22 AM
ASP.NET, ASP.NET 3.5, ExecuteXmlReader, OLE DB, Web development, XML
I have to intergrate a third party product that uses an MS Access database with my AS/400 machine and be able to both update the Access data as well as read data from the Access database to use on the 400. Does anyone know how I can do this?
Answer Question | August 15, 2009 5:01 PM
iSeries RPG programming, Microsoft Access, RPGLE
hello expetise , myself being a student of 3rd yr computer engineering , actually i m not good @ language so suggest me course detials in network or system management ,what kind of basic should i have that will help me in course + referr me some books online to bulit my base? , hope [...]
Answer Question | July 24, 2009 8:12 AM
IT careers, Network administration, Networking careers, Systems administration
The title of the switchboard changes to the title of one of the items. I can’t figure out why.
Answer Question | July 17, 2009 3:22 PM
Access 2007, Access Switchboard, Microsoft Access
hi which certification done is to be better either Oracle or Red Hat Linux? I dont have interest in programming so Is Administration is only field for me? please guide me Thanks
Answer Question | September 4, 2009 7:19 AM
Certifications, IT careers, Linux certifications, Oracle certifications, Red Hat Enterprise Linux
I want to select a row from the parent table based on whether there are two or more rows in a child table. What is the best way to do that?
Answer Question | September 2, 2011 1:01 AM
SELECT statement, SQL, SQL queries
We are trying to write a program that will take the output of a report, & put it on a CSV file. This file will the be sent via email to user(s). Please provide with steps to accomplish this including foldersetup, etc.
Answer Question | August 18, 2009 9:47 PM
AS/400 CSV, AS/400 import/export, CSV format, OS/400, V5R1, write csv file AS400
I remember in Access 2000 you used to be able to import an external document and use it as a Access form after overlaying the table fields. We use a “User Request form” that I would like to use but I do not see where or how to accomplish this with Access 2007(??) If this [...]
Answer Question | July 14, 2009 2:46 PM
Access 2007, Microsoft Access
hello, help, i have a access database with menu items–id, food items, description, price. with vs2008 i have connected to this database. and displayed on a aspx webpage using gridview, i can manipulate it with certain sql statements showing only certain things from the database, but the headings of the titles keep showing this is [...]
Answer Question | July 13, 2009 4:27 PM
Access Database, Microsoft Access, Visual Studio, Visual Studio 2008
when i run below all SQL Query simulataneously against 1500000 Rows its take 10 minutes i put the non-clustered index on the columns TATCallType ,CallTo the data type of both columns is varchar select ID,AuditMaster_ID,CallTo,CallTypeTag into Auditdata_callto from auditdata where AuditData.TATCallType is null and substring(AuditData.CallTo,1,convert(int,0))=” and len(AuditData.CallTo)=10 select ID,AuditMaster_ID,CallTo,CallTypeTag into Auditdata_callto from auditdata where AuditData.TATCallType [...]
Answer Question | July 14, 2009 10:00 AM
Slow SQL Query, SQL queries, SQL query optimization
Plz let me know the procedure to bring the controls of Crstal Report 2008 in VB6? What control has to be select and what coding should be use for the same??am using sql 2000 as a back-end.plz help..
Answer Question | July 14, 2009 9:28 AM
Crystal Reports 2008 controls, Database connectivity, SQL Server 2000, VB 6, Visual Basic 6
Hi, I’ve been working as an AS400 Professional in one of India’s largest MNCs for the past 2 years. Now i have a chance of shifting into MAINFRAMES in same organization. Most of my friends telling me that MAINFRAMES had lot of opportunities compared to AS400. Can anyone please suggest me how bright AS400 would [...]
Answer Question | June 17, 2011 8:42 AM
AS/400 careers, Career development, IT careers, Mainframe
i write the following Query to execute against the 1500000 in SQL Server 2000 DECLARE Cur_Prefix CURSOR FOR SELECT PrefixNo,PrefixLen,AfterPrefixLen FROM NoSeriesMaster_Prefix WHERE PrefixType=’SMS’ order by ID OPEN Cur_Prefix FETCH NEXT FROM Cur_Prefix INTO @PrefixNo,@PrefixLen,@AfterPrefixLen WHILE @@FETCH_STATUS = 0 BEGIN SET @SQLStatement = ‘update ‘+@TABLE+’ set AuditData.TATCallType=”12”, AuditData.TATCallUnit=”1” ‘ + ‘from ‘+@TABLE+’ AuditData ‘+ ‘inner [...]
Answer Question | July 29, 2009 2:51 PM
INNER JOIN statement, SQL
Hi guys I have just finished my graduation and i am looking for a certification course in Network Security but don’t know where to start. Any Help would be great. Thanks.
Answer Question | July 15, 2009 10:43 AM
Certifications, IT careers, Networking careers, Networking certifications, Security certifications
hi my name is udit gupta m a student of t.y. computer engineering , i would like to know that student not intrestead in programing field can jump to another feilds like networking & what course they should do that may help such student in final year .let me inform you that my interest field [...]
Answer Question | November 30, 2010 5:04 AM
IT careers, IT education, Networking careers
How can we create a family tree map using php and mysql?
Answer Question | April 3, 2010 12:45 PM