Just a note, I am still hoping for some help on doing this in ADO.net.
Here is my solution in classic ado & vb. It works well, and the code is much more simple... it seems to me that the power of .net is offset by it's complexity :-/
[noevil]
Option Explicit
Public Con As ADODB.Connection...
Hello, Thanks for reading my post :-)
This is the first time that I have attempted to write anything using ado.net, I am used to classic ado.
I have been pulling my hair out with this one... I have written a simple function that removes duplicates from a database table. (Oh, I thought, this...
Thankyou!!!
OK, I have not explained my problem very well, but you have managed to understand me enough... as you have helped me resolve it!
I used your much more simiplified code (unlike my poor attempt at simplification! :~/) and used it to experiment.
Your code was pretty much what I had...
Thanks for your quick response :-)
I was trying to simplify the post to keep it shorter, however, I see what you mean it is difficult to see what I am on about.
I have tried using mysql_connect() in the contructor with the logic that it will keep the connection open for that object and any...
I have some data stored in MySQL DB and use a class object to retrieve the data on a single php page.
I want to create a single connection to the database, call the object's function several times to collect each individual peice of data, and then close the connection. So far, I have only been...
Good idea Golom, thankyou.
That might work, currently I capture the problem as an event, and the idea of letting the vb error handling work for me may tidy things up. I'll give that a go.
Your a star!
E-Bean
Thanks Golom, But no.
Public WithEvents Object1 as Class1
Say if the below code is my Form1 class.
----------------------------------------
Private str as String
Sub Example()
On Error GoTo ErrorTrap
str = Object1.Property
'Other code doing other things with this property...
Hello, and thanks for looking at my problem.
I need to find a way of telling the system to stop running all code, a sort of halt completely, other than just 'Exit Sub' or 'Exit Function'.
I have tried using the err.raise method, but this does not actually stop the code from running. Once the...
Thanks RhythmAce,
Sorry, it was a typo. I have 160 mb, 128 + 32mb. I have another 128mb dimm in the post now.
So kde and gnome are notorious for this eh? So how much is enough? I only have 2 dimm slots on this old box.
In theory then, unless I need to use the gui (i intend to mainly run...
By using the net time command on each users pc,(possibly including the bdc!) redirecting to the pdc.
eg.
c:>NET TIME \\Server /set /y
It is a good idea to do this in the logon script.
marcdmac has a good looking script written in vb in this very forum...
of course, you will need to delete...
Mandrake 9.1 (my first linux!)
200 mhz pentium cpu.
I cant login to the KDE, in fact - it has never logged in. I can login on ICEWM, but the KDE just hangs on a blank screen showing the stopwatch. The HDD crunches, but still no desktop.
I have upgraded the RAM from 32MB to 168MB - still not...
I think that you need to work on isolating this problem.
You have 3 different tasks, do they all fail or is it just one that fails? Is it a different reason for failure for each task or is it exactly the same error message/reason?
Could you test to see if a normal executable file runs as...
Thanks BCastner,
I didnt think to try the ms kb for a problem like this, but then what else do I expect for an os from Microsoft? - It is bound to be a known issue.
I have installed the scanner software before, yet it still would not have it. I will have to try to install some other scanner...
Hi Paul00,
I am sorry, Paul, but I (and most likely others) am having trouble understanding your post. English does not appear to be your native language.
As I understand - you are trying to install xp and are having trouble with partioning?
Try to put the problem simply - and use more full...
Hello all,
I have a problem with xp and a HP R45 all in one printer. The fact is, HP have not posted a driver for it yet, so the scanner half is not working. The user is not interested in the scanner for now, and will make do with the R40 (R40 as R45 not availiable!) printer driver alone...
Jim,
I have just had a look at the table it creates, and it defaults to required = "NO".
Intresting question though - I will have a look into that when I get the chance. I am going to get some sleep now... its getting late here in Devon,UK. I may look into it next week...
I agree with CCLINT as my code did use the 'in' clause! Yet I failed to mention it :(
Here is a tested and debugged update!
You can use 2 connections... one for the first db and one for the third to create the table. I feel that creating and inserting the table gives you more control than...
Hi jopaumier,
I hope this helps... I based it on a similar bit of code to rescue a corrupt database recently. Although this bit is untested...
Public function ElectronikBean()
Dim cnMyDB1 As New ADODB.Connection
Dim cnMyDB2 As New ADODB.Connection
Set cnMyDB1.ConnectionString =...
(To sleipnir214 )
Yes you are right, I was not on the right track, but after viewing my own post last night, I re-read your comments. It is only natural for me to think Win32, as that is all I have been used to for a long time...
So, to reiterate, Unix family OSs use a user directory or a...
Thanks for the tip - and for redirecting me onto the correct path. It can be difficult to find your way when your left groping around in the dark!
What the support person was saying did not make a lot of sense as - like you say, they did not even tell me the correct details. It makes sense...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.