|
Hi this is santosh. i am writing code to access records from multiple tables created in oracle databaseinto VB.
I gave the connection string, i gave record set.it is working to retrieve data from one table , but when i was trying to retrieve data from mutiple tables by joining , its not working.
please help me in writing a select statement to join multiple tables in VB.
Bye
santosh
santosh
|
|
|
|
|
My guess is that your join statements are the problem, double check them.
|
|
|
|
|
i wrote the join statement but its still showing run-time error. i think my sytanx for join is wrong. so can u please give me the syntax to join tables and retrieve records from the database.
thanks and regards,
santosh.
|
|
|
|
|
I have a VB6 application that is running on a Windows 2000 Server using Terminal Services which are being managed by Citrix MetaFrame XP. Also running is ScrewDrivers v3 (A.K.A. Simplify Printing) from triCerat to manage the client printers.
I am using a third party custom ActiveX control called VSPrinter, which is part of VSView from ComponentOne, to provide print preview and printer control.
When I trigger a print from the print preview, I am presented with the standard Windows PrintDialog.
The problem is that the available printer list is populated with ALL printers available to Terminal Services, not just the printers for this client.
The ComponentOne support was useless, and their forums are littered with problems regarding usage under Citrix. Their standard reply is that one should check their forums for help. The common theme on the forum is that their product has not been tested in a Citrix environment.
Has anyone else used this control and observed this problem?
Or has anyone else found a print preview control that works in this environment?
|
|
|
|
|
i want to open a prefilled mail message.
the parameters are:
- to
- subject
- an attachment file
on my workstation the next code works fine:
Public Class SendFile
Private oApp As Object
Private oNameSpace As Object
Private olMailItem As Integer = 0
Private olByValue As Integer = 1
Public Sub New(ByVal AttachmentName As String)
'Return a reference to the MAPI layer
oApp = CreateObject("Outlook.Application")
oNameSpace = oApp.GetNamespace("MAPI")
'login with the currently user
oNameSpace.Logon(Nothing, Nothing, True, True)
OpenMessage(AttachmentName)
End Sub
Private Sub OpenMessage(ByVal AttachmentName As String)
Dim oMailItem As Object = oApp.CreateItem(olMailItem)
Dim oAttachments = oMailItem.Attachments
oAttachments.Add(AttachmentName, olByValue)
'open mailformular
oMailItem.Display()
End Sub
End Class
but on a citrix metaframe system (Windows 2000 Server installed) it fails with
-- ActiveX component can't create object
what's wrong about it?
stephan
|
|
|
|
|
Possible Outlook is not installed on that machine or you are referencing a different version on your machine (and subsequently in code) than what is installed on the citrix box?
"Half this game is ninety percent mental."
- Yogi Berra
|
|
|
|
|
My UserControl, I'm developing, have to get a custom constructor, with a parameter (StyleEnum) to getting a default-Style. This value is editable as the Style-Property in the PropertyGrid (Within the constructor I set the Style-Property too). The Style-Property will be not serialised (because it's value will be get in the constructor). I added a converter for my Control to generate the correct InstanceDescriptor. The code-generation works fine, but while testing I had a problem I can't solve:
I added my control to a form, changes the Style-Property to a other value and looked at the code. All is fine, the new value is be given to the constructor. Then I closed the form and the form-code and reopened the form. The Style-Property in code is still the old, but the Style-Property in the PropertyGrid is resseted to the initial value of the control. It looks like, the control is loaded with the standard constuctor without an parameters. How I can solve that problem, how I can tell the IDE to use the custom constructor with property?
-- modified at 8:41 Wednesday 7th December, 2005
|
|
|
|
|
The IDE is crap in this regard.
Your best bet, and I always do this, is make the default constructor private if you don't want it to be used.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Thanks for that good idea, I will try it and (if I found this thread) will tell you if it works.
|
|
|
|
|
Hi,
I need to print a windows form which has labels, text boxes ets on it. I do not want to display the windows form on screen as its being printed. Is there a way to do this.
Thanks
John
|
|
|
|
|
hi in my application i wanna store and retrieve images using sql server. i am using vb6 as my language. if anybody can help me please help.....
Roy Joseph
|
|
|
|
|
Generally the way to do this is to store image in a file, then you will only store the path to the image in SQL Server.
"Half this game is ninety percent mental."
- Yogi Berra
|
|
|
|
|
Tahnk you . But i want to store image not image path. in .Net e can use memory stream buffer to do this things. but in VB6........ what ? if u know plz reply.
Roy Joseph
|
|
|
|
|
In KB 149040 Microsoft reports a bug, but gives only a way to reproduce the error, but not a way to solve it. VB6.0 gives this error 3020 when I use
..............Recordset.Edit
..............Recordset.Delete
..............Recordset.Update
Error 3020 is meant to be given when you use Update without an AddNew or an Edit method.
Does anyone know how I can avoid this error, because VB6.0 does not delete the record because of this error.
|
|
|
|
|
Have your tried updating to a newer MDAC on your machine? MDAC Downloads[^]
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi, does anyone know who to programmatically to get a list of message in outlook express or ms outlook and show it in a list view? (VB.Net or VB6)
|
|
|
|
|
The code posted below write the eMail-Subjects of all eMails in the Inbox-Folder into a ListBox called List1. If you want to list the eMails of the other folders you have to loop through them with the 'oNamespace.Folders'-Object. I hope I could help you...
Dim oOutlook As Outlook.Application<br />
Dim oNamespace As Outlook.NameSpace<br />
<br />
Set oOutlook = CreateObject("Outlook.Application")<br />
Set oNamespace = oOutlook.GetNamespace("MAPI")<br />
<br />
Dim lvItem As MailItem<br />
<br />
For Each lvItem In oNamespace.GetDefaultFolder(olFolderInbox).Items<br />
List1.AddItem lvItem.Subject<br />
Next
|
|
|
|
|
Thank you very much for your answer. I will try to test it and let you know when it is working or not.
|
|
|
|
|
I already test your code and found some error with the reference, but i already customize of part of it as show below:
Dim oOutlook As Microsoft.Office.Interop.Outlook.Application<br />
Dim oNamespace As Microsoft.Office.Interop.Outlook.NameSpace<br />
<br />
oOutlook = CreateObject("Outlook.Application")<br />
oNamespace = oOutlook.GetNamespace("MAPI")<br />
<br />
Dim lvItem As Microsoft.Office.Interop.Outlook.MailItem<br />
<br />
List1.Items.Clear()<br />
For Each lvItem In oNamespace.GetDefaultFolder(6).Items<br />
' List1.Items.Add(lvItem.Subject)<br />
With List1.Items<br />
.Add(lvItem.SenderName)<br />
End With<br />
Next
Thank you very much for give me some idea about solving this problem!
Best Regard,
Kanel
|
|
|
|
|
Ok, the Code I posted is for VB6... I forgot to tell you...
|
|
|
|
|
Thank you very much for your respond. It is no problem, at least it's already give me an idea how to get the message from outlook. But I have one more question, if i select on the specific subject or sender, how could i load the content of the message into the text box? I assume that the message contain only text format.
|
|
|
|
|
i wanna to move my form towards mouse pointer on desktop . it should move whenever i move mouse pointer. please help me to do this. i tried with form's left property and move metod. but no use....
please help
thanks
Roy Joseph
-- modified at 2:04 Wednesday 7th December, 2005
|
|
|
|
|
Hey All
I have to develop a small application for which I have to generate the barcodes for the identifcation of the person.
Keep track how many times that person come
I have to develop it in .Net
Anybody Plz give me the idea
1. That how to generate the unique Barcodes
2. Then Read them each time person entered
What Approach should i follow
Hema Chaudhry
|
|
|
|
|
|
In the program i am writing i use the software you can find at this sight
http://www.idautomation.com/formscontrols/
They work well. Gives you more options then some. And suports alot of different formats. Also, there is a standard for barcodes that you should folow if you are writing this for a bussiness. Here is a sumary of how it works and the address where you can look at the info for yourself. Please keep in mind that this is a report i sent to my boss regaurding our product so you may have to ignore some of what im saying in it that is specific to us. Also i copy and pasted most of this from the howstuffworks sight. HAPPY HACKING:
===========================================================================
Sigts to use:
-www.howstuffworks.com/upc.htm
-www.uc-council.org
===========================================================================
===========================================================================
NOTES:
-We may need to aply for a manufacturer id with the council
-No price is incoded. the POS system looks up the UPC and sends back the
price of the item.
===========================================================================
===========================================================================
BAR CODE FORMAT:
-First 6 digits are the manufacturer id and the first of these 6 is the
"number system character"
-next 5 digits are the item # set by the store (have them set it in meatbooks)
-last digit is the check digit to insure the scan read correctly.
===========================================================================
===========================================================================
HOW TO MAKE THE CHECK DIGIT:
using the code 63938200039 calculating the check digit:
1.) Add together the value of all of the digits in odd positions
(digits 1, 3, 5, 7, 9 and 11).
6 + 9 + 8 + 0 + 0 + 9 = 32
2.) Multiply that number by 3.
32 * 3 = 96
3.) Add together the value of all of the digits in even positions
(digits 2, 4, 6, 8 and 10).
3 + 3 + 2 + 0 + 3 = 11
4.) Add this sum to the value in step 2.
96 + 11 = 107
5.) Take the number in Step 4. To create the check digit,
determine the number that, when added to the number in step 4,
is a multiple of 10.
107 + 3 = 110
6.) The check digit is therefore 3.
Each time the scanner scans an item, it performs this calculation.
If the check digit it calculates is different from the check digit it
reads, the scanner knows that something went wrong and the item
needs to be rescanned.
===========================================================================
===========================================================================
THE NUMBERSYSTEMCHARACTER(first digit of manufacturer id):
0 = Standard UPC number
(must have a zero to do zero-suppressed numbers)
1 = Reserved
2 = Random-weight items
(fruits, vegetables, meats, etc.)
3 = Pharmaceuticals
4 = In-store marking for retailers
(A store can set up its own codes, but no other store will understand them.)
5 Coupons
6 Standard UPC number
7 Standard UPC number
8 Reserved
9 Reserved
# 4 example
Since Toys R Us is the only store that will ever use this bar code
it's the only place where the gift certificate can be redeemed
Toys R Us made up its own UPC code for the gift certificate and used
number system 4 so it could do that.
===========================================================================
===========================================================================
COUPON BAR CODES:
the coupon's bar code starts with a 5 to indicate that it is a coupon.
The next 5 digits are the Post's manufacturer ID.
The next 3 digits are called the family code.
The next 2 digits are a value code.
The final digit is the normal check digit.
The family code and value code are set up arbitrarily by the UPC
coordinator for the manufacturer. It must be done that way because
a coupon will often be usable for a whole family of products.
For example, a coupon might be good for four different kinds of
soap made by the same manufacturer. In the same way, the value code
represents the value of the coupon arbitrarily. The manufacturer
sends the retailer the data that tells the retailer's computer
exactly which products fit the family code, and exactly how much to
take off. When the coupon is scanned, the POS computer:
1.) Decodes the family code
2.) Checks to make sure the customer purchased an item from the family
3.) Decodes the value code
4.) Sends the discount back to the cash register
===========================================================================
===========================================================================
INCODING A BARCODE:
So let's say you would like to incode the actual bars in the bar code and
map them to numbers.This is something that will make you cross-eyed, but
it can be done. First of all, look at any 12-digit bar code. It is made
up of black bars and white spaces between the bars. Assume that the
thinnest bar or space that you see (for example, the first bar on the left)
can be called "one unit wide." The bars and spaces can therefore be seen to
have proportional widths of one, two, three or four units. If you look
at any bar code you can see examples of these four widths.
The start of any bar code is "1-1-1." That is, starting at the left you
find a one-unit-wide black bar followed by a one-unit-wide white space
followed by a one-unit-wide black bar (bar-space-bar). Following the
start code, the digits are encoded like this:
0 = 3-2-1-1
1 = 2-2-2-1
2 = 2-1-2-2
3 = 1-4-1-1
4 = 1-1-3-2
5 = 1-2-3-1
6 = 1-1-1-4
7 = 1-3-1-2
8 = 1-2-1-3
9 = 3-1-1-2
(Something to notice: All of these encodings seem to add up to 7.)
So let's take this barcode as an example:
043000181706:
-The bar code starts with the standard start code of 1-1-1 (bar-space-bar).
-The zero is 3-2-1-1 (space-bar-space-bar).
-The four is 1-1-3-2 (space-bar-space-bar).
-The three is 1-4-1-1 (space-bar-space-bar).
-The next three zeros are 3-2-1-1 (space-bar-space-bar).
-In the middle there is a standard 1-1-1-1-1 (space-bar-space-bar-space),
which is important because it means the numbers on the right are
optically inverted!
-The one is 2-2-2-1 (bar-space-bar-space).
-The eight is 1-2-1-3 (bar-space-bar-space).
-The one is 2-2-2-1 (bar-space-bar-space).
-The seven is 1-3-1-2 (bar-space-bar-space).
-The zero is 3-2-1-1 (bar-space-bar-space).
-The six is 1-1-1-4 (bar-space-bar-space).
-The stop character is a 1-1-1 (bar-space-bar).
===========================================================================
===========================================================================
SOME OF WHAT OUR POS NEEDS TO DO:
-Handle coupons
-Handle pricing
===========================================================================
This should be what we need. We will have to check into the manufacturur id.
Im not sure if that would be something we have to use or not.
Pablo
|
|
|
|