|
|
My mistake. That's what I get for making an assumption because of the object you were using.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Actually you can't do it! You can use a loop and store different rows at each time. Therefore, you should carry the values with an array like OrderType(I).
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
JUNEYT wrote: Actually you can't do it!
Are you saying that because you know he is using MS Access? Or is this a general statement about SQL?
|
|
|
|
|
I assumed that he was using Access. Moreover, in development and programming it is not appropriate approach to insert 3 rows at same time with a single string because of readability and troubleshooting purposes.
If he was talking about the possiblity, yes you are right he can. 
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
You can create a result of three records and insert in the table, as Colin suggested.
Here's a short example:
insert into some_table (some_field, another_field)<br />
select 'Some data', 42<br />
union all<br />
select 'Some more data', -1<br />
union all<br />
select 'Even more data', 38745982
(I am not certain that a union works when creating a result for an insert this way. You might have to put the select statements in parentheses to make it a result, and select from that.)
---
single minded; short sighted; long gone;
|
|
|
|
|
I am not selecting anything, I am just inserting text files into a MySQL database. I am trying to increase the speed of my application because the data is being inserted very slow. However, when I run the program on my computer it will insert the files pretty quick but when ran on the computer in which I installed the application it will run slow. Any other ideas on how to increase the speed?
|
|
|
|
|
jds1207 wrote: I am not selecting anything
If you want to add more than one record with an insert query, you have to. There is no other way to make an insert query add more than one record.
---
single minded; short sighted; long gone;
|
|
|
|
|
Could you send me a sample using the code I provided?
|
|
|
|
|
jds1207 wrote: I am not selecting anything
The SELECT is to create a result set with three rows in it. You will also notice that it is part of the INSERT statement (you may wish to look up a SQL reference to see what you can do with an INSERT statement - including inserting data based on the result of a SELECT)
|
|
|
|
|
I have a home grown dll (written in VB6) that I suddenly cannot register on one of my machines Until now I could). I get error 0X80004005 when I try to register or unregister the dll using regsrv32. I also get a Permission Denied error when I compile it. The compile creates the dll file.
I have tried researching this elsewhere to no avail.
Thanks in advance for any assistance!;)
|
|
|
|
|
The problem appears to be that your component is dependant on the existance of another .DLL or COM component, which is not registered or could otherwise not be found. When you compile the .DLL code, VB6 automatically tries to register the new component. If a dependacy is missing, the registration can fail. Another possibility is that you're not part of the PowerUsers or Administrators group, so you don't have the permissions to register components.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Dave- Thanks for your quick response. I should have mentioned that I am a member of the Administrators group. As for missing another .dll or .com, my component uses MSAccess and Microsoft ADO 2.0 Library is a reference in the project.
Gerry Kopelman
|
|
|
|
|
ADO 2.0? That's going back in time!
Well, it's probably not a dependancy issue, unless you start installing it on Windows 2000 and higher. In that case, you'll probably have to update the code to use ADO 2.6 or better.
Another possibility I didn't think of is that an older version of the .DLL that is being built is already in use by another app somewhere and the new build can't be written to the disk.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
After a bit more research, open a CMD prompt on your machine and type SET TMP at the C:> prompt. What do you get back? Do the same with SET TEMP...
You should get back something like:
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
C:\>set tmp
TMP=C:\Temp
C:\>set temp
TEMP=C:\Temp
C:\>
BOTH environment variables must return a path to a folder (that exists!) used for temporary files. Without the environment variables or the folder they point to, ADO can generate this error.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Dave- I apologize for the long delay since your last post. I was sidetracked by another issue. I hope you can continue to provide some advice.
I did as you advised and got the following:
TMP=c:\docume~1\Gerryk~1\locals~1\Temp
and
TEMP=c:\docume~1\Gerryk~1\locals~1\Temp
The folder does exist.
To reference another post of yours, I see that the program is using ADO 2.5 and not ADO 2.0 (my mistake.)
I still have the same problem.
Do you have any other suggestions?
Gerry
|
|
|
|
|
I have no idea what it would be now. ADO 2.5 is still pretty old. The latest version, before Vista, was 2.8 and that's been out for over 2 years now.
Hmmmm... Well, I'd try recreating the project. Create a new project, of the same type, and setup the references to the same as what you had before and save the project. Then exit Visual Studio and copy the source files (*.vb) from the old project to the new one. Get back into VS and add the new code files to the project and recompile it. This will generate a new set of GUIDs for the project and MIGHT take care of it. I haven't used VB6 in about 6 years now, so I may very well be missing something here.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Sir/madam,
Can i add the landscape / portrait option in my crystal reports program in vb.net
Please help.
Thanks and Regards
Pankaj
|
|
|
|
|
|
Public Class Class1<br />
Public Sub f1()<br />
MessageBox.Show("interfacse")<br />
End Sub<br />
End Class
Public Interface inter<br />
Sub f1()<br />
End Interface
Public Class Form3<br />
Implements inter<br />
Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />
<br />
End Sub<br />
Private Sub abc() Implements inter.f1<br />
<br />
End Sub<br />
End Class
The problem is i wanted the member f1 of class class1
in the interface inter.
I mean when i implements the interface inter in class form3
I need not to write the code of function f1 of class class1 again.
But the control does not goes to the function f1 of class class1.
Please help.
|
|
|
|
|
I think you have misunderstood the purpose of interfaces.
An interface defines a public interface that classes can implement. There is no other relationship than that. When you declare that Form3 implements inter, you must provide a body (the implementation) for the methods and properties. You did this with Class1, but you provided only an empty body for Form3. Thus Form3 does nothing.
However, as I am at a loss as to what you are actually trying to acheive here I cannot suggest a reasonable alternative at this time.
|
|
|
|
|
Sir/Madam
Can i please get to know the various types of connection to do the code.
I mean if the application is based on three database.Can this be possible to lock the database and keep it open.and simultaneoluly open the another database.
I finally wanted to know the various types of connection
Thanks and regards
Pankaj
|
|
|
|
|
amaneet wrote: I mean if the application is based on three database.Can this be possible to lock the database and keep it open.and simultaneoluly open the another database.
You can open as many connections as the databases will allow. However, remember that the preferred pattern is to open a connection, perform the query and then close the connection as quickly as possible so you don't tie up resources.
amaneet wrote: I finally wanted to know the various types of connection
There are as many types of connections as databases that support the .NET Framework.
|
|
|
|
|
Sir,
can u please provide any link?
Thanks and regards
Pankaj Garg
|
|
|
|
|
amaneet wrote: can u please provide any link?
A link to what?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
