|
Thanks for your reply...if i give like below as u advised,
ADOXtable.Keys.Append("PrimaryKey", ADOX.KeyTypeEnum.adKeyPrimary, "LOGICAL_DB_NAME")
ADOXtable.Keys.Append("PrimaryKey", ADOX.KeyTypeEnum.adKeyPrimary, "DIM_NAME")
ADOXtable.Keys.Append("PrimaryKey", ADOX.KeyTypeEnum.adKeyPrimary, "CHARX_NAME")
ADOXtable.Keys.Append("PrimaryKey", ADOX.KeyTypeEnum.adKeyPrimary, "CHARX_TABLE")
Exception raised...
{"Exception from HRESULT: 0x80040E99"}
Data: {System.Collections.ListDictionaryInternal}
ErrorCode: -2147217767
HelpLink: Nothing
InnerException: Nothing
Message: "Exception from HRESULT: 0x80040E99"
Source: "Interop.ADOX"
StackTrace: " at ADOX.Keys.Append(Object Item, KeyTypeEnum Type, Object Column, String RelatedTable, String RelatedColumn)
at IWSSample.IWSSample.CreateAccessDatabaseandtables(String DatabaseFullPath) in C:\LEGO\June19\IWSSample.vb:line 1021"
TargetSite: {System.Reflection.RuntimeMethodInfo}
Thanks,
Sivakumar.M.
|
|
|
|
|
Well, I didn't say I tested it. I said I think you may have to do something like that. Try reading the documentation on ADOX's Key.Append method. You may have to supply other information to the Append method, like foreign table names and columns.
|
|
|
|
|
Something like this?
key1 = New ADOX.key
key1.Name = "PrimaryKey"
key1.Type = ADOX.KeyTypeEnum.adKeyPrimary
key1.Columns.Append "LOGICAL_DB_NAME"
key1.Columns.Append "DIM_NAME"
key1.Columns.Append "CHARX_NAME"
ADOXtable.Keys.Append key1
Note the similarity with yesterdays index question - have a look at the ADOX object library.
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
|
|
|
|
|
Superb.....It is working fine now...Thanks a lot...
|
|
|
|
|
Hi all,
I have an application in Visual Basic 6.0, which spools text to a text file and then prints. After printing file will be deleted. But here, I couldn't know printer status. Is printing over or still printing...I couldn't know. If I know, I wont delete the file. If that is single file, then I can adjust, but continually 10 files will be printed.
All I want to know the status of the Printer...Please help me out.
Ramesh Sambari
Knowledge is like honey.
Collect it, to make life sweet.
|
|
|
|
|
specialdreamsin wrote: Visual Basic 6.0
Why are you using VB6 ? It really sucks. And, it's unsupported. If you want VB6 help, you should put it in the subject line, so you only attract people who have been developing long enough to remember what that was.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
Christian Graus wrote: so you only attract people who have been developing long enough to remember what that was.
No, no. It's "people who are still young enough to remember what that was."
Us old guys can't remember a damn thing from that far back!
|
|
|
|
|
What you saying humm?
I remember humm everything as if humm it was only yesterday humm!
Everyone knows that once the humm. Sorry, nap time.
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
Christian, (i'm sure i'll get slammed for this but...)
I'm confused by your question of "Why are you using VB6". While I agree that vb6 and dotnet are night in day in comparison, I'm sure you aware that a developer's tools are not always up to them. If his company has many many applications written in vb6, then it's not always possible to do a mass conversion spending time and resources to do so...finding alternatives to ocx's that were being used, ramp up time learning dotnet stuff replacing the vb6 etc. Not to mention the amount of testing that would need to occur testing the new versions of an existing app as well as possible distribution considerations (installing the app and ms framework on possibly thousands of computers).
Now if the above is not the case and the developer went into vb6 willingly then yes he should be questioned on his choices.
My company has a website written with asp and vb6 dlls. Website has thousands of pages on it and would take years to rewrite in asp.net. $$$$ talks and other projects are more important...
Don't hate me Nathan
'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous
'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous
|
|
|
|
|
nlarson11 wrote: I'm sure you aware that a developer's tools are not always up to them.
Agreed. Yet, unless this is a legacy project, the question may become, why does your work use VB6 ?
nlarson11 wrote: Now if the above is not the case and the developer went into vb6 willingly then yes he should be questioned on his choices.
And that's why I asked why he's using it, rather than flat out saying 'you should never use VB6'. I know sometimes people have to use it, but I'd say the majority of people I ask that to, on these forums, are not in that boat. A lot actually are surprised they can get VB.NET for free, and are happy to hear it.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
vb6 does not expose that itself. You will need to use an API call to check the status. just google "how to check printer status in vb6". it will give you the results you ask for.
Nathan
'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous
'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous
|
|
|
|
|
Hi
If you know the Answer, try to help others. This is the Area where we share knowledge. This is not to fight each other. right ?
Thanks for understanding.
Ramesh Sambari
Knowledge is like honey.
Collect it, to make life sweet.
|
|
|
|
|
Hi,
I know this question is posted million of times and i search on the internet for very long time for the solutions but to no avail.
I want to create a table (called "Customers") in a Microsoft Access database and then insert/delete records into the table and update the table. The table shall have 3 columns:
ID
Customer Name
Customer Address
I know i need to make the "ID" column as an autonumber and a primary key, as i need to insert and delete records and update the table.
I am using the Visual basic 2008 Express edition and quite familar with the OledBcommand. I greatly appreciate if there is any kind, helpful and generous expert out there who can advise me the VB code for this using "Oledbcommand".
Thank you very much.
|
|
|
|
|
If you issue the following command to the Access database, using the oledbCommand and ExecuteNonQuery
CREATE TABLE Customers ([Id] COUNTER, [Customer Name] TEXT(60), [Customer Address] TEXT(255))
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
Hi Steve,
I need the [Id] to be primary key, as i need to insert new records and delete records into the Access database table and finally update the Access database table.
The code:
" CREATE TABLE Customers ([Id] COUNTER, [Customer Name] TEXT(60), [Customer Address] TEXT(255)) "
seems does not make [Id] as primary key.
Pls kindly advise me. Thanks.
|
|
|
|
|
|
Hi All,
I built a program for Creating Entry for running my application to startup. But windows defunder shows it spyware.
Description:
This program has potentially unwanted behavior.
Advice:
Permit this detected item only if you trust the program or the software publisher.
Resources:
regkey:
HKLM\Software\Microsoft\Windows\CurrentVersion\Run\\ABCD
runkey:
HKLM\Software\Microsoft\Windows\CurrentVersion\Run\\ABCD
file:
D:\Program Files\ABCD\ABCD.exe
Category:
Not Yet Classified
So please give me the solution for resolving this problem.
If you can think then I Can.
|
|
|
|
|
ignore defender, or abandon this functionality. IF you want to make your app run on startup, put it in the startup group of the start menu.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
The was tagged as "Potentially unwanted" because applications normally do not modify the Run key. Really, the only time that key should be modified would be at installation time of your app, not run-time.
|
|
|
|
|
you know what i knew that you would post a post like this
sooner or later since you posted a post about sendkeys
are you trying to develop something malicious?
TheMrProgrammer
|
|
|
|
|
And why are you asking me this? Reply to the OP on his post, not mine.
|
|
|
|
|
i ahve a windows(desktop) application softwere which i am working on,
I need to add functionalty in that, like when you minimise you can store tool bar on the taskbar.(like windows media player)
it can be done with VC++ ,VB.NET
any suggetions?
|
|
|
|
|
Here[^]
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
I searched and tried several answer from yesterday but i could not solve this yet... Other thing is i am a beginner...
I am trying to update the StatusStrip from a class but it's not updating... Here's my code.
This is my Form1----------
Public Class Form1
Public trash As New Class1
Private WithEvents eventsUpdateSSclass1 As UpdateStatusStrip.Class1
Private Sub UpdateStatusStrip(ByVal msg As String, ByVal color As Color) Handles ventsUpdateSSclass1.UpdateStatusStrip
Me.ToolStripStatusLabel1.Text = msg
Me.ToolStripStatusLabel1.BackColor = color
Me.StatusStrip1.Refresh()
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
trash.runRunRun()
End Sub
End Class
This is my Class ------------
Public Class Class1
Public Sub New()
End Sub
Public Event UpdateStatusStrip(ByVal msg As String, ByVal color As Color)
Public Sub runRunRun()
Dim k As Integer = 0
For i As Integer = 1 To 100
For j As Integer = 1 To 1000
k = j + i
RaiseEvent UpdateStatusStrip(CStr(k), Color.Orange)
'call UpdateStatusStrip(CStr(k), Color.Orange) is not working.
Next
Next
RaiseEvent UpdateStatusStrip(String.Empty, Nothing) 'to check
End Sub
End Class
I will really really appreciate your help.
|
|
|
|
|
Hi,
all Control operations need to be handled by the GUI thread, so if you have one handler (here a button click handler) taking too long, the user will be left in the dark until that handler is done, and the GUI thread can continue doing its business, such as updating statusstrip texts.
What you should do is delegate long-winding stuff to some other thread(s); and when they suddenly need to access a Control, you would then need the Control.InvokeRequired/Control.Invoke pattern (except inside the BackgroundWorker.Progress and Completed handlers).
Luc Pattyn [Forum Guidelines] [My Articles]
DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.
|
|
|
|