Question about Gupta Computers & Internet

Open Question

Gupta Dir Sir, Iam Programmer with clipper/dbase III i try to learn gupta in trial version i connect  my test program to sql server 2000 and every think ok, i put alot of data lije itemno ,item description in sql table around 7500 record i tray to display this information in gupta test program by SalTblPopulate(hWndForm,hSQLSRV2,CprFltrSelect,TBL_FillAllBackground) It take around 1 minut to retrive all data that is very slow for user to wait this data and alsho when you display all data . my question to help my connection to sql server 2000 using sqlolde  and iam using more is any way to increase speed to retrive data is best using sql server by odbc of windows is way in gupta retrieve data els e than using saltblpopulate is any website that have sample or small program to connect to sql           that help understand the way to connec and retrieve. help mey for this thing wille let me continue test all my question and take decition to work with gupta and leave clipper (as you know clipper index retrive data faster and my user found higer retrive data than clipper) my opinion is ther another way to increase spee. thank you very much programmes / fathi h. ebrahem

Posted by on

Ad

6 Suggested Answers

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad
  • 244 Answers

SOURCE: SQL Server 2000 SP3 - Installation Path

The only way to change it. Is to reinstall the SQL Server, and be guided accordingly once you meet the setup option you need to change the folder destination where you can setup the sql.

Hoping this will be the solution you are looking for.


Best Regards,


Philip

Posted on Oct 30, 2007

Ad
mcc99
  • 51 Answers

SOURCE: DTS MS SQL 2000 to Sybase

Try using a transaction block.

Posted on Mar 15, 2008

  • 1 Answer

SOURCE: I'm a Fresher in ASP.NET 2.0, Please help me

You need to change the column type from BoundField to TemplateField and call the substring method like this

<asp:TemplateField>
<HeaderTemplate>
Comments
</HeaderTemplate>
<ItemTemplate>
<%#Eval("Comments").ToString().Substring(0, 25)%>
</ItemTemplate>
</asp:TemplateField>
In this snippet, I am displaying only the first 25 characters of the Comments field.Only problem with this approach is that if even one of the rows contains a comments field with less than 25 characters, this might trigger an error.The fool proof way then is to write a small function in codebehind which will check the length of the field, chop off any extra characters and in case of shorter strings,

( THANKING " Balgates " For this HELP )

Posted on May 05, 2008

  • 1 Answer

SOURCE: QUEST SQL Navigator 3.2 with Oracle 10g Fails

I followed the advice given above and copied the ORACLE_HOME/bin/ociw32.dll to ora73.dll in the same directory. copy ociw32.dll ora73.dll
And the software worked immediately.

Posted on Sep 12, 2008

  • 57 Answers

SOURCE: Unable to create database from within VWD 2005 Express

try to complete uninstall .net framework and install it again or get the latest copy of .net framework to install 3.5 latest version already available for download

Posted on Dec 01, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

16 Answers

How can I repair a corrupted MDF files and SQL server?


Similar question has been answered here: http://www.fixya.com/support/t24364927-sql_repair_recovery_process_very

Before asking any question in the forum, first you need to search your problem.

May 12, 2014 | Microsoft Database Software A5K-02817 SQL...

7 Answers

How to recover SQL server mdf files?


RecoveryFix for SQL database recovery software is recover and repair MDF files components from corrupted SQL server database. This software compatible with Windows 7, Server 2008, Vista, Server 2003, XP and 2000. More details see this site: http://www.en.repairsqlserver.net/ or download this tool from http://www.en.repairsqlserver.net/free-trial.html

May 06, 2014 | Microsoft Database Software A5K-02817 SQL...

3 Answers

Visual Basic and SQL


Hi,

Visual Basic 6.0 and MS Sql server 7 or 2000 are highly compatible with each other. VB.net is compatable with sql 2005 which is inbuilt as well.

Jul 07, 2009 | Microsoft Windows Vista Ultimate Edition

1 Answer

I want to install SQL server2000 free!


you cant get sql server 2000 free, but you can get sql 2005 express edition free. http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en this is the link to download SQL 2005 express edition. This is same as SQL 2000 if you just want to work on queries.

Oct 19, 2008 | Microsoft MS SQL SERVER (810-01567-3-1)...

5 Answers

SQL 401: cannot open database


SQL database Recovery Software remove errors from SQL server database and allow recover your all database of SQL Server 2012 or below versions. The software support with all over version of SQL server. Try at here:-
SQL Database Recovery

Jun 06, 2008 | Computers & Internet

4 Answers

Restoring files from the database


I suggest you use the Enterprise manager (gui tool to manage SQL).
Restoring a single table is not an option.
You can however restore a file or filegroup.
Make sure to backup before you start and NOT to restore database to its original name or original file location, to avoid acidents.
Normally you will have databases with only 2 files: the data at its Primary file group, and log file.
You may wish to create a new file group and move tables to the new group by recreating them there and exporting data from old table to new table. Then recreate indexes. This may prove to be complex as all tables and indexes have unique names and can't coexist with exact duplicate of them.

oh yea..... did I say backup?
well just in case backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup
but dont overwrite that backup

Feb 11, 2008 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

SQL Server 2000 SP3 - Installation Path


The only way to change it. Is to reinstall the SQL Server, and be guided accordingly once you meet the setup option you need to change the folder destination where you can setup the sql.

Hoping this will be the solution you are looking for.


Best Regards,


Philip

Oct 26, 2007 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

141 people viewed this question

Ask a Question

Usually answered in minutes!

Top Gupta Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Gupta Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...