Solved

RemoteData Example

Posted on 1998-08-20
13
181 Views
Last Modified: 2010-04-30
I'm new to RemoteData.
I want to write an application connecting using an ODBC-connection. The thing I want is only to see the result of a given SQL-Statement in a table, edit the data in table and delete and insert new rows and write them to the DataBase.
Can I also work with rollback and commit??
Perhaps you can send me a short example!!!

thanx
witty
0
Comment
Question by:witty
  • 7
  • 6
13 Comments
 
LVL 4

Expert Comment

by:mcix
Comment Utility
What kind of database is this?
0
 
LVL 1

Author Comment

by:witty
Comment Utility
it should run on mssql and centura!
wiity
0
 
LVL 1

Author Comment

by:witty
Comment Utility
it should run on mssql and centura!
witty
0
 
LVL 4

Expert Comment

by:mcix
Comment Utility
Check into:

http://backoffice.microsoft.com/downtrial/moreinfo/sqldrk.asp

Download the ADO and SQL Server Developer’s Guide

There is a sample project in the Zip

0
 
LVL 1

Author Comment

by:witty
Comment Utility
OK - but what's the different between DATA and MSRDC - object?
0
 
LVL 4

Expert Comment

by:mcix
Comment Utility
1. Basically, the Data object uses the JET engine to access a database.  While it is possible to connect to other data sources, such as Excel, FoxPro, dBase, etc... It is usually used to manipulate an Access database.  This is commonly referred to as DAO or Data Access Objects.

2. The Remote Data Control encapsulates RDO or Remote Data Objects.  At one time, this was the method used to access ODBC data sources (for bound controls).  With VB5 and now 6, MS has introduced ADO, Active Data Objects and more recently OLEDB and UDA, universal data access.

It seems that the future will be in ADO using an OLEDB provider will be the future (for now anyway).

These are the general guidelines we use:

1. If you know you only need to go at Access use DAO/JET.  
2. If you are considering porting or combining Access and SQL Server, use RDO.  
3. If you only need SQL Server or some other ODBC/OLEDB data source, use ADO.
4. If you don't know, start with DAO and work your way up.

After writing several apps, using all of the above mentioned, it really depends on what your target database is.  In our shop, we use the one that fits the task at hand.

By the way, did the article help you?
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 1

Author Comment

by:witty
Comment Utility
Can I use DATA - object for access to CENTURA Databases via ODBC?

witty
0
 
LVL 4

Expert Comment

by:mcix
Comment Utility
Do you mean SQLBase?
0
 
LVL 4

Expert Comment

by:mcix
Comment Utility
According to Centura, the answer is yes!

Look @

http://www.centurasoft.com/products/sqlbase/white/sqlconn.html
0
 
LVL 1

Author Comment

by:witty
Comment Utility
thanks
one last question:
VB 5.0: what can be wrong when i get a connection to a mssql database (I see the data in the grid-table), but i can't edit the data and add new rows!
it looks like the database is readonly - but it isn't. I think there must be a simple reason for this!!

thanks witty
0
 
LVL 4

Expert Comment

by:mcix
Comment Utility
A couple of things here, possibly...

Starting with the obvious properties of the DBGrid and MSRDC Controls (You are using the controls?):

1. Right Click on the Grid and Select Properties.
2. By Deafult, AllowAddNew and AllowDelete are not checked in the general tab.
3. Read-Only Property of the MSRDC is set to true.

These were just off the top of my head and I'm sure you've found them by now...

0
 
LVL 1

Author Comment

by:witty
Comment Utility
hey you helped me!

if you wanna points write a "answer" - or should I delete the question ;-) ?
0
 
LVL 4

Accepted Solution

by:
mcix earned 150 total points
Comment Utility
Hey Witty, long time no hear... Hope things are moving along for you.  I am glad to have helped you...

If you need more help, just e-mail me

marko_justus@hotmail.com

so we can be more direct without having to check these questions all the time...
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now