Search results for query: *

I have been struggling for several days now trying to figure out why I am getting the failed to enable constraints, one or more rows contain values violating non-null, unique, or foreign-key constraints when running my code. I have a stored procedure in sql server, part of it below...

Didnt know stating that adding the left joins wasnt enough. So this works, when i remove the left joins and the last two items from the select. Once I add in either left join, i get the error. It isnt a problem with the SQL, it is an issue with how Visual Studio is trying to parse it, I...

its when i add in either left join

The query works just fine when run other places, just not when using the tableadapter wizard in visual studio.

Can anyone help, I still cant figure this out.

If I am posting this is the wrong area, I apologize. I am trying to add a table adapter to one of my datasets. The dataset has oracle as its datasource using ODP.NET. When I put in the query (which works elsewhere) I get this error (Syntax Error: Expecting identifier or quoted identifier)...

i just went with singleton

Ok. The entire purpose of how i did it with frmglobals is so that only one instance of the form can be open at any given time. I don't want to have two instances of a form open at once. I did some research on how to do that, and the frmglobals seemed the easiest. It has been working, but The...

So i removed the formclosed event i had above that is on frm_metrics that had the disposing stuff in it. But when i try it the second time, it is still freezing. BTW, the code in the first post, the top code section is from the first form frm_metrics_sectsum and the bottom code section is from...

And doesnt doing frmGlobals.frm_metrics = New frm_metrics just create it over again?

Ok, i understand, but the weird thing is, i open that form from other places, like a menu ribbon and it doesnt have this problem. Not sure why it does here.

So if i leave the second form open, go back to the first form, click on another row, it brings the form to the front with the correct combo set. This is the expect result. It is only when I close the second form and the first form tries to reopen in.

I have a form with a grid on it. I have handled the row click event (I am using devexpress winforms addins). I take the employee id from the first form, open the second form and set a value for one of the lookup combos. The first time i do this it works perfectly. If i then close that second...

This might be a dump question and I am just overlooking something. I have a combobox with a datasource to a dataset datatable. It list a bunch of IDs. Next to it, I have a bunch of textboxes that i bound to other fields of that datatable. When I open the form, the combobox is empty like it...

Still coming up type expected

Is it this: Dim query = From a In dt Let a_cctrid = a.Field(Of Integer)("cctrid") Join b In EMS_DS.TEMSCCTR On a_cctrid Equals b.cctr_id Group a_cctrid By cctr = b.cctr_cd, cctrcnt = a_cctrid Into Group...

i messed up in the first place Dim query = From a In dt Join b In EMS_DS.TEMSCCTR On a.cctrid Equals b.cctr_id Group By a.cctrid Into cctrcnt = Count(a.cctrid) Select b.cctr_cd, cctrcnt But where do i...

Where do i put that, in the join or group by?

I am trying to write a linq query and having a fit trying to figure it out. Am not very good with linq, just the basics. I code in vb. So I created a datatable in code, then want to write a query that joins it to a typed datatable. Here is what i have so far: Dim dt As New DataTable...

I am trying to create a table adapter that contains a case when and IN clauses, see below: SELECT CATSCOUNTE, PABRJ AS FYR, PABRP AS PP, PERSNO AS EMPL_ID, PNALT AS EMP_NO, CASE WHEN SUBSTR(lstar,1,3) IN ('LAD','LIN','IDR') THEN 'Z' ELSE...