|
Hello I have a little problem that has been really bugging me.
I have a program that I made that retrieves a database table from oracle. The program allows the user to insert and update the database. These functions work great. My problem is that I can not get the delete to work because the table doesn't have a primary key defined. I am not able to change the structure of the table by adding a primary key but I would like to add the primary key in my code.
what is the syntax to add a primary key in vb. My primary key will need to be a compound key that consists of the following three columns "GROUP_NAME", "ENTITY_TYPE", "DESCRIPTION.
I am lost this is what i tried but doesnt work:
dsBaseCalc.Tables("BASE_CALC_CODES").PrimaryKey = ("GROUP_NAME")
dsBaseCalc.Tables("BASE_CALC_CODES").PrimaryKey = ("ENTITY_TYPE")
dsBaseCalc.Tables("BASE_CALC_CODES").PrimaryKey = ("DESCRIPTION")
any help would be greatly appreciated. I am a newbie
Erica
|
|
|
|
|
Never tried it, but I think you can just make an array of datacolumns to pass as the primarykey:
Dim pk3(2) As DataColumn
pk3(0) = MyDataTable.Columns("Col1")
pk3(1) = MyDataTable.Columns("Col2")
pk3(2) = MyDataTable.Columns("Col3")
MyDataTable.PrimaryKey = pk3
|
|
|
|
|
Thank you so much for that info.
Erica
|
|
|
|
|
imonfiredammit wrote: My problem is that I can not get the delete to work because the table doesn't have a primary key defined.
That's a huge mistake in designing the table schema. Nothing in your code is going to fix this. You can "patch" it by doing what your discussing, but the point behind the Primary Key is to have a field that uniquely identifies each and every record in the table. From what I've seen in your code, you cannot guarantee this. Your best course of action is to go back to the database and add a Primary Key column to the table.
|
|
|
|
|
(in WIN XP)I don't know the place in registry where I can get the exe
paths of all installed applications. However I can find the installed
applications in HLM\Software\Microsoft\Windows\Current Version\Uninstall.
I want to fetch the paths in a program from the registry.
Please help me...
|
|
|
|
|
You can't do this because that information isn't stored in the registry. The data is specific to each application, not the installer. The installer doesn't care what the path to the .EXE is, so it doesn't store that information anywhere.
|
|
|
|
|
Hello
how can i generate random numbers between 10.1 to 19.9, i mean for ex. 10.8,14.8,19.2 etc
any help
waiting for your kind help
thanks
|
|
|
|
|
<br />
dim rnd as new Random()<br />
dim val = 10.0f + (rnd.Next(99)+1.0f)/10.0f<br />
the .Next(99) method gives you a random number between 0 and 99
so (rnd.Next(99)+1.0f)/10.0f will give you a number between 0.1 and 9.9
|
|
|
|
|
hello sir
first of all thanks for your quick rep
and it's working fine
thank you very much for helping beginners like me
|
|
|
|
|
Do you want specific numbers with a step of 0.1 as in your example, or any floating point number between the values, i.e. numbers like 12.7848726343455 and 17.93847509823745?
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
hello sir
thanks for your rep.
yes i want any numbers like 12.7848726343455 and 17.93847509823745 as you said but only two digits after decima like 12.78 , 17.93 something like that
waiting for your kind rep.
have a nice day
thanks
|
|
|
|
|
That doesn't make it much clearer, and it also doesn't match what you originally requested.
Perhaps you can explain what is it that you are going to use it for?
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
hello sir
thanks again for your rep.
I just want to generate random numbers like 10.1,15.9,19.3,or 66.9,99.1 or 44.39,11.19,31.45 etc. like CKIng's help i have tried it and it's working but if you have some thing different then it's worth to know it
thanks again for your rep.
have a nice day
|
|
|
|
|
I am upgrading VB6 to VB.Net
here is the code giving me the error
<br />
Public Sub oCustomTask2_Trans_Sub1(ByVal oCustomTask2 As Object)<br />
<br />
Dim oTransformation As DTS.Transformation2<br />
<br />
oTransformation = oCustomTask2.Transformations.New("DTS.DataPumpTransformCopy")
Error 168 Constructor call is valid only as the first statement in an instance constructor.
whats the meaning of that and how can i resolve that?
here is the upgrade warning given by Upgrade vizard
'UPGRADE_WARNING: Couldn't resolve default property of object oCustomTask2.Transformations. Click for more: 'ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"'
|
|
|
|
|
Without knowing all the background it's hard to help but:
try
Dim oTransformation As New DTS.Transformation2
OR:
The problem is with the
<br />
oTransformation = oCustomTask2.Transformations.New("DTS.DataPumpTransformCopy")<br />
part.
A constructor is not a simple Method (it for example no return value) but a OPERATOR. So try
<br />
oTransformation = new oCustomTask2.Transformations("DTS.DataPumpTransformCopy")<br />
But as already said: it's hard to tell without knowing the oCustomTask (is it a class with subclass Transformations? Or is it a Namespace?) and DTS.Transformation2.
|
|
|
|
|
I can't get my sub main() to execute. I tried it in the main form and, as suggested by another user, in a module. The console.writeline never executes in either place. What am I doing wrong? Thanks!
Module Module1
Sub Main()
Console.WriteLine("HERE")
End Sub
End Module
|
|
|
|
|
You have to set the entry-point in your project-settings. Normaly this points to the main-form - but you can set it to the Sub Main.
|
|
|
|
|
Well it seems I can only do that if I make the project a console application instead of a windows application. Otherwise sub main is not a choice in the startup dropdown. But I'm not sure what the difference is, or if I really want to do that.
|
|
|
|
|
Ok - you are right - strange.
Try using C# instead
|
|
|
|
|
I read in several places that putting a sub main() in your code in vb.net automatically ran that sub main() instead of the default. But that doesn't seem to be happening for me.
Thanks
|
|
|
|
|
In order to specify your own "Sub Main", you have to turn off the "Enable application framework" option directly under the option to pick your startup object.
|
|
|
|
|
I guess I should have seen that... the checkbox is right there in front of my eyes..
Thanks!
|
|
|
|
|
in my VB6 code the code line is like this
PopupMenu mnuAddDeleteItems
upgrade vizard change it to
PopupMenu(mnuAddDeleteItems)
but
i am getting the error
<br />
Error 125 Name 'PopupMenu' is not declared.
PopupMenu is custom function?
how can i resolve the issue
|
|
|
|
|
You might have to rewrite the code using the ContextMenu class.
|
|
|
|
|
there is no implimentaion for popupmenu in VB6
just its using the method
can u please giveme some pointers how to
replave that with contextmenu?
|
|
|
|