Oracle

[RonR]

has anybody here used VB 6 with Oracle 10g XE??


is it a real bear to setup???


does it work similar to Access???

I want to use VB 6 to create a front end of an Oracle DB.

[Hack]

I've used VB6 to create a front end to Oracle (it was 9i) and it worked fine.

Similiar to Access???? Well, they are both databases. Thats similiar.

Oracle supports PL/SQL, not T-SQL that you would use in SQL Server or Access. They are a lot alike, but there are differences that you need to know or PL/SQL will toss errors back at you that, on the surface, make no sense.

How are have you gotten with this?

[GaryMazzone]

The XE version is similar to SQL Express version. By that I mean it is a smaller version of the big brother. The connection to and use of XE is the same as using any version of Oracle. You might need to check on network connectivity, in earlier version of the desktop version of Oracle they did not allow network connections from other machines out of the box. You need to do some configuration work to all that.

[RonR]

I have not started yet, just doing research first.


In Access I use unconventional methods to obtain the results I need.

I have no formal training in programming so I have to use what I understand as long as it works.

this is how I move thru data to find the records I want:


rsIncidents.MoveFirst
For Z = 1 To rsIncidents.RecordCount
RsIncidents.Absolute position = Z


if RsIncidents("ClientName").value & "" = "Jim Jones" then

'do stuff here

end if



next


I have experimented using the Access filter command and it is no faster.

would Oracle allow me to use similar code to go thru its records??



Does Access 2002 work any better than Access 97??

[GaryMazzone]

You would start using SQL filtering when you use Oracle.

Say you were looking for the Client name Jim Jones the SQL would be:

Select * From Clients Where ClientName = 'Jim Jones'

The you open the recordset using that SQL statement.

You start using ADO code (or ADO.Net if using anything newer the VB6). You need to start coding every aspect of the database interaction. I would start doing that whether or not you use Oracle. I would go with the newest version of Access you have if you decide to stay with Access (I personally would not do that).

[RonR]

ok.

each record has the name, but it also has the month, the day of the week and maybe another field that ALL have to meet certain specs to be displayed in a flexgrid.

can this be done with the SQL???

so, Oracle does not have the "AbosolutePosition" feature?

[GaryMazzone]

You build you SQL Statement where clause with the required parameters. I have never used the absolutePostion feture of a recordset, I have never needed it. That is a fetaure of the recordset and has nothing to do with Oracle. Using the where clause to build the SQL Statement with just reduces the amount of data you are tying to return. The Database us normally quicker in filtering the data then the app will be.

[RonR]

can you give me an example of how to SQL the multiple fields in a search??

[GaryMazzone]

There are may references in the forums for SQL training. The Database Section FAQ has them:

Where can I find a tutorial for SQL?
General (includes explanations and examples of several types of SQL statements)
multi-table queries
complex Updates
Reference for SQL with Access
Reference for SQL with SQL Server
How do I use values (numbers, strings, dates) in SQL statements?

How do I put the ' character into an SQL string?

How can I put the value of a variable/control into my SQL statement?

How can I find out why my SQL statement isn't working?

How can I work with parent-child data, where a child can also be a parent? (SQL Server example)


Look at this web page (the fist link General) http://sqlcourse.com/

[Hack]

In addition to Gary's link, we cover some SQL in out Database FAQ section.

[RonR]

thanks for the info guys.