Recent content by Dzidze

Hi to all. Here are the facts: I have 3 variables declared as Global Objects in a module: OraSession OraDatabase OraRecordset Here is the code: Private Sub LoadGrid() Dim sSQL As String Dim sData As String Set OraSession = CreateObject("OracleInProcServer.XOraSession")...

You might need to redo your package and specify the dependencies of some files. As for the line, I think it is there by default. ''Life is like a box of chocolate...''

Hi Bob. Thanks for the tips. Actually, I'm not too fond of the format, but like you said, I'm new to Oracle. I know there is a lot to know about it, so I guess I should get my hands on everything that comes my way. What is good though, from what you said, is the fact that they tell you a lot...

To do that, you will need: a) a DriveListBox (Drive1) b) a DirListBox (Dir1) c) a FileListBox (File1) d) a TextBox (txtChoice) Then: Private Sub Drive1_Change() On Error Resume Next Dir1.Path = Drive1.Drive End Sub Private Sub Dir1_Change() Dim sFile As String File1.Path =...

Hi to all. I'm just wondering if the information contained in the OLN (Oracle Learning Network) is worth. I checked a free video, but it lasted only 5 minutes. I'll be working with Oracle 8i in 2 weeks, and in the last 3 months, I purchased 6 books on Orale (DBA, PL/SQL, Tuning, Recovery...

vr9.com is also a free web hosting to consider. They are growing very fast and keep on trying to improve an already pretty neat package. ''Life is like a box of chocolate...''

Hi Terry. There is absolutly nothing to fear. Oracle will take it no problem. ''Life is like a box of chocolate...''

If your database is in access, then compacting it will buy you some time. But if it is really growing fast, then you should really consider switching to Oracle or SQLServer. ''Life is like a box of chocolate...''

Why don't you just make your querry on the city? (with some Inner Joints) then, x = rst1.RecordCount ''Life is like a box of chocolate...''

No problem... Just hope it helped you get through ''Life is like a box of chocolate...''

Got my answer ''Life is like a box of chocolate...''

The best one would probably be Seagate's Crystal Report. ''Life is like a box of chocolate...''

Hi to all. We are in the process of having Oracle 8i at work. It has been approved, but only with 10 users(connections). I know that within 3 months we'll need more than 20. Since Oracle requires at least 20 users to reside on a two processor server, here's my question. Does Oracle need any...

Hi elecrta, use the following code: Private Sub LoadGrid() Dim wk As Workspace Dim db As Database Dim rs As Recordset Dim sSQL As String Dim sData As String Set gWk = CreateWorkspace("Data", "admin", "",dbUseJet) Set gDb =...

Hi to all Sheffield's code is good. But when you close a recordset, you should always use this code right after: Set rs = Nothing ''Life is like a box of chocolate...''