Stack Overflow
Stack Overflow

Questions tagged [expressionbuilder]

95 questions
0
votes
1 answer

How make a more generic WHERE clause?

I have been looking at making a more generic WHERE clause so I don't to repeat code. I have the following that returns posts based on a tag. The same thing could used just as easily for return posts based on a search term or on a category. The only…
Ashok Padmanabhan
  • 2,110
  • 1
  • 19
  • 36
0
votes
1 answer

If statement in MS Access Expression Builder on Control Source

I have an unbound textbox on my form I put on the control source =Date()-[boundfield] and it works fine it gives the number of days I needed but I wanted to have an If statement in this unbound field so using the expression builder I typed on the…
Juan Filipe
  • 403
  • 6
  • 11
  • 23
0
votes
1 answer

How to get previous month's number

I have the following SSIS expression: Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2) + RIGHT("0" + (DT_STR,4,1252) DatePart("yyyy",getdate()),2) which gives me 0614. How can I change the month code so it always gives me the previous month's…
Si8
  • 9,141
  • 22
  • 109
  • 221
0
votes
3 answers

Microsoft Access 2010 (32-bit), Win7 (64-bit) - IIf function in Expression Builder not working

I'm having trouble getting the IIf() function to work in the Expression Builder in Microsoft Access 2010 64-bit, Windows 7 Professional. I have knocked the problem down to its most basic form, and it really looks to me like the IIf function, within…
Tony Rowlett
  • 3
  • 1
  • 8
0
votes
1 answer

Check if a query returns a blank cell and replace with 0

I've written a query in access and it returns a blank cell for most of the results, I need to replace these blank cells with a 0 The first way I tried was: TtlSickDays: IIf([TotalSickDays]='',0,[TotalSickDays]) But I got the error message: Data…
user2811184
0
votes
1 answer

How to display text from a query into a textbox

I have a textbox on my report and I have a query which always returns a single cell: SELECT CustomMessage FROM OrderSheetSettings; My aim is to display the single cell that it returns and place it into the textbox through the expression…
user2811184
0
votes
1 answer

"Generation of designer file failed" when adding custom ExpressionBuilder tags to .ascx

I am making some changes to a user control (.ascx file) in my ASP.NET 3.5 web application project in Visual Studio 2008. I noticed that the changes I was making in the markup were not being reflected in the designer file (a fairly well-known…
Andrew
  • 14,325
  • 4
  • 43
  • 64
0
votes
1 answer

Eclipselink JPA MappingSelectionCriteria customization

According to EclipseLink/Examples/JPA/MappingSelectionCriteria I can make some filtering on OneToOne or OneToMany relationships. To do that I have to implement DescriptorCustomizer. My question is: Can I do some conditional filtering with this…
user1278890
  • 643
  • 8
  • 22
0
votes
1 answer

Why Variable on SSIS couldn't give the value?

Hello Before this question i already ask on Stckoverflow Create Dynamic Path For SSIS Logging with SSIS log provider for Text files I Follow the suggestions, but my Log File didn't create? why it happens ? is it Logging on SSIS text Log File…
Sabilv
  • 602
  • 1
  • 15
  • 44
0
votes
1 answer

Create Dynamic Path For SSIS Logging with SSIS log provider for Text files

hello i got trouble with Path destination of SSIS log provider for Text files at first i use the path static like D:\\ but right now the path i want to get the path from sql table and put it on variable, so i create expression builder for SSIS txt…
Sabilv
  • 602
  • 1
  • 15
  • 44
0
votes
1 answer

Eclipselink Expression that retrieves the last N rows with some criteria

I have a table that contains the following columns: @Column(name="CTDESTATUS") private String status; @Column (name= "CTDEMESSAGE") private String message; @Temporal(TemporalType.TIMESTAMP) @Column (name = "CTDTDATE") private Date date; @Column…
elias
  • 15,010
  • 4
  • 40
  • 65
-1
votes
1 answer

Can we select rows with duplicate entries in Alter Row transformation in Azure Data Factory?

There are two columns: col_A col_B 111 2.0 222 1.0 222 2.0 333 1.0 Using alter row transformation i would like to select rows that have repeated entries in col_A, in this example 222 and select the corresponding highest value in…
Lav Mehta
  • 92
  • 1
  • 2
  • 13
-1
votes
1 answer

How to autofill text area base on combo box value on MS.Access

I had problem when trying make form using MS.Access and i don't know how to make text area value same as combobox value like this picture:
Rizal Maulana
  • 73
  • 1
  • 9
-1
votes
1 answer

Expression Builder Date Assignment

I've built an SSIS package that runs on schedule weekly on Mondays. It looks for a .csv file that has a date at the end of the file name, which is 2 Saturdays ago from the date it runs (on Mondays). I need the variable to default to two Saturdays…
JohnE
  • 1
-1
votes
1 answer

Select first value from list using expression builder - Access 2013

I'm currently trying to set the default value of a combobox to the first value in that combobox using the expression builder. The box is populated by a table with one column. I'm quite new to Access, so sorry in advance if this is a silly question. …
Åustin
  • 71
  • 8
1 2 3 4 5
6
7