Search results for query: *

...Set OraDatabase = OraSession.dbOpenDatabase("Service", "user/tpassword", 0&) sSQL = "SELECT * FROM tbldba" Set OraRecordset = OraDatabase.CreateDynaset(sSQL, 8&) If OraRecordset.RecordCount = 0 Then Me.MSFlexGrid.Clear Else...

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...''

Sure Ablecken. There is always 1000's of ways to do something, but I'd like to see your solution. ''Life is like a box of chocolate...''

Actually you can. You have to use the Multimedia control for that (which comes with VB). I did create one a long time ago using codes I found on the internet(it was on another forum). I think you can find some help for that on the microsoft site. Although the help file I found was specific to...

Hi tganeshven. Have you tried if all then....elseif 1 then....elseif 2 etc... If that doesn't work, show us the coding. There is a lot of people here who could easily find an answer for you. Cheers

I found a mistake in my example: Here is the right code for the function: Function OpenRecordset() As Boolean Dim sSQL As String On Error GoTo err_openrecordset sSQL = "SELECT tblX.x_id, tblx.x_name, " sSQL = sSQL & "tblx.date_arrived " sSQL = sSQL &...

...the regular form, they only access the names of the clients that have been entered in the database. It's a bit more work for you, but in the end it can prove quite usefull. For this new form, use a SQL statement: ''INSERT* INTO tblCLIENT WHERE tblClient.name = '' & txtName.Text Hope it...